NTSB investigations: Hughes 369HS
4 cases on aircraft the registry lists as Hughes 369HS, where the first occurrence was “Loss of engine power(partial) - mech failure/malf”. 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1993 | 1 |
| 1997 | 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\" = 352))
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" = 352))
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 LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.NTSB MIA93LA143Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Orlando, FLUnsuitable terrain encountered during the autorotative forced landing. Contributing to the accident was total loss of engine power due to seizure of the compressor impeller following failure of the no.2 bearing for undetermined reasons.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 LAX84LA163Accident · Serious injuriesLimited investigationFinal reportHughes 500C (369HS) · San Diego, CAThe plt reported a partial power loss. During the forced landing tahe right skid collapsed & the t/r severed the tail boom. During a subsequent eng test, the eng would produce no more than 20 PSI torque at 100% N2. The fuel control & fuel nozzle were found to…