What happened to the enterprise D?

Answer 1

Following the Khitomer mission, the Enterprise was ordered by Starfleet Command to return to Spacedock to be decommissioned. In spite of this, Captain Kirk ordered the ship on course to the "second star to the right, ...and straight on 'til morning." Kirk later recorded in his log that the Enterprise and her history "will shortly become the care of another crew." Star Trek Memory alpha shows that it was decomissioned in 2293.

Answer 2

The Enterprise NCC-1701-B does not have a decomission report. In the film Star Trek Generations she became ensnared within the Nexus when she maneuvered within transporter range of the Starship Lakul. Scotty devised a plan to use a resonance burst from the deflector dish in order to simulate an antimatter explosion and free the Enterprise. Kirk went to deflector control to make necessary modifications as the Enterprise's engineering hull was struck by an energy tendril; Harriman was going to do it himself, but Kirk took the role instead, deciding that Harriman was needed on the bridge, and in the chair. The Enterprise escaped with minor casualties and a hull breach along sections 20 through 28 on decks 13 through 15. Kirk was believed killed in the breach, and the mission became notorious because of his loss. Star Trek Memory Alpha therefore shows it as still active in the year 2293.

Answer 3

The Enterprise (Kirk's Enterprise) was destroyed in the Wrath of Khan.

The Enterprise B was shown in the movie: Star Trek Generations, but was damaged (not destroyed). The Enterprise D (Picard's Enterprise) was destroyed in Star Trek Generations (movie) when the saucer section crash-landed on a planet.