Final NTSB investigations: Lycoming HIO-360-A1A

8 cases on aircraft whose registry engine model is Lycoming HIO-360-A1A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Final NTSB investigations: Lycoming HIO-360-A1A per year, 1966–2026: 8 cases
1966	1
1969	1
1972	1
1973	1
1974	1
1975	1
1976	1
2011	1

Where

Open the map

Latest cases

Query with SQL

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41885')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41885'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41885'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN11LA315Accident · No injuriesLimited investigationFinal reportHughes 269B · Edgerton, INA loss of clearance between the tail rotor drive shaft and the tailboom bulkhead for undetermined reasons, which resulted in the overstress failure of the drive shaft.Apr 29, 2011 · N9561F · Substantial damage NTSB DEN76FTE70Accident · No injuriesClosedHughes 269B · Broomfield, COMay 18, 1976 · N9440F · Substantial damage NTSB OAK75DVG54Accident · No injuriesClosedHughes 269B · Newell, CAApr 10, 1975 · N9369F · Substantial damage NTSB DEN75FTE24Accident · No injuriesClosedHughes 269B · Ft.Collins, COSep 8, 1974 · N9440F · Substantial damage NTSB DEN74FTE30Accident · Minor injuriesClosedHughes 269B · Broomfield, CONov 14, 1973 · N9440F · Substantial damage NTSB OAK72FVW25Accident · No injuriesClosedHughes 269B · Las Vegas, NVMar 19, 1972 · N9440F · Substantial damage NTSB LAX70D0213Accident · No injuriesClosedHughes 269B · Phoenix, AZNov 14, 1969 · N9440F · Substantial damage NTSB LAX66A0085Accident · No injuriesClosedHughes 269B · Idlewild, CAMay 7, 1966 · N9440F · Substantial damage