NTSB investigations: Hughes 369HS, AK
15 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
| 1972 | 2 |
|---|---|
| 1973 | 1 |
| 1975 | 4 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 2 |
| 1982 | 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.\"eventStateOrRegion\" = 'AK' 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 ('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 c."eventStateOrRegion" = 'AK' 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 ('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 ANC82DA039Accident · No injuriesFinal reportHughes 369HS · Tok, AKThe pilot was conducting a non-revenue, sling-load operation on mt neuberer, while donating his services to Tok community tv, inc. he stated that he was lifting three empty propane bottles from a snow field when he noticed the auto relight lamp flash. He…NTSB ANC80DA083Accident · Minor injuriesClosedHughes 500C · Sitka, AKNTSB ANC80DA080Accident · No injuriesClosedHughes 369 · Kivalina, AKNTSB ANC79DA086Accident · Serious injuriesClosedHughes 500C · Alakanuk, AKNTSB ANC78DA061Accident · Minor injuriesClosedHughes 500-C · Ketchikan, AKNTSB ANC77FA086Accident · Minor injuriesClosedHughes 369HS · Cantwell, AKNTSB ANC76AA128Accident · 3 fatalClosedHughes 369HS · Hawk Inlet, AKNTSB ANC76AA109Accident · Serious injuriesClosedHughes 369HS · Juneau, AKNTSB ANC76AA024Accident · No injuriesClosedHughes 369HS · Nome, AKNTSB ANC76AA011Accident · Minor injuriesClosedHughes 369HS · Deadhorse, AKNTSB ANC76DAG94Accident · Minor injuriesClosedHughes 269B · Anchorage, AKNTSB ANC75AA069Accident · 3 fatalClosedHughes 369HS · Petersburg, AKNTSB ANC74AA013Accident · Serious injuriesClosedHughes 369HS · Ketchikan, AKNTSB ANC73AA024Accident · 1 fatalClosedHughes 369B · Deadhorse, AKNTSB ANC73AA019Accident · No injuriesClosedHughes 369S · Craig, AK