Star Trek: The Next Generation

The Inner Light (5x25)

:

Picard is struck by an energy beam from an alien probe, which renders him unconscious and places him in the life of a citizen on the planet Kataan, with his memory of the Enterprise intact. Although he searches for a way to return, he finally decides to live his life with his Kataan wife, have children & grandchildren, learning to play a flute and completely immersing in the Kataan culture...