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 ATL99FA048Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Cartersville, GAIn flight collision with terrain for undetermined reasons.NTSB CHI99LA059Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Plymouth, INthe pilot's failure to maintain directional control of the airplane while landing. Factors associated with the accident were the tailwind condition and the pilot landing in the wrong direction.NTSB IAD99FA025Accident · 1 fatalField investigationFinal reportLake LA-4-250 · Laconia, NHA loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.NTSB DEN99LA026Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Granby, COThe in-flight encounter with clear air turbulence during descent.NTSB FTW99LA034Accident · Serious injuriesLimited investigationFinal reportStanton Staros SA 260 · Marion, TXThe fuel leak for an undetermined reason which resulted in an in-flight fire.NTSB ANC98LA165Accident · Serious injuriesLimited investigationFinal reportMaule ML-7 · Wasilla, AKThe pilot's inadequate compensation for the wind conditions, resulting in an inadvertent stall. Contributing factors were the gusty and turbulent weather conditions.NTSB MIA98FA250Accident · 5 fatalField investigationFinal reportPiper Aerostar 600 · N. Myrtle Beach, SCThe pilot's failure to maintain airspeed (Vs) during a single engine approach resulting in an inadvertent stall. Factors contributing to the accident were a fatigue crack in the exhaust pipe in the right engine, the aircraft weight and balance was exceeded,…NTSB FTW98LA396Accident · Serious injuriesLimited investigationFinal reportDempsey Skybolt TD8 · Dundee, TXHard landing due to the pilot's improper landing flare. Factor were the fuel exhaustion due to the pilot's failure to refuel, and his lack of familiarity with the airplane.NTSB FTW98LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Beaumont, TXThe pilot's failure to maintain control of the airplane while attempting to return to the airport. Factors were the open baggage compartment door and the pilot's diverted attention to the open door.NTSB ATL98LA100Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-4-250 · Wise, NCThe pilot's improper turn during the takeoff that resulted in dragging the sponson. A factor was the rough water caused by the boat wake.NTSB MIA98LA169Accident · No injuriesLimited investigationFinal reportMohr Skybolt · Lakeland, FLthe failure of the pilot to maintain directional control of the airplane, after landing, resulting in the airplane departing the left side of the runway and subsequent impact with the ground.NTSB FTW98FA185Accident · 2 fatalField investigationFinal reportYoung Glasair III · St. Martinville, LAThe pilot's failure to maintain control of the aircraft as a result of VFR flight into instrument meteorological conditions and flight into known adverse weather conditions. Contributing factors were turbulence, clouds, dark night and lack of an instrument…NTSB IAD98LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Red Hook, NYinadequate compensation for the crosswind by the pilot, and his failure to maintain directional control during the landing. Related factors were: the gusty crosswind condition, and high vegetation that was encountered after departing the runway.NTSB ATL98FA056Accident · 1 fatalField investigationFinal reportJohn S. Hickey Swearingen SX 300 · Thomson, GAThe pilot's inadequate preflight planning of the fuel supply required for the flight that resulted in fuel exhaustion and the loss of engine power.NTSB SEA98FA040Accident · 2 fatalField investigationFinal reportFreije Lancair IV · Garwood, IDThe pilot's failure to maintain aircraft control after entering known adverse weather. Related factors were, the pilot's failure to follow the published IFR departure procedures, low ceilings and snow, and the pilot's lack of recent instrument experience.NTSB ANC98LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKThe pilot's failure to maintain an adequate visual lookout. Factors in the accident were flat lighting conditions, and inadequate airport facilities.NTSB MIA98LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Holly Springs, MSa total loss of power due to fuel starvation as a result of the pilot's lack of adequate preflight planning and preparation and his failure to adequately refuel his airplane.NTSB ANC98LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kongiganak, AKThe pilot misjudged distance/altitude and airspeed, and his delay initiating a go-around. Related factors were the downdraft and snowbank.NTSB FTW98LA106Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Taos, NMthe pilot's improper flare and improper recovery from a bounced landing.NTSB IAD98FA015Accident · 1 fatalField investigationFinal reportSocata TB-20 Trinidad · Roanoke, VALoss of engine power for undetermined reasons. A related factor was the low ceiling.NTSB MIA98FA040Accident · 3 fatalField investigationFinal reportCommander 114B · Cross City, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the terrain (tree,…NTSB NYC98LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Johnstown, PAthe pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.NTSB NYC98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Scottsville, VAimproper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.NTSB CHI97FA293Accident · 2 fatalField investigationFinal reportKeaggy-David Skybolt · Adeline, ILThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB ATL97LA123Accident · 1 fatalLimited investigationFinal reportJurka P51D Mustang · Fort Pierce, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while starting to maneuver for an emergency landing, which resulted in loss of aircraft control (stall) and collision with terrain.NTSB LAX97LA281Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Borrego, CAThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain runway alignment during the takeoff roll.NTSB FTW97LA284Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pine Bluff, ARloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB FTW97LA263Accident · Serious injuriesLimited investigationFinal reportBronner Steen Skybolt · Brazoria, TXa fuel leak at a wobble pump fuel hose clamp, which resulted in loss of fuel and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.NTSB SEA97LA140Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3-1 · Monument Valley, UTthe pilot's inadequate preflight planing/preparation, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident included: high, gusty, variable winds, and terrain induced downdrafts.NTSB NYC97FA080Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Waterford, VAfailure of the pilot to follow the published instrument (IFR) approach procedure, by failing to maintain the minimum altitude for that segment of the approach.NTSB LAX97LA158Accident · 2 fatalLimited investigationFinal reportDevendorf Glassair GL25 · Congress, AZfailure of the pilot to recover from an inverted stall/spin prior to impact with the ground. The reason for the loss of control was not determined.NTSB NYC97LA072Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Vincentown, NJThe pilot's failure to maintain directional control, which resulted in an on ground loss of control. A contributing factor was a crosswind.NTSB MIA97LA123Accident · No injuriesLimited investigationFinal reportCumberland Skybolt · Smithfield, NCInstallation by a student mechanic of a counterweight retaining washer that did not meet engine manufacturers specifications resulting in partial separation of the counterweight, failure of the No.5 connecting rod adjacent to the counterweight, and seizure of…NTSB ATL97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Memphis, TNfailure of maintenance personnel to properly inspect (and repair) the brake assembly, which allowed a subsequent brake fluid leak and eventual fire.NTSB IAD97LA044Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · University Park, PAthe pilot's inability to control the airplane due to a damaged/bent elevator control lever and resultant lack of elevator authority.NTSB LAX97LA303Accident · 1 fatalLimited investigationFinal reportFleming Glassair III · Dunsmuir, CAwas the pilot's intentional flight into marginal meteorological conditions in mountainous terrain during dark nighttime conditions.NTSB SEA97LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albany, ORfailure of the SA-750 pilot to see-and-avoid the Cessna 172, which had landed ahead of him on the same runway. The inherent visual restrictions of the SA-750 (a tandem two-place biplane) was a related factor.NTSB MIA97LA003Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Mobile, ALthe pilot's improper management of fuel, which resulted in fuel exhaustion and loss of engine power during a go-around, and subsequent collision with trees and terrain during a forced landing.NTSB IAD97LA003Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Mahopac, NYthe pilot's failure to maintain directional control during takeoff, which resulted in a inflight collision with trees (sapplings). A factor related to the accident was: the quartering tailwind that was encountered during takeoff.NTSB FTW96LA369Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Salida, COtotal failure of the induction air control linkage (bolt), which allowed the alternate air door to close and starve the engine of air.NTSB ANC96FA137Accident · Serious injuriesField investigationFinal reportPiper PA-32 · Haines, AKthe pilot's inadvertent flight into instrument meteorological conditions (IMC) failure to maintain adequate altitude/clearance from terrain, while maneuvering to reverse the direction of flight. Factors associated with the accident were: the pilot's…NTSB CHI96LA317Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Stewartville, MNthe pilot's improper in-flight planning/decision, which resulted in a failure to reach the proper touchdown point for the landing. The fractured nose gear shimmy damper attaching collar and the jammed nose gear were related factors.NTSB MIA96LA207Accident · Minor injuriesLimited investigationFinal reportStout Glasair III · Boynton Beach, FLinadequate preflight by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.NTSB CHI96LA272Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Poseyville, INthe pilot's improper flare during the landing. A factor relating to the accident was: the pilot's lack of familiarity with the make and model of airplane.NTSB CHI96LA246Accident · Minor injuriesLimited investigationFinal reportElliot Steen Skybolt · Belleville, ILthe inadequate weld on the landing gear by the builder/pilot.NTSB IAD96LA089Accident · No injuriesLimited investigationFinal reportPiper PA60-601P · Willard, OHthe pilot's inability to maintain directional control of the airplane during the landing flare/touchdown.NTSB MIA96LA123Accident · Serious injuriesLimited investigationFinal reportVernon L. Cox COX-HAWK · Mebane, NCThe pilot's inadvertent flight into instrument meteorological conditions in an airplane not equipped with appropriate instrumentation which led to the pilot's inability to maintain control and spatial disorientation. In addition, during an attemped recovery…NTSB ANC96LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Nome, AKthe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain adequate altitude/clearance from terrain. Low ceilings and snow covered terrain were factors in the accident.NTSB NYC96LA064Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Stratford, CTinadequate visual lookout by the pilot and the vehicle operator, resulting in their failure to see and avoid each other.NTSB ATL96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32-RT-300 · Blountville, TNInadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.