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 LAX98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Healdsburg, CAthe pilot's misjudged distance and altitude relationship to the runway during a short field approach, which resulted in an undershoot and a hard landing.NTSB NYC98LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Perkasie, PAThe flight instructor failure to maintain directional control, which resulted in an off runway landing, after the left engine was reported to have lost power.NTSB FTW98LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Midlothian, TXfatigue failure of the #2 cylinder fuel injection line in an area where the line was previously damaged, which resulted in an in-flight engine compartment fire and a forced landing. Related factors were: the previous damage of the fuel injector line, and the…NTSB FTW98LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Galveston, TXinadequate maintenance and/or preflight inspection of the airplane, and subsequent blockage of the fuel filters, which led to fuel starvation, partial loss of engine power in both engines, and a forced landing. A related factor was the lack of suitable…NTSB MIA98LA014Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Miami, FLloss of engine power for an undetermined reason(s), which resulted in a forced landing and subsequent encounter with rough water.NTSB SEA97LA220Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Stuart Island, WAThe pilot's improper decision to land on a wet grass runway with a ten knot tailwind. Factors were the wet runway surface and tailwind.NTSB FTW97LA357Accident · No injuriesLimited investigationFinal reportMooney M20M · Broomfield, COThe pilot's flaring of the airplane prematurely at a low airspeed that resulted in a hard landing, and an inadvertent stall during the attempted go-around and subsequent loss of control.NTSB CHI97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fargo, NDthe pilot's misjudgment of altitude and distance to the runway, while on final approach to land, and failure to attain the proper touchdown point on the runway during the landing. The exposed runway lip was a related factor.NTSB MIA97LA243Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Oxford, NCfatigue failure of the No.4 connecting rod in an area where galling had occurred, which resulted in loss of engine power and a forced landing. Related factors were: the pilot's lack of communication by failing to select the proper UNICOM frequency; and his…NTSB CHI97LA277Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAinadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.NTSB MIA97LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Burnsville, NCThe failure of the pilot to use the checklist to confirm that the main cabin door was closed and locked before takeoff. Also, failure of the pilot to attain the proper touchdown point during the precautionary landing. Contributing to the accident was the self…NTSB FTW97LA267Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Denver, COinadequate visual lookout by the bus driver. Factors relating to the accident were: darkness and bright background lighting.NTSB ANC97FA097Accident · 4 fatalField investigationFinal reportPiper PA-32 · Skagway, AKjamming/failure of the left magneto impulse coupling, which stopped rotation of the magneto gear, and resulted in subsequent shearing of the accessory intermediate idler gear. Factors relating to the accident were: the lack of suitable terrain for a forced…NTSB FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…NTSB FTW97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Greeley, COunlatching of the left outboard engine cowling latches for undetermined reason(s), which allowed the left engine cowling to separate inflight and strike the vertical stabilizer.NTSB ATL97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sparta, TNA fire in the left engine started by a leak in the fuel pump.NTSB LAX97LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Burbank, CAimproperly secured upper cowl fasteners by unknown person(s).NTSB FTW97FA171Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Rye, COThe pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.NTSB ANC97LA069Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Selawik, AKThe pilot's failure to extend the landing gear. A factor associated with the accident was the pilot's diverted attention while in the landing pattern.NTSB CHI97LA110Accident · Serious injuriesLimited investigationFinal reportGulfstream 500B · Mission, KSthe pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB NYC97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Belmar, NJThe student pilot's improper decision to taxi off the runway into sand after the nose gear collapsed. A factor in the accident was the student pilot's improper flare.NTSB ANC97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKa fuel leak from an engine driven fuel pump which initiated an engine fire, and the fuel pump manufacturer's inadequate quality control of the fuel pump.NTSB FTW97LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Salida, COThe airplane's performance being exceeded due to the pilot's inadequate preflight planning. Factors were the uphill runway, high density altitude, and the pilot's lack of experience performing takeoffs from a high altitude airport.NTSB MIA97WA044Accident · No injuriesForeign investigationPiper PA-23-250 · Walker Cay, BahamasNTSB MIA97FA031Accident · 1 fatalField investigationFinal reportPiper PA32-300D · Reform, ALa complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.NTSB ANC97LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Nunapitchuk, AKthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing. Factors associated with the accident were: the low fuel condition, which led to a single engine landing, and the crosswind condition.NTSB CHI97LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Lansing, ILthe pilot's improper planning/decision, and his failure to go around, while there was still sufficient runway remaining. The unfavorable wind condition was a related factor.NTSB MIA97WA017Accident · 2 fatalForeign investigationPiper PA-32-300 · St. Vincent, WNNTSB MIA97IA016Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Mccomb, MSthe lineman's fueling of the aircraft with the wrong type fuel, the pilot's failure to verify the type of fuel added to the aircraft before flight, and failure of the refueling facility to be equipped with the proper fuel nozzle.NTSB FTW97LA027Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Lubbock, TXthe pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB ATL96LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Georgetown, SCfailure of maintenance personnel to comply with an airworthiness directive, requiring periodic magneto inspections; inadequate annual inspection of the airplane by (other) maintenance personnel; and subsequent failure of the impulse coupling in the left…NTSB CHI96LA335Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Janesville, WIfuel exhaustion as a result of an inadequate preflight by the pilot in command.NTSB FTW97LA029Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Stanton, TXPilot's failure to maintain clearance with a wire resulting in the separation of the rudder and a loss of aircraft control.NTSB FTW96GA365Accident · 2 fatalFinal reportPiper PA-23-250 · Jennings, LAThe pilot's failure to maintain clearance. Factors were the pilot's lack of recent experience in the make and model of airplane, the dark night, and fog.NTSB CHI96LA333Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Chicago, ILthe pilot's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's improper flare during the forced landing.NTSB MIA96LA187Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · St Petersburg, FLa loss of engine power due to fuel contamination, which resulted in a forced landing (ditching) in water. Factors relating to the accident were: an inadquate annual inspection by maintenance personnel, and an inadequate preflight inspection by the pilot.NTSB FTW96LA302Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Rogers, ARfuel exhaustion due to the pilot's failure to refuel. Factors were the below landing minimums weather conditions and the lack of suitable terrain for the forced landing.NTSB IAD96LA110Accident · No injuriesLimited investigationFinal reportMooney M20M · Hartford, CTthe pilot's inadequate control of the airplane during the approach to landing/landing roll. A related factor is the pilot's inadequate remedial action (attempted go-around).NTSB SEA96LA164Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hillsboro, ORblockage of the vents to both wing fuel tanks, after unknown personnel failed to remove tape (protective covering) from the vents, which resulted in collapsed fuel tanks (and wing damage).NTSB NYC96LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Williamstown, NJinadequate maintenance, which resulted in a failure of the magneto housing hold-down flange, a disconnect of the magneto from the engine, and loss of engine power. The obstruction (fence post) in the emergency landing area was a related factor.NTSB LAX96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Kernville, CAthe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain a proper rate of descent.NTSB ATL96FAMS1Accident · 3 fatalMissing aircraftFinal reportAero Commander 500-B · MissingUndetermined.NTSB NYC96LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Matawan, NJthe pilot's misjudgment of altitude and distance during final approach.NTSB NYC96FA073Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bridgeport, WVThe pilot's inablility to maintain aircraft control due to a full nose down trim condition, which resulted in a loss of control and collision with terrain.NTSB FTW96LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Sulphur Springs, TXthe pilot's failure to maintain terrain clearance. A factor was his diverted attention to the performance of the manual gear extension procedure.NTSB LAX96FA122Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Grand Canyon, AZthe failure of the pilot to maintain directional control of the aircraft after landing. Contributing to the accident was the icy runway conditions with poor braking.NTSB FTW96LA139Accident · No injuriesLimited investigationFinal reportRockwell 500U · Hampton, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB ATL96TA047Accident · Minor injuriesFinal reportPiper PA-32-300 · Windermere, FLthe use of improper connecting rod bolts, failure of the overhaul facility to record the correct overhaul date on the work orders for the stored connecting rod assemblies, and subsequent failure of the connecting rod bolts.NTSB MIA96FA078Accident · 3 fatalField investigationFinal reportAero Commander 500S · Manati, PRFailure of the flight crew, for undetermined reasons, to recover from a stall and resulting uncontrolled descent. This resulted in the aircraft colliding with the terrain while in a 45-60 degree nose down attitude at a slow speed.NTSB FTW96LA114Accident · No injuriesLimited investigationFinal reportMooney M20M · Alpine, TXThe pilot's failure to maintain airspeed during a misjudged landing flare resulting in a hard landing.