NTSB investigations, NM
28 cases where NTSB found Aircraft power plant.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 5 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0105'))
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", '0105')) 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 WPR24LA198Accident · Minor injuriesClass 3 · LimitedFinal reportWarren B Cox COX Breezy · Albuquerque, NMThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was maintenance…NTSB WPR24LA063Accident · Minor injuriesClass 3 · LimitedFinal reportBender Thomas G RV-6 · Moriarty, NMA loss of engine power for undetermined reasons.NTSB WPR23LA304Accident · Minor injuriesClass 3 · LimitedFinal reportVan Grouw R / Cantrell L White Lightning · Las Vegas, NMA reported partial loss of engine power during cruise flight for undetermined reasons.NTSB WPR23FA275Accident · 1 fatalClass 3 · FieldFinal reportCessna T310R · Santa Fe, NMA total loss of left engine power as a result of improper installation of the aft-facing crankshaft counterweight retaining rings. Also causal was the pilot’s failure to maintain adequate airspeed following the loss of left engine power, which resulted in the…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 WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.NTSB WPR21LA173Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Santa Fe, NMA leak in the oil line that supplied the engine with oil, which resulted in oil exhaustion and the total loss of engine power. Contributing to the accident was the routing of the oil line to close to the exhaust manifold.NTSB WPR20LA121Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Angostura, NMThe pilots precautionary off airport landing due to an undetermined engine issue.NTSB CEN19FA008Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Canoncito, NMThe partial loss of engine power due to induction system icing. Contributing to the accident was the fractured carburetor heat control cable, which rendered the carburetor heat inoperative.NTSB CEN16LA234Accident · No injuriesLimited investigationFinal reportNorth American Navion · Alamogordo, NMThe failure of the No. 5 exhaust valve key spring, which resulted in a total loss of engine power.NTSB CEN15LA360Accident · 1 fatalLimited investigationFinal reportNorth American T 28A · Las Cruces, NMFailure of the No. 6 cylinder connecting rod, due to improper rotation of the propeller during a previous hydraulic lock.NTSB CEN14FA462Accident · 4 fatalField investigationFinal reportCessna 421C · Las Cruces, NMThe misfueling of the airplane with jet fuel instead of the required aviation fuel, and the resultant detonation and a total loss of engine power during initial climb. Contributing to the accident were the line service technician's inadvertent misfueling of…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 CEN13LA194Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Eagle Nest, NMA total loss of engine power due to a rapid throttle change during autorotation, which the flight instructor initiated in response to a low rotor rpm warning, which resulted from the separation of one of the magnets used to provide rotor rpm indications from…NTSB CEN12CA496Accident · No injuriesData collectionFinal reportBlack Donald Cozy III · Los Lunas, NMA loose oil line, which allowed oil to leak onto the hot engine turbocharger and resulted in a fire.NTSB CEN12LA289Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Grants, NMThe loss of engine power due to an excessively rich fuel mixture that occurred during operations at idle power settings at a high density altitude. Contributing to the accident was the flight instructor’s poor decision-making in choosing to practice an…NTSB CEN12LA261Accident · No injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe partial loss of engine power due to an intake valve that was stuck in the open position.NTSB CEN11LA648Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ocate, NMThe pilot’s failure to apply carburetor heat, which resulted in the formation of carburetor ice and a partial loss of engine power.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 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 CEN10LA282Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Las Cruces, NMA loss of engine power due to fuel starvation as a result of water contamination in the fuel, and the pilot's inadequate preflight inspection. Contributing the accident was an inoperative number 5 cylinder exhaust valve.NTSB CEN10LA166Accident · No injuriesLimited investigationFinal reportCessna 421B · Artesia, NMA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB CEN10CA111Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Reserve, NMAn in-flight fire due to a fuel leak from the No. 5 cylinder's broken fuel injector/line.NTSB CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.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 CEN09CA104Accident · No injuriesData collectionFinal reportMooney M20C · Edgewood, NMA total loss of engine power while at cruise altitude for undetermined reasons.