Retired Air Force major general missing for weeks once led Wright-Patterson, an Ohio base steeped in decades of UFO theories