Fatal NTSB investigations, NM
28 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 3 |
| 2015 | 5 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 3 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 WPR24FA213Accident · 1 fatalClass 3 · FieldFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Chamberino, NMAn aerodynamic stall and loss of control for reasons that could not be determined based on the available information.NTSB WPR23FA138Accident · 1 fatalClass 3 · FieldFinal reportAerotrike Cobra · Santa Teresa, NMThe pilot’s exceedance of the aircraft’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN22FA317Accident · 4 fatalClass 3 · FieldFinal reportBell UH-1H · Chapelle, NMThe total loss of engine power due to the fatigue failure of the starter-generator input (zerol) gear which failed due to poor maintenance. Contributing to the accident was the unsuccessful autorotation complicated by the setting sun and high density altitude.NTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.NTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.NTSB WPR19FA103Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Farmington, NMThe noninstrument-rated pilot's continued visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB WPR19LA078Accident · 1 fatalClass 3 · LimitedFinal reportRans S12 · Socorro, NMA loss of control for reasons that could not be determined based on available evidence.NTSB CEN18FA262Accident · 1 fatalField investigationFinal reportSchempp-Hirth Flugzeugbau Ventus 3F · Moriarty, NMThe pilot's exceedance of the glider's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB CEN18LA012Accident · 1 fatalLimited investigationFinal reportGlobe GC 1A · Los Lunas, NMThe loss of directional control during takeoff and impact with a steel culvert.NTSB CEN17FA227Accident · 2 fatalField investigationFinal reportBeech E 90 · Ruidoso, NMThe pilot's failure to maintain clearance from terrain after takeoff during dark night conditions.NTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN15FA325Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Truth or Consequences, NMThe student pilot's improper decision to conduct a flight in dark night conditions without a solo night flight endorsement and his subsequent loss of airplane control.NTSB CEN15FA277Accident · 1 fatalField investigationFinal reportNorthwing Design Apache Sport · Taos, NMThe powered-lift aircraft's departure from controlled flight for reasons that could not be determined from the available information.NTSB CEN15FA255Accident · 2 fatalField investigationFinal reportCub Crafters CC18-180 · Raton, NMThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN15LA253Accident · 1 fatalLimited investigationFinal reportSchleicher ASW27 - 18E · Lamy, NMA loss of glider control for reasons that could not be determined based on the available evidence and the glider’s severe fragmentation.NTSB CEN15LA059Accident · 1 fatalLimited investigationFinal reportRoss H/Herriott M Vans Aircraft RV 3 · Las Cruces, NMThe pilot’s failure to maintain airplane control, which resulted in a stall/spin. Contributing to the accident was the pilot’s failure to obtain adequate familiarization in the accident airplane type before the accident.NTSB CEN15FA044Accident · 1 fatalField investigationFinal reportMooney M20K · Clines Corners, NMThe noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…NTSB CEN14FA369Accident · 3 fatalField investigationFinal reportAgusta A109E · Newkirk, NMThe pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.NTSB CEN14FA077Accident · 2 fatalField investigationFinal reportAviat A-1C-200 · Los Alamos, NMThe pilot’s loss of airplane control while maneuvering after takeoff in gusty wind conditions.NTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB CEN13LA299Accident · 1 fatalLimited investigationFinal reportPeck Norman O Peck P-1 · Aztec, NMThe pilot’s loss of airplane control during takeoff for reasons that could not be determined because postaccident fire damage precluded a complete examination of the airplane.NTSB CEN13FA183Accident · 4 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot's loss of control while flying in a turbulent mountain-wave environment. Contributing to the accident was the pilot's overconfidence in his ability to safely pilot the airplane in gusting wind conditions and his lack of experience operating in…NTSB CEN12FA291Accident · 1 fatalField investigationFinal reportBeech V35B · Las Vegas, NMThe pilot’s loss of airplane control for reasons that could not be determined because postaccident examination revealed no evidence of preimpact anomalies that would have precluded normal operation.NTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.NTSB CEN11FA652Accident · 2 fatalField investigationFinal reportConcannon Milton Radial ROC · Socorro, NMThe pilot's failure to maintain adequate airspeed during the visual approach to the runway, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s lack of experience in the airplane make and model and the possible sedating…NTSB CEN09FA195Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Golden, NMThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of alcohol and his subsequent impairment.NTSB CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.NTSB DFW08FA170Accident · 5 fatalField investigationFinal reportCessna U206F · Santa Rosa, NMThe pilot's failure to maintain safe flying airspeed for undetermined reasons resulting in an inadvertent stall.