NTSB investigations: Lycoming 0-235 series, CA
6 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of engine power”. 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
| 1983 | 1 |
|---|---|
| 1994 | 1 |
| 1995 | 2 |
| 2003 | 1 |
| 2004 | 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 ('41505')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 ('41505')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.NTSB LAX04LA022Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · San Martin, CAThe absence of compression in two of the airplane's four cylinders, and the pilot/mechanic's failure to maintain the engine in an airworthy condition, which resulted in a loss of engine power during takeoff-initial climb, and subsequent forced landing.NTSB LAX96LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAloss of engine power for an undetermined reason.NTSB LAX95LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Helendale, CALoss of engine power for an undetermined reason(s). A factor in the accident was the pilot's selection of unsuitable terrain for the forced landing.NTSB LAX94LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Riverside, CAa total loss of engine power for undetermined reasons.NTSB LAX83LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Guadalupe, CAAfter practicing a series of power-on departure stalls at 3500 feet, the plt climbed to 6500 feet and practiced several power-off approach/landing stalls. At about 3000 feet the engine sputtered and quit. The plt was unable to restore power and made an…