NTSB investigations: Lycoming TI0-540 series, 2021
18 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\") = 2021
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") = 2021
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 CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.NTSB WPR22FA055Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Medford, ORThe pilot’s failure to maintain aircraft control during the initial climb into clouds due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA22LA064Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · Tampa, FLThe total loss of engine power due to the failure of maintenance personnel to properly tighten the fuel supply line b-nut at the manifold valve during installation.NTSB WPR22FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20M · Snoqualmie, WAThe pilot’s decision to fly the airplane into known icing conditions, which resulted in a loss of airplane control and collision with terrain.NTSB ERA22LA042Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Flemingsburg, KYThe pilot’s failure to obtain the proper touchdown point or go-around, which resulted in a runway excursion.NTSB ERA22LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Immokalee, FLThe flight instructor’s delayed remedial action which resulted in the airplane impacting terrain short of the runway.NTSB ERA22FA014Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-260 · Blairsville, GAThe pilot’s decision to commence the flight in low IFR weather conditions, and making immediate turns after takeoff in IMC, resulting in spatial disorientation and a loss of airplane control.NTSB ERA21LA386Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH-12E · Millen, GAThe improper reassembly of the tail rotor gearbox following maintenance, which resulted in fatigue failure of the input pinion gear shaft, and the subsequent loss of tail rotor drive.NTSB GAA21WA242AccidentClass 5 · ForeignMooney M20M · Tököl, HungaryNTSB WPR21LA363Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Orcas Island, WAThe total loss of engine power due to the pilot’s mismanagement of the fuel system which resulted in fuel starvation.NTSB WPR21LA326Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Del Mar, CAThe partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.NTSB CEN21FA360Accident · 3 fatalClass 3 · FieldFinal reportMooney M20M · Victoria, MNThe pilot’s loss of airplane control due to spatial disorientation during final approach, which led to a spiral dive that overstressed the airplane and resulted in an in-flight breakup.NTSB WPR21LA256Accident · No injuriesClass 4 · LimitedFinal reportMooney M20 · Nampa, IDThe pilot’s failure to use the landing checklist and to extend the landing gear, which resulted in a gear-up landing.NTSB CEN21LA298Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Jennings, LAThe pilot’s failure to extend the landing gear before landing.NTSB CEN21LA312Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · St. Louis, MOThe pilot’s failure to maintain directional control during the landing roll with hydroplaning conditions.NTSB GAA21WA093Accident · No injuriesClass 5 · ForeignMooney M20M · Lübeck, GermanyNTSB GAA21WA051Accident · No injuriesClass 5 · ForeignPiper PA-31-350 · Buitron, MexicoNTSB CEN21LA104Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA-24-250 · New Hudson, MIThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of an instrument rating and the low visibility at the time…