NTSB investigations: Lycoming IO-540 series
1,056 cases on aircraft whose registry engine model is Lycoming IO-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 ('41530', '41585'))
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 ('41530', '41585'))
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 CHI96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Marion, INthe pilot's failure to maintain directional control during landing.NTSB MIA96FA048Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Memphis, TNthe pilot's continued flight into known forecast icing conditions which resulted in the aircraft developing an ice buildup, and the pilot's failure to maintain control of the aircraft. The icing conditions was a factor.NTSB CHI96FA049Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Parker, KSthe pilot's impairment of judgment and performance due to a drug (cocaine); his improper in-flight decision to continue flight over an overcast condition and then to descend into instrument meteorological conditions (IMC); his failure to maintain control of…NTSB NYC96LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Honsdale, PAthe pilot's improper evaluation of the weather briefing, and his decision to fly into known forecasted moderate to severe icing conditions. Factors in the accident were the adverse weather conditions encountered during the flight and landing.NTSB ANC95LA172Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Aniak, AKThe pilot's inadequate weather evaluation. Factors associated with the accident were: the box canyon, rising terrain, wind gusts, and downdrafts.NTSB ANC95LA161Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aniak, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB LAX95LA314Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Marana, AZthe pilot's poor installation of the propeller which allowed the propeller to become loose, and the pilot's improper emergency procedure by feathering the wrong propeller.NTSB FTW95LA355Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fayetteville, ARThe pilot's inability to extend the landing gear due to the failure of an emergency gear extension valve.NTSB ANC95LA138Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Togiak, AKThe pilot's inadequate compensation for wind conditions and failure to maintain proper alignment with the intended point of landing. A factor relating to the accident was: the unfavorable wind condition.NTSB FTW95LA327Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Monroe, LAThe pilot's improper positioning of the fuel selector resulting in fuel starvation and the failure of the pilot to follow the published emergency procedures for propeller feathering. Factors were the fence and the trees.NTSB BFO95LA062Accident · 1 fatalLimited investigationFinal reportBerg Steen Skybolt · Bath, NYthe pilot's failure to maintain sufficient altitude/clearance to avoid trees while performing aerobatic maneuvers. Related factors are the low altitude at which the maneuver was initiated and the delayed recovery/pull-up.NTSB MIA95WA150Accident · No injuriesForeign investigationMaule M-7-235 · Cat Cay, BahamasNTSB CHI95LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeville, MNThe pilot misjudged distance and altitude during landing.NTSB MIA95LA061Accident · No injuriesLimited investigationFinal reportGlassair III · Boynton Beach, FLa violent shimmy of the nose gear for undetermined reason(s), which resulted in an on-ground loss of directional control and a subsequent nose over.NTSB MIA95FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · York, SCThe noninstrument-rated pilot's failure to maintain control of the airplane due to spatial disorientation while conducting flight in instrument meteorological conditions (IMC). A factor relating to the accident was: failure of the pilot to follow…NTSB MIA95FA037Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sylvan Springs, ALPoor in-flight planning/decision by the pilot-in-command for failure to deviate to an alternate airport after encountering icing conditions in an airplane not certificated for flight in icing conditions. Also, failure of the pilot to maintain altitude…NTSB NYC95FA042Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Colonie, NYFailure of the pilot to maintain control of the aircraft, possibly from falling asleep.NTSB FTW94LA305Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Nacogdoches, TXThe pilot's inadequate compensation for crosswind during landing rollout. A factor was the variable crosswind.NTSB FTW94LA283Accident · 2 fatalLimited investigationFinal reportWalton Skybolt · Collinsville, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall.NTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.NTSB CHI94LA218Accident · No injuriesLimited investigationFinal reportCallair A9B · Minot, NDthe pilot's failure to maintain clearance from the wheat field. A factor was the turbulence.NTSB ATL94LA126Accident · Serious injuriesLimited investigationFinal reportGreen Starduster TOO · Chattanooga, TNThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall, and collision with terrain.NTSB LAX94LA253Accident · No injuriesLimited investigationFinal reportSchumacher Swearingen SX-300 · Kingman, AZthe pilot's inadvertent raising the flaps during a go-around attempt. A factor in the accident was the gusty crosswind condition.NTSB ANC94LA068Accident · No injuriesLimited investigationFinal reportMaule M6-235 · Bethel, AKThe pilot's failure to maintain directional control during landing.NTSB LAX94LA225Accident · Serious injuriesLimited investigationFinal reportStaudacher 300S · Chandler, AZThe operation of the engine at an RPM setting that exceeded the original design specifications and resulted in the failure of the no. 5 connecting rod bearing.NTSB ATL94FA075Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Smithville, TNThe pilot's failure to obtain recent weather information to avoid flight into icing conditions. Factors in the accident were: management-induced pressure and the icing conditions.NTSB BFO94LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Norfolk, VAFatigue failure of the engine mounting bolt which resulted in loss of engine power and subsequent on ground collision with the terrain.NTSB MIA94FA067Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Sugarloaf Key, FLWas the failure of the pilot-in-command to perform a visual lookout and maintain his altitude. Contributing to the accident was the dark night, over water, visual descent.NTSB MIA94LA041Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Atlanta, GAFailure of the pilot-in-command to apply power after the airspeed decrease just before touchdown and also failure to recover from the bounced landing. Contributing to the accident was the in-flight encounter with wind gusts while on approach to land.NTSB BFO94FA021Accident · 1 fatalField investigationFinal reportPiper PA32R-301 · Butler, PAThe pilot's inadvertent flight into IMC conditions and his failure to maintain proper altitude. The weather conditions were a factor.NTSB FTW94WA073Accident · Minor injuriesForeign investigationPiper Aerostar 601P · Campeche, MexicoNTSB NYC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-602P · Falls Of Rough, KYThe pilot's inadequate visual lookout prior to entering the runway, resulting in a taxi off the runway to avoid conflict, onto soft terrain, and the subsequent collapse of the landing gear.NTSB ANC94LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Karluk, AKThe selection of unsuitable terrain for landing.NTSB SEA93LA203Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Recluse, WYThe brake system locked for undetermined reasons.NTSB CHI93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Point Lookout, MOThe pilot's failure to attain the proper touchdown Point.NTSB CHI93LA318Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Minto, NDThe pilot's failure to maintain adequate aircraft control during ground maneuvering. Inadequate visual outlook by the pilot and the pilot of the other aircraft was a contributing factor.NTSB CHI93LA294Accident · No injuriesLimited investigationFinal reportNorth American F-51 · Fond Du Lac, WIthe pilot-in-command of the F-51's diverted attention and failure to maintain a visual outlook.NTSB BFO93FA107Accident · Serious injuriesField investigationFinal reportUS/Lta 138S Airship · New York, NYInadequate design of, and design standards for, the airship which resulted in an envelope failure following separation of a portion of the night sign equipment.NTSB NYC93LA122Accident · 1 fatalLimited investigationFinal reportSmitrvich Starduster SA-300A · Millville, NJThe pilot's inflight planning which resulted in fuel exhaustion. A factor was inadequate preflight planning.NTSB FTW93FA183Accident · 1 fatalField investigationFinal reportEagle DW-1 · Goree, TXThe pilot's failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the airplane.NTSB ANC93LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Skagway, AKA total loss of engine power as a result of a fatigue failure of the #2 connecting rod. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.NTSB CHI93LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Elbow Lake, MNthe pilot's failure to maintain an adequate visual outlook during aerial application manuevers.NTSB LAX93IA235Incident · No injuriesIncident investigationFinal reportUS/Lta 138-S · Santa Maria, CAInadequate specifications in the design and manufacture of a rudder control tube rod end bearing by the airship manufacturer.NTSB CHI93LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · West Chicago, ILThe pilot-in-command's inadequate compensation for the wind conditions he encountered during the landing approach and touchdown and not maintaining a proper descent rateNTSB BFO93FA082Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Lyburn, WVFailure of the pilot to attain sufficient altitude to remain clear of rising terrain and objects. Factors related to the accident were darkness and rising terrain.NTSB MIA93WA095Accident · No injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasNTSB ANC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Egegik, AKThat the lift off airspeed was not attained by the pilot in command because of the snow covered runway.NTSB ANC93LA036Accident · No injuriesLimited investigationFinal reportMaule M5 · Chena Hot Sprng, AKThe total failure of the landing gear axle as a result of a pre existing fracture in the axle.NTSB LAX93LA114Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Rachael, NVThe pilot poor preflight planning and preparation. The road sign was a factor relating to this accident.NTSB ANC93LA029Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Heiden, AKThe failure of the number 3 cylinder intake valve stem. A factor in the degree of damage the aircraft sustained in the mishap was attributable to the off airport emergency landing on show covered tundra.