A Miranda-class Federation starship that fought in the fleet Sisko led to retake Deep Space 9 in 2374 and was destroyed during the attempt to break through the Dominion lines.
The USS Majestic is a Federation starship of the Dominion War. It takes part in Operation Return, the attempt to recapture Deep Space 9 before the Dominion can bring down the minefield at the wormhole, shown in the episode Sacrifice of Angels.
The Federation fleet is heavily outnumbered. Sisko sends his attack fighters against the Cardassian ships to provoke them, and Dukat lets a gap open as a trap. As the Defiant and the ships around it drive for the opening, the Majestic and the USS Sitak, flying beside the Defiant, are both destroyed.
The loss of the two escorts shows how costly the breakthrough is. Only the Defiant gets clear before Klingon reinforcements arrive to turn the battle.