NTSB investigations: Lycoming GO-480 series
8 cases on aircraft whose registry engine model is Lycoming GO-480 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1997 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41527')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('41527')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ANC97LA128Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fort Yukon, AKfailure of the pilot to maintain directional control of the airplane, which resulted in a swerve and collision with a tree as the pilot continued the takeoff, subsequently jamming the stabilator and causing the plane to crash in water.NTSB LAX96LA174Accident · No injuriesLimited investigationFinal reportHelio H-295 · Grand Canyon, AZthe partial failure of the landing gear brake system resulting from loss of the clips retaining the right-hand brake disk. The resulting loss of braking authority impaired the pilot's ability to maintain directional control in a left quartering tailwind and…NTSB SEA92LA155Accident · No injuriesLimited investigationFinal reportHelio H-295 · Laramie, WYThe pilot's failure to maintain runway alignment, and an inadvertent ground-loop. Factors include crosswinds.NTSB ATL91LA065Accident · No injuriesLimited investigationFinal reportHelio H-295 · Dunlap, TNFailure of the pilot to maintain control of the aircraft, which resulted in a ground loop/swerve. The crosswind was a related factor.NTSB ANC88LA122Accident · No injuriesLimited investigationFinal reportHelio H-295 · Anchorage, AKDuring the takeoff roll on the runway at approximately 20 to 25 mph the pilot lost directional control of the airplane. The airplane looped to the right.NTSB LAX84LA387Accident · No injuriesLimited investigationFinal reportHelio H-295 · Santa Ana, CAAs the tailwheel settled to the rwy the acft veered right and ground looped collapsing the left main ldg gear. The left main gear oleo strut failed due to tensile overload.NTSB ANC83LA136Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fairbanks, AKThe plt reported that during the landing roll, the left brake failed & the acft ran off the right side of the rwy. Reportedly, the acft was damaged when it went off the gravel rwy at or near the departure end. No malfunction or failure of the brake assembly…NTSB LAX83FA100Accident · No injuriesField investigationFinal reportHelio H-395 · Tucson, AZThe acft ground looped during landing and collided with an acft arresting system component. The pilot was landing on RWY11L. He did not report any difficulty controlling the acft until he began his flare. At that time he stated that a slight air disturbance…