It has long been on the minds of doomsday preppers and fiction media creators alike – but how likely is it, really?