Skip to content

NTSB investigations: Lycoming 0-540 series

3,541 cases on aircraft whose registry engine model is Lycoming 0-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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 ('41532')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('41532'))
  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 ('41532'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MIA94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Labelle, FLThe pilot-in-command exceeding the structural limits of the airplane's design limits by in-flight over-stress that resulted in damage to the gear extension system, fuselage and control surfaces.Nov 21, 1993 · N5755P · Substantial damage NTSB FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.Nov 10, 1993 · N6651P · Destroyed NTSB SEA94LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Renton, WAThe student pilot's failure to maintain directional control during landing. The crosswind was a factor.Oct 9, 1993 · N7367E · Substantial damage NTSB SEA93LA212Accident · No injuriesLimited investigationFinal reportCessna 182RG · Vancouver, WAThe pilot's inadvertent landing gear retraction.Sep 23, 1993 · N736ZV · Substantial damage NTSB LAX93LA342Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hesperia, CAThe aircraft's encounter with a low level windshear and the pilot's inadequate compensation for the existing wind conditions.Sep 4, 1993 · N5523P · Substantial damage NTSB ANC93LA159Accident · 1 fatalLimited investigationFinal reportMorgan Steen Skybolt MI-2 · Nome, AKThe pilot delayed in recovering from the aerobatic maneuver.Aug 29, 1993 · N23JM · Substantial damage NTSB NYC93LA168Accident · No injuriesLimited investigationFinal reportPiper PA-25-225 · Chesapeake, VAThe loosening of the crankshaft geardrive as a resulted of a sheared bolt and guide pin which resulted in the loss of engine power. A factor was a forced landing on a crop field.Aug 26, 1993 · N9556P · Substantial damage NTSB CHI93DTG03Accident · No injuriesFinal reportPiper PA-25-235 · Washburn, NDthe loss of engine power due to a magneto failure.Aug 20, 1993 · N4693Y · Substantial damage NTSB LAX93FA311Accident · 3 fatalField investigationFinal reportRobinson R44 · El Monte, CAFatigue failure of the cyclic control (stick) assembly, which resulted in loss of cyclic (pitch & roll) control.Jul 31, 1993 · N445RH · Destroyed NTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.Jul 12, 1993 · N8906L · Substantial damage NTSB ATL93LA126Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Bainbridge, GAThe failure of the landing gear axle.Jul 7, 1993 · N4874Y · Substantial damage NTSB ATL93LA121Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate clearance from the ground.Jul 2, 1993 · N8659L · Substantial damage NTSB NYC93LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Spencer, MAThe pilot's inadequate preflight planning for the high density altitude departure and the delay in aborting the takeoff roll, with insufficient runway remaining, resulting in a collision with treesJun 28, 1993 · N3490W · Substantial damage NTSB NYC93LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · West Milford, NJA manufacturer's defect which resulted in fatigue failure of the magneto impluse coupling spring and the loss of engine power. A factor was unsuitable terrain.Jun 27, 1993 · N8220J · Substantial damage NTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.May 19, 1993 · N8787L · Substantial damage NTSB BFO93LA091Accident · No injuriesLimited investigationFinal reportCessna 172N · Petersburg, OHThe pilot's failure to attain the proper touchdown point while attempting to land on a wet grass strip, and his failure to perform a go around. The wet grass runway was a factor.May 18, 1993 · N7355E · Substantial damage NTSB LAX93LA196Accident · No injuriesLimited investigationFinal reportDornier DO-28 · Paradise, CAThe poor in flight fuel consumption calculations by the pilot and the pilot's in flight decision not to switch fuel tanks which caused the total failure of both of the airplane's engines. Factors relating to this accident were fuel starvation and the high…May 2, 1993 · N12828 · Destroyed NTSB SEA93LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Forest Grove, ORThe pilot in command's inadequate preflight planning. Factors contributing to the accident were the wet terrain, tailwind, trees, and wires.Apr 24, 1993 · N9637P · Substantial damage NTSB FTW93FA132Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Henryetta, OKThe pilot's decision to fly into known adverse weather conditions and the ensuing spatial disorientation. Factors were the weather, and the pilot's decision to fly into IMC with inadequate flight and navigational equipment installed in the aircraft.Apr 18, 1993 · N4689P · Destroyed NTSB MIA93WA098Accident · No injuriesForeign investigationPiper PA-32-260 · N. Eleuthera I., BahamasApr 11, 1993 · N3910W · Substantial damage NTSB MIA93IA083Incident · No injuriesIncident investigationFinal reportAero Commander 500 · Everglades City, FLThe preexisting fatigue cracking of the propeller hub arm in the bearing retention radius due to polishing and wear of the radius from contact with the split rings, resulting in a propeller blade separating from the propeller hub on the takeoff ground run,…Mar 7, 1993 · N3836C · Minor damage NTSB MIA93LA063Accident · No injuriesLimited investigationFinal reportBates Barracuda I · Bay St. Louis, MSUndetermined due to the destruction of the airplane after the gear collapsed on landing.Feb 6, 1993 · N852DH · Destroyed NTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.Feb 6, 1993 · N8784W · Substantial damage NTSB CHI93LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Austin, MNThe pilot's failure to maintain altitude. The pilot's continued flight into IMC, diverted attention and the environmental conditions were factors.Feb 4, 1993 · N3658W · Substantial damage NTSB LAX93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Big Bear, CAThe pilot's failure to maintain directional control of the aircraft after touchdown.Dec 31, 1992 · N129AB · Substantial damage NTSB NYC93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cheriton, VAThe pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.Dec 10, 1992 · N9102W · Substantial damage NTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.Nov 7, 1992 · N9008E · Destroyed NTSB CHI93LA017Accident · 1 fatalLimited investigationFinal reportPiper PA-25-260 · Trenton, NDThe pilot's improper aircraft handling while maneuvering at low altitude.Oct 24, 1992 · N8675L · Destroyed NTSB NYC93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Pulaski, VAThe improper decision by the non-instrument-rated pilot to continue VFR flight into known instrument meteorological conditions resulting in spatial disorientation and loss of control of the airplane. Factors which contributed to the accident were the actions…Oct 9, 1992 · N31953 · Destroyed NTSB FTW92LA226Accident · No injuriesLimited investigationFinal reportBell 47-J2A · Booneville, ARThe pilot's failure to maintain adequate rotor RPM during autorotative landing. Factors were fuel exhaustion, the pilot's improper fuel consumption calculations, and the pilot not refueling the helicopter.Sep 16, 1992 · N291FW · Substantial damage NTSB ATL92LA184Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Powellsville, NCThe failure of the no.1 exhaust valve.Sep 14, 1992 · N6953Z · Substantial damage NTSB LAX92LA372Accident · No injuriesLimited investigationFinal reportMaule M5-180C · San Jose, CAThe pilot's misjudged landing flare which resulted in a bounced landing and the pilot's improper recovery from the bounced landing.Sep 1, 1992 · N8070 · Substantial damage NTSB LAX92LA371Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Casa Grande, AZThe pilots inadequate compensation for the existing wind conditions. The gusty nature of the cross wind condiitons encountered was a factor.Aug 29, 1992 · N8647W · Substantial damage NTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.Aug 22, 1992 · N3985W · Substantial damage NTSB MIA92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Brooksville, FLThe pilot-in-command's failure to maintain alignment with the runway during landing. This resulted in an in-flight collision with a runway marker, collapse of the right main landing gear, and subsequent collision with terrain.Aug 10, 1992 · N119Q · Substantial damage NTSB LAX92LA321Accident · No injuriesLimited investigationFinal reportCessna R182 · Redding, CAThe pilots selection of the wrong runway for takeoff under the existing wind conditions.Jul 30, 1992 · N5116T · Substantial damage NTSB BFO92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Norwalk, OHLoss of engine power due to undetermined reasons and the lack of suitable terrain for a forced landing.Jul 20, 1992 · N7727J · Destroyed NTSB CHI92DTK03Accident · Serious injuriesFinal reportPiper PA-25-235/250 · Ramona, SDFailure of the pilot to maintain a visual lookout while maneuvering during aerial application of agricultural chemicals.Jun 24, 1992 · N4601Y · Destroyed NTSB CHI92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Indian River, MIAn on ground collision with a deer during a landing ground roll.Jun 13, 1992 · N8303Q · Substantial damage NTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.Jun 9, 1992 · N6138S · Substantial damage NTSB FTW92FA152Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260B · Decatur, TXThe loss of engine power as the result of the failure of the engine oil pump. Factors were non compliance with a service bulletin, the lack of suitable terrain, and inadvertent stall.Jun 7, 1992 · N22FD · Destroyed NTSB NYC92FA093Accident · 3 fatalField investigationFinal reportCessna 172N · Brookeville, MDImproper inflight planning/decision by the flight instructor (pic/cfi) in the Cessna 172, his misjudgement of distance between the two airplanes, and inadequate visual lookout by both pilots in the Cessna 172.Jun 1, 1992 · N738YV · 2 aircraft · Destroyed NTSB FTW92LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Des Arc, ARThe power loss due to the failed exhaust stack resultant from inadequate maintenance inspection. Factors were the lack of suitable terrain for the landing and the pilot's failure to maintain airspeed.May 21, 1992 · N7354Z · Substantial damage NTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.May 18, 1992 · N4427Y · Destroyed NTSB SEA92LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Chubbuck, IDInadequate preflight planning/preparation. A factor to the accident was: a guy wire.May 14, 1992 · N4488Y · Substantial damage NTSB BFO92LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Falmouth, KYThe pilot misjudged the airplane's altitude and distance in reference to the runway. Contributing to the accident was the fuel system leak.May 8, 1992 · N7851P · Substantial damage NTSB CHI92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sidney, NEWas an inadvertent stall/mush during landing by the pilot. A factor related to the accident was lack of recent total experience.Apr 26, 1992 · N3811W · Substantial damage NTSB FTW92LA120Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Madil, OKThe pilot's failure to maintain adequate clearance with the wires. A factor was the existing sunglare.Apr 23, 1992 · N7603Z · Substantial damage NTSB LAX92FA151Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Lebec, CAThe pilot's delayed inflight decision to reverse course to avoid forecast adverse weather conditions. Contributing to the accident was icing conditions and lightning.Mar 27, 1992 · N4335N · Destroyed NTSB FTW92LA097Accident · No injuriesLimited investigationFinal reportCessna R182RG · Little Rock, ARThe complete loss of engine power due to carburetor icing, and the pilot's delayed application of carburetor heat. Factors were the weather conditions which were highly conducive to carburetor icing, and the unsuitable terrain at the pilot's disposal to…Mar 26, 1992 · N5529S · Substantial damage