Star Trek: Deep Space Nine: Season 6, Episode 26 - ProjectFreeTV

6 - 26: Tears of the Prophets

Sisko is chosen to lead an invasion into Cardassian territory, ignoring a warning of impending doom if he leaves DS9 from the Prophets, resulting in fatal consequences for a member of the crew.