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 ANC01LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Chefornak, AKThe pilot's inadvertent stall/mush during the final phase of the landing approach. A factor associated with the accident is a crosswind.NTSB DEN01LA100Accident · No injuriesLimited investigationFinal reportCessna T206H · Watkins, COthe pilot's failure to maintain the proper decent rate during the flare resulting in a hard landing. Contributing factors icing conditions and accumulations of wing ice.NTSB MIA01LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Wilmington, NCA total loss of engine power due to the failure of maintenance to properly secure the fuel selector cover, resulting in the pilot inadvertently selecting "off" instead of "left" tank, and the subsequent forced landing to uneven terrain.NTSB NYC01IA126Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Newark, OHThe company maintenance personnel's failure to comply with the service bulletin, which resulted in a fuel boost pump leakage and subsequent fire during taxi. A factor was the manufacturer's confusing service bulletin.NTSB MIA01FA126Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Fort Lauderdale, FLThe pilot's exceeding the forward center of gravity (CG) ) limits at the time of engine start, the inability of the pilot to control the airplane due to the exceeded CG limits, the failure of the pilot to abort the takeoff with sufficient runway remaining,…NTSB DEN01LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 1731A · Hobbs, NMthe pilot's failure to maintain directional control during flare/landing.NTSB MIA01FA107Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Concord, NCAn in-flight collision with terrain for undetermined reasons.NTSB LAX01FA113Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Essex, CARupture of the fuel injection flow divider diaphragm due to improper manufacture of the raw material stock from which the diaphragm was fabricated. The diaphragm tear resulted in complete engine power loss, which required the pilot to descend into an…NTSB NYC01WA082Accident · 2 fatalForeign investigationAero Commander 500S · Kross, IcelandNTSB MIA01LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300T · Gulfport, MSthe pilot's attempted flight into known adverse weather, resulting in an in flight loss of control, exceedance of design limits of the aircraft, and wing separation prior to collision with water.NTSB LAX01FA103Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Paso Robles, CAThe pilot/owner/operator's failure to maintain control of the airplane during the takeoff initial climb resulting in an in-flight collision with terrain. Contributing to the accident was the dark night light condition.NTSB FTW01LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA32-R-301T · Haslet, TXthe improper installation of the oil filter bypass valve by an unknown person, which resulted in the loss of engine oil and subsequent loss of total power during a normal descent. A contributing factor to the accident was the lack of suitable terrain for the…NTSB MIA01LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeland, FLThe pilot's failure to disengage the parking brake prior to taxi and his failure to stop and investigate the brakes when they malfunctioned during taxi for takeoff resulting in the wheel brakes heating and starting the tires on fire.NTSB MIA01GA070Accident · 2 fatalFinal reportPiper PA-32-300 · Marathon, FLThe pilot-in-command's lack of recent experience in instrument flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water while descending.NTSB CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.NTSB CHI01TA063Accident · Serious injuriesFinal reportPiper PA-23 · Griffith, INThe unsuitable terrain for landing encountered by the pilot. Factors included the loss of power for undetermined reasons and the rough terrain.NTSB ANC01LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Deadhorse, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were clouds, fog, dusk light conditions, and the pilot's self-induced pressure to complete the flight prior to nightfall.NTSB MIA01FA043Accident · 1 fatalField investigationFinal reportPiper PA-31-325 · Belvidere, NCThe pilot's failure to maintain airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions resulting in the airplane entering a descending turn and crashing into terrain.NTSB CHI01LA042Accident · No injuriesLimited investigationFinal reportAerostar PA-60-601P · Preston, MNaltitude/clearance from the trees not being obtained/maintained by the pilot. Factors to the accident were the trees and the contamination of the pitot/static system.NTSB CHI01LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tecumseh, MIThe pilot was unable to rotate the aircraft during takeoff for undetermined reasons. A factor associated with the accident was the soft terrain, which the airplane encountered during the aborted takeoff.NTSB DEN01LA023Accident · No injuriesLimited investigationFinal reportCessna 310N · Montrose, COthe pilot's inadequate airspeed on final approach which resulted in a hard landing. A contributing factor was wind shear.NTSB DEN01LA005Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Grand Junction, COTotal failure of the right forward inboard landing gear door hinge pin for undetermined reasons.NTSB DEN00LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Blanding, UTThe pilot's failure to follow the checklist and lower the landing gear for landing. A factor was diverted attention.NTSB CHI00LA303Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · Jeffersonville, INthe pilot's inadequate normal braking and the pilot's inability to stop the airplane on the runway. Factors relating to this accident were the hydroplaning conditions, wet runway, the tailwind, the trees, and the ravine.NTSB ANC00LA133Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Emmonak, AKThe pilot's continued operation of the airplane on unsuitable terrain, and the subsequent failure of the main landing gear torque link. Factors in the accident were rough and uneven runways, and inadequate surveillance of airport facilities/runway conditions…NTSB NYC00LA254Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Factoryville, PAThe pilot's failure to attain the proper touchdown point.NTSB CHI00LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Mason City, IAthe unsuitable terrain for landing encountered by the pilot and the failure of the oil filter converter plate gasket. Factors to the accident were the total loss of oil and the soft terrain condition.NTSB LAX00LA339Accident · No injuriesLimited investigationFinal reportCessna 210E · Holbrook, AZThe lack of elevator control during final approach, for undetermined reasons, that resulted in a hard landing.NTSB LAX00FA310Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hilo, HIDeterioration and failure of the oil filter converter plate gasket, which resulted in a loss of engine power and a subsequent in-flight fire.NTSB ATL00FA081Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Lumber City, GAPilot's failure to follow instrument procedures and descended below approach minimums and collided with trees. A factor was low clouds.NTSB CHI00LA255Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Omaha, NEthe landing gear not deployed, the checklist not followed, the lack of familiarity with the airplane, the landing gear warning system not understood, and the landing gear warning disregarded by the pilot.NTSB DCA00MA080Accident · 11 fatalMajor investigationFinal reportPiper PA-31 Navajo · Burlington Twp., NJthe failure of the pilots of the two airplanes to see and avoid each other and maintain proper airspace separation during visual flight rules flight.NTSB ATL00FA075Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Augusta, GAImproper preflight planning/preparation by the pilot, which resulted in taking off with the airplane exceeding the weight and balance limitations. Factors to the accident were the improper loading of the airplane, taking off from a short, up sloping runway…NTSB SEA00LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birkenfeld, ORThe pilot's delayed go-around, which resulted in the aircraft not clearing the fence posts. A contributing factor was the fence posts.NTSB LAX00LA277Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Boulder City, NVThe fatigue fracture and separation of the No. 6 cylinder fuel injector line due to the company maintenance personnel's failure to comply with an Airworthiness Directive. A factor in the accident was the company's decision to operate the aircraft in…NTSB MIA00LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Immokalee, FLThe inadequate supervision of the pilot rated student by the CFI for her failure to note that the fuel selector was positioned to an empty fuel tank. Also, failure of the CFI to attain the proper rate of descent at touchdown resulting in a hard landing.…NTSB MIA00WA209Accident · Serious injuriesForeign investigationPiper PA32-300 · Staniel Cay, BahamasNTSB DEN00LA120Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-350P · Spanish Fork, UTFailure by the pilot to maintain control of the aircraft during initial climb following takeoff.NTSB NYC00LA158Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Wauseon, OHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.NTSB FTW00LA176Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Del Rio, TXThe separation of the #3 connecting rod, piston, and cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA170Accident · No injuriesLimited investigationFinal reportAero Commander 700 · Breckenridge, TXFuel exhaustion as a result of an inaccurate fuel quantity indicating system. A factor was the lack of suitable terrain for the forced landing.NTSB ANC00IA063Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tanana, AKAn in-flight oil leak due to the deterioration of oil filter adapter plate gasket material, and the supplier's distribution of inadequate material. A factor associated with the accident was the engine manufacturer's inadequate quality control.NTSB DEN00IA093Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Erie, COImproper installation of cylinders by unknown maintenance personnel who failed to torque the cylinder stud nuts sufficiently.NTSB DEN00FA086Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Estes Park, COA descent below the surrounding terrain, by the pilot, in IMC conditions. Factors were high mountainous terrain, clouds, inaccurate weather evaluation by the pilot, and the pilot's flight into IMC conditions.NTSB ATL00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-200 · Mt. Pleasant, SCThe airplane collision with a deer during a night landing.NTSB MIA00LA140Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Vieques, PRThe pilot's improper compensation for wind conditions during approach to landing resulting in the aircraft touching down hard, short of the runway, and receiving substantial damage.NTSB ANC00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe pilot's misjudgment of distance/altitude, and subsequent undershoot during landing. Factors in the accident were light snow precipitation, flat light conditions, snow-covered terrain, and the absence of a visual approach slope indicator.NTSB LAX00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Coalinga, CAThe failure of the landing gear for undetermined reasons to go into the locked position after the pilot conducted a manual and emergency gear extension. A factor in the accident was the undetermined failure of the electrical system.NTSB MIA00LA077Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · W. Columbia, SCThe inadequate wording of the NOTAM for failure to identify that the usable width of the runway was reduced and the inadequate snow removal by airport personnel for failure to remove the snow from the runway resulting in the on-ground collision with a snow…NTSB NYC00LA069Accident · No injuriesLimited investigationFinal reportMooney M20M · Montpelier, VTA blocked crankcase breather line due to ice and improper maintenance which resulted in further restricting the line. A factor in this accident was the below freezing outside air temperature.