The phrase "gone tits up" refers to the Egyptian practise of tying bluetits to helium balloons and releasing them. The birds invariably die past 20,000 ft, hence the association with misadventure.