Fatal NTSB investigations: Lycoming TI0-540 series, 1999
6 cases on aircraft whose registry engine model is Lycoming TI0-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 | 1 |
|---|---|
| 1966 | 3 |
| 1968 | 5 |
| 1969 | 3 |
| 1970 | 1 |
| 1971 | 4 |
| 1972 | 6 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 4 |
| 1976 | 5 |
| 1977 | 6 |
| 1978 | 14 |
| 1979 | 12 |
| 1980 | 16 |
| 1981 | 13 |
| 1982 | 15 |
| 1983 | 13 |
| 1984 | 9 |
| 1985 | 7 |
| 1986 | 9 |
| 1987 | 10 |
| 1988 | 6 |
| 1989 | 8 |
| 1990 | 2 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 8 |
| 1994 | 8 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 6 |
| 1999 | 6 |
| 2000 | 6 |
| 2001 | 14 |
| 2002 | 17 |
| 2003 | 12 |
| 2004 | 16 |
| 2005 | 12 |
| 2006 | 13 |
| 2007 | 7 |
| 2008 | 11 |
| 2009 | 10 |
| 2010 | 9 |
| 2011 | 8 |
| 2012 | 14 |
| 2013 | 7 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 5 |
| 2017 | 4 |
| 2018 | 7 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 9 |
| 2024 | 1 |
| 2025 | 3 |
| 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\") = 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 ('41533'))
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 ('41533'))
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 MIA00FA043Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pelham, ALThe student pilot's decision to continue the visual flight rules flight into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB FTW00FA035Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · New Orleans, LAthe pilot's failure to maintain aircraft control which resulted in a stall/spin. A contributing factor was the dusk light condition.NTSB FTW99FA199Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Bethany, OKThe pilot's failure to maintain the minimum controllable airspeed. A factor was the disconnected rubber interconnect boot, which resulted in the partial loss of left engine power.NTSB DEN99FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Magdalena, NMThe pilot's inadvertent flight into adverse weather and the subsequent in-flight breakup. Factors were the pilot's lack of experience in high altitude flying and the thunderstorm.NTSB DEN99FA081Accident · 2 fatalField investigationFinal reportPiper PA-23E-250 · Tucumcari, NMThe pilot's inadvertent stall. A factor was the loss of power of one engine in the twin-engine airplane.NTSB MIA99LA155Accident · 1 fatalLimited investigationFinal reportAero Commander 500B · Atlantic Ocean (Atlantic Ocean)an in-flight collision with water for undetermined reasons, due to the wreckage never being recovered from the water.