NTSB investigations: Lycoming I0360 SER A&C, CA
6 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C, where the first occurrence was “Loss of control - in flight”. 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 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 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 ('41511')
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\" = 250))
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 ('41511')
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" = 250))
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 LAX04LA320Accident · Serious injuriesLimited investigationFinal reportHebb Avid Magnum · Bridgeport, CAthe pilot's failure to adequately compensate for the crosswind condition and his failure to maintain an adequate airspeed while using crossed controls, which led to a stall.NTSB LAX92FA172Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Placerville, CAThe pilot's failure to maintain control of the airplane and his improper use of the flight controls which endured airframe loads that exceeded the aircraft's design stress limits. Factors which contributed to the accident related to the pilot's encounter with…NTSB LAX89DUG03Accident · 1 fatalFinal reportVan'S/Fish RV-4 · Hesperia, CAThe pilot's failure to properly latch the canopy prior to takeoff and by allowing the aircraft to enter into a stall during a critical phase of flight at an attitude insufficient to recover safely. A factor in the accident was the loss of his eyeglasses when…NTSB LAX86DVA04Accident · 1 fatalFinal reportGlen Davis Glasair · Chinese Camp, CAA glasair homebuilt aircraft collided with a barn shortly after takeoff on a night time business trip. The aircraft departed from the extreme left side of the runway which had a high growth of vegetation. The aircraft was observed to be about 40 to 50 ft…NTSB SEA85LA130Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Truckee, CAContrary to common departure practice, the pilot commenced his takeoff from the lake headed westbound and towards rising terrain. Additionally, he failed to use all the takeoff surface available. The density altitude at donner lake at the time of the accident…NTSB LAX82DA204Accident · No injuriesFinal reportBeech C-24R · Big Bear, CAA witness observed the aircraft to pitch and roll while on final approach. At about 30-40 feet above the ground the nose pitched downward and the aircraft collided with the runway. Moderate turbulence and gusty winds were reported on final approach.