NTSB investigations: Hughes 369A, TX

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

19982026

NTSB investigations: Hughes 369A, TX per year, 1998–2026: 4 cases
1998	1
2016	1
2017	1
2018	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" = 'TX' 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 ('4470503')) 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\" = 'TX' 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 ('4470503'))
  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" = 'TX' 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 ('4470503'))
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 CEN18LA183Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Stoneburg, TXThe pilot's unsafe and aggressive operation of the helicopter at low altitude, which resulted in impact with trees.May 19, 2018 · N369GK · Destroyed NTSB CEN17LA336Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Burnet, TXThe pilot's inadequate inflight decision making, which resulted in a total loss of engine power due to fuel exhaustion.Sep 2, 2017 · N50MP · Substantial damage NTSB GAA16LA182Accident · Serious injuriesLimited investigationFinal reportHughes 369 · Weatherford, TXThe pilot/mechanic's inadequate postmaintenance and preflight inspections, which resulted in his failure to remove the antitorque pedal lock and a subsequent loss of control during hover operations.Apr 8, 2016 · N298SD · Substantial damage NTSB IAD98GA110Accident · 1 fatalFinal reportHughes OH-6A · Newark, TXFailure of the Instructor Pilot to control the helicopter's rate of descent during a demonstrated autorotation. Contributing to the accident were the Operator's lack of: a. Instructor Pilot standardization procedures, and b. Specific or adequate flight…Sep 25, 1998 · N234ZM · Destroyed