Fatal NTSB investigations: Lycoming I0360 series, 2009
5 cases on aircraft whose registry engine model is Lycoming I0360 series. 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
| 1964 | 2 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 4 |
| 1969 | 2 |
| 1970 | 4 |
| 1971 | 1 |
| 1973 | 6 |
| 1974 | 6 |
| 1975 | 3 |
| 1976 | 5 |
| 1977 | 11 |
| 1978 | 11 |
| 1979 | 14 |
| 1980 | 12 |
| 1981 | 18 |
| 1982 | 7 |
| 1983 | 9 |
| 1984 | 6 |
| 1985 | 2 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 8 |
| 1989 | 8 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 11 |
| 2000 | 6 |
| 2001 | 10 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 12 |
| 2005 | 10 |
| 2006 | 10 |
| 2007 | 9 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 8 |
| 2012 | 6 |
| 2013 | 10 |
| 2014 | 11 |
| 2015 | 7 |
| 2016 | 5 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 8 |
| 2020 | 3 |
| 2021 | 6 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 6 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2009
AND c.\"highestInjuryLevel\" = 'Fatal'
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'))
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") = 2009
AND c."highestInjuryLevel" = 'Fatal'
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'))
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 ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…NTSB ERA10FA074Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Wappinger, NYA total loss of engine power due to a delamination of the No. 3 connecting rod bearing. Contributing to the accident was the inadequate maintenance inspection of the engine oil system.NTSB ERA10FA062Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Dennisville, NJThe non-instrument-rated pilot's decision to depart into known instrument meteorological conditions, which resulted in his spatial disorientation and overcontrol of the airplane and the subsequent in-flight structural failure. Contributing to the accident was…NTSB ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.NTSB WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.