NTSB investigations, FL
14 cases where NTSB found Ignition system.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2014 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 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\" = 'FL' 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\", '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 c."eventStateOrRegion" = 'FL' 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", '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 ERA25LA056Accident · No injuriesClass 4 · LimitedFinal reportFinn Lassen RV-4 · O'Brien, FLA total loss of engine power and navigational equipment as a result of a faulty battery.NTSB ERA22LA322Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV10 · Palatka, FLTotal loss of engine power due to the improper installation of an electronic ignition system connector plug.NTSB ERA21LA261Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jupiter, FLThe flight instructor’s failure to obtain the proper touchdown point during a forced landing. Contributing to the accident was the improper service and subsequent inadequate inspection of the single-drive, dual magneto, which resulted in a total loss of…NTSB ERA21LA052Accident · 1 fatalClass 3 · LimitedFinal reportLancair Legacy FG · Hollywood, FLThe pilot/owner’s failure to properly reinstall the number 1 cylinder spark plug, which resulted in a partial loss of engine power during the initial climb. Contributing was the pilot's exceedance of the airplane’s critical angle of attack during an attempted…NTSB WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.NTSB ERA17LA340Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Ocklawaha, FLA failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.NTSB ERA17FA339Accident · 1 fatalField investigationFinal reportHickox Andy Andys Gyroplane · Umatilla, FLThe pilot's improper response to a total loss of engine power, which resulted in main rotor blade contact with the rudder and vertical stabilizer, and a subsequent uncontrolled descent. The loss of engine power was due to the separation of the electrical…NTSB ERA17LA077Accident · No injuriesLimited investigationFinal reportBeech 76 · Dunnellon, FLAn inadequate 100-hour maintenance inspection that failed to detect and correct loose nuts on a single-drive dual magneto, which led to the subsequent separation of the magneto from the engine during initial climb and the total loss of engine power.NTSB ERA16LA156Accident · Minor injuriesLimited investigationFinal reportAtkinson Eaglet · Deland, FLA total loss of engine power during initial climb due to a separation of the ignition plug.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 ERA10LA301Accident · No injuriesLimited investigationFinal reportHood John Sidney Tango · New Port Richey, FLThe improper inspection of the airplane ignition system during the last condition inspection by a mechanic, resulting in an ignition cable disconnecting and a partial loss of engine power.NTSB ERA10LA229Accident · No injuriesLimited investigationFinal reportDalin Ronald K T-51 Mustang · Lakeland, FLThe builder’s use of inadequate material for the exhaust manifold adapters resulting in heat damage and chafing of the crankshaft synchronizer and timing wires that rendered an inoperative ignition system and loss of engine power.NTSB ERA09FA355Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Naples, FLA loss of engine power due to the improper installation of the right magneto by maintenance personnel resulting in subsequent loss of engine power. Contributing to the accident was the inadequate 100-Hour inspection by the mechanic when he failed to note that…