NTSB investigations: Lycoming I0360 SER A&C, 2019
7 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\") = 2019
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") = 2019
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 ANC19LA051Accident · No injuriesClass 3 · LimitedFinal reportLake LA-4-200 · Girdwood, AKThe pilot's loss of directional control while landing, which resulted in a runway excursion and collision with terrain.NTSB CEN19LA226Accident · Minor injuriesClass 3 · LimitedFinal reportCashen Super Acro Sport · Detroit Lakes, MNAn open circuit in the engine's electrical switch box, which resulted in a partial loss of engine power and subsequent forced landing.NTSB CEN19LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Ypsilanti, MIThe pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…NTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.NTSB CEN19FA139Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Moose Lake, MNThe pilot’s failure to maintain control of the airplane after departing into a snowstorm.NTSB GAA19CA282Accident · No injuriesData collectionFinal reportCessna 172 · Edwards Air Force Base, CAAn undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.NTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.