NTSB investigations: Hughes 269C, OR
8 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
| 1980 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2000 | 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\" = 'OR' 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" = 'OR' 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 SEA04LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Hillsboro, ORThe pilot's selection of unsuitable terrain for a practice auto rotation landing. A contributing factor was the soft terrain.NTSB SEA00FA038Accident · No injuriesField investigationFinal reportHughes 269C · Sherwood, ORThe pilots failure to arrest the helicopter's descent rate during a planned approach to a hover. Factors include uneven terrain.NTSB SEA97LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Hood River, ORThe pilot-in-command's misjudgment of altitude and airspeed during a turn.NTSB SEA93LA001Accident · No injuriesLimited investigationFinal reportHughes 269C · Hillsboro, ORThe pilot in command's failure to maintain proper altitude during the hover. Factors contributing to the accident were the pilot in command's lack of total experience in rotorcraft and his diversion of attention while hovering.NTSB SEA90LA016Accident · 1 fatalLimited investigationFinal reportHughes 269C · Estacada, ORThe pilot misjudged clearance between her external load and the obstruction. Factors related to the accident were: the obstruction, improper maintenance and modification of the external load line/hook by the operator, failure of the pilot to jettison the…NTSB SEA88LA093Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Prineville, ORThe pilot reduced power for landing and a high sink rate developed. The pilot attempted to increase power to correct the sink rate but got no response. Rotor rpm's were diminishing, so the plt lowered the collective to regain rpm's. the pilot elected make an…NTSB SEA86LA026Accident · No injuriesLimited investigationFinal reportHughes 269C · Brooks, ORA total loss of power occurred due to the number 4 cylinder failing. A tail boom strike occurred during a hard landing in a parking lot, severing the tail boom.NTSB SEA81FYM07Accident · No injuriesClosedHughes 269C · Pilot Rock, OR