Worst Starship Disasters?

[Farscape One]

That was not Paul Rice, though. He was a projection that the Echo Poppa 607 used to get more information out of Riker.

It was not explictly stated it was destroyed, true, but given how the ship version of that device was easily handling a Galaxy class starship, odds are the Drake was destroyed.

 

[Samuel]

U.S.S.Exeter from "The Omega Glory". Entire crew killed by disease that reduces theme to piles of white crystals and debris.