@filmfann it did not crash in 4. In fact, it didn’t even exist until the very end of 4. The original Enterprise crashed in 3, and the crew commandeered the Klingon ship, which they used for the majority of 4. At the end of 4, the crew was given command of a brand new ship, the Enterprise-A.
Original crashed in 3 (Search for Spock).
A was never seen destroyed, but was due to be retired at the end of 6 (The Undiscovered Country)
B was never seen destroyed (never seen at all, except the beginning of 7 (Generations) ).
C was presumably destroyed (off camera) after the events of the TNG episode “Yesterday’s Enterprise”.
D crashed in 7 (Generations).
E is the “current” ship, last seen in 10 (Nemesis).