Fatal NTSB investigations, 2012
13 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 17 |
| 2010 | 14 |
| 2011 | 15 |
| 2012 | 13 |
| 2013 | 10 |
| 2014 | 24 |
| 2015 | 15 |
| 2016 | 14 |
| 2017 | 11 |
| 2018 | 17 |
| 2019 | 19 |
| 2020 | 9 |
| 2021 | 14 |
| 2022 | 12 |
| 2023 | 11 |
| 2024 | 12 |
| 2025 | 4 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2012
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\" = '342' 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 year(c."eventDate") = 2012 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" = '342' 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 ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…NTSB WPR13LA045Accident · 1 fatalLimited investigationFinal reportPiper PA-32 · ObyanA partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…NTSB CEN13FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Maryland Heights, MOThe pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.NTSB CEN12FA616Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Kingsland, TXThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power resulting from an engine intake valve that became stuck open. Contributing to the accident was the pilot’s decision to operate the airplane when a required maintenance…NTSB CEN12FA601Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brighton, MIThe pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…NTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…NTSB ERA12FA514Accident · 2 fatalField investigationFinal reportSocata TB 10 · Shirley, NYThe pilot/owner's operation of the airplane with known deficiencies, and the mechanic's failure to reattach the mixture control cable to the mixture control arm following maintenance of the carburetor.NTSB ERA12FA513Accident · 1 fatalField investigationFinal reportMcleod Alan FW-190 1/2 Scale · Columbus, GAThe pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.NTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…NTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…NTSB DCA12FA051Accident · 2 fatalClass 1 · FieldFinal reportConvair 440 - NO Series · San Juan, PRthe flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.NTSB CEN12FA170Accident · 2 fatalField investigationFinal reportMooney M20E · San Antonio, TXThe pilot's inadvertent overboost of the turbocharged engine during initial climb, which resulted in detonation and a partial loss of engine power followed by the pilot's failure to maintain airspeed and the instructor's delayed remedial action, which…NTSB ERA12FA146Accident · 1 fatalField investigationFinal reportAerostar PA-60-601P · Philadelphia, MSThe pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…