NTSB investigations: Lycoming 0-540 series, CA
353 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND 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 SEA07CA123Accident · No injuriesData collectionFinal reportPiper PA28-235 · San Jose, CAWind shear encounter during approach for landing.NTSB LAX06LA269Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Carlos, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB ANC06LA041Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mammoth Lake, CAThe collapse of the right main landing gear during landing, which resulted in a loss of directional control and an on-ground encounter with a snowbank. A factor associated with the accident was other maintenance personnel's inadequate inspection of the…NTSB LAX06FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Mammoth Lakes, CAthe pilot's failure to maintain an adequate airspeed resulting in a stall/spin.NTSB LAX05CA280Accident · No injuriesData collectionFinal reportPiper PA-28-236 · San Martin, CAthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the spongy brakes.NTSB LAX05FA271Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Pomona, CAA loss of engine power during the landing approach due to fuel starvation caused by debris and corrosion in the carburetor assembly. A factor contributing to the accident was the failure of the owner to comply with the manufacturer's service bulletin…NTSB LAX05LA266Accident · No injuriesLimited investigationFinal reportAgusta SF 260D · Redding, CAthe company maintenance personnel's failure to follow a prescribed canopy installation procedures.NTSB LAX05FA262Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Big Bear City, CAThe pilot's failure to maintain aircraft control and adequate airspeed while executing an evasive maneuver during an aborted landing, which resulted in a cross-controlled accelerated stall and impact with terrain. Contributing to the accident was the probable…NTSB LAX05FA189Accident · Serious injuriesField investigationFinal reportRobinson R44 · Lucerne Valley, CAthe pilot's failure to maintain adequate main rotor rpm and directional control while maneuvering at low altitude. Contributing factors in the accident were the helicopter's gross weight in excess of the maximum hover out of ground effect limit, a high…NTSB LAX05LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · California City, CAThe failure of the normal landing gear system to extend for undetermined reasons that resulted in a gear collapse during landing.NTSB LAX05CA095Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lake Arrowhead, CAthe certified flight instructor's failure to adequately compensate for wind conditions and his selection of terrain unsuitable for a safe takeoff which resulted in a dynamic rollover.NTSB LAX05LA075Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Llano, CAthe pilot's inadequate preflight planning and failure to verify the amount of fuel onboard the airplane prior to departure, which resulted in loss of engine power due to fuel exhaustion.NTSB LAX04LA287Accident · No injuriesLimited investigationFinal reportCessna TR182 · Torrance, CAA wheels up landing due to the failure of the hydraulic hose leading to the nose gear actuator, which depleted the hydraulic system of pressurized fluid.NTSB LAX04CA263Accident · No injuriesData collectionFinal reportCessna R182 · California City, CAthe pilot's failure to lower the landing gear. A contributing factor was the pilot's distraction while on final approach.NTSB LAX03FA142Accident · 2 fatalField investigationFinal reportCessna TR182 · Eagleville, CAthe pilot's encounter with mountain wave activity with downdrafts and severe turbulence, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was the pilot's improper decision to continue flight into an area of…NTSB LAX03FA051Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Anaheim Hills, CAthe pilot's encounter with forecast severe turbulence during an inadvertent penetration of an intense weather cell, which resulted in the pilot exceeding the design structural limits of the airplane. A factor in the accident was the pilot's inadequate…NTSB LAX03LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Van Nuys, CAfuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB LAX02LA095Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAThe pilot's inadequate planning and improper fuel consumption calculation, which resulted in fuel exhaustion.NTSB LAX02LA065Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oceano, CAA loss of engine power due to the separation of the mixture control cable from the mixture control arm of the carburetor. The mixture cable separation was due to maintenance personnel's failure to secure the mixture control cable away from the nose landing…NTSB LAX02LA050Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Maria, CAInadequate maintenance and inspection of the engine dual magneto that resulted in a loss of engine power during a critical phase of flight, and the subsequent undershoot forced landing in soft terrain.NTSB LAX02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Avalon, CAthe total loss of engine power during departure climb for undetermined reasons.NTSB LAX02LA001Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Petaluma, CAThe pilot's inadvertent (dark, nighttime) VFR flight into instrument meteorological conditions and subsequent loss of altitude control. A factor in the accident was the pilot's inadequate preflight weather evaluation.NTSB LAX01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chino, CAThe pilot's failure to extend the landing gear. A factor was the pilot's failure to use the landing checklist.NTSB LAX01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Petaluma, CAFailure of non-airframe and powerplant mechanic/certificated owners to properly install a new mixture cable that became entangled in the nose landing gear during its extension for landing, resulting in a loss of engine power.NTSB LAX01LA074Accident · No injuriesLimited investigationFinal reportCessna TR182 · Concord, CAThe failure of the pilot to maintain clearance from buildings during taxi.NTSB LAX01FA055Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's improper IFR procedure, failure to maintain course alignment, and use of a nonapproved handheld GPS receiver for navigation during flight in actual instrument meteorological conditions. Factors contributing to the accident were the low clouds and…NTSB LAX00LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Chester, CAThe loss of engine power for undetermined reasons.NTSB LAX00LA019Accident · No injuriesLimited investigationFinal reportCessna TR182 · Fresno, CAInadequate maintenance inspection mandated by the FAA, and the inadequate design of the exhaust heater core/muffler and deflectors that failed to divert hot exhaust gasses away from the battery and cabin heat valve.NTSB LAX99LA159Accident · No injuriesLimited investigationFinal reportCessna R182 · San Luis Obispo, CAThe inadequate preflight inspection of the aircraft by the pilot-in-command which resulted in a loss of engine power due to water contamination in the fuel system. A factor in the accident was an improper maintenance alteration which disabled a fuel sump…NTSB LAX99LA045Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Inyokern, CAThe failure of the pilot to maintain control of the aircraft while landing.NTSB LAX98LA308Accident · No injuriesLimited investigationFinal reportRockwell Commander 114 · Atwater, CAAn internal capacitor failure and melting of the point cam followers, which resulted in failure of both magnetos, and subsequent total loss of engine power.NTSB LAX98LA231Accident · No injuriesLimited investigationFinal reportCessna 182RG · Cameron Park, CAThe pilot's decision to initiate a turn to exit the runway at an excessive rate of speed.NTSB LAX98LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Maricopa, CAThe pilot's misjudgment of the wind direction and speed, and, his inadequate compensation for those conditions. A factor in the accident was the short runway length, which limited the pilot's time to attempt a go-around.NTSB LAX98LA131Accident · No injuriesLimited investigationFinal reportCallair A-9 · Thermal, CAThe failure of the oil pump drive shaft due to the installation of an incorrect oil pump crankshaft gear by maintenance personnel at the last overhaul.NTSB LAX98LA019Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fullerton, CAthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground swerve and subsequent damage to the airplane.NTSB LAX97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAa loss of engine power for undetermined reasons.NTSB LAX97LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Palo Alto, CAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent overload failure of the nose gear.NTSB LAX97FA070Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Lucerne Valley, CAthe pilot's failure to maintain an adequate airspeed after encountering turbulence, low level wind shear, and an open door.NTSB LAX97FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Lost Hills, CAThe pilot's continued VFR flight into instrument meteorological conditions, which led to spatial disorientation and loss of aircraft control, and the pilot exceeding the aircraft's design stress limits during an attempted recovery. The noninstrument-rated…NTSB LAX96LA297Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Truckee, CAThe pilot's failure to properly compensate for a crosswind component during the go-around in a high density altitude environment that led to a loss of aircraft control..NTSB LAX96LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Santa Ana, CAthe pilot's decision to turn off the runway while at an excessive speed that did not allow him to maintain directional control of the aircraft.NTSB LAX96FA229Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Big Bear City, CAimproper preflight by the pilot, by failing to ensure that the fuel selector was positioned to an approved fuel tank with adequate fuel before takeoff; his failure to reposition the fuel selector (per emergency procedures) after the loss of engine power; and…NTSB LAX96LA195Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Adelanto, CAfuel exhaustion as a result of an improper preflight inspection and operating with a known malfunctioning fuel gauge.NTSB LAX96LA193Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Compton, CAThe pilot of the other aircraft's failure to see and avoid N6WR. A factor in the accident was the narrow, confined nature of the taxiway, which restricted the Stinson pilot's ability to perform clearing turns while taxiing.NTSB LAX96FA130Accident · No injuriesField investigationFinal reportBellanca 7GCAA · Los Alamitos, CAthe failure of both pilots to see and avoid each other. Factors were the pilots' failure to use available radar services.NTSB LAX96LA128Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bishop, CAfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve. The unfavorable wind condition was a related factor.NTSB LAX96LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Paradise, CAThe pilot's attempted flight into known adverse weather conditions.NTSB LAX95FA161Accident · 2 fatalField investigationFinal reportHelio H-250 · Round Mountain, CAthe pilot's poor preflight planning/preparation and in-flight decision by continuing VFR flight into instrument meteorological conditions. The pilot's delay in returning to the departure airport, the low clouds, and low visibility were factors in this…NTSB LAX95LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hemet, CAThe other aircraft pilot's inadequate bounced landing recovery and his failure to maintain directional control.NTSB LAX95LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAthe pilot's mismanagement of the fuel system and his failure to select a tank containing fuel.