TNG: Cause and Effect (S05E18)

Ho-hum, another spatial anomaly… and then the Enterprise is destroyed before the opening credits even run. The earliest rug-pull cold open I can think of (this aired in 1992).

Also part of the storied history of Cheers/Star Trek crossovers.