Fatal NTSB investigations: Lycoming IO-540 series, 2001
10 cases on aircraft whose registry engine model is Lycoming IO-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
| 1971 | 1 |
|---|---|
| 1978 | 2 |
| 1979 | 2 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 1 |
| 1997 | 6 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 4 |
| 2001 | 10 |
| 2002 | 21 |
| 2003 | 12 |
| 2004 | 10 |
| 2005 | 11 |
| 2006 | 11 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 7 |
| 2010 | 13 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 9 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 9 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 7 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 3 |
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\") = 2001
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 ('41530', '41585'))
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") = 2001
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 ('41530', '41585'))
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 LAX02FA031Accident · 5 fatalField investigationFinal reportAero Commander 500S · Eagleville, CAthe pilot's encounter with forecast mountain wave conditions, moderate or greater turbulence, and icing, with downdrafts that likely exceeded the climb capability of the airplane, which was encountered at an altitude that precluded recovery. Also causal in…NTSB CHI02FA034Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spearville, KSthe pilot's failure to maintain aircraft control and his inadvertent flight into known adverse weather conditions. Factors relating to this accident were the pilot's limited ability to see at night, spatial disorientation, the dark night, and the fog.NTSB LAX02FA019Accident · 1 fatalField investigationFinal reportCessna 182S · Little River, CAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB ATL01FA105Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Byhalia, MSThe pilot's improper evaluation of weather conditions which lead to an inflight encounter with turbulent weather resulting in an in flight break up of the airframe, and subsequent uncontrolled descent into terrain. A factor was the pilot's drug impairment.NTSB ANC01FA106Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Kotzebue, AKThe pilot's failure to maintain adequate clearance from an obstruction (antenna tower), and his continued flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, and low visibility.NTSB ANC01FA093Accident · 6 fatalField investigationFinal reportPiper PA-32-300 · Haines, AKThe pilot's continued flight into known adverse weather conditions, and his poor in-flight decision making. Factors associated with the accident were clouds and mountainous terrain. A finding is the pilot's use of FAA prohibited drugs.NTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.NTSB IAD01FA070Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Greenwich, CTThe pilot's failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation. Factors in the accident were the fog, and the pilot's use of a sedating medication.NTSB MIA01FA108Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Marco Island, FLThe failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…NTSB ATL01FA019Accident · 1 fatalField investigationFinal reportCessna 206H · Vandiver, ALThe pilot's inflight decision to continued visual flight into instrument meteorological conditions resulted in the inflight collision with trees. Low ceilings and trees were factors