NTSB investigations: Lycoming I0360 SER A&C, 2000
10 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 8 |
| 1977 | 9 |
| 1978 | 5 |
| 1979 | 5 |
| 1980 | 8 |
| 1981 | 6 |
| 1982 | 18 |
| 1983 | 11 |
| 1984 | 12 |
| 1985 | 9 |
| 1986 | 13 |
| 1987 | 13 |
| 1988 | 9 |
| 1989 | 6 |
| 1990 | 12 |
| 1991 | 7 |
| 1992 | 6 |
| 1993 | 11 |
| 1994 | 5 |
| 1995 | 9 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 9 |
| 1999 | 16 |
| 2000 | 10 |
| 2001 | 25 |
| 2002 | 25 |
| 2003 | 29 |
| 2004 | 32 |
| 2005 | 23 |
| 2006 | 19 |
| 2007 | 21 |
| 2008 | 12 |
| 2009 | 16 |
| 2010 | 17 |
| 2011 | 23 |
| 2012 | 13 |
| 2013 | 14 |
| 2014 | 11 |
| 2015 | 10 |
| 2016 | 19 |
| 2017 | 16 |
| 2018 | 14 |
| 2019 | 7 |
| 2020 | 11 |
| 2021 | 10 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 7 |
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\") = 2000
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'))
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") = 2000
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'))
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 CHI01IA047Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Cloud, MNthe fatigue failure of the propeller blade during the initial takeoff climb. The failure was a result of a material defect, which occurred during the manufacturing process and the manufacturers failure to detect the defect.NTSB DEN01LA014Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Longmont, COthe total failure of the left main gear strut during the landing roll. A contributing factor was the 6-foot high snow bank that the airplane impacted when it left the runway.NTSB MIA01LA018Accident · No injuriesLimited investigationFinal reportMooney M-20J · Deland, FLthe dual student's improper use of the brakes and the flight instructor's inadequate supervision which resulted in a loss of directional control and a subsequent ground swerve during which the aircraft exited the runway and collided with a runway sign.NTSB LAX01FA023Accident · 2 fatalField investigationFinal reportMooney M-20J · Wheaton Springs, CAThe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in the in-flight collision with mountainous terrain.NTSB CHI00LA287Accident · No injuriesLimited investigationFinal reportCessna 172R · New Lenox, ILThe pilot's failure to maintain directional control during landing. Factors to the accident were the pipe that was struck, the crosswind, and the pilot's runway selection.NTSB DEN00LA139Accident · No injuriesLimited investigationFinal reportFudold Avid - Magnum · Walden, COThe pilot's inadvertent stall/mush during a go-around attempt. A contributing factor was the high density altitude weather condition.NTSB NYC00FA118Accident · 5 fatalField investigationFinal reportMooney M20J · Norton, VAThe pilot's improper weather evaluation, which resulted in a loss of aircraft control. Factors in this accident were icing conditions, and aircraft loading which exceed the airplane's weight and balance limitations.NTSB CHI00LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe student pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the misjudged landing flare, the student's lack of total experience, the runway lights, and the runway signs.NTSB ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.NTSB FTW00LA060Accident · No injuriesLimited investigationFinal reportCessna 172R · Angleton, TXThe pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.