A Hundred Days (S03E17)

Col. Jack O'Neill and the rest of SG-1 have established ties with a small village on the planet Edora and its leader, Laira, with whom O'Neill shares a mutual and quiet attraction. Everyone gathers to watch the annual meteor shower referred to by the natives as "fire rain." At first, it's a pleasant light show, but an extra-large shooting star prompts Maj. Samantha Carter and Dr. Daniel Jackson to conduct further research. Their results indicate that Edora travels through an asteroid belt every year, but every 150 years or so, the orbit hits a particularly dense section of debris. Those meteors strike the planet's surface to cataclysmic effect, and apparently this is one of those years. SG-1's evacuation of the villagers is all but complete when Laira discovers her son is missing. O'Neill rushes off to assist her, ordering the rest of SG-1 to return to base. Carter and Teal'c barely make it out in time before a large meteor hits the Edora stargate, burying it and trapping O'Neill and Laira on the distant planet. Both SG-1 and the Edorans are stunned by the loss of their beloved leaders, but SG-1 isn't prepared to accept this tragedy as final just yet. (Metro-Goldwyn-Mayer (MGM))