Fatal NTSB investigations: Lycoming 0-540 series, 2009
10 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 5 |
|---|---|
| 1965 | 4 |
| 1966 | 2 |
| 1967 | 7 |
| 1968 | 7 |
| 1969 | 6 |
| 1970 | 10 |
| 1971 | 3 |
| 1972 | 5 |
| 1973 | 2 |
| 1974 | 4 |
| 1975 | 3 |
| 1976 | 4 |
| 1977 | 7 |
| 1978 | 8 |
| 1979 | 8 |
| 1980 | 11 |
| 1981 | 8 |
| 1982 | 12 |
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 12 |
| 1986 | 5 |
| 1987 | 7 |
| 1988 | 6 |
| 1989 | 9 |
| 1990 | 5 |
| 1991 | 7 |
| 1992 | 7 |
| 1993 | 6 |
| 1994 | 8 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 8 |
| 1999 | 1 |
| 2000 | 6 |
| 2001 | 9 |
| 2002 | 7 |
| 2003 | 10 |
| 2004 | 10 |
| 2005 | 8 |
| 2006 | 11 |
| 2007 | 7 |
| 2008 | 7 |
| 2009 | 10 |
| 2010 | 8 |
| 2011 | 11 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 5 |
| 2020 | 6 |
| 2021 | 10 |
| 2022 | 8 |
| 2023 | 8 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 6 |
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 ('41532'))
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 ('41532'))
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 WPR10FA068Accident · 2 fatalField investigationFinal reportSchleicher ASW-27 · Middletown, CAThe failure of both pilots to see and avoid the other airplane. Contributing to the accident was the pilot's failure to yield right of way to the glider.NTSB WPR10FA005Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Black Canyon City, AZThe pilot's decision to continue VFR flight into instrument meteorological weather conditions which resulted in controlled flight into terrain. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB ERA09FA417Accident · 4 fatalField investigationFinal reportRobinson Helicopter R44 · Boonsboro, MDThe pilot’s improper decision to depart on a visual flight rules (VFR) flight at night in adverse weather conditions in close proximity to rising mountainous terrain in a helicopter that was only certified to be operated under VFR and his subsequent failure…NTSB ERA09FA411Accident · 1 fatalField investigationFinal reportCessna R182 · Hayesville, NCFlight into terrain for undetermined reasons.NTSB ANC09WA063Accident · 1 fatalForeign investigationMaule M-5-235C · Whitehorse, CanadaOn July 13, 2009, about 2145 pacific daylight time, a float-equipped Maule M-5-235C airplane, N9138E, nosed over and partially sank while landing on Kluane Lake, about 127 miles northwest of Whitehorse, Yukon, Canada. The airplane was being operated as a…NTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…NTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.NTSB WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.NTSB CEN09LA144Accident · 3 fatalLimited investigationFinal reportCox William M Bearhawk · Anahuac, TXA loss of control in flight for undetermined reasons.NTSB ERA09LA131Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Pensacola, FLThe pilot’s failure to maintain airspeed following a total loss of engine power during a low-level approach, which resulted in an aerodynamic stall. Contributing to the accident was fuel exhaustion due to the pilot’s inadequate preflight planning.