NTSB investigations: Hughes 369HS, CA
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
| 1974 | 1 |
|---|---|
| 1975 | 3 |
| 1977 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2001 | 1 |
| 2010 | 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\" = 'CA' 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" = 'CA' 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 WPR10LA308Accident · No injuriesLimited investigationFinal reportHughes 369HS · Paicines, CAAn in-flight fire for undetermined reasons.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 LAX90FA248Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369HS · Modesto, CAIn-flight engine fire of undetermined origin.NTSB LAX88LA322Accident · No injuriesLimited investigationFinal reportHughes 369HS · Columbia, CADuring an external load operation, there was an indication of high torque and the oil chip light illuminated. The engine lost power and the pilot initiated an autorotation. The helicopter collided with the sloping terrain and rolled over. Inspection of the…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…NTSB LAX83FA420Accident · 1 fatalField investigationFinal reportHughes 369HS · Ventura, CAThe helicopter was observed descending 'straight down' & 'nose first.' The wreckage was located about 200 yds offshore in about 30 ft of water. Witnesses stated that it was dark & hazy. They were able to see the acft lights, but not the stars. The plt did not…NTSB LAX82FA026Accident · 2 fatalClosedHughes 369HS · Lakeside, CANTSB LAX80FVG36Accident · No injuriesClosedHughes 369HS · Georgetown, CANTSB OAK79DVG13Accident · No injuriesClosedHughes 369C · Montague, CANTSB OAK77FVM22Accident · No injuriesClosedHughes 369HS · Salinas, CANTSB OAK77FA038Accident · Minor injuriesClosedHughes 369HS · Mt Darwin, CANTSB LAX75FUA24Accident · Minor injuriesClosedHughes 369HS · Long Beach, CANTSB LAX75AL045Accident · Serious injuriesClosedHughes 369HS · Ballarat, CANTSB OAK75DXQ35Accident · No injuriesClosedHughes 369HS · Truckee, CANTSB OAK75DVD21Accident · No injuriesClosedHughes 369 · Pinole, CA