NTSB investigations: Lycoming I0360 series, 2002
10 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 3 |
| 1988 | 2 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 6 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 10 |
| 2003 | 5 |
| 2004 | 7 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 9 |
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 year(c.\"eventDate\") = 2002
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\" = 260))
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 year(c."eventDate") = 2002
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" = 260))
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 DEN03LA013Accident · No injuriesLimited investigationFinal reportMooney M20E · Broomfield, COthe pilot's failure to maintain directional control after landing due to a sheared steering horn attach bolt that should have been replaced by maintenance personnel in compliance with an outstanding service bulletin. Contributing factors included the pilot's…NTSB IAD02LA092Accident · No injuriesLimited investigationFinal reportGoff Glassair · Stow, MAThe pilot's improper positioning of the throttle during engine start, which resulted in his inability to maintain control of the airplane.NTSB IAD02LA083Accident · No injuriesLimited investigationFinal reportMenzies Glassair II · Laconia, NHThe pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB FTW02LA202Accident · Minor injuriesLimited investigationFinal reportJackie SNS-7-Hiperbipe 3 · Lancaster, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during takeoff roll.NTSB LAX02LA184Accident · No injuriesLimited investigationFinal reportCessna 172S · Monterey, CAThe pilot was unfamiliar with the airplane's systems and failed to set the elevator trim in accordance with the published checklist.NTSB FTW02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · McKinney, TXthe pilot's failure to maintain directional control of the airplane while taxiing from landing.NTSB FTW02LA115Accident · No injuriesLimited investigationFinal reportCessna 172S · Angel Fire, NMThe pilots failure to maintain directional control during the crosswind landing. A contributing factor was the gusting wind condition.NTSB LAX02LA130Accident · No injuriesLimited investigationFinal reportCessna 172S · Palm Springs, CAThe pilot lost directional control and collided with a runway edge light and taxiway sign.NTSB LAX02LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Camarillo, CAThe pilot's failure to maintain directional control.NTSB LAX02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot of the landing airplane failed to maintain directional control resulting in the on-ground collission.