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 WPR10CA193Accident · No injuriesData collectionFinal reportRobinson R44 · San Juan Batista, CAThe pilot's failure to maintain adequate clearance from wires while maneuvering and his subsequent improper use of the collective control, which resulted in the main rotor contacting the tail boom.NTSB CEN10LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Peoria, ILA loss of engine power for undetermined reasons during climb out after takeoff, which resulted in a forced landing to a roadway.NTSB WPR10FA005Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Black Canyon City, AZThe pilot's decision to continue VFR flight into instrument meteorological weather conditions which resulted in controlled flight into terrain. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB CEN09LA605Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Troy, MIA loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.NTSB WPR09LA436Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Torrance, CAA main rotor overspeed due to the pilot’s failure to maintain rotor RPM within allowable limits during a practice autorotation.NTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.NTSB CEN09CA515Accident · No injuriesData collectionFinal reportCessna TR182 · Carrollton, OHThe airplane's impact with the deer during the night landing.NTSB CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.NTSB ERA09FA417Accident · 4 fatalField investigationFinal reportRobinson Helicopter R44 · Boonsboro, MDThe pilot’s improper decision to depart on a visual flight rules (VFR) flight at night in adverse weather conditions in close proximity to rising mountainous terrain in a helicopter that was only certified to be operated under VFR and his subsequent failure…NTSB ERA09FA411Accident · 1 fatalField investigationFinal reportCessna R182 · Hayesville, NCFlight into terrain for undetermined reasons.NTSB ANC09WA063Accident · 1 fatalForeign investigationMaule M-5-235C · Whitehorse, CanadaOn July 13, 2009, about 2145 pacific daylight time, a float-equipped Maule M-5-235C airplane, N9138E, nosed over and partially sank while landing on Kluane Lake, about 127 miles northwest of Whitehorse, Yukon, Canada. The airplane was being operated as a…NTSB ERA09CA395Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Rutherford, NCThe pilot's failure to maintain adequate airspeed while performing a go-around which resulted in a stall.NTSB ERA09LA380Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Westerly, RIThe pilot's failure to use carburetor heat resulting in a complete loss of engine power due to carburetor icing.NTSB WPR09CA315Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Preston, IDA loss of engine power due to fuel exhaustion that resulted from the pilot's inadequate fuel planning.NTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…NTSB ANC09CA056Accident · No injuriesData collectionFinal reportMaule M-5-235C · Wasilla, AKThe pilot's selection of an unsuitable takeoff area with an unfavorable wind.NTSB ERA09CA318Accident · No injuriesData collectionFinal reportPiper PA28 · Elberton, GAThe student pilot's improper recovery from a bounced landing.NTSB WPR09CA271Accident · No injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 235 · Ontario, ORThe pilot's misjudged landing flare. Contributing to the accident was the pilot's lack of any experience in the make and model airplane.NTSB ANC09LA042Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wasilla, AKA loss of engine power due to the blockage of the carburetor air inlet by a piece of engine baffling. Contributing to the accident was a worn engine baffle, and the pilot/owner's failure to have the engine baffle replaced.NTSB WPR09CA240Accident · No injuriesData collectionFinal reportFagan BearHawk · Hadley, NVThe pilot's inadequate compensation for the gusting crosswinds during takeoff.NTSB ANC09GA040Accident · No injuriesFinal reportRobinson Helicopter R44 · Iliamna, AKThe main rotor transmission mount design, which resulted in an in-flight vibration/oscillation, and damage to the helicopter during an emergency descent and hard landing. Contributing to the accident was the lack of information from the manufacturer regarding…NTSB WPR09LA204Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Los Angeles, CAThe pilot's inadequate compensation for the crosswinds and failure to maintain directional control during the landing roll.NTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.NTSB CEN09CA245Accident · No injuriesData collectionFinal reportCessna R182 · Granger, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight.NTSB WPR09LA169Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · San Carlos, CAA total loss of engine power during the initial climb for undetermined reasons.NTSB WPR09CA157Accident · No injuriesData collectionFinal reportPiper PA-24-250 · San Luis Obispo, CAThe pilot's inadequate compensation for the crosswinds during touchdown.NTSB WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.NTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.NTSB WPR09CA131Accident · No injuriesData collectionFinal reportCessna TR182 · Amargosa Valley, NVThe pilot's failure to maintain adequate airspeed and runway alignment.NTSB CEN09LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28C-235 · Falcon, COA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB WPR09CA109Accident · No injuriesData collectionFinal reportSeher Bearhawk · Reno, NVThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during takeoff. Contributing to the accident were a crosswind and the pilot's delayed decision to abort the takeoff.NTSB CEN09LA144Accident · 3 fatalLimited investigationFinal reportCox William M Bearhawk · Anahuac, TXA loss of control in flight for undetermined reasons.NTSB ERA09LA131Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Pensacola, FLThe pilot’s failure to maintain airspeed following a total loss of engine power during a low-level approach, which resulted in an aerodynamic stall. Contributing to the accident was fuel exhaustion due to the pilot’s inadequate preflight planning.NTSB CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.NTSB ERA09WA113Accident · 12 fatalForeign investigationBritten Norman BN-2A MK III · Turks and Caicos, Turks & Caicos IslandsNTSB ERA09LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · New Bern, NCA loss of engine power for undetermined reasons.NTSB WPR09FA038Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Sedona, AZThe partial loss of engine power while maneuvering for undetermined reasons.NTSB ERA09LA051Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · San Juan, PRThe detachment of the forward left servo control tube upper rod end attachment bolt during a hover due to separation of its retaining nut for undetermined reasons.NTSB ERA09LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Plymouth, NCThe Piper Dakota (PA-28-236) pilot's failure to see and avoid the Piper Cherokee (PA-32-260).NTSB WPR09LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORAn in-flight engine fire due to the fatigue fracture of an exhaust pipe that resulted from a failure of the pipe's slip joint.NTSB NYC08LA299Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Cumberland, RIThe pilot's improper fuel management practices, which resulted in fuel starvation and a complete power loss. Contributing to the accident was the pilot's misdiagnosis of the situation, and his cessation of trouble-shooting to positively identify and correct…NTSB LAX08LA284Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spotted Bear, MTThe pilot's inadequate compensation for the variable wind conditions and failure to maintain adequate airspeed during landing.NTSB LAX08LA272Accident · 1 fatalLimited investigationFinal reportSocata Rallye 235E · San Martin, CAThe pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.NTSB LAX08FA267Accident · 1 fatalField investigationFinal reportCessna TR182 · Sahuarita, AZThe pilot’s failure to maintain clearance from mountainous terrain while maneuvering at low altitude for undetermined reasons.NTSB CHI08CA243Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Cosmos, MNThe pilot's failure to maintain clearance from the guide wire while maneuvering on an aerial application flight. Contributing to the accident was the presence of the guide wire.NTSB NYC08CA278Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Dresden, TNThe pilot's failure to maintain the proper altitude/clearance while on final approach.NTSB LAX08LA254Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Jean, NVThe failure of both pilots to see and avoid the other aircraft while maneuvering over the airport.NTSB CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.NTSB CHI08CA206Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Lowell, MIThe inadequate preflight planning/preparation and the short field takeoff procedure not followed by the pilot. An additional cause was the delayed aborted takeoff by the pilot. A contributing factor was the trees.NTSB LAX08LA235Accident · No injuriesLimited investigationFinal reportExtra Flugzeugproduktions-und EA 300/L · San Jose, CAThe pilot of the other airplane's inadequate visual lookout and failure to maintain clearance from another airplane.