NTSB investigations: Hughes 369HS, 1986
4 cases on aircraft the registry lists as Hughes 369HS. 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
| 1969 | 1 |
|---|---|
| 1970 | 2 |
| 1971 | 3 |
| 1972 | 7 |
| 1973 | 3 |
| 1974 | 3 |
| 1975 | 13 |
| 1976 | 9 |
| 1977 | 9 |
| 1978 | 6 |
| 1979 | 6 |
| 1980 | 9 |
| 1981 | 7 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 7 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470728'))
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 year(c."eventDate") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470728'))
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 MIA87FA046Accident · 2 fatalField investigationFinal reportHughes 369HS · Zephyrhills, FLA witness stated that she heard the eng on the helicopter quit. She looked out her window and watched the helicopter hit the ground, bounce, hit again, flip over and the tail broke off. The helicopter then burst into flames and exploded. Exam of the eng…NTSB ATL86LA251Accident · No injuriesLimited investigationFinal reportHughes 369HS/H-500 · Waterloo, ALThe acft lifted off the top of the support truck and started a takeoff with a partial load of chemicals to be applied to a logged over forest area. About 10-15 feet after lift off the plt detected a loss of rotor RPM. He was at the edge of a ravine with steep…NTSB CHI86LA219Accident · Minor injuriesLimited investigationFinal reportHughes 500 (369HS) · West Lafayette, INThe helicopter was at a low altitude hover video taping an athletic event when the aft flex coupling on the tail rotor failed. The plt was unable to regain control and during descent the main rotor blades struck the roof of a residence. The helicopter then…NTSB SEA86FA056Accident · 3 fatalField investigationFinal reportMcDonnell Douglas 369D · Cougar, WAThe helicopter departed the landing area after a night photography session across the valley floor from the Mt. St. Helens volcano. Prior to departure the plt reported the weather was closing in and getting 'nasty'. Wx conditions as reported prior to…