NTSB investigations, NM
29 cases where NTSB found Not determined.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 7 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 4 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 1 |
Where
Open the mapLatest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05')) 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 WPR23LA198Accident · Minor injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · Clovis, NMThe airplane’s uncontrollable descent and forced landing for reasons that could not be determined.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 CEN19FA032Accident · 1 fatalField investigationFinal reportMooney M20C · Santa Fe, NMCollision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's poor preflight planning and poor decision to depart on the accident flight.NTSB CEN18LA207Accident · No injuriesLimited investigationFinal reportCessna T210 · Clovis, NMThe total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18FA192Accident · 1 fatalField investigationFinal reportBeech D17S · Santa Fe, NMThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available information.NTSB CEN18LA117Accident · No injuriesLimited investigationFinal reportBlack Donald Cozy III · Los Lunas, NMThe seizure of the propeller gearbox for reasons that could not be determined based on the available information, which resulted in a forced landing.NTSB CEN17LA098Accident · No injuriesLimited investigationFinal reportRobinson Michael E Cozy Mark IV · Anthony, NMA total loss of engine power during climbout for reasons an examination of the engine and fuel system was not able to determine, which resulted in a forced landing on unsuitable terrain.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 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 CEN14LA373Accident · Serious injuriesLimited investigationFinal reportGarramone Mike A Vixen · Columbus, NMA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB CEN14FA193Accident · Minor injuriesField investigationFinal reportAirbus AS350 B3E · Albuquerque, NMThe pilot's loss of yaw control during takeoff due to the absence of hydraulic boost to the tail rotor pedals for reasons that could not be determined based on the available information. A finding in the accident was the lack of a caution indicator to alert…NTSB CEN14LA107Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Silver City, NMThe collapse of the landing gear during landing for reasons that could not be determined during postaccident examinations.NTSB CEN13LA571Accident · No injuriesLimited investigationFinal reportCessna 182J · Santa Teresa, NMA loss of engine power for reasons that could not be determined because no anomalies were found during the postaccident engine examination.NTSB CEN13LA158Accident · No injuriesLimited investigationFinal reportBell 206B III · Ponderosa, NMA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA659Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 210S · Albuquerque, NMThe failure of the balloon envelope parachute vent to properly seat, which resulted in the uncontrolled descent of the balloon. The reason the vent did not properly seat during the accident flight could not be determined because the vent operated properly…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 CEN11LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Ruidoso, NMThe left engine's intermittent loss of power during initial climb for undetermined reasons. Contributing to the accident was the high density altitude at the time of the accident.NTSB CEN11LA044Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Grants, NMThe loss of partial engine power for undetermined reasons.NTSB CEN10LA586Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Deming, NMThe loss of engine power for undetermined reasons.NTSB CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.NTSB CEN10LA449Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMA total loss of engine power following a loss of oil pressure for undetermined reasons.NTSB CEN10LA399Accident · No injuriesLimited investigationFinal reportBeech V35A · Truth or Consequences, NMA total loss of engine power for undetermined reasons.NTSB CEN10CA267Accident · No injuriesData collectionFinal reportCessna R172E · Alamogordo, NMAn unknown event that resulted in damage to the airplane's firewall.NTSB CEN10CA091Accident · Minor injuriesData collectionFinal reportGrumman American AA-5B · Santa Fe, NMThe restricted elevator control movement for undetermined reasons.NTSB CEN09FA430Accident · Serious injuriesField investigationFinal reportBeech 35-A33 · Las Vegas, NMThe loss of engine power for undetermined reasons.NTSB CEN09LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Santo Domingo Pueblo, NMA loss of engine power due a loss of oil pressure resulting in heat distress and mechanical failure of the engine. The reason for the loss of oil pressure was not determined.NTSB DEN08LA145Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Angle Fire, NMControlled flight into terrain for unknown reasons.NTSB DFW08CA150Accident · Minor injuriesData collectionFinal reportCortesy, John E Airborne Edge-X · San Juan Pueblo, NMThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing to the accident was the loss of engine power for undetermined reasons.