It landed on the coastal area of Bevelle after Cid's airship shot its front legs off, then Sin took to the skies and waited above the city until the final showdown.
After Yu Yevon was defeated, though, sin didn't actually fall and instead just exploded in the air.