NTSB investigations: Lycoming 0-320 series, 2010
7 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Loss of engine power (partial). Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 9 |
| 2010 | 7 |
| 2011 | 10 |
| 2012 | 14 |
| 2013 | 4 |
| 2014 | 9 |
| 2015 | 10 |
| 2016 | 7 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 7 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 7 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 6 |
| 2026 | 10 |
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\") = 2010
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342'))
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") = 2010
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '342'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN11CA062Accident · No injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot/mechanic’s improper inspection of the airplane following the engine installation.NTSB ANC10CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's rapid application of throttle and carburetor heat causing the engine to hesitate and lose power during takeoff following an aborted landing.NTSB WPR10LA424Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Lakeview, ORA partial loss of engine power during the initial climb due to a stuck exhaust valve.NTSB CEN10LA429Accident · 1 fatalLimited investigationFinal reportWarth Dennis J Classic Sport S-18 · Tea, SDA loss of engine power for undetermined reasons and the pilot's loss of airplane control, which led to an aerodynamic stall.NTSB CEN10LA403Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5 · Hutto, TXThe loss of engine power due to fuel starvation as a result of the pilot's failure to visually verify his fuel quantity prior to the flight.NTSB WPR10LA298Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Hillsboro, ORA partial loss of engine power while on approach for undetermined reasons.NTSB WPR10LA302Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Richfield, UTThe pilot’s decision to operate the unairworthy airplane with suspected performance deficiencies in a high density altitude and the subsequent partial loss of engine power due to low compression.