NTSB investigations
8 cases where NTSB found Recip eng wiring.
Cases per year
| 2009 | 1 |
|---|---|
| 2015 | 1 |
| 2017 | 1 |
| 2020 | 2 |
| 2023 | 2 |
| 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01058597')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01058597')) 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 ANC24LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · Talkeetna, AKA degraded ignition system, which resulted in a total loss of engine power. Contributing to the accident was maintenance personnel’s inadequate inspection of the ignition system.NTSB WPR23LA314Accident · Serious injuriesClass 3 · LimitedFinal reportReynolds Ronald B Team Acft Z-MAX · Rigby, IDThe loss of engine power during takeoff due to inadequately secured wires, which resulted in the wearing of the wires’ sheaths and the grounding of the airplane’s electrical system. Contributing to the accident was the pilot’s failure to maintain airplane…NTSB ERA23LA320Accident · 1 fatalClass 3 · LimitedFinal reportMesnard Velocity Twin · Sandersville, GAA total loss of power in the right engine due to the right ECU injector wires being severed by the main landing gear actuator piston teeter bar as a result of a lack of clearance and protection of the wiring bundle.NTSB ERA20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportJust JA 30 Superstol · Clover, SCThe separation of a spark plug lead, resulting in a partial loss of engine power and collision with trees.NTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.NTSB WPR18LA009Accident · No injuriesLimited investigationFinal reportBarber Warren D Turbine Cubs P A 18 · Skull Valley, UTThe activation of the wheel brakes during landing, which resulted in a nose-over. The reason for the wheel brake activation could not be determined.NTSB CEN15FA315Accident · 2 fatalField investigationFinal reportSanford Zenith CH 601XL · Bristol, WIThe pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…NTSB CEN09CA232Accident · No injuriesData collectionFinal reportCessna 150D · Madison, INThe loss of engine power due to the failure of the engine's muffler which melted and grounded the ignition P-lead wire.