NTSB investigations: Lycoming HIO-360 series, GA
9 cases on aircraft whose registry engine model is Lycoming HIO-360 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 per year
| 1969 | 1 |
|---|---|
| 1971 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 2016 | 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\" = 'GA' 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 ('41524'))
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" = 'GA' 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 ('41524'))
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 ERA19LA173Accident · No injuriesClass 3 · LimitedFinal reportHughes 269B · Hampton, GAGround resonance during landing for reasons that could not be determined based on the available information.NTSB ERA16LA261Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Calhoun, GAThe helicopter owner’s failure to ensure the helicopter’s airworthiness and the inadequate inspection and maintenance of the helicopter's landing gear dampers, which resulted in ground resonance during throttle application. Contributing to the damage of the…NTSB ATL94LA100Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hiram, GAThe inadvertent flight from VMC conditions to IMC conditions by the pilot. A factor in the accident was the ground fog in the area.NTSB ATL90LA043Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norcross, GAThe student pilot's improper execution of the landing procedure resulting in dynamic roll-over of the helicopter.NTSB MIA79DKG57Accident · No injuriesClosedHughes 269C · Montezuma, GANTSB MIA77FKG78Accident · No injuriesClosedHughes 269 · Montezuma, GANTSB MIA77FKG69Accident · No injuriesClosedHughes 269C · Montezuma, GANTSB MIA72FKG44Accident · No injuriesClosedHughes 269B · Arlington, GANTSB MIA70F0248Accident · No injuriesClosedHughes 269B · Arlington, GA