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 LAX92LA144Accident · No injuriesLimited investigationFinal reportPiper PA28-235 · Havasu Lake, CAThe dual student's failure to maintain directional control, the cfi's improper supervision of the flight, and the cfi's failure to perform the necessary remedial action. Contributing to this accident was the dual student's improper use of the brakes.NTSB DEN92LA031Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Durango, COThe pilot's failure to maintain directional control. A factor was: crosswind.NTSB FTW92LA052Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cottonport, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB FTW92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Houston, TXThe pilot's failure to correctly calculate fuel consumption and the loss of engine power. A factor was the unsuitable terrain.NTSB FTW92LA027Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Fe, NMThe right main gear collapsed for undetermined reasons, which resulted in the pilot's loss of directional control during the landing roll.NTSB SEA92LA017Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Belt, MTA blocked fuel vent and an inadequate preflight inspection, which resulted in fuel starvation.NTSB DEN92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Ellicott, COA power loss for undetermined reasons, the pilot's poorly planned approach, and excessive airspeed. Factors were: the pilot's intentional flight into IMC, accumulation of wing ice and his becoming lost disoriented.NTSB SEA92FA222Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Moran, WYThe pilot's failure to maintain clearance and altitude from terrain while maneuvering, and his failure to adequately compensate for the wind conditions. Factors contributing to the accident are terrain-induced turbulence, unfavorable winds, gusty high winds,…NTSB LAX92LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Linden, CAThe pilot in command inaccurately calculating the aircraft's fuel consumption, and not re-fueling the aircraft prior to takeoff from his last departure point. This resulted in a power loss due to fuel exhaustion. A factor in this accident was the unsuitable…NTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.NTSB MIA92LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Vieques, PRInadequate aircraft maintenance inspection resulting in the defective muffler which failed and caused an inflight fire.NTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.NTSB SEA91LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Arco, IDWater in the fuel tank and the inability of the pilot to flare for landing after maneuvering to avoid transmission lines in his flight path during the forced landing.NTSB LAX91LA367Accident · No injuriesLimited investigationFinal reportCessna R182 · Fredonia, AZFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.NTSB ATL91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waxhaw, NCThe spatial disorientation experienced by the pilot in IMC, his failure to maintain aircraft control, and the exceeding of the design stress limits of the aircraft. Factor(s) in this accident were: the pilot's inadequate preflight planning, the VFR flight…NTSB ATL91LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Roxobel, NCThe failure of the left magneto stop pin, resulting in the seizure of the magneto and the failure of the magneto drive gear, and ultimately engine stoppage. A factor in this accident was: the presence of trees at the forced landing area.NTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.NTSB ATL91LA133Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Hawkinsville, GAThe pilot's inadequate preflight planning, his failure to refuel the airplane when he observed his fuel supply getting low, and the resultant exhaustion of his fuel supply.NTSB LAX91FA310Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Hesperia, CAThe pilot's improper refueling and inadequate preflight which resulted in fuel contamination and the inadvertent stall.NTSB LAX91LA304Accident · 1 fatalLimited investigationFinal reportPiper PA24-250 · Temple Bar, AZThe pilot's failure to maintain control of the aircraft during an attempted return to runway maneuver and the entry into an inadvertent stall/spin at low altitude. The exact nature of the emergency problem encountered by the pilot is undetermined.NTSB DEN91LA088Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Las Cruces, NMPower loss due to fuel contamination. A factor was: pilot's inadequate airplane preflight.NTSB MIA91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PROil exhaustion for undetermined reasons.NTSB MIA91FA155Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Long Boat Key, FLAn inflight loss of control and subsequent collision with the water for unknown reasons.NTSB CHI91DEP05Accident · No injuriesFinal reportPiper PA-25-235 · Neenah, WIThe pilot in command's failure to attain sufficient airspeed to achieve flight, and his failure to abort the takeoff.NTSB SEA91LA114Accident · No injuriesLimited investigationFinal reportCessna TR182 · Green River, UTWorn brakes. Contributing to the accident was: poor maintenance.NTSB CHI91LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Jackson, MIFailure to the pilot to assure gear extension. Factors related to the accident were the electrical failure due to a seized alternator and diverted attention by the pilot.NTSB LAX91LA177Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · Gualala, CAThat the pilot failed to properly use the flight controls and to maintain directional control. Contributing to this accident were the gusty crosswind conditions that existed at the time of the accident.NTSB LAX91LA171Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Casa Grande, AZThat the pilot failed to maintain proper alignment during the landing roll on the narrow airstrip.NTSB FTW91DPJ01Accident · Serious injuriesFinal reportPiper PA-25 · Spiro, OKA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB BFO91LA032Accident · No injuriesLimited investigationFinal reportPiper PA32-260 · Roanoke, VAThe pilot's failure to maintain terrain clearance on a night visual approach.NTSB MIA91LA081Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plant City, FLFailure of the pilot to maintain proper alignment during the landing roll, excessive rudder input, and loss of directional control resulting in the collapse of the right main landing gear.NTSB ATL91LA048Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Lumberton, NCThe pilot suffered a stroke and lost control of the airplane on final approach.NTSB NYC91LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wildwood, NJThe pilot's failure to apply carburetor heat during the descent which resulted in a loss of engine power due to carburetor ice.NTSB CHI91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe deer crossing the runway which the pilot was unable to avoid.NTSB MIA91LA041Accident · No injuriesLimited investigationFinal reportCessna 182RG · Orlando, FLFailure of the pilot to maintain directional control during the landing roll.NTSB DEN91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sherman, TXA pilot induced inadvertent stall.NTSB CHI91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oswego, KSFuel starvation due to improper placement of the fuel tank selector by the pilot.NTSB CHI91LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Latham, KSFailure of the pilot to maintain a proper altitude.NTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB NYC91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bally, PAThe pilot's improper recovery from a bounced landing and his failiure to maintain directional control.NTSB ATL91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GATotal failure of a connecting rod cap bolt which resulted in a total loss of power.NTSB LAX91FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Redlands, CAA total loss of engine power due to fuel starvation as a result of a fuel system leak of an undetermined origin.NTSB NYC91LA008Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Moscow, PAA hard landing due to the failure of the pilot to properly arrest his descent rate and the failure of the flight instructor to adequately monitor the actions of the pilot.NTSB DEN90DTE08Accident · No injuriesFinal reportPiper PA-25-235 · Idalia, COThe encounter with an unfavorable wind, a dust devil. A factor was the inability of the pilot to maintain directional control.NTSB CHI90LA253Accident · No injuriesLimited investigationFinal reportPiper PA25-235 · Logansport, INThe engine failed due to fuel exhaustion. The presence of standing corn in the touchdown area was a factor.NTSB NYC90LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Reading, PAA loss of engine power for unknown reasons and an off airport landing on unsuitable terrain.NTSB SEA90LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA24-250 · Lagrande, ORThe pilot did not allow the airplane to attain an adequate airspeed prior to the retraction of flaps and landing gear.NTSB FTW90DQG04Accident · 1 fatalFinal reportPiper PA-25-235 · Lubbock, TXFailure of the pilot to maintain adequate airspeed and altitude during a turn-around maneuver, which resulted in the aircraft stalling into the ground.NTSB DEN90DQA03Accident · No injuriesFinal reportPiper PA-25-235 · Fabens, TXEngine failure due to shorting of the magneto's 'p' lead, and failure of the exhaust manifold.NTSB DEN90LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bingham, NMThe fuel exhaustion induced power loss. Factors were the pilot's failure to refuel and the unsuitable terrain in which the forced landing was performed.