Fatal NTSB investigations: Lycoming O&VO-360 series, 2009
11 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 |
|---|---|
| 1965 | 2 |
| 1966 | 8 |
| 1967 | 5 |
| 1968 | 9 |
| 1969 | 5 |
| 1970 | 6 |
| 1971 | 4 |
| 1972 | 2 |
| 1973 | 5 |
| 1975 | 7 |
| 1976 | 4 |
| 1977 | 7 |
| 1978 | 26 |
| 1979 | 19 |
| 1980 | 20 |
| 1981 | 20 |
| 1982 | 15 |
| 1983 | 9 |
| 1984 | 14 |
| 1985 | 8 |
| 1986 | 8 |
| 1987 | 17 |
| 1988 | 9 |
| 1989 | 8 |
| 1990 | 6 |
| 1991 | 3 |
| 1992 | 8 |
| 1993 | 9 |
| 1994 | 11 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 11 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 17 |
| 2002 | 21 |
| 2003 | 25 |
| 2004 | 18 |
| 2005 | 14 |
| 2006 | 11 |
| 2007 | 6 |
| 2008 | 9 |
| 2009 | 11 |
| 2010 | 9 |
| 2011 | 8 |
| 2012 | 13 |
| 2013 | 6 |
| 2014 | 11 |
| 2015 | 2 |
| 2016 | 7 |
| 2017 | 13 |
| 2018 | 9 |
| 2019 | 16 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 7 |
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 ('41514'))
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 ('41514'))
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 CEN10LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Naytahwaush, MNThe non-instrument rated pilot's decision to continue the flight into known instrument meteorological conditions resulting in spatial disorientation and impact with terrain.NTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.NTSB CEN09LA536Accident · 2 fatalLimited investigationFinal reportBrown Steen Skybolt · Harrison, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB WPR09FA400Accident · 2 fatalField investigationFinal reportPiper PA-24 · Prescott, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering to return to the runway at a high density altitude, which resulted in an aerodynamic stall.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.NTSB WPR09FA309Accident · 4 fatalField investigationFinal reportBeech B95 · Holbrook, AZThe pilot’s decision to depart when ill and his failure to maintain control of the airplane during a return to the airport, likely because of his physical illness and drug impairment.NTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.NTSB CEN09FA340Accident · 2 fatalField investigationFinal reportGulfstream American AA-5B · Humbird, WIThe pilot's decision to attempt a visual flight rules flight into an area of known instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA09FA311Accident · 1 fatalField investigationFinal reportMooney M20D · Clintwood, VAThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB CEN09WA248Accident · 2 fatalForeign investigationPiper PA-28-181 · Steep, United KingdomNTSB CEN09FA111Accident · 2 fatalField investigationFinal reportLantzair Flyers Lancair 360 · Joliet, ILThe pilot’s failure to maintain adequate flying speed during the night takeoff for undetermined reasons, which resulted in an inadvertent aerodynamic stall and subsequent loss of control