S4E20 : The Last Man (1)

Sheppard returns to Atlantis after a mission and finds the city abandoned, all systems dead -- and instead of ocean, sand dunes as far as the eye can see.