NTSB investigations: Lycoming 0-320 series, 2019
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\") = 2019
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") = 2019
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 ERA19LA274Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB9 · Fort Meade, MDThe failure of the carburetor intake scat tubing, which resulted in a partial loss of engine power.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19LA265Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairhope, ALFailure of the No. 3 exhaust valve and the subsequent loss of engine power due to engine operation with an excessively lean fuel mixture over a period of time.NTSB WPR19LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fullerton, CAPartial loss of engine power during takeoff due to an age-degraded carburetor heat valve seal, which detached and partially blocked the carburetor air inlet. Contributing to the accident was an inadequate maintenance inspection.NTSB WPR19LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Placerville, CAThe partial loss of engine power due to an improperly maintained carburetor.NTSB ANC19LA011Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Anchorage, AKA loss of engine power due to oil starvation as the result of a loose B-nut fitting on the engine oil cooler, resulting in a forced landing to a soft, snow-covered surface, and a subsequent nose over.NTSB WPR19LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Salt Lake City, UTA partial loss of engine power due to the mechanic’s failure to properly secure the throttle lever locking nut and cotter pin.