NTSB investigations: Hughes 369HS

7 cases on aircraft the registry lists as Hughes 369HS, where the first occurrence was “In flight collision with terrain/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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Hughes 369HS per year, 1982–2026: 7 cases
1982	1
1992	1
1994	2
1999	1
2003	1
2005	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470728') 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" = 230)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470728')
      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\" = 230))
  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.aircraft_model_code IN ('4470728')
    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" = 230))
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 DEN05LA056Accident · No injuriesLimited investigationFinal reportHughes 369HS · Provo, UTthe pilot's improper in-flight planning and decision making, his failure to maintain terrain clearance, and the total failure of the tail rotor drive shaft as a result of the tail rotor strike.Feb 3, 2005 · N9118F · Substantial damage NTSB CHI04LA017Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Evansville, MNThe pilot's misjudgment of clearance from the surface of the lake during the aerial application pass. The low altitude operation, glassy water, and his visual perception were contributing factors.Oct 21, 2003 · N49TJ · Substantial damage NTSB LAX99LA292Accident · 2 fatalLimited investigationFinal reportHughes 369HS · Pohnpei (Pacific Ocean)An in-flight collision with the water for undetermined reasons.Sep 1, 1999 · N42054 · Destroyed NTSB SEA94FA194Accident · 2 fatalField investigationFinal reportHughes 369HS · Seaside, ORInflight collision with terrain for undetermined reasons.Jul 24, 1994 · N7771F · Destroyed NTSB MIA94LA165Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Sarasota, FLAltitude misjudged by the pilot.Jun 22, 1994 · N520TC · Substantial damage NTSB SEA93LA030Accident · No injuriesLimited investigationFinal reportHughes 369HS · Scotts Mills, ORThe pilot in command's misjudged descent. Factors include the pilot in command's lack of experience in this type of operation.Nov 27, 1992 · N9228F · Substantial damage NTSB SEA82DA055Accident · No injuriesFinal reportHughes 500C · Darrington, WADuring an approach to a 9100 foot high snow covered landing site the wind shifted to a tailwind condition. The pilot elected to continue and attempted a skid on landing. While skidding through the snow the left skid impacted rising terrain underneath a 12…Apr 19, 1982 · N9131F · Substantial damage