NTSB investigations: Hughes 369HS
11 cases on aircraft the registry lists as Hughes 369HS, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 2000 | 1 |
| 2001 | 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.\"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\" = 220))
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" = 220))
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 LAX01LA211Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Mountain View, CAThe pilot's failure to maintain control while hovering out of ground effect. A factor was the wind gusts.NTSB SEA01FA032Accident · 2 fatalField investigationFinal reportHughes 369HS · Pierce, IDWhile maneuvering, clearance from an object was not maintained. A tree was a factor.NTSB CHI97LA016Accident · 1 fatalLimited investigationFinal reportHughes 369 · Vestaburg, MIfailure of the pilot to maintain clearance with the wires.NTSB SEA96LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Arock, ORthe pilot's failure to see and avoid the transmission wire. A factor was the low altitude flight.NTSB LAX95LA298Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas 500 · Pacific Ocean (Pacific Ocean)the accidental discharge of a spear gun by the observer.NTSB SEA95LA139Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Orting, WAThe pilot's failure to see and avoid the cable.NTSB BFO91LA036Accident · No injuriesLimited investigationFinal reportHughes 369HS · Columbia, MDThe pilot's inadequate visual lookout, which resulted in his failure to see-and-avoid the obstruction (fence post).NTSB LAX90LA162Accident · No injuriesLimited investigationFinal reportHughes 369C · Kahului, HIThe pilots failure to ensure that adequate room existed to position the helicopter on the landing platform. Contributing to the accident was the failure of ground personnel to ensure that hazards to the landing helicopter were clear of the landing area.NTSB NYC89LA171Accident · No injuriesLimited investigationFinal reportHughes 369HS · Niagara Falls, NYFailure of the pilot to see and avoid the cables.NTSB MIA88FA257Accident · Serious injuriesField investigationFinal reportHughes 500 · Riviera Beach, FLThe traffic watch helicopter was cruising northbound along the interstate at 450 ft AGL & 85 KTS airspeed. A grinding noise was heard & the tail rotor separated from the acft. The acft began an uncommanded right turn which was arrested in about 1/4 turn. The…NTSB LAX82DA140Accident · 3 fatalFinal reportHughes 369HS · 8 S. Of Page, AZThe aircraft was number two in a trail of three helicopters flying up the Colorado river at marble canyon to page, AZ when it struck an aerial cableway stretching across the river, 22 ft above the water. Witnesses stated that after the collision the…