Lycoming GO-435
NTSB investigations · 26
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('41520', '42072')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('41520', '42072')
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 ANC19LA027Accident · No injuriesClass 3 · LimitedFinal reportHelio H391 · Hope, AKThe pilot’s failure to maintain directional control during a precautionary landing, which resulted in a ground loop. Contributing to the accident was a partial loss of engine power for reasons that could not be determined.NTSB CEN10LA338Accident · No injuriesLimited investigationFinal reportPilatus P3-05 · Canby, MNThe North American's pilot's failure to maintain adequate visual lookout, which resulted in an on-ground collision with the Pilatus.NTSB IAD00FA044Accident · 1 fatalField investigationFinal reportKurzenburger Stuka JU-87 · Urbana, MDThe pilot's failure to obtain/maintain aircraft control after takeoff.NTSB ANC95LA122Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Kodiak, AKOverload failure of the main landing gear wheel.NTSB ANC94LA007Accident · No injuriesLimited investigationFinal reportHelio H-391-B · Beaver Creek, AKThe pilot's failure to maintain the required airspeed during the emergency descent as published in the pilot's manual. A factor is the loss of engine power for undetermined reasons.NTSB LAX91LA144Accident · No injuriesLimited investigationFinal reportHelio H391B · Prescott, AZThe pilot's failure to maintain directional control and improper use of the flight controls. Contributing to this accident was the cross wind and soft terrain, and the pilot's lack of experience in the airplane.NTSB NYC90DGM03Accident · Minor injuriesFinal reportContinental Copters MK5A · Cranesville, PAThe pilot's inability to maintain control of the helicopter after the loss of a portion of the cyclic control assembly; this resulted in ground impact and post-impact fire.NTSB ANC88LA139Accident · No injuriesLimited investigationFinal reportCessna 180B · Fairbanks, AKThe plt rprtd that drg an aborted takeoff, the acft overran the departure end of the rwy & the left main gear failed. He said he misjudged the performance of the acft, & when he aborted, there was insufficient rwy remaining to stop. Also, he believed the hi…NTSB ANC86LA159Accident · No injuriesLimited investigationFinal reportCessna 180B · Clear, AKThe plt & passenger were on a hunting trip & had selected a clearing on a brush covered hillside for a landing. The clearing had been previously used as an airstrip. While on final apch to land at dusk, the plt lost sight of the touchdown area due to darkness…NTSB ANC84LA171Accident · No injuriesLimited investigationFinal reportHelio H-395A · Shellerbager Ps, AKThe plt landed on a rwy that was covered with 18 to 30 inches of snow. Shortly after touchdown the acft nosed over. The plt recommended that when in doubt about landing-don't land.NTSB CHI81FEP41Accident · No injuriesClosedDehavilland DHC-1 · Mequon, WINTSB ANC80FAA15Accident · No injuriesClosedHelio Acft H-250 · Northway, AKNTSB MKC80DCJ03Accident · Minor injuriesClosedNavion B · Norfolk, NENTSB MIA78PKJ80Accident · No injuriesClosedNavion B · Milton, FLNTSB DEN75FQA09Accident · Minor injuriesClosedNavion A · Aztec, NMNTSB MIA71FLA11Accident · No injuriesClosedRyan Navion · Pensacola, FLNTSB MIA70DKJ49Accident · No injuriesClosedAero Comdr 520 · Mobile, ALNTSB LAX70D0221Accident · No injuriesClosedBeech B50 · Riverside, CANTSB DIA69F0128Accident · No injuriesClosedHelio H-391B · Cumberland, MDNTSB SEA67F0233Accident · Minor injuriesClosedNavion B · Hillsboro, ORNTSB FTW67A0028Accident · No injuriesClosedHughes 269A · Wylie, TXNTSB LAX67F0059Accident · No injuriesClosedHelio H-391B · Van Nuys, CANTSB CHI67F0087Accident · No injuriesClosedNavion B · Marshall, WINTSB UNK65X0610Accident · No injuriesClosedAero Cmdr 520 · Chicago, ILNTSB UNK65X0217Accident · Minor injuriesClosedHelio 391B · Perry, FLNTSB UNK64X4012Accident · No injuriesClosedHughes 269A · Santa Ana, CA
Back to Lycoming GO-435