Stargate Atlantis

The Last Man (1) (4x20)

:

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.