NTSB investigations: Lycoming I0360 series, CA
9 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1988 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1995 | 1 |
| 2002 | 1 |
| 2004 | 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\" = 353))
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" = 353))
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 LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.NTSB LAX02LA187Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Placerville, CAA loss of engine power due to the pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB LAX95LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Paula, CAfuel exhaustion due to the pilot's failure to perform preflight fuel consumption calculations, and his failure to refuel the aircraft.NTSB LAX94LA040Accident · No injuriesLimited investigationFinal reportBeech D95A · Hollister, CAThe improper position of the fuel selector switch by the dual student during the before landing checklist and inadequate supervision by the CFI. Fuel starvation to both engines was a factor in this accident.NTSB LAX93LA070Accident · No injuriesLimited investigationFinal reportBeech C24R · Oakland, CAFuel starvation due to improper fuel system management by both pilots and the failure of the flight instructor to adequately supervise the conduct of the flight.NTSB LAX92LA354Accident · No injuriesLimited investigationFinal reportHughes 269C · Corona, CAThe flight instructor's improper supervision of the flight; the dual student pilot's failure to use carburetor heat; and the flight instructor's improper use of the tail rotor pedals. Contributing to this accident was the engine failure due to carburetor…NTSB LAX92LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Altadena, CAThe pilot's improper use of the fuel selector by selecting an empty tank. Contributing to the accident was the pilot's decision to operate the airplane with a known deficiency without having maintenance performed to determine the cause of a previous loss of…NTSB LAX88LA279Accident · No injuriesLimited investigationFinal reportMooney M20E · Visalia, CAThe pilot removed the vacuum pump from the engine prior to the flight because of an internal failure in the pump. The pilot did not install a cover plate on the accessory mounting hole vacated by the pump. After takeoff on the local flight, the pilot noticed…NTSB LAX82FA361Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Arcata, CAThe plt & pax were on a cross-country from somewhere in the klamath, CA area to hayward, CA. Witnesses observed it flying southbound at 50 to 100 ft over the ocean's shore line. Reportedly, the acft made a sharp left turn toward land, then crashed on a…