NTSB investigations: Lycoming GO-435, AK
7 cases on aircraft whose registry engine model is Lycoming GO-435. 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 per year
| 1980 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2019 | 1 |
Where
Open the mapLatest cases
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\" = 'AK' 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 ('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_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" = 'AK' 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 ('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 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 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 ANC80FAA15Accident · No injuriesClosedHelio Acft H-250 · Northway, AK