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 ATL93LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Goldsboro, NCThe pilot's improper decision in attempting a night landing at an airport without operating runway lights which resulted in a touchdown off the runway. Factors which contributed to the accident were: an airplane lighting malfunction for an undetermined…NTSB MIA93LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Titusville, FLLoss of engine power during the downwind leg for undetermined reasons, poor in-flight planning/decision by the dual student, and inadequate supervision by the pilot-in-command (CFI).NTSB ATL93FA041Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Atlanta, GAThe pilot's failure to maintain clearance from approach lights while conducting a night landing. A factor was a dark night.NTSB ATL93LA040Accident · No injuriesLimited investigationFinal reportShaw Velocity HXB · Savannah, GAThe disengagement of the idler gear, which interrupted fuel pump operation, and resulted in the total loss of engine power. Factors were the lack of suitable terrain and the water.NTSB ANC93LA019Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Scammon Bay, AKThe pilots VFR flight into IMC conditions, and his failure to maintain sufficient altitude while maneuvering. Contributing to the accident were the whiteout snow and fog conditions.NTSB MIA93LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Pierce, FLAn engine failure over unsuitable terrain. The cause of the engine failure was fuel contamination by ferrous metal particles that prevented the fuel servo from operating properly. The origin of the contamination is unknown.NTSB LAX93LA012Accident · 2 fatalLimited investigationFinal reportGilbert SX300 · Rosamond, CAThe pilots inadequate compensation for the wind conditions and his failure to maintain an adequate airspeed while maneuvering which led to an inadvertent stall spin.NTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.NTSB ANC92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Togiak, AKThe pilot's improper preflight planning/decision, and his delay in aborting the takeoff. Contributing factors were the berm and the standing water on the runway.NTSB DEN92LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Leadville, COThe pilot's failure to compensate for wind conditions and maintain directional control. Factors included: the pilot allowing the airplane to lift off prematurely, and gusty crosswinds.NTSB NYC92LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lancaster, PAThe failure of the left engine turbochargers bearings, which resulted in a loss of power and subsequent degradation of climb performance.NTSB LAX92TL#08Accident · No injuriesClass 3Final reportPiper PA36-300 · Madera, CANTSB LAX92LA223Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Groveland, CAThe pilot's inadvertent placement of the landing gear selector in the up position during the initial portion of the landing rollout.NTSB LAX92LA235Accident · No injuriesLimited investigationFinal reportMcquen Glassair III · Casa Grande, AZFuel starvation due to the pilot's misreading of a newly installed fuel selector panel with placards and a position pointer which were confusing. Factors in the accident were the confusing nature of the fuel panel and placard design and the school bus which…NTSB MIA92WA116Accident · 1 fatalForeign investigationPiper PA-23-250 · Marsh Harbour, BahamasNTSB SEA92LA078Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aravada, WYThe pilot's failure to maintain a visual lookout, and his diverted attention. Factors include a low pass, and a transmission wire in the path of flight.NTSB LAX92LA176Accident · No injuriesLimited investigationFinal reportMcewen Dick Glasair III · Casa Grande, AZA failure of the pilot to select the proper fuel tank and subsequent fuel starvation. Contributing to the accident was an inadequate design by the manufacturer that permitted the fuel selector to be rotated 360 degrees, and the pilot's lack of familiarity…NTSB ANC92LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Sleetmute, AKThe airplane stalled when the pilot failed to maintain flying speed.NTSB MIA92LA096Accident · 2 fatalLimited investigationFinal reportAnkerman, Donald L. SX300 · Okeechobee, FLFailure of the pilot-in-command to maintain airspeed (vs) resulting in inadvertent stall/mush.NTSB MIA92LA068Accident · 3 fatalLimited investigationFinal reportPiper PA-32-301 · Atlantic Ocean (Atlantic Ocean)Undetermined. The airplane crashed in the Atlantic Ocean and was not located.NTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…NTSB LAX92LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT-300 · Big Bear City, CAThe failure of the pilot to maintain directional control and improper use of the rudder. Contributing to the accident was the improper installation by the company of a hand control mechanism that required the pilot to operate the airplane controls with one…NTSB MIA91LA221Accident · 2 fatalLimited investigationFinal reportJohn H. Logan Loganair I · Gainesville, FLThe non-instrument rated pilot in command's decision to depart under special visual flight rule clearance in instrument flight rules conditions during darkness with a failed vacuum pump and resulting inoperative flight instruments which resulted in an…NTSB CHI91DTK05Accident · No injuriesFinal reportEagle DW1 · Hurley, SDThe failure of the pilot to maintain a visual lookout.NTSB ATL91LA169Accident · Minor injuriesLimited investigationFinal reportBates, Frank L Skybolt · Yatesville, GAThe pilot's failure to maintain a proper altitude during maneuvering flight.NTSB ANC91LA135Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Mystic Pass, AKThe pilot lost control of the airplane. Contributing to the accident was unfavorable wind and turbulence.NTSB BFO91LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · New Market, VAThe pilot's inadequate inflight decision that resulted in VFR flight into IMC.NTSB CHI91DER09Accident · No injuriesFinal reportEagle Eagle DW-1 · Windom, MNThe pilot's improper aircraft handling. Related factors are the pilot's inattention and the airplane's deteriorated performance capability.NTSB CHI91DCQ06Accident · No injuriesFinal reportPiper PA-36-300 · Oakley, KSA loss of engine power for an undetermined reason(s).NTSB FTW91DRA03Accident · No injuriesFinal reportBronner Skybolt · Alvin, TXThe pilot's failure to maintain terrain clearance. A factor was the pilot's decision to perform a low pass.NTSB CHI91DER04Accident · No injuriesFinal reportBellanca Eagle DW-1 · Hector, MNThe loss of engine power due to the total failure of a connecting rod. Related factors are the low maneuvering altitude and the unsuitable (muddy) terrain encountered during the forced landing.NTSB NYC91FA145Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Wallingford, CTThe pilot attempting a VFR flight in adverse weather conditions, at an altitude that was insufficient to clear trees along his route of flight. Factors related to the accident were the pilot's lack of instrument rating, and his overconfidence to fly in…NTSB ANC91IA052Incident · No injuriesIncident investigationFinal reportPiper PA-32-301 · Eek, AKThe failure of the center torque link bolt.NTSB NYC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Celina, OHThe pilot-in-command's improper use of the powerplant controls, magnetos and brakes.NTSB FTW91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Enid, OKThe mechanical failure of the ignition switch. A factor was the pilot's failure to apply the parking brake or use airplane wheel chocks.NTSB ANC91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kongikank, AKThe pilot in command's failure to maintain airspeed during approach resulting in an inadverrtent stall annd uncontrolled descent into the ground.NTSB CHI91FA031Accident · 4 fatalField investigationFinal reportPiper PA-32-RT300 · Gaylord, MIThe pilot's failure to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night, adverse weather conditions, and the pilot's overconfidence in continuing VFR flight into these conditions.NTSB BFO91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Milton, KYThe in-flight failure of both engines due to the pilot's mismanagement of the fuel system.NTSB NYC90FA215Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Montgomery, NYAn inadequate preflight by the pilot which resulted in a power loss due to fuel exhaustion.NTSB CHI90DCQ01Accident · Minor injuriesFinal reportPiper PA 36-300 · Mingo, KSInadequate airspeed resulting in a stall/mush being encountered by the PIC. Contributing factors were a tailwind and a load jettison not performed.NTSB MIA90LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Hattiesburg, MSFailure of the pilot in command to attain adequate airspeed prior to liftoff during an attempted takeoff. The pilot then lost control of the airplane in flight. The pilot also delayed in his decision to abort the takeoff.NTSB SEA90LA147Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Rawlins, WYPilot's improper planning/decision, and his misjudgement of the aircraft's climb capability in conditions of high density altitude and unanticipated atmospheric conditions. The high density altitude and rising terrain were related factors.NTSB CHI90LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · East Tawas, MIThe private pilot's failure to maintain adequate control of the aircraft after touchdown.NTSB LAX90DVG12Accident · Serious injuriesFinal reportE.J. Novotny Steen Skybolt · Fall River Mill, CALoss of power for undetermined reasons.NTSB SEA90LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Island Park, IDPilot's failure to maintain directional control, while attempting a soft-field takeoff. The crosswind was a related factor.NTSB LAX90DUA01Accident · Minor injuriesFinal reportHomebuilt JP-350-1 · Torrance, CAThe aircraft collision with the ground after the pilot experienced a loss of engine thrust due to propeller overspeed condition. Contributing to the accident was the pilot's improper servicing of the propeller hub that allowed the overspeed to occur.NTSB MKC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Little Rock, ARThe failure of the powerplant due to a sheared timing gear. Contributing factors were unsuitable terrain and restricted vision due to fog.NTSB FTW90DQG02Accident · No injuriesFinal reportBellanca BL-DW-1 · Petersberg, TXLoss of directional control as the result of an encounter with a dust devil.NTSB LAX90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-300 · Sacramento, CAAn inadvertent collision with a large bird during the hours of darkness while in the landing pattern.NTSB MKC90LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Norfolk, NEInproper in-flight planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the adverse weather conditions, the pilot's lack…