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 DFW08FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Cassville, MOThe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing to the accident was the pilot's self-induced pressure to conduct the…NTSB LAX08CA249Accident · No injuriesData collectionFinal reportFowler SX300 · Cheyenne, WYLoss of engine power due to fuel starvation.NTSB CHI08CA199Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Bryan, OHThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations. A contributing factor was the inaccurate fuel gauge.NTSB CHI08LA180Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar 601P · Alexandria, MNThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain for the forced landing.NTSB LAX08LA183Accident · Minor injuriesLimited investigationFinal reportRobinson R44 II · Topanga, CAThe in-flight separation of the tail rotor gear box for an undetermined reason. Contributing to the accident was the hilly terrain, which was unsuitable for a forced landing.NTSB LAX08CA182Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Missoula, MTThe student's inadvertent control interference, which the flight instructor was unable to overcome. A contributing factor was the instructor's poor crew coordination in his failure to verbally command the student to relinquish the controls and his inadequate…NTSB MIA08WA116Accident · No injuriesForeign investigationAero Commander 500S · North Bimini, BahamasNTSB LAX08LA154Accident · 1 fatalLimited investigationFinal reportMaule MX-7-235 · Boulder, MTThe pilot's decision to continue flight at low altitude in instrument weather conditions and his failure to maintain clearance from a power line. Contributing to the accident were low cloud and visibility conditions.NTSB NYC08TA183Accident · Minor injuriesFinal reportRobinson R44 II · Lake Wales, FLThe pilot's improper recovery from a practice autorotation.NTSB DFW08CA136Accident · No injuriesData collectionFinal reportPiper PA-36 · Thomas, OKThe disconnected throttle linkage resulting in the loss of engine power during takeoff-initial climb. A factor contributing to the accident was the muddy forced landing site.NTSB DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.NTSB MIA08FA091Accident · 1 fatalField investigationFinal reportAeroFab Lake LA-250 · Skaneateles, NYThe certified flight instructor's failure to maintain airspeed during a steep turn.NTSB ANC08LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Koliganek, AKThe pilot's VFR flight into adverse weather conditions that resulted in a collision with snow-covered terrain during a turn to reverse direction. Factors contributing to the accident were low ceilings, flat lighting conditions, and the snow-covered terrain.NTSB LAX08CA084Accident · No injuriesData collectionFinal reportPiper PA32-301FT · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and his subsequent failure to maintain an adequate airspeed during landing. A contributing factor was the weather windshear condition.NTSB MIA08CA073Accident · No injuriesData collectionFinal reportCessna 182 · Fort Lauderdale, FLThe pilot's failure to maintain directional control during recovery from a bounced landing.NTSB MIA08FA070Accident · 3 fatalField investigationFinal reportUlrich Christen Velocity XL RG · Titusville, FLThe pilot of the Velocity’s failure to see and avoid the flight of four RV-8s that had landed and were in the process of clearing the runway.NTSB SEA08LA070Accident · 1 fatalLimited investigationFinal reportKidd Chris Harmon ROC · Maricopa, CAThe pilot's failure to maintain an adequate terrain clearance altitude while maneuvering in mountainous, hilly terrain. Contributing to the accident were hilly terrain, a low ceiling and gusty winds.NTSB NYC08CA083Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Fenner, NYThe pilot's delayed decision to perform a precautionary landing. Contributing to the accident was the reduced visibility in snow and the soft terrain.NTSB DFW08CA054Accident · No injuriesData collectionFinal reportMicco MAC-145B · Arcola, TXThe pilot's failure to maintain directional control. A contributing factor was the prevailing crosswind.NTSB CHI08CA048Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar Aerostar 601 · Elyria, OHThe pilot's momentary loss of control after takeoff, which resulted in an in-flight collision with a tree. A contributing factor was the presence of the tree.NTSB LAX08FA028Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · McFarland, CAThe pilot's inadequate preflight preparation and improper fueling procedures that led to fuel exhaustion.NTSB ANC08LA010Accident · No injuriesLimited investigationFinal reportPiper 601P · Penn Yan, NYThe loss of engine power during cruise flight for an undetermined reason.NTSB MIA08LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Farmingdale, NYThe failure of both pilots to see and avoid while maneuvering resulting in a midair collision. Contributing to the accident was the local controller's failure to properly identify conflicting traffic.NTSB DEN08CA016Accident · No injuriesData collectionFinal reportRobinson R-44 II · Cleveland, GAthe student pilot's failure to maintain control of the helicopter during the landing, resulting in substantial damage to the helicopter. Contributing to the accident was the windy conditions.NTSB CHI08CA013Accident · No injuriesData collectionFinal reportCessna 182 · Middlefield, OHThe proper touchdown point not obtained by the pilot and the inadequate supervision by the certified flight instructor during landing. A contributing factor was the rough terrain encountered during landing.NTSB SEA07LA270Accident · Serious injuriesLimited investigationFinal reportSocata TB20 · Beatty, NVThe pilot's failure to follow the manufacturer's procedures during a go-around and subsequent loss of airplane control. A contributing factor to the accident was the dark night.NTSB NYC07FA226Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Whitfield, ALThe pilot’s intentional flight into known thunderstorms.NTSB MIA07CA139Accident · Minor injuriesData collectionFinal reportTrinidad TB-20 · White Plains, NYThe pilot's failure to obtain adequate airspeed for takeoff which resulted in a stall, runway overrun down an embankment, and collision with a fence. A factor in accident was the pilot not utilizing the full length of the runway for takeoff.NTSB CHI07FA279Accident · 2 fatalField investigationFinal reportSocata TB-20 Trinidad · Pointe Aux Pins, MIUndetermined.NTSB ANC07LA081Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235 · Fairbanks, AKThe reversal of the elevator control cables by maintenance personnel, and the inadequate preflight inspection by the flight instructor and dual student.NTSB NYC07LA189Accident · Minor injuriesLimited investigationFinal reportStout Gordon Glasair III · Captiva, FLA loss of engine power for undetermined reasons.NTSB SEA07CA226Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Waterville, WAThe loss of engine power during takeoff for an undetermined reason. A contributing factor was the high vegetation in the field where the airplane came to rest.NTSB SEA07FA223Accident · 4 fatalField investigationFinal reportRobinson R44 II · Easton, WAThe pilot's improper planning/decision in attempting a downwind takeoff under high density altitude conditions that resulted in a loss of control and impact with terrain. Contributing to the accident were the helicopter's gross weight in excess of the maximum…NTSB NYC07LA183Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Fort Lauderdale, FLThe total loss of power in one engine during approach, due to a fatigue fracture of the crankshaft.NTSB LAX07CA246Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C1 · Challis, IDthe pilot's inadequate bounced landing recovery technique, which resulted in a hard landing.NTSB SEA07FA199Accident · 2 fatalField investigationFinal reportCessna 182S · New River, AZThe pilot's inadvertent VFR flight into IMC and his ensuing failure to maintain aircraft control while in cruise flight. Contributing factors were the cloudy weather and the dark night conditions.NTSB SEA07CA221Accident · No injuriesData collectionFinal reportBritten-Norman BN-2A-20 · Stanley, IDThe pilot's failure to verify that the airplane was refueled, which resulted in a loss of engine power from both engines due to fuel exhaustion and a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07FA149Accident · 1 fatalField investigationFinal reportSocata TB-20 · Groesbeck, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.NTSB DFW07CA126Accident · Minor injuriesData collectionFinal reportGray Jack Tean Rocket F1 · Seabrook, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB CHI07CA158Accident · No injuriesData collectionFinal reportCessna 182S · Cedarburg, WIThe improper landing flare which resulted in the airplane porpoising during the landing and the subsequent overload of the nose gear.NTSB CHI07CA153Accident · No injuriesData collectionFinal reportCessna 182S · Harvard, ILThe pilot's misjudged flare and improper recovery from a bounced landing, which caused the nose gear to collapse and subsequent damage to the propellor and underside of the airplane.NTSB SEA07LA114Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A-20 · Hamilton, MTThe loss of power in one engine, for undetermined reasons, soon after establishing the takeoff departure climb. Factors include rough/uneven terrain.NTSB NYC07LA104Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Richmond, VAThe improper installation of the right brake assembly by maintenance personnel.NTSB CHI07LA115Accident · 2 fatalLimited investigationFinal reportBird Seawind 3000 · Knox City, MOThe loss of engine power for an undetermined reason. Contributing to the accident was the unsuitable terrain that was encountered by the pilot during the forced landing.NTSB MIA07LA085Accident · Minor injuriesLimited investigationFinal reportSmith Carter A Wheeler Exp 2000 · Stuart, FLContamination of the fuel system which resulted in a loss of engine power. Contributing to the accident was unsuitable terrain for a forced landing.NTSB SEA07CA104Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Concord, CAThe pilot's failure to maintain directional control during landing, resulting in a ground loop/swerve and collapse of the nose landing gear. A contributing factor was the gusty wind condition.NTSB ATL07LA073Accident · 1 fatalLimited investigationFinal reportCulver, Aurther L. Seawind 3000 · Yanceyville, NCThe pilot's failure to maintain clearance/altitude while operating in instrument meteorological conditions (IMC). Contributing to the accident was the pilot's lack of an instrument rating, his improper decision to operate in IMC, a low cloud ceiling, and…NTSB DEN07FA079Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ponte Vedra Bch, FLthe mechanic's improper installation of the attachment hardware for the servo to swashplate push-pull tube joint which resulted in a disconnection, subsequent loss of control, and impact with terrain. Contributing factors were the company management's…NTSB CHI07LA092Accident · No injuriesLimited investigationFinal reportSocata TB-20 Trinidad · Rhinelander, WIThe failure of the pilot to maintain directional control of the airplane during taxi. A contributing factor was the gusting winds and sign.NTSB LAX07LA099Accident · 1 fatalLimited investigationFinal reportMallian Rocket II · Arvin, CALoss of control during cruise for undetermined reasons.