NTSB investigations: Lycoming IO-540 series, CA
88 cases on aircraft whose registry engine model is Lycoming IO-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 ('41530', '41585'))
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 ('41530', '41585'))
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 LAX02FA073Accident · 1 fatalField investigationFinal reportPiper Aerostar 601P · Stonyford, CAthe pilot's failure to maintain terrain clearance during cruise flight, which resulted in the in-flight collision with mountainous terrain. Factors in the accident were the mountainous terrain and the dark night light conditions.NTSB LAX02LA068Accident · No injuriesLimited investigationFinal reportCessna 206H · Mammoth Lakes, CAthe pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a loss of aircraft control and nose over during landing roll.NTSB LAX02FA031Accident · 5 fatalField investigationFinal reportAero Commander 500S · Eagleville, CAthe pilot's encounter with forecast mountain wave conditions, moderate or greater turbulence, and icing, with downdrafts that likely exceeded the climb capability of the airplane, which was encountered at an altitude that precluded recovery. Also causal in…NTSB LAX02LA021Accident · No injuriesLimited investigationFinal reportCessna 182S · Palm Springs, CAThe failure of the pilot-in-command to maintain directional control of the airplane after encountering a dust devil during landing roll.NTSB LAX02FA019Accident · 1 fatalField investigationFinal reportCessna 182S · Little River, CAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB LAX02LA015Accident · No injuriesLimited investigationFinal reportThomson Harmon Rocket II · Perris, CAthe airplane builder's failure to properly install a bolt and nut into the aileron and elevator flight control system. A contributing factor was the soft terrain conditions for the ensuing forced landing.NTSB LAX01LA045Accident · Serious injuriesLimited investigationFinal reportCollette Glassair III · Guistine, CAMaintenance personnel misrouted the crankcase breather hose so that it was pinched when the cowling was installed. This pressurized the crankcase displacing the oil seal and forcing oil out of the engine. A factor was the unsuitable terrain encountered during…NTSB LAX01FA003Accident · 1 fatalField investigationFinal reportCessna 182S · Santa Rosa, CAthe pilot's loss of airplane control due to spatial disorientation. A related factor was the low ceiling.NTSB LAX00LA282Accident · Serious injuriesLimited investigationFinal reportDaniel J. Lee Express 90 · Cottonwood, CAThe pilot's failure to maintain directional control during landing roll, which resulted in the on ground collision with trees.NTSB LAX99LA201Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Valley Springs, CAThe fatigue failure and separation of the No. 6 connecting rod end cap, which led to a catastrophic failure of the engine. The fatigue crack initiation was due to galling on the rod end cap, which was most likely caused by an undetermined factory…NTSB LAX97LA281Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Borrego, CAThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain runway alignment during the takeoff roll.NTSB LAX97LA303Accident · 1 fatalLimited investigationFinal reportFleming Glassair III · Dunsmuir, CAwas the pilot's intentional flight into marginal meteorological conditions in mountainous terrain during dark nighttime conditions.NTSB LAX93IA235Incident · No injuriesIncident investigationFinal reportUS/Lta 138-S · Santa Maria, CAInadequate specifications in the design and manufacture of a rudder control tube rod end bearing by the airship manufacturer.NTSB LAX93LA012Accident · 2 fatalLimited investigationFinal reportGilbert SX300 · Rosamond, CAThe pilots inadequate compensation for the wind conditions and his failure to maintain an adequate airspeed while maneuvering which led to an inadvertent stall spin.NTSB LAX92TL#08Accident · No injuriesClass 3Final reportPiper PA36-300 · Madera, CANTSB LAX92LA223Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Groveland, CAThe pilot's inadvertent placement of the landing gear selector in the up position during the initial portion of the landing rollout.NTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…NTSB LAX92LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT-300 · Big Bear City, CAThe failure of the pilot to maintain directional control and improper use of the rudder. Contributing to the accident was the improper installation by the company of a hand control mechanism that required the pilot to operate the airplane controls with one…NTSB LAX90DVG12Accident · Serious injuriesFinal reportE.J. Novotny Steen Skybolt · Fall River Mill, CALoss of power for undetermined reasons.NTSB LAX90DUA01Accident · Minor injuriesFinal reportHomebuilt JP-350-1 · Torrance, CAThe aircraft collision with the ground after the pilot experienced a loss of engine thrust due to propeller overspeed condition. Contributing to the accident was the pilot's improper servicing of the propeller hub that allowed the overspeed to occur.NTSB LAX90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-300 · Sacramento, CAAn inadvertent collision with a large bird during the hours of darkness while in the landing pattern.NTSB LAX89LA036Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Camarillo, CAPilot of N8219J used poor judgement when she elected to execute the high speed taxi operation.NTSB LAX87DVA03Accident · No injuriesFinal reportEagle DW-1 · Modesto, CADuring an aerial application flight, the pilot stated that just after the aircraft became airborne, it began to lose altitude and struck a canal bank at the end of the dirt strip. There were no reported mechanical failures or malfunctions. The acft was loaded…NTSB LAX86LA008Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Santa Barbara, CAOn oct. 3, 1985, pipter PA-23-250 crashed into the pacific ocean while on an air sampling flt near Santa Barbara, CA. The ac was destroyed and the two plts were fatally injured. The flt was to be flown along a predermined route utilizing loran navaids. The ac…NTSB LAX85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAAfter spending the day skiing, the plt & passengers planned to depart on a return flt to san diego. The wind was from 210 to 220 deg at about 10 mph. The plt elected to takeoff on rwy 7 since low clouds were approaching from the west & the visibility was near…NTSB LAX85LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Sanger, CAUpon touchdown, the left main landing gear contacted a pothole in the rwy aprx 175 ft from the threshold. Skid marks from the left main tire were seen on the rwy beginning at that point along with metal scrappings from the gear. Shortly thereafter, skid marks…NTSB LAX82DA239Accident · No injuriesFinal reportCessna R182 · Fresno, CAWhen the landing gear was extended to demonstrate an approach-to-landing stall, there was no safe indication. The gear was recycled but the nose gear would not extend. All attempts to extend the nose gear, including the use of the emergency extension hand…NTSB LAX82FA161Accident · 3 fatalField investigationFinal reportSmith Aerostar 600 · Burbank, CAThe aircraft departed into IFR conditions with a non-instrument rated pilot in the left front seat and his wife, an instrument rated pilot, in the right front seat. After the pilot reported climbing through 2800 ft MSL, the radar controller observed that the…NTSB LAX81DUG13Accident · No injuriesClosedPiper PA-32 · Salton Sea, CANTSB LAX81DUG02Accident · No injuriesClosedPiper PA-32 · Rialto, CANTSB LAX80FUG39Accident · No injuriesClosedNa Rockwell 114 TC · Baker, CANTSB LAX80FUD04Accident · No injuriesClosedPiper PA-32 · Los Angeles, CANTSB LAX79FA050Accident · 1 fatalClosedPiper PA-32 · La Posta, CANTSB LAX78FA071Accident · 4 fatalClosedPiper PA-32 · Laverne, CANTSB OAK78DXQ41Accident · No injuriesClosedPiper PA-28 · Lake Tahoe, CANTSB OAK78FVM18Accident · Serious injuriesClosedBrittnorman BN2A21 · San Jose, CANTSB LAX76DUG47Accident · Minor injuriesClosedStarduster TOO · Sun City, CANTSB LAX68F0270Accident · No injuriesClosedAero Comdr 680 · Van Nuys, CA