Fatal NTSB investigations: Lycoming IO-540 series, 1999
7 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
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\") = 1999
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") = 1999
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 MIA00LA025Accident · 1 fatalLimited investigationFinal reportFrederick Rocket II · Coral Springs, FLThe pilot's failure to maintain airspeed while maneuvering (VSO) resulting in an inadvertent stall and subsequent in-flight collision with water. Contributing to the accident was the pilot's improper fuel management resulting in a total loss of engine power…NTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.NTSB DEN99FA066Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar 601P · Ruidoso, NMThe pilot's failure to maintain aircraft control for undetermined reason. A factor was the low ceiling IMC weather condition.NTSB FTW99FA104Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Waldron, ARThe pilot's encounter with adverse weather and loss of aircraft control, which resulted in exceeding the aircraft's design stress limits. Factors were the pilot's lack of total experience in the make and model of airplane, and the icing and thunderstorm…NTSB NYC99LA063Accident · 1 fatalLimited investigationFinal reportPiper PA 32R-301 · Dulles, VAThe FBO employee's diverted attention, resulting in an inadvertent encounter with a rotating propeller.NTSB ATL99FA048Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Cartersville, GAIn flight collision with terrain for undetermined reasons.NTSB IAD99FA025Accident · 1 fatalField investigationFinal reportLake LA-4-250 · Laconia, NHA loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.