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.

NTSB MIA92LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Opa Locka, FLThe pilot's inadequate compensation for wind condition and failure to maintain runway alignment during the landing roll. A contributing factor was a shifting crosswind.Jun 8, 1992 · N9307P · Substantial damageNTSB CHI92LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Round Lake, ILThe pilot-in-command's failure to follow emergency procedures, and the fire in the electrical system for reasons undetermined.Jun 1, 1992 · N812PC · DestroyedNTSB ANC92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Funter Bay, AKThe pilot's attempted flight into known adverse weather.May 25, 1992 · N15950 · Substantial damageNTSB CHI92IA141Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Valentine, NEThe failure of the pilot in command to extend the landing gear and the inattentive FAA inspector (check airman). Associated factors are the inoperative landing gear warning system, the inadequate preflight inspection by the pilot and FAA inspector, and the…May 7, 1992 · N143AC · Minor damageNTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiApr 29, 1992 · N4026W · DestroyedNTSB FTW92LA121Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe failure of the hydraulic system seal and the subsequent fluid leak.Apr 28, 1992 · N140RD · Substantial damageNTSB FTW92LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Denver, COThe loss of hydraulic fluid due to a ruptured hydraulic line in the landing gear system.Apr 3, 1992 · N6460Y · Substantial damageNTSB BFO92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Brewer, METhe pilot's failure to correct an excessive descent rate during flare. Contributing to the accident was the pilots improper compensation for wind conditions.Mar 19, 1992 · N62951 · Substantial damageNTSB LAX92LA150Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Austin, NVThe pilot's loss of control due to the failure of his control wheel during an attempted go around.Mar 16, 1992 · N4075R · Substantial damageNTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.Mar 6, 1992 · N100LC · DestroyedNTSB ANC92LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tununak, AKMisjudged wind information. Factors to the accident were: turbulence, crosswind and flight into known adverse weather.Feb 4, 1992 · N76RL · Substantial damageNTSB BFO92LA019Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Bowling Green, KYThe pilot's premature flare, stalling the airplane which resulted in a hard landing. Factors related to the accident were the dual fuel flow gauge failures and deteriorating weather conditions.Jan 13, 1992 · N9161K · Substantial damageNTSB MIA92WA060Accident · No injuriesForeign investigationPiper PA-31-350 · Nagua, Dominican RepublicDec 28, 1991 · N225CH · Substantial damageNTSB MIA92LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Daytona Beach, FLTotal loss of engine power for undetermined reasons.Dec 8, 1991 · N22213 · Substantial damageNTSB CHI92FA044Accident · 1 fatalField investigationFinal reportPiper PA-32RT/300T · Camdenton, MOThe pilot's disregard for wind conditions, not aborting the takeoff, and inadequate remedial action by the pilot after the airplane became airborne. Factors associated with the accident are an inadequate weather evaluation by the pilot, not maintaining…Dec 8, 1991 · N39555 · DestroyedNTSB CHI92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Charles City, IAProper glide path not maintained. Factors in the accident are the premature landing gear extension and inadequate airspeed by the pilot in command.Nov 12, 1991 · N9161P · Substantial damageNTSB ATL92FA019Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Darden, TNThe pilot's failure to maintain control of the airplane. The pilot exceeded the design limits of the airframe.Oct 29, 1991 · N3559J · DestroyedNTSB NYC92LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Groton, CTThe pilot's failure to maintain the minimum descent altitude during the approach. A factor was pilot fatigue.Oct 27, 1991 · N14256 · Substantial damageNTSB FTW92LA008Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Big Spring, TXThe complete loss of engine power due to a failed piston rod. A factor was the lack of suitable terrain for the forced landing.Oct 14, 1991 · N9755E · Substantial damageNTSB ANC92IA001Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Fairbanks, AKIncorrect installation of crankshaft counterwweight rollers by the manufacturer during remanufacture of the engine. Factor was the inadequate surveillance of the engine assembly process by the manufacturer.Oct 2, 1991 · N200AK · Minor damageNTSB CHI91LA299Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Boscobel, WIImproper remedial action by the pilot-in-command (PIC), and inadequate monitoring by the designated pilot examiner (DPE) during a simulated emergency procedure. Factors related to the accident were: the loss of power in one engine due to an undetermined…Sep 20, 1991 · N915PM · Substantial damageNTSB NYC91LA232Accident · No injuriesLimited investigationFinal reportPiper PA46-350P · Dayton, OHA malfunction of the elevator trim indicator and incorrect position of the trim tab which resulted in the pilot aborting the takeoff and a loss of directional control on the ground.Sep 8, 1991 · N350MM · Substantial damageNTSB BFO91FA078Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sod, WVThe improper level off which resulted in a hard landing. Contributing was fuel starvation resulting in partial loss of engine power.Aug 31, 1991 · N5435Y · DestroyedNTSB ATL91LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300D · Chamblee, GAThe pilot's premature lift off when he failed to identify rotation airspeed and the subsequent inadvertent stall of the airplane.Aug 16, 1991 · N4164W · Substantial damageNTSB LAX91LA343Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Byron, CAThe pilot's failure to refuel the airplane and his misjudging the distance to the runway.Aug 3, 1991 · N504DB · Substantial damageNTSB NYC91LA185Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Templeton, MAFuel starvation induced power loss on first the left engine due to a failed fuel fitting and then the right engine due to a worn fuel fitting. A factor was the lack of suitable terrain for the forced landing.Jul 22, 1991 · N54819 · Substantial damageNTSB LAX91LA315Accident · 2 fatalLimited investigationFinal reportPiper PA32-300 · Corona, CAThe pilot's failure to maintain an airspeed above the aircraft's stall speed after the engine failed. Factors contributing to the accident were: the failure of the engine, magneto and accessory drive gear, the rough terrain conditions over which the engine…Jul 17, 1991 · N5233S · Substantial damageNTSB LAX91LA313Accident · No injuriesLimited investigationFinal reportRockwell 500S · Kahului, HIThe pilot's inadequate preflight inspection of the aircraft after refueling. The failure of the aircraft manufacturer to publish the refueling instructions in the operator's manual, the inadequate fuel servicing of the aircraft by other maintenance personnel…Jul 15, 1991 · N260AC · Substantial damageNTSB CHI91LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Flint, MIPropeller pitch change mechanism sheared. Factors related to the accident were powerplant vibration and proper touchdown point not possible.Jul 14, 1991 · N8803P · Substantial damageNTSB NYC91LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rhinebeck, NYThe pilot did not calculated the airplane's performance data to insure that he had enough runway to clear an obstacle at the end of the field, which resulted in the airplane's landing gear striking high hedges, subsequently the pilot elected to land in a…Jul 2, 1991 · N5002F · Substantial damageNTSB DEN91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Englewood, COThe pilot's failure to maintain visual lookout. A factor was: the pilot's improper use of the throttle controls and brakes.Jun 19, 1991 · N4064R · Substantial damageNTSB MIA91LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Clearwater, FLInadequate annual inspection of the airplane by maintenance personnel who failed to detect a deteriorated oil line. This resulted in oil exhaustion causing the total loss of engine power due to failure of one of the connecting rods. Also inadvertent…May 9, 1991 · N55653 · Substantial damageNTSB ANC91LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKWas the hard landing caused when the pilot encountered a downdraft during the final approach portion of the landing. Contributing to the accident was the downdraft and the dirt/river bank just short of the runway.May 3, 1991 · N4593T · Substantial damageNTSB DEN91FA065Accident · 1 fatalField investigationFinal reportPiper PA-31B-310 · Bennett, COIn-flight separation of the left engine cowl assembly that was not properly latched, and failure of the pilot to maintain minimum control speed, which resulted in his loss of aircraft control. Factors related to the accident were: an inadequate preflight…May 1, 1991 · N7407L · DestroyedNTSB ANC91LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kasigluk, AKThe pilot's failure to maintain directional control of the airplane on landing. Contributing to the accident was the snowbank.Mar 28, 1991 · N76RL · Substantial damageNTSB FTW91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Leander, TXThe pilot's failure to maintain a proper descent rate during the final approach.Mar 5, 1991 · N9190A · Substantial damageNTSB ATL91FA052Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Munford, ALThe pilot attempting visual flight in instrument meteorological conditions below the minimum safe altitude for terrain clearance. Contributing factors were the low ceiling and mountainous terrain.Feb 7, 1991 · N27818 · DestroyedNTSB ATL91IA050Incident · No injuriesIncident investigationFinal reportPiper PA-60-600 · Cochran, GAFailure of the right engine shutoff valve which resulted in a complete loss of engine power. The airplane veered off the right side of the runway and the right main landing gear collapsed as a result of the pilots failure to maintain directional control…Feb 5, 1991 · N6070D · Minor damageNTSB ATL91FA047Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Cordele, GAFailure of the pilot to attain proper runway alignment and to maintain proper altitude. Related factors were: darkness and the pilot becoming lost/disoriented.Feb 3, 1991 · N9209P · DestroyedNTSB ATL91FA040Accident · 4 fatalField investigationFinal reportRockwell 114 · Bessemer, ALFailure of the pilot to follow instrument flight rules (IFR) and maintain the minimum descent altitude (mda) during the VOR approach. Factors related to the accident were: darkness and the adverse weather conditions.Jan 20, 1991 · N4827W · DestroyedNTSB MIA91LA070Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Orlando, FLFailure of the pilot to follow proper procedures resulting in a gearup landing.Jan 19, 1991 · N27759 · Substantial damageNTSB ANC91IA020Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Nome, AKWas the sheared fitting on the nose gear actuator shuttle valve which caused the nose gear to not extend for landing.Jan 15, 1991 · N4118G · Minor damageNTSB MIA91WA056Accident · Minor injuriesForeign investigationPiper PA-31-350 · Rock Sound, BahamasDec 28, 1990 · N141RA · DestroyedNTSB DEN91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Abilene, TXAn in flight encounter with turbulence. Factors were the pilot's inadequate aircraft preflight.Nov 7, 1990 · N6078Y · Substantial damageNTSB 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.Sep 29, 1990 · N22450 · Substantial damageNTSB 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.Sep 29, 1990 · N9161D · DestroyedNTSB 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.Sep 8, 1990 · N393HM · Substantial damageNTSB 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.Aug 23, 1990 · N8756P · Substantial damageNTSB MIA90WA175Accident · No injuriesForeign investigationPiper PA-23-250T · AnguillaAug 7, 1990 · N43HB · Substantial damageNTSB 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.Jul 25, 1990 · N32446 · Substantial damage