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.
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 ('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" 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 ERA17LA257Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Myrtle Beach, SCA loss of available power to the main rotor due to a fractured exhaust pushrod and housing, which allowed engine oil to coat the V-belts. Contributing to the accident was the pilot's decision to continue the tour and his failure to maintain adequate rotor rpm…NTSB CEN17LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Pierce, NEThe pilot’s failure to maintain clearance from trees during a low-level agricultural aerial application flight.NTSB GAA17CA395Accident · No injuriesData collectionFinal reportCessna R182 · San Jose, CAThe other pilot’s failure to maintain separation from another airplane in the run-up area while taxiing.NTSB CEN17LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-235 · Harrisonville, MOThe pilot's failure to maintain a safe distance between the airplane and a person on the ground, which resulted in serious injuries to the person.NTSB WPR17LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-260 · Mukilteo, WAThe improper maintenance of the carburetor, which resulted in a stuck float and a partial loss of engine power during takeoff.NTSB ERA17LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Mooresville, NCThe pilot's failure to properly configure the airplane's flaps for takeoff, which resulted in a longer ground roll and subsequent runway excursion.NTSB ERA17WA124Accident · 1 fatalForeign investigationPiper PA25 · Villa Tapia, Dominican RepublicOn March 4, 2017, about 1330 coordinated universal time, a Piper PA-25-235, N8969L, was destroyed following a collision with antenna wires and terrain during an aerial application flight near Villa Tapia, Dominican Republic. The pilot was fatally injured. The…NTSB ERA17LA116Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Chatham, NJMaintenance personnel's improper installation and inspection of the crankshaft gear bolt during major overhaul, which resulted in the crankshaft gear disengaging from the accessory gears of the engine and a subsequent loss of power.NTSB ANC17TA015Accident · Serious injuriesFinal reportPiper PA-32 · Pilot Point, AKThe pilot's continued flight into known icing conditions, which resulted in structural icing and a forced landing on icy, snow-covered terrain.NTSB WPR17FA052Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Port Orford, ORThe pilot's loss of vision during cruise flight, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to fly with a known medical condition.NTSB WPR17LA020Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Taylor, AZA total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB ERA17CA039Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Houlton, MEA total loss of engine power due to fuel starvation, which resulted from the pilot’s mismanagement of the available fuel.NTSB ERA17LA033Accident · No injuriesLimited investigationFinal reportCessna TR182 · Watertown, NYA collapse of the main landing gear for reasons that could not be determined based on the available evidence.NTSB GAA17CA289Accident · No injuriesData collectionFinal reportCessna R182 · Llano, TXThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA037Accident · No injuriesData collectionFinal reportPiper PA24 · Wagoner, OKThe pilot's failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA016Accident · No injuriesData collectionFinal reportRobinson Stewart J Bearhawk · Calhan, COThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ANC16LA072Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe fatigue fracture failure of both main landing gear (MLG) legs during the landing roll, which resulted in the collapse and separation of both MLG legs.NTSB CEN16FA378Accident · 2 fatalField investigationFinal reportPiper PA 28-235 · Lee's Summit, MOThe pilot's improper control inputs during takeoff, which resulted in the exceedance of the airplane's critical angle of attack and subsequent departure stall, and loss of airplane control.NTSB WPR16LA167Accident · Minor injuriesClass 3 · LimitedFinal reportSiai-Marchetti SF260 · Fullerton, CAThe failure of the pilot to set the flaps to the proper takeoff setting before takeoff, resulting in an aerodynamic stall during takeoff and loss of control.NTSB CEN16LA334Accident · Serious injuriesLimited investigationFinal reportPiper PA 25-235 · Bushton, KSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA471Accident · No injuriesData collectionFinal reportPiper PA24 · Hillsboro, OHThe pilot's descent below the intended glidepath during the approach, which resulted in an impact with a ditch prior to the runway.NTSB CEN16LA332Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Miller, MOThe mechanic's improper installation of the left aileron swage fitting, which resulted in an inflight loss of control.NTSB CEN16LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA 25-235 · Arlington, WIThe pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.NTSB ERA16WA219Accident · 2 fatalForeign investigationPiper PA 23-250 · South Bimini, BahamasOn June 19, 2016, about 2120 UTC, a Piper PA-23, N63ZZ was destroyed when it impacted terrain during a forced landing following a loss of engine power near South Bimini International Airport, South Bimini, Bahamas. Two occupants were fatally injured during…NTSB ERA16CA218Accident · No injuriesData collectionFinal reportPiper PA32 · Block Island, RIThe pilot's failure to attain the proper touchdown point and the airplane’s subsequent collision with obstacles during an attempted go-around.NTSB ERA16LA225Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Punta Gorda, FLThe tower controller’s failure to identify and mitigate jet blast from an airplane conducting an engine test run, and the effect of the jet blast on landing traffic, which resulted in a runway excursion when a landing airplane encountered the blast.…NTSB GAA16CA285Accident · No injuriesData collectionFinal reportMaule M5 · Hamilton, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB GAA16CA277Accident · Minor injuriesData collectionFinal reportPiper PA 24 · Loda, ILThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing, runway excursion, and impact with a…NTSB GAA16CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Las Vegas, NVThe pilot receiving instruction's incorrect action of interfering with the flight controls and failure to comply with the flight instructor's commands, which resulted in a loss of lateral bank control and a rollover.NTSB WPR16LA117Accident · No injuriesLimited investigationFinal reportHowell Bob Howell Special · Minden, NVThe failure of the right main landing gear assembly due to overstress fracture.NTSB ERA16LA190Accident · No injuriesLimited investigationFinal reportCessna R182 · Lake City, FLInternal failure of the main electrical contactor, which resulted in a complete loss of electrical power and an inability to extend the landing gear through normal means.NTSB GAA16CA226Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to maintain the airplane's descent rate resulting in a hard landing, and subsequent substantial damage to the firewall.NTSB GAA16CA171Accident · No injuriesData collectionFinal reportRockwell International 114 · Addison, TXThe private pilot's failure to maintain directional control during the landing roll and the flight instructor's delayed remedial action, which resulted in a runway excursion, collision with an airport sign, and a nose gear collapse.NTSB CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…NTSB GAA16CA142Accident · No injuriesData collectionFinal reportMaule M5 · Wasilla, AKThe student pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, and an impact with terrain.NTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.NTSB GAA16CA101Accident · No injuriesData collectionFinal reportCessna 182 · Baton Rouge, LAAn inadvertent collision with a bird while maneuvering during an aerial observation flight.NTSB ERA16LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Millville, NJThe total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB ERA16LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Opa Locka, FLMaintenance personnel's inadequate inspection of the exhaust system, which resulted in the escape of exhaust gases into the engine compartment and a subsequent total loss of engine power.NTSB GAA16CA043Accident · No injuriesData collectionFinal reportCessna 182 · Douglas Bisbee, AZThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion, left main landing gear collapse, and a collision with terrain.NTSB ERA16CA024Accident · Minor injuriesData collectionFinal reportMaule M5 · Warrentown, VAThe pilot's failure to maintain clearance of a cattle-guard fence on landing. Contributing to the accident was his lack of recent flying experience.NTSB CEN16LA021Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Winneconne, WIAn engine compartment fire during landing, which resulted in extensive fire damage, for reasons that could not be determined during examinations of the remaining wreckage.NTSB ERA16LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bluemont, VAA total loss of engine power as a result of the separation of the No. 5 connecting rod for reasons that could not be determined based on the available information.NTSB GAA15CA270Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with a fence.NTSB CEN15LA444Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · New Orleans, LAThe collapse of the landing gear for reasons that could not be determined based on the available information.NTSB ANC15LA073Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fort Glenn, AKThe separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.NTSB CEN15LA404Accident · 1 fatalLimited investigationFinal reportCessna TR182 · Midland, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR15FA250Accident · 1 fatalField investigationFinal reportPiper PA 25 · Llano, CAThe pilot's loss of airplane control during the landing approach due to an incapacitating medical event.NTSB CEN15LA383Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Harvey, NDThe partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.NTSB ERA15CA272Accident · Minor injuriesData collectionFinal reportSmith Steen Skybolt · Junction City, KYThe pilot's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.