I love that ep... and I really like the song he plays on the flute... and I like the fact that the flute becomes a fixture that he revists from time to time.
The glee on his face as an old man when his old "dead" friend comfirms that he really was right.... the final speech given to please don't forget us.... very touching.
That episode is called the Inner Light.
Yup:
Years afterward, an extremely old Kamin is chasing after his grandson. Meribor and Batai come to take both of them to see "the launching." Kamin is initially not interested, but is talked into it. They head out to the courtyard, where Kamin sits on a bench at the outskirts. "What is it they're launching?"
"You know it, father. You've already seen it." "Seen it? What are you talking about? I haven't seen any missile." "Yes, you have, old friend. Don't you remember?"
Kamin turns, awestruck, to see his friend Batai again, as hale and hearty as he was in the prime of life.
"You saw it just before you came here. We hoped our probe would encounter someone in the future-someone who could be a teacher, someone who could tell the others about us."
"Oh...oh, it's me...isn't it? I'm the someone. I'm the one it finds. That's what this launching is-a probe that finds me in the future!"
"Yes, my love." This comes from Eline, now alive again and flush with the beauty of youth. "The rest of us have been gone a thousand years. If you remember what we were, and how we lived, then we'll have found life again."
"Eline..." He watches the missile lift off.
"Now, we live in you. Tell them of us...my darling..." Kamin stares...
...and Picard wakes up on the bridge of the Enterprise as the probe breaks contact and shuts down. He's initially very disoriented, but quickly reacquires at least a cursory knowledge of the situation. He discovers that he's only been unconscious for 20 or 25 minutes, and accompanies Bev to sickbay.
Some time later, Riker visits Picard in his ready room. As Picard gets used to the fact that this is once again his home, Riker hands him a small box they found inside the probe after they examined it. He leaves, and Picard opens the box, to find his flute. He cradles it to his breast, then softly plays it, as we see the ship fading off towards the stars.