NTSB investigations: Lycoming I0360 series, CA
6 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1989 | 1 |
|---|---|
| 1991 | 2 |
| 1993 | 1 |
| 1999 | 1 |
| 2002 | 1 |
Where
Open the mapLatest 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 ('41515')
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\" = 351))
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 ('41515')
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" = 351))
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 LAX02LA256Accident · Minor injuriesLimited investigationFinal reportDodd RV-4 · Tehachapi, CAthe owner/builder's improperly fabricated and installed fuel line, which cracked at the point of the flare, resulting in a fuel leak and loss of engine power during the takeoff climb. A contributing factor was the soft terrain that jammed the landing gear…NTSB LAX99LA287Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Emigrant Gap, CAThe fatigue failure and separation of the number three cylinder due to the cylinder overhaul facility's improper inspection and quality control processes.NTSB LAX93LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hesperia, CAFatigue failure of the exhaust valve due to inadequate maintenance and inspection.NTSB LAX91LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Redwood City, CAThe fatigue failure of the number two connecting rod and rod cap due to an engine overspeed condition which the rods and rod caps were exposed at some undetermined historical point.NTSB LAX91LA314Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · So. Lake Tahoe, CAEngine failue due to the failure of the crankshaft resulting from failure induced by a non-metallic inclusion in the shaft.NTSB LAX89FA095Accident · 1 fatalField investigationFinal reportMooney M20F · Truckee, CAThe pilot's decision to fly with a known deficiency of the aircraft, the worn fuel injector with an interior leak, which resulted in loss of engine power, and the pilot's failure to maintain adequate airspeed, which resulted in a stall.