NTSB investigations: Lycoming TI0-540 series, 1990
16 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 | 9 |
|---|---|
| 1965 | 27 |
| 1966 | 32 |
| 1967 | 49 |
| 1968 | 48 |
| 1969 | 47 |
| 1970 | 48 |
| 1971 | 63 |
| 1972 | 45 |
| 1973 | 51 |
| 1974 | 62 |
| 1975 | 46 |
| 1976 | 52 |
| 1977 | 58 |
| 1978 | 68 |
| 1979 | 65 |
| 1980 | 57 |
| 1981 | 55 |
| 1982 | 47 |
| 1983 | 40 |
| 1984 | 46 |
| 1985 | 43 |
| 1986 | 43 |
| 1987 | 35 |
| 1988 | 33 |
| 1989 | 32 |
| 1990 | 16 |
| 1991 | 30 |
| 1992 | 30 |
| 1993 | 25 |
| 1994 | 26 |
| 1995 | 27 |
| 1996 | 31 |
| 1997 | 23 |
| 1998 | 22 |
| 1999 | 26 |
| 2000 | 36 |
| 2001 | 43 |
| 2002 | 46 |
| 2003 | 37 |
| 2004 | 41 |
| 2005 | 44 |
| 2006 | 49 |
| 2007 | 32 |
| 2008 | 33 |
| 2009 | 28 |
| 2010 | 34 |
| 2011 | 23 |
| 2012 | 31 |
| 2013 | 27 |
| 2014 | 25 |
| 2015 | 31 |
| 2016 | 21 |
| 2017 | 21 |
| 2018 | 22 |
| 2019 | 20 |
| 2020 | 29 |
| 2021 | 18 |
| 2022 | 28 |
| 2023 | 31 |
| 2024 | 15 |
| 2025 | 18 |
| 2026 | 19 |
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\") = 1990
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") = 1990
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 MIA91WA056Accident · Minor injuriesForeign investigationPiper PA-31-350 · Rock Sound, BahamasNTSB DEN91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Abilene, TXAn in flight encounter with turbulence. Factors were the pilot's inadequate aircraft preflight.NTSB SEA90LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Albany, ORThe pilot's decision to land with a strong tailwind resulted in the collapse of the landing gear.NTSB LAX90LA338Accident · Serious injuriesLimited investigationFinal reportMooney M-20-M · Flagstaff, AZEngine failure due to a ruptured fuel pump diaphragm. A factor in the accident was the unsuitable nature of the terrain to make a forced landing.NTSB ANC90LA173Accident · 2 fatalLimited investigationFinal reportPiper PA-32RT-300T · Glacier Island, AKUndetermined mechanical failure(s) that resulted in loss of engine power, smoke in the cockpit, and a subsequent emergency descent for a forced landing (ditching) at sea. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA90LA172Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Destin, FLThe pilots failure to obtain accurate wind information resulting in the airplane being blown off the runway on landing when a gust which exceeded the crosswind capability of the airplane was encountered.NTSB MIA90WA175Accident · No injuriesForeign investigationPiper PA-23-250T · AnguillaNTSB MIA90LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, FLThe pilots decision to depart for his destination airport in the path of approaching thunderstorms resulting in the encounter with wind gusts during landing which exceeded his limitations.NTSB NYC90LA163Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Wilmington, OHA power loss caused by fuel exhaustion when the pilot took off with the fuel selector on the empty fuel tank.NTSB CHI90FA174Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Ashton, ILA loss of aircraft control for an unknown reason, while en route in instrument meteorological conditions (IMC) on a dark night, and the pilot exceeding the design stress limits of the aircraft while attempting to recover from uncontrolled flight. Factors…NTSB CHI90LA144Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Carbondale, ILThe pilot's inability to maintain directional control during the touchdown and landing roll.NTSB CHI90LA141Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Plainfield, ILThe pilot's failure to insure that the landing gear was extended and locked prior to touchdown.NTSB MIA90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jackson, MSThe pilot's improper compensation for the cross-wind.NTSB MIA90FA090Accident · Minor injuriesField investigationFinal reportButler Aerostar 601 · Lake Butler, FLInflight failure of the left engine which was caused by inadequate maintenance and inspection by company maintenance personnel resulting in heat damaged magneto leads as a result of a missing exhaust flange-to-turbocharger seal. In addition, the inflight…NTSB MIA90WA062Accident · No injuriesForeign investigationPiper PA-23-250 · Congotown, Congo - KinshasaNTSB FTW90LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Liberty, TXLoss of engine power due to failure of the tappet faces. A factor in the accident was the unsuitable terrain in which the forced landing was made.