Fatal NTSB investigations: Lycoming 0-540 series, 2004
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
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\") = 2004
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") = 2004
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 MIA05FA020Accident · 1 fatalField investigationFinal reportRawdon Bros. T1 · Pembroke Pines, FLImproper maintenance by company maintenance personnel, and the pilot-in-command's operating the airplane with known deficiencies, which resulted in the loss of engine power due to fuel system contamination, and a loss of control while maneuvering to return to…NTSB MIA04LA133Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-27 · Vega Baja, PRThe pilot's improper inflight planning which resulted in an inflight encounter with weather (low ceilings and thunderstorms), his loss of aircraft control, and an inflight collision with the ocean during uncontrolled descent.NTSB MIA04FA128Accident · 4 fatalField investigationFinal reportCessna R182 · Milton, FLThe pilots operation of the airplane with known deficiencies in the equipment based on witness statements describing an excessive rpm drop and rough running engine after starting, during the engine run-up, and after becoming airborne, his failure to abort the…NTSB ANC04FA092Accident · 2 fatalField investigationFinal reportMaule M-5-235C · Seward, AKThe failure of an aviation mechanic/inspector to adequately inspect the pilot/owner's work during the engine overhaul, which resulted in a loss of engine oil and engine power during cruise flight, and a subsequent ditching. Factors associated with the…NTSB DEN04FA115Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Mineral Wells, TXthe pilot's failure to maintain airspeed which resulted in a stall. A contributing factor was the low altitude.NTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…NTSB LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB MIA04FA086Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Venice, FLFailure of the pilot to recover from an improper landing flare resulting in his failure to maintain airspeed (Vs), an inadvertant stall, loss of control, and inflight collision with terrain during an uncontrolled descent.NTSB IAD04FA017Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · North Lima, OHThe pilot's failure to maintain a safe altitude clearance from trees. Factors included the night lighting conditions and the pilot's diminished night vision capability.NTSB FTW04FA057Accident · 1 fatalField investigationFinal reportCessna 182RG · El Dorado, ARThe loss of engine power as a result of loss of engine oil due to the failure of the oil filter converter plate gasket and the noncompliance to an airworthiness directive. Contributing factors were the lack of suitable terrain for the forced landing and the…