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 ERA25LA006Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Moore Haven, FLThe pilot’s failure to initiate the cross country flight with an adequate fuel supply, resulting in a loss of engine power and forced landing due to fuel exhaustion.NTSB WPR25LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Soda Springs, IDThe passenger’s inadvertent application of brakes during landing which resulted in a nose over.NTSB CEN25LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Englewood, COThe collapse of the right main landing gear during landing rollout.NTSB CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA24LA380Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Baltimore, MDThe undetected worn internal parts of the on-condition carburetor, which restricted movement of the float, resulting in fuel starvation. Contributing to the severity of the accident was the pilot’s delayed reduction of the throttle when performing a forced…NTSB CEN24LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Grand Island, NEThe pilot’s inadequate preflight planning/preparation that resulted in fuel exhaustion during cruise flight, a total loss of engine power, and an impact with terrain during a forced landing.NTSB WPR24FA295Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-24-250 · Hawthorne, CAOn September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title…NTSB ERA24LA350Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Shirley, NYThe pilot’s excessive speed during the final approach, which resulted in a collision with a fence during the subsequent aborted landing.NTSB CEN24LA322Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Chetek, WIThe pilot’s improper landing flare and hard landing.NTSB ANC24LA070Accident · No injuriesClass 4 · LimitedFinal reportRoberts Jeff Super RV8 · Carter, WYThe pilots encounter with a shifting winds during takeoff, which resulted in a loss of control and runway excursion.NTSB ERA24LA288Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Medina, OHThe pilot’s failure to extend the landing gear and the flight instructor’s lack of remedial action, which resulted in a landing with the landing gear not correctly configured.NTSB WPR24LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Fernley, NVThe pilot’s failure to maintain directional control during gusting wind conditions.NTSB ERA24LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Zephyrhills, FLA partial loss of engine power during initial climb due to fuel contamination that resulted from corrosion and loose corrosion debris in the carburetor, which restricted fuel flow to the engine.NTSB ERA24LA248Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Colquitt, GAThe failure of the fuel shutoff valve from corrosion, which allowed the valve stem to obstruct the internal fuel port, resulting in a restriction of fuel flow to the engine.NTSB CEN24LA206Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to use the carburetor heat during a descent that resulted in the loss of engine power due to carburetor icing.NTSB WPR24LA160Accident · Minor injuriesClass 3 · LimitedFinal reportSteen Skybolt · Santa Maria, CAA total loss of engine power during approach for reasons that could not be determined.NTSB ERA24LA177Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Carrabassett, METhe pilot’s failure to attain a proper touchdown point while landing in gusty wind conditions.NTSB ERA24LA164Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · North Kingstown, RIA total loss of engine power during final approach due to the pilot’s failure to recognize that the environmental conditions were susceptible to carburetor icing and apply carburetor heat, which resulted in the formation of carburetor ice. Contributing to the…NTSB WPR24FA105Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Madras, ORThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with turbulence and structural icing conditions, loss of control, and subsequent impact with terrain.NTSB CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.NTSB ERA24LA108Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Abingdon, VAThe pilot's failure to lower the airplane's landing gear prior to landing, which resulted in abnormal runway contact.NTSB CEN24LA059Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lubbock, TXThe pilot’s failure to maintain directional control during the landing that resulted in a runway excursion, an impact with a runway sign, and a nose gear collapse.NTSB GAA24WA049Accident · 5 fatalClass 5 · ForeignPiper PA-32-260 · Terre-de-Haut, GuadeloupeNTSB ERA24LA054Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-260 · Millington, TNThe pilots’ fuel mismanagement during the cross-country flight and incorrect fuel tank selection for the landing approach, which resulted in fuel starvation, a momentary loss of engine power, and collision with terrain short of the runway.NTSB ERA24LA031Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ocklawaha, FLThe pilot’s failure to attain a proper touchdown point which resulted in a runway overrun and subsequent impact with a fence.NTSB ERA24LA014Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Ottawa, OHA total loss of engine power due to the formation of carburetor ice..NTSB GAA24WA033Accident · 2 fatalClass 5 · ForeignPiper PA-24-250 · San Juan de la Costa, MexicoNTSB CEN23FA360Accident · Serious injuriesClass 3 · FieldFinal reportPiper PA-24-250 · Oklahoma City, OKThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN23LA357Accident · No injuriesClass 4 · LimitedFinal reportPiper PA25 · Hartington, NEThe pilot’s misperception of the rising terrain resulting in a collision with crops and terrain.NTSB WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Eastsound, WAThe pilot’s improper in-flight fuel management, which led to fuel starvation and a total loss of engine power.NTSB ERA23LA290Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Clearwater, FLThe pilot’s improper preflight inspection which resulted in a loss of engine power due to fuel contamination (water).NTSB ERA23LA287Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCThe pilot’s failure to maintain control of the helicopter during a hover taxi, which resulted in a rollover.NTSB CEN23LA274Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Durango, COThe pilot’s failure to extend the landing gear before landing.NTSB WPR23LA239Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Alturas, CAA loss of engine power due to the failure of the right magneto distributor gear and the pilot’s decision to conduct a test flight with known mechanical issues.NTSB CEN23LA255Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Westhope, NDThe pilot’s failure to maintain aircraft control that resulted in an impact with terrain after takeoff.NTSB WPR23FA225Accident · 1 fatalClass 3 · FieldFinal reportCessna R182 · McCall, IDMaintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.NTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.NTSB CEN23LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Watkins, COThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize the prelanding checklist to ensure the landing gear was extended before landing.NTSB CEN23LA233Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Carrington, NDA total loss of engine power as a result of carburetor ice that formed while the engine was operating at a low power setting for an extended period of time before departure.NTSB GAA23WA159Accident · No injuriesClass 5 · ForeignPiper PA-32-260 · Nicholls Town, BahamasNTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.NTSB ERA23FA239Accident · 1 fatalClass 3 · FieldFinal reportCommander 114TC · Palm City, FLA loss of engine power for undetermined reasons, and the pilot’s subsequent loss of control, which resulted in impact with terrain.NTSB CEN23LA213Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ray, MIThe flight instructor’s failure to maintain airplane control during simulated engine-out procedures. Contributing to the accident was the flight instructor’s decision to land with a tailwind.NTSB ERA23FA234Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-25-235 · Hollywood, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.NTSB ANC23LA033Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235 · Soldotna, AKThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA23FA185Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Sebastian, FLThe pilot’s failure to maintain airplane control during recovery from a bounced landing, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.NTSB CEN23LA132Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Hotchkiss, COThe pilot’s loss of control during landing rollout on a snow-covered, turf airstrip.