A huge fireball that soared through the skies in the Northeast prompted hundreds of people to contact the authorities