NTSB investigations: Lycoming TI0-540 series, 2007
32 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\") = 2007
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") = 2007
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 NYC08IA069Incident · No injuriesIncident investigationFinal reportPiper PA-32R · Destin, FLAn in-flight fire due to a fractured fuel injector line as a result of an unauthorized repair to the line.NTSB CHI08FA054Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Warrens, WIThe decision by the pilot to fly into known adverse weather, and the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors include the clouds and the night conditions.NTSB SEA08FA046Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Orting, WAThe pilot's failure to maintain clearance from trees while maneuvering. A contributing factor was the dark night.NTSB CHI08LA044Accident · No injuriesLimited investigationFinal reportAero Commander GA-500-B · Kansas City, MOThe pilot delayed lowering the landing gear in the landing sequence and the main gear were not in the down and locked position upon touchdown.NTSB DEN08LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Trinidad, COThe pilot's failure to extend the landing gear.NTSB LAX07CA285Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Stockton, CAThe pilot's inadequate compensation for the gusty, crosswind and downdraft wind condition, which resulted in a hard landing.NTSB MIA07WA153Accident · No injuriesForeign investigationAerostar 601 · Siena, ItalyNTSB ATL07LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Pittsgrove, NJA partial loss of engine power due to low compression for undetermined reasons.NTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.NTSB CHI07FA305Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Defiance, OHThe pilot's spatial disorientation when he encountered convective turbulence which resulted in a loss of control. This encounter resulted in an in-flight break up. Contributing to the accident was the convective turbulence in the clouds.NTSB SEA07LA254Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Corona, CAFuel starvation as a result of the pilot's fuel system mismanagement and failure to select a tank containing fuel.NTSB CHI07CA282Accident · No injuriesData collectionFinal reportMooney M20M · Grand Rapids, MIThe pilot not maintaining directional control of the aircraft during the crosswind landing. Factors were the crosswind and the runway lights that were impacted.NTSB ATL07LA110Accident · 1 fatalLimited investigationFinal reportCessna T206H · Lovell, METhe pilot's failure to retract the amphibious floatplane's landing gear during a water landing.NTSB DEN07LA119Accident · Serious injuriesLimited investigationFinal reportCessna T206H · Gunnison, COAn inadvertent stall during takeoff/initial climb. Contributing factors in this accident were a partial loss of engine power for reasons undetermined, and high density altitude conditions.NTSB DEN07CA112Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Joes, COthe pilot's improper takeoff planning and subsequent failure to maintain aircraft control during the takeoff. Contributing factors were the high density altitude and tailwind.NTSB DEN07CA110Accident · No injuriesData collectionFinal reportCessna T206H · Steamboat Spngs, COThe pilot's inadvertent encounter with adverse weather conditions (dirt devils/whirlwinds) and his inability to control the airplane during that encounter resulting in the airplane impacting the runway, subsequently going off the side of the runway, and…NTSB ANC07LA059Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Kotzebue, AKLocked parking brakes and the operator's maintenance personnel's failure to properly secure the parking brake cable at its fuselage attaching clamp.NTSB DEN07CA105Accident · Minor injuriesData collectionFinal reportPiper PA-32-301T · Santa Fe, NMThe pilot's inadequate preflight planning and preparation, and improper in-flight decisions resulting in fuel exhaustion. A factor was the unsuitable terrain for landing.NTSB NYC07CA141Accident · No injuriesData collectionFinal reportPiper PA31-310 · Marietta, PAThe pilot's failure to obtain the proper touchdown point, which resulted in an undershoot.NTSB ANC07LA048Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Tuluksak, AKThe loss of engine power during cruise due to the pilot's failure to refuel the airplane prior to fuel exhaustion. Factors contributing to the accident were the delayed extension of the gear, and the gear being unlocked at touchdown.NTSB ANC07FA047Accident · No injuriesField investigationFinal reportPiper PA-32-300 · Kake, AKA fractured exhaust manifold, which resulted in an in-flight fire, and the inadequate inspection of the airplane by the operator's maintenance personnel.NTSB ATL07LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Columbia, SCThe pilot's improper landing flare, resulting in a hard landing.NTSB NYC07LA106Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Brunswick, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the attempted takeoff above the airplane's maximum gross weight, and an undetermined partial power loss, as reported by the pilot.NTSB NYC07FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Windham, CTThe pilot's failure to maintain control of the airplane during a go-around.NTSB MIA07LA084Accident · 5 fatalLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot's continued visual flight rules flight into known adverse weather conditions, resulting in an in-flight loss of aircraft control. Contributing to the accident were thunderstorms.NTSB CHI07CA109Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Walker, MNThe pilot's inadvertent failure to lower the landing gear.NTSB ATL07FA069Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Andrews, NCThe pilot's misjudgment of distance and altitude during a night approach for landing, resulting in an in flight collision with wires and the ground.NTSB SEA07LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lincoln, CAAn in-flight fire occurred during the initial climb as a result of the aviation maintenance technician's failure to sufficiently tighten the b-nut that was found disconnected post-accident. A contributing factor was the engine manufacturer's failure to…NTSB SEA07CA089Accident · No injuriesData collectionFinal reportCessna T206H · Boise, IDThe pilot's failure to maintain aircraft control which resulted in the aircraft porpoising during the landing. A factor was the wind gusts.NTSB ATL07LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Phenix City, ALLoss of engine power due to fuel starvation, the pilot's inadequate preflight planning, and his misunderstanding of how the fuel system operates. Contributing to the accident was the manufacturers insufficiently defined procedures for low fuel operations,…NTSB CHI07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Pellston, MIThe fatigue failure of the engine cylinder which resulted in a complete loss of engine power, and the unsuitable terrain encountered by the pilot during the subsequent forced landing. Contributing to the accident were the night lighting condition, and trees.NTSB DEN07CA057Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Craig, COThe pilot's improper in-flight planning and unsuitable area selected for landing. A contributing factor was the snow covered terrain and runway.