Star Trek: The Next Generation: Season 2, Episode 13

2 - 13: Time Squared

The Enterprise picks up a Star Fleet shuttle floating in space and much to the crew's surprise, another Captain Picard is on board the shuttle. They then learn that the Enterprise is destroyed in a upcoming disaster.