NTSB investigations: Lycoming 0-320 series, CA
9 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Loss of engine power (total). 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 | 2 |
|---|---|
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 2 |
| 2017 | 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
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\" = '341'))
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" = 'CA' AND c."eventCountry" = 'USA'
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" = '341'))
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 WPR24FA080Accident · 1 fatalClass 3 · FieldFinal reportSwanson R/Swanson S RV-6 · Concord, CAA total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.NTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR15CA207Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Carlsbad, CAThe pilot's failure to manage the fuel system properly during a banner tow operation resulting in a loss of engine power due to fuel starvation.NTSB WPR15LA164Accident · No injuriesLimited investigationFinal reportPiper PA28 - 140 · El Cajon, CAThe pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank, and his delayed movement of the fuel selector handle to the other tank, which resulted in a loss of engine power due to fuel starvation.NTSB WPR13LA402Accident · No injuriesLimited investigationFinal reportCessna 172N · Long Beach, CAThe total loss of engine power during initial climb due to debris within the carburetor mixture metering sleeve.NTSB WPR13LA353Accident · Minor injuriesLimited investigationFinal reportWeber GPA-2 · Brentwood, CAA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA227Accident · No injuriesLimited investigationFinal reportCessna 150F · San Diego, CAA total loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB SEA08LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CAA loss of engine power due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the mounting bolts for the newly installed vacuum pump.NTSB LAX08LA206Accident · No injuriesLimited investigationFinal reportCessna 172N · El Cajon, CAThe loss of engine power due to carburetor ice resulting from the flight instructor's failure to use the carburetor heat when simulating an engine failure. Contributing to the accident were the carburetor icing weather condition and the lack of suitable…