People were jolted awake by the 'loud and scary explosion' in the middle of the night