NTSB investigations: Lycoming I0360 SER A&C, 2023
6 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\") = 2023
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") = 2023
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 CEN24LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Arlington, TXA reported loss of engine power during the landing approach due to undetermined reasons, which resulted in a forced landing and collision with a fence.NTSB WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.NTSB ERA23LA302Accident · No injuriesClass 4 · LimitedFinal reportPollock Michael D Velocity 173RG · Lebanon, NHThe pilot’s failure to store the nose landing gear securing bar within reach in the cabin, which resulted in a nose gear collapse following a manual landing gear extension.NTSB CEN23LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fredericksburg, TXThe pilot’s failure to maintain airplane control during an attempted go-around resulting in abnormal contact with the runway pavement and a runway excursion.NTSB ERA23LA187Accident · Serious injuriesClass 4 · LimitedFinal reportLewis/Urmston RV 4 200 · Cedar Key, FLThe pilot’s inadequate compensation for gusting wind conditions while landing, which resulted in a loss of directional control.NTSB ERA23LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCanton Paul A RV-6 · Milton, FLThe incorrect installation of the fuel pickups, which resulted in a total loss of engine power due to fuel starvation. Contributing was the lack of documentation of the airplane’s unusable fuel.