Reports of mysterious low-flying aircraft provoked outlandish theories, but old-fashioned hysteria appears to have been to blame