The USS Enterprise NCC-1701-D of Star Trek: The Next Generation is clearly an amazing piece of advanced technology, but infallible it was not. between the holodeck malfunctions and the upgrade that would awry, the ship had a propensity to be destroyed.
The Enterprise-D appears in more Star Trek than any other vessel. All 176 episodes of Star Trek: The Next Generation, the movie Star Trek: Generations as well as the first episodes of both Star Trek: Deep Space Nine and Star Trek: Picard and as the finale of Star Trek: Enterprise. That's a total of 180 appearances. In no less than eight of them the Enterprise-D is destroyed. Fourteen times.
I wrote this for Hero Collector.