let's see
1701 - destroyed in The Search for Spock
A - spared, but took several torpedoes in its last movie
B and C - don't count
D - several alternates in the series, plus definitely* in Generations
E - crashed into Nero's ship, crushed half of its extremely oval saucer, probably written off
DS9 - I don't recall it exploding, but it lost a lot of Runabouts and I don't remember how many Defiants
Voyager - a few alternates. I recall it crashing into the Robocop guy's ship, plus the T-1000-like version dissolving
NX-01 - now that the CGI special effects are viable, the Xindi did a good number. Also I recall one alternate ripped open the top of the bridge
JJ-prize - Beyond
*I didn't follow the newer shows but I know that it came back in ST:Picard
DS9 was destroyed in "VISIONARY", but that was one of the future time jumps of O'Brien.