NTSB investigations: Hughes 269C, ID
7 cases on aircraft the registry lists as Hughes 269C. 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 | 1 |
|---|---|
| 1976 | 1 |
| 1977 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 2003 | 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\" = 'ID' 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 ('4470504'))
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" = 'ID' 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 ('4470504'))
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 SEA03LA158Accident · No injuriesLimited investigationFinal reportHughes 269C · Melba, IDThe pilot's failure to maintain control of the helicopter due to his failure to maintain rotor rpm. Factors contributing to the accident were the corn crop, and the pilot's abrupt maneuver to avoid obstacles.NTSB SEA84LA035Accident · No injuriesLimited investigationFinal reportHughes 269C · Almo, IDThe plt stated, he was attempting to depart with visibility of 1/8 to 1/4 mi in fog. Shortly after departure the visibility dropped to approximately 50 to 100 ft. he attempted a slow runing landing and landed hard.NTSB SEA82DA019Accident · No injuriesFinal reportHughes 269C · S.E. Of Malta, IDThe purpose of the flight was for predator (coyote) control. The pilot was following a coyote at a low-altitude, moderate-speed air taxi over snow and sagebrush covered terrain. One of the aircraft's snowboards caught several sagebrush limbs and the pilot…NTSB SEA77DYA32Accident · No injuriesClosedHughes 269C · Malta, IDNTSB SEA77DYA27Accident · No injuriesClosedHughes 269C · Gooding, IDNTSB SEA76DYA39Accident · No injuriesClosedHughes 269A · Gooding, IDNTSB SEA72DYA29Accident · No injuriesClosedHughes 269C · Soda Springs, ID