NTSB investigations: Lycoming TI0-540 series
2,259 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, newest first
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 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 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 NYC08LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Palakta, FLThe partial loss of engine power for undetermined reasons.NTSB NYC08CA272Accident · No injuriesData collectionFinal reportPiper PA32 · Charleston, SCThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the crosswind condition and a wind gust, as reported by the pilot.NTSB DEN08LA118Accident · No injuriesLimited investigationFinal reportMooney M20M · Elbert, COThe pilot's failure to maintain aircraft control during a go-around, resulting in an aerodynamic stall. Contributing to the accident was the high density altitude.NTSB DFW08LA176Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Cookson, OKThe partial loss of engine power during initial takeoff climb for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX08FA203Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Mount Charleston, NVThe pilot's failure to maintain clearance from mountainous terrain and his selection of a cruise altitude that provided inadequate terrain clearance. Contributing to the accident were the high density altitude and the rapidly rising terrain.NTSB DEN08FA114Accident · 2 fatalField investigationFinal reportAero Commander 500S · Linwood, KSThe pilot-in-training inadvertently shutting off both engine fuel control valves causing a loss of power in both engines, and the pilot's failure to maintain control of the airplane resulting in a stall. Contributing to the accident was the chief pilot's…NTSB ANC08LA074Accident · No injuriesLimited investigationFinal reportLake L-4 · Girdwood, AKA partial loss of engine power for an undetermined reason, which resulted in a forced landing. Contributing to the accident was rough and uneven terrain.NTSB MIA08FA115Accident · 3 fatalField investigationFinal reportCessna T206H · Cedar Key, FLThe pilot’s failure to maintain clearance from the water during a dark night approach to a coastal airport.NTSB MIA08LA149Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Charlotte AmaliThe failure of maintenance personnel to identify inadequate clamping of the aluminum line during inspection, and the undetected fatigue cracking of the line which resulted in the loss of hydraulic fluid.NTSB LAX08CA158Accident · No injuriesData collectionFinal reportCessna T182T · Vandenberg, FLThe pilot's unstabilized approach and failure to maintain directional control during landing, which resulted in a veer off the runway.NTSB DEN08WA094Accident · 2 fatalForeign investigationPiper PA-46-350P · Léguillac-de-l'Auche, FranceNTSB NYC08CA179Accident · Minor injuriesData collectionFinal reportCessna T182T · Newport, RIThe pilot's failure to maintain adequate airspeed during a go-around. Contributing to the accident was the pilot's improper weather evaluation and a tailwind.NTSB DFW08LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Emporia, KSA total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.NTSB DEN08LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Houston, TXLoss of engine power for reasons undetermined. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB NYC08WA173Accident · 8 fatalClass 5 · ForeignPiper PA-31-310 · Maiquetia, VenezuelaOn April 28, 2008, about 1425 coordinated universal time (UTC), a Piper PA-31-310, N6463L, was destroyed during impact with residences, shortly after takeoff from Aeropuerto Internacional Del Centro Simon Bolivar (SVMI), Maiquetia, Venezuela. The certificated…NTSB MIA08FA094Accident · 2 fatalField investigationFinal reportMooney M20M · Midlothian, VAThe pilot’s improper control inputs resulting from spatial disorientation.NTSB DFW08LA089Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Abbeville, LAThe failure of both pilots to see and avoid the other approaching airplane. A contributing factor was the close proximity between the two private airstrips.NTSB LAX08LA080Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORThe failure of company maintenance personnel to install the upper pivot bolt through the pivot hole in the upper end of the landing gear actuating rod, and the company maintenance inspector's inadequate inspection of the work performed.NTSB MIA08CA077Accident · No injuriesData collectionFinal reportPiper PA24-260 · West Palm Beach, FLThe pilot's failure to follow the checklist resulting in a gear up landing.NTSB DFW08FA056Accident · 1 fatalField investigationFinal reportAero Commander 500B · Tulsa, OKThe pilot's loss of control due to spatial disorientation and the pilot exceeding the design/stress limits of the aircraft. Factors contributing to the accident were the pilot's reported gyro problem, the dark night conditions , and prevailing instrument…NTSB SEA08LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Placerville, CAThe collapse of the right main landing gear during landing for undetermined reasons.NTSB MIA08CA039Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lapine, ALThe pilot's failure to attain the proper touchdown point.NTSB NYC08CA084Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Brooksville, FLA deer darting into the path of the airplane during the landing roll.NTSB ANC08MA038Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kodiak, AKThe failure of company maintenance personnel to ensure that the airplane's nose baggage door latching mechanism was properly configured and maintained, resulting in an inadvertent opening of the nose baggage door in flight. Contributing to the accident were…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.