NTSB investigations: NONE, NM

15 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight encounter with weather”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19852026
NTSB investigations: NONE, NM per year, 1985–2026: 15 cases
19851
19861
19881
19941
19951
20013
20041
20051
20075

Latest cases

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB DEN08LA007Accident · No injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's inability to maintain aircraft control due to high winds, resulting in the aircraft coming in contact with an arroyo and a wall in a residential area.Oct 9, 2007 · N5315M · Substantial damageNTSB DEN08LA006Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-105 · Rio Rancho, NMthe pilot's inability to maintain aircraft control due to high winds resulting in the aircraft coming in contact with two houses.Oct 9, 2007 · N1024B · Substantial damageNTSB DEN08LA005Accident · Serious injuriesLimited investigationFinal reportSproul 72K-TET · Rio Rancho, NMThe pilot's inadequate inflight planning/judgment, and his selection of unsuitable terrain on which to make a landing. Contributing factors in this accident were the unfavorable wind, and the pilot misjudging his airspeed.Oct 9, 2007 · N72KX · No damageNTSB DEN08LA004Accident · 1 fatalLimited investigationFinal reportAerostar S-66A · Albuquerque, NMThe pilot's failure to maintain adequate visual lookout and clearance resulting in an in-flight collision with power lines, and the ground crew's improper assistance. Contributing to this accident were the high wind, the pilot's diverted attention, low…Oct 8, 2007 · N7179Z · Substantial damageNTSB DEN07CA092Accident · No injuriesData collectionFinal reportCentrair 101C · Alamogordo, NMThe pilot's inability to control the glider after encountering the downdraft causing the glider to land short of the dirt strip. Factors contributing to the accident were the downdraft and the runway marker.May 12, 2007 · N991JB · Substantial damageNTSB DEN06CA009Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 210S · Albuquerque, NMthe improper decision by the pilot to continue with the landing and the hard landing encountered by the pilot. Contributing to the accident were the high winds and the proper descent rate not being possible.Oct 7, 2005 · N211LB · No damageNTSB DEN05CA009Accident · Serious injuriesData collectionFinal reportThunder and Colt 180A · Albuquerque, NMthe balloon pilot's improper in-flight planning and failure to maintain aircraft control during descent into high winds resulting in a hard landing and subsequent serious injury to a passenger. Factors contributing to the accident were the high winds and…Oct 9, 2004 · N784TC · No damageNTSB FTW02LA043Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Alamogordo, NMThe pilot's failure to maintain altitude and clearance with small trees during a precautionary landing.Nov 23, 2001 · N2078D · Substantial damageNTSB FTW02LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Albuquerque, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in an inflight collision with objects while landing. A contributing factor was the high wind weather condition.Oct 13, 2001 · N3636Z · Substantial damageNTSB DEN01LA116Accident · Serious injuriesLimited investigationFinal reportCameron Balloons N-210 · Rio Rancho, NMthe pilot's inadvertent weather encounter with wind shear, and the resulting inability to maintain the proper landing descent rate, which resulted in a hard landing. A factor was the high wind weather condition.Jun 13, 2001 · N7507V · No damageNTSB FTW95LA326Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Red River, NMThe pilot's lack of compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the lack of thermal lift and the tailwind.Jul 24, 1995 · N2972 · Substantial damageNTSB FTW95LA006Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Alamogordo, NMThe encountered turbulence. A factor was the lack of suitable terrain available for the forced landing.Oct 2, 1994 · N70792 · Substantial damageNTSB DEN89LA013Accident · Minor injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe plt, with two pax aboard a hot air balloon, participated in the 1988 Albuquerque, NM international balloon fiesta. The plt said he received a wx briefing and then departed in VFR wx conditions. After aprx 45 min of flt, the plt said he encountered…Oct 9, 1988 · N3592C · Substantial damageNTSB DEN86LA059Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Alamogordo, NMUpon returning to the arpt, the plt decided to make a fly-by. The plt reported that while on a modified downwind at an alt of aprx 50 ft AGL, the glider which he was piloting encountered adverse winds and downdrafts. Control of the acft was lost and it…Jan 1, 1986 · N166JD · DestroyedNTSB DEN86LA006Accident · Minor injuriesLimited investigationFinal reportSkypower GBN-41-100 · Pecos, NMFlt was participation in the 1985 balloon fiesta, a night helium-filled balloon race from albuquerque, new Mexico, to elkhart, Kansas. One hr after launch plt encountered small wind shear, causing loss of altitude, ballast, and helium. Plt then encountered…Oct 6, 1985 · N59SP · Substantial damage