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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2001 | 3 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 5 |
Where
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB FTW02LA043Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Alamogordo, NMThe pilot's failure to maintain altitude and clearance with small trees during a precautionary landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…