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 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.NTSB 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.NTSB ANC92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Funter Bay, AKThe pilot's attempted flight into known adverse weather.NTSB 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…NTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiNTSB FTW92LA121Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe failure of the hydraulic system seal and the subsequent fluid leak.NTSB 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.NTSB 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.NTSB 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.NTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.NTSB 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.NTSB 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.NTSB MIA92WA060Accident · No injuriesForeign investigationPiper PA-31-350 · Nagua, Dominican RepublicNTSB MIA92LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Daytona Beach, FLTotal loss of engine power for undetermined reasons.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB FTW91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Leander, TXThe pilot's failure to maintain a proper descent rate during the final approach.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB MIA91LA070Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Orlando, FLFailure of the pilot to follow proper procedures resulting in a gearup landing.NTSB 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.NTSB MIA91WA056Accident · Minor injuriesForeign investigationPiper PA-31-350 · Rock Sound, BahamasNTSB DEN91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Abilene, TXAn in flight encounter with turbulence. Factors were the pilot's inadequate aircraft preflight.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA90WA175Accident · No injuriesForeign investigationPiper PA-23-250T · AnguillaNTSB 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.