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 ANC02IA093Incident · Serious injuriesIncident investigationFinal reportPiper PA-31-350 · Talkeetna, AKThe passenger's incapacitation during a high altitude flight due to a loss of consciousness as the result of a pre-existing cardiovascular condition. A contributing factor in the incident was the operator's improper use of disposable oxygen masks without a…NTSB CHI02LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Beaumont, KSThe pilot's inadequate preflight planning and his failure to abort the takeoff when he realized the aircraft was not accelerating as expected. The wet and muddy turf runway was a contributing factor.NTSB ATL02WA116Accident · 2 fatalForeign investigationAero Commander 500-B · Roseau, DominicaNTSB NYC02FA106Accident · 2 fatalField investigationFinal reportCessna A185F · Pleasant Mount, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.NTSB ANC02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Noorvik, AKThe partial loss of engine power during the climb to cruise for an undetermined reason, which resulted in a forced landing in soft terrain. A factor associated in the accident was the lack of suitable terrain for the forced landing.NTSB LAX02FA166Accident · 2 fatalField investigationFinal reportSocata TB-21 · New River, AZthe pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition, and the…NTSB FTW02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Bogalusa, LAa deer that ran in front of the airplane during the takeoff phase. A contributing factor was the lack of an airport perimeter fence to prevent deer from entering the runway environment.NTSB LAX02LA140Accident · No injuriesLimited investigationFinal reportCessna T206H · Sedona, AZThe pilot's inadequate compensation for the variable, gusty and crosswind conditions, which led to a bounced landing and a subsequent pilot induced porpoise oscillation. A factor in the accident was the pilot's decision to continue the landing in a crosswind…NTSB CHI02LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Valparaiso, INThe pilot not maintaining aircraft control while encountering windshear during initial climbout, resulting in a stall at a low altitude.NTSB ATL02IA079Incident · No injuriesIncident investigationFinal reportRockwell International 500-S · Jackson, ALThe pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, loss of engine power in both engines, and subsequent forced landing in a field.NTSB MIA02FA079Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Palm Bay, FLThe in-flight loss of control for undetermined reasons resulting in the in-flight collision with terrain.NTSB MIA02IA072Incident · No injuriesIncident investigationFinal reportPiper PA-31-325 · Fort Laudedale, FLThe failure of the pilot to assure all items of the before landing checklist were complied with before landing, resulting in the wheels up landing.NTSB MIA02FA067Accident · 1 fatalField investigationFinal reportPiper PA32R-300 · Broadway, NCThe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.NTSB SEA02GA053Accident · 3 fatalFinal reportPiper PA-31 · Atlanta, IDThe pilot's failure to maintain aircraft control while in cruise flight which resulted in the in-flight separation due to overload of the spar at the right wing root. Hypoxia was a factor.NTSB ATL02FA057Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hamilton, GAThe loss of engine power for undetermined reasons.NTSB DEN02LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Ferron, UTa loss of engine power due to the ingestion of foreign object(s) into the meshing of the gears, causing a malfunction of the magneto idler gear and failure of maintenance personnel to detect the signs of imminent failure during a mandatory oil filter…NTSB NYC02LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Atlantic City, NJThe pilot's failure to lower the landing gear prior to landing.NTSB NYC02FA060Accident · 1 fatalField investigationFinal reportRockwell 500S · Exeter, RIThe pilot's failure to maintain control after encountering icing conditions while on approach for landing. Factors in this accident were the night light conditions and pilot's failure to select the airplane's propeller de-icing switches to the "on" position.NTSB MIA02LA061Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Belle Glade, FLthe pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.NTSB ATL02FA043Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Atlanta, GAThe pilot experienced spatial disorientation that resulted in the loss of control.NTSB DEN02LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Pagosa Springs, COthe total power failure of the right engine due to the failure of its lubricating system. Contributing factors were the lack of suitable terrain for a forced landing, and the terrain being above the airplane's single engine performance capability.NTSB MIA02FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Micanopy, FLThe pilot's experiencing spatial disorientation while maneuvering at a low altitude at night under visual meteorological conditions which resulted in an uncontrolled descent and an in-flight collision with a tree.NTSB MIA02FA048Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hollywood, FLThe pilot's inadequate planning for a Title 14 CFR Part 135 on-demand air taxi flight, and his failure to refuel the airplane, which resulted in fuel exhaustion while en route over the Atlantic Ocean, a power off glide, and ditching in the ocean.NTSB CHI02LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Olathe, KSThe pilot's failure to maintain directional control during landing resulting in the overload of the nose gear fork. The overload failure of the nose landing gear fork, the embankment, and the remedial action not possible were contributing factors.NTSB LAX02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Groveland, CAThe pilot's collision with an unobserved animal that entered the active runway during the dark nighttime when the pilot's visibility was diminished.NTSB MIA02FA044Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Raleigh, NCthe pilot's failure to maintain control of the airplane, due to spatial disorientation, while performing a missed approach, resulting in an uncontrolled descent, and subsequent impact with a tree and a house. Factors in this accident were dark night, fog,…NTSB FTW02LA052Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Duncan, OKThe pilot's descent below the minimum descent altitude, and his failure to maintain obstacle clearance. Contributing factors were the below approach/landing minimum weather, the dark night conditions, and the inoperative REIL's.NTSB MIA02WA043Accident · No injuriesForeign investigationPiper PA-32R-300 · Rum Cay, BahamasNTSB CHI02FA042Accident · 2 fatalField investigationFinal reportMooney M20M · Evansville, INThe fatigue failure of the turbocharger exhaust band clamp and aircraft control not possible by the pilot due to the fire.NTSB FTW02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Galveston, TXthe pilot's failure to set the parking brake before exiting the aircraft to remove the wheel chocks.NTSB CHI02LA019Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Phillips, WIThe fuel starvation encountered on takeoff and unsuitable terrain the pilot encountered during the forced landing. A factor was the fuel selector valve malfunction.NTSB ATL02LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Wales, FLThe pilot's improper decision to land on a wet sod runway which resulted in a loss of directional control during landing. Factors were the wet grass strip which allowed the airplane to hydroplane.NTSB IAD01LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Medina, OHfatigue failure of the dual magneto mounting flanges that resulted from undetected contact damage sustained during a previous installation, which resulted in its separation from the engine during take-off.NTSB DEN01FA161Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Pagosa Springs, COthe flight crews' intentional low altitude flight, and failure to maintain obstacle clearance.NTSB CHI01FA312Accident · Serious injuriesField investigationFinal reportPiper PA-32R-301T · Downers Grove, ILthe improper preflight planning/preparation and the short field take off/procedure not followed by the pilot. Contributing factors were the airplane's forward center of gravity, the variable gusting wind and improper weight and balance calculations by…NTSB NYC01FA223Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bern Township, PAThe pilot's loss of control for undetermined reasons, which resulted in a high speed dive to the ground.NTSB DEN01LA132Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Grand Junction, COthe failure of the nose landing gear right drag brace (link assembly) due to fatigue.NTSB NYC01FA189Accident · 1 fatalField investigationFinal reportPiper PA-46-350 · Westfield, MAThe pilot's failure to maintain aircraft control while maneuvering during a go-around.NTSB NYC01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Sandy Hook, NJA total loss of engine power for undetermined reasons.NTSB MIA01FA193Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Black Mountain, NCThe pilot's continued VFR flight into IMC conditions resulting in the airplane colliding with mountainous terrain.NTSB FTW01LA158Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Belle Chase, LAthe pilot's failure to maintain clearance with a utility pole while maneuvering. Contributing factors were the pilot's impairment due to alcohol intoxication and the night light conditions.NTSB NYC01LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Watch Hill, RILoss of engine power for undetermined reason.NTSB CHI01LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Plattsmouth, NEthe loss of engine power for undetermined reasons during the approach and the inadvertent stall that occurred during the forced landing. Factors relating to this accident were the low airspeed, the uphill terrain, and the fence.NTSB ANC01LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKA malfunction of the engine fuel control due to an improper overhaul by other maintenance personnel, and subsequent loss of engine power during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.NTSB LAX01FA207Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Stockton, CAa loss of engine power for undetermined reasons. Also causal was the inadequate supervision of the flight by the CFI for allowing a simulated emergency maneuver to continue below an altitude which would not allow for recovery contingencies.NTSB CHI01LA174Accident · No injuriesLimited investigationFinal reportSmith Aerostar 600 · Wonewoc, WIThe deer on the runway as the airplane was landing.NTSB LAX01FA201Accident · No injuriesField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVfatigue failure of the right main landing gear retraction arm.NTSB IAD01LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-310 · Uniontown, OHFuel exhaustion due to the pilot's failure to perform fuel calculations. A factor was the inboard fuel tank probes not being within the manufacturer's resistance limits, which resulted in inaccurate fuel gauges.NTSB LAX01LA179Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paulden, AZCatastropic engine failure due to oil depletetion caused by an oil filter gasket failure.NTSB LAX01LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Napa, CAThe pilot-in-command's failure to verify the fuel supply before flight, and his improper fuel management, that resulted in fuel starvation and loss of engine power during takeoff climb resulting in a forced landing and collision with ground obstacles.