NTSB investigations, 2014
13 cases where NTSB found Ignition system.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 14 |
| 2010 | 18 |
| 2011 | 8 |
| 2012 | 8 |
| 2013 | 6 |
| 2014 | 13 |
| 2015 | 13 |
| 2016 | 12 |
| 2017 | 9 |
| 2018 | 10 |
| 2019 | 7 |
| 2020 | 10 |
| 2021 | 11 |
| 2022 | 10 |
| 2023 | 20 |
| 2024 | 11 |
| 2025 | 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 year(c.\"eventDate\") = 2014
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010574'))
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") = 2014 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010574')) 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 ERA15FA049Accident · Serious injuriesField investigationFinal reportMooney M20C · Lewisburg, WVThe pilot's failure to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were abnormal engine operation due to improper…NTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…NTSB WPR14LA327Accident · Serious injuriesLimited investigationFinal reportDavid L Thompson Challenger II · Winterhaven, CAA total loss of engine power during cruise for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s loss of control during the forced landing.NTSB ERA14FA350Accident · 2 fatalField investigationFinal reportWilderoder Great Lakes 2TIA · Lillian, ALA loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…NTSB CEN14LA374Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockville, INA partial loss of engine power due to a failure of the dual magneto system. Contributing to the accident was the improper maintenance of the duel magneto system.NTSB CEN14CA380Accident · No injuriesData collectionFinal reportDantonio 404 · Wichita Falls, TXThe separation of a spark plug wire resulting in a loss of engine power during climb out and a subsequent forced landing on a field containing trees.NTSB CEN14LA371Accident · 1 fatalLimited investigationFinal reportAir Command 532 · Petersburg, MIThe noncertificated pilot’s failure to maintain control of the gyroplane following a total loss of engine power due to a loose spark plug.NTSB ERA14LA253Accident · Serious injuriesLimited investigationFinal reportPiper J3C - 65 · Hopkinsville, KYThe failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.NTSB WPR14LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G · El Monte, CAA partial loss of engine power during climbout due to a malfunctioning magneto and spark plugs.NTSB CEN14LA195Accident · No injuriesLimited investigationFinal reportLarsen Mark V · Amelia, OHThe distributor failure, which resulted in a total loss of engine power during cruise climb.NTSB ERA14CA191Accident · Minor injuriesData collectionFinal reportTerry F King Zenith 701 · La Belle, FLThe pilot's failure to maintain airspeed after a total loss of engine power at takeoff, which resulted in a hard landing. Also causal was the pilot/owner/builder's improper installation of the magnetos which resulted in the engine power loss.NTSB ERA14FA123Accident · 1 fatalField investigationFinal reportWilliams Christopher T Sonex · Wellington, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the…NTSB WPR14FA091Accident · Minor injuriesField investigationFinal reportCirrus Design SR22 · Pocatello, IDThe distributor gear teeth failure of the right magneto that resulted in severe engine vibration and partial loss of engine power, which progressively led to the failure of the left magneto distributor drive gear teeth. Contributing to the airplane’s…