NTSB investigations: Hughes 269A, IL

10 cases on aircraft the registry lists as Hughes 269A. 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

19642026

NTSB investigations: Hughes 269A, IL per year, 1964–2026: 10 cases
1964	1
1968	1
1969	1
1970	3
1977	1
1978	1
1987	1
2001	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."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470402')) 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.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470402'))
  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" = 'IL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470402'))
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 CHI01LA223Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Jacksonville, ILThe helicopter's loss of engine power for undetermined reasons while maneuvering close to the ground, and the low altitude and low airspeed. A factor relating to this accident was the pilot not being able to get into autorotation.Jul 22, 2001 · N8733F · Substantial damage NTSB CHI87DEE10Accident · Minor injuriesFinal reportHughes 269A · Plainfield, ILWhile maneuvering at about 4 feet above ground level the pilot experienced a loss of engine power and entered an uncontrolled right turn and descent, colliding with the ground. The engine power loss was due to the failure of a stud and bolt holding the…Sep 15, 1987 · N8927F · Substantial damage NTSB CHI78FEV42Accident · No injuriesClosedHughes 269A · Williamsfield, ILJul 10, 1978 · N8774F · Substantial damage NTSB CHI77FEE30Accident · No injuriesClosedHughes 269 · Woodstock, ILJun 27, 1977 · N8925F · Substantial damage NTSB CHI71DBD08Accident · No injuriesClosedHughes 269A · Freeport, ILAug 1, 1970 · N8827F · Substantial damage NTSB CHI70FBD38Accident · No injuriesClosedHughes 269A · Dixon, ILMay 27, 1970 · N8871F · Substantial damage NTSB CHI70FBD33Accident · Minor injuriesClosedHughes 269A · West Chicago, ILMay 9, 1970 · N8790F · Substantial damage NTSB CHI70F0300Accident · No injuriesClosedHughes 269A · Lexington, ILJul 26, 1969 · N8769F · Substantial damage NTSB CHI68F0016Accident · No injuriesClosedHughes 269A · Richmond, ILJun 4, 1968 · N8873F · Substantial damage NTSB UNK64X2599Accident · Minor injuriesClosedHughes 269A · Andalusia, ILJul 1, 1964 · N8748F · Destroyed