NTSB investigations, 2020, CA
8 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 18 |
| 2010 | 16 |
| 2011 | 12 |
| 2012 | 12 |
| 2013 | 7 |
| 2014 | 14 |
| 2015 | 10 |
| 2016 | 10 |
| 2017 | 13 |
| 2018 | 10 |
| 2019 | 6 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 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\") = 2020
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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") = 2020 AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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 WPR21LA069Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · San Diego, CAA partial loss of engine power due to the fatigue fracture of the No. 3 exhaust valve rocker arm stud.NTSB WPR21LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCo Z Cozy · Compton, CAThe partial loss of engine power due to an improperly installed sparkplug.NTSB WPR21LA052Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Fallbrook, CAA partial loss of engine power for reasons that could not be determined with the available evidence.NTSB WPR20LA225Accident · No injuriesClass 3 · LimitedFinal reportVans RV 8 · Grimes, CAA partial loss of engine power for reasons that could not be determined because the airplane was not examined.NTSB WPR20LA212Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Lake Tahoe, CAThe partial loss of engine power due to carbon buildup in the No. 4 cylinder resulting from the pilot’s inadequate mixture-leaning procedures.NTSB WPR20LA148Accident · Serious injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Blythe, CAThe excessive wear of one magneto’s wiring harness, which resulted in a loss of engine power during takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following the loss of engine power, which resulted in exceedance of the…NTSB WPR20LA136Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Fresno, CAThe partial loss of engine power for reasons that could not be determined based on available evidence.NTSB WPR20LA094Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Torrance, CAThe partial loss of power due to a malfunction of the throttle cable, which limited movement of the throttle body.