NTSB investigations: Hughes 269A
5 cases on aircraft the registry lists as Hughes 269A, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1999 | 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 ('4470402')
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\" = 230))
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 ('4470402')
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" = 230))
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 DEN99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Parkman, WYThe pilot's inadequate in-flight planning by exceeding the helicopter's performance climb capability. Factors were the downdraft encountered during initial climb following takeoff, and the high density altitude.NTSB LAX93FA260Accident · 1 fatalField investigationFinal reportHughes 269A · Henderson, NVthe pilot's improper use of the collective control and his failure to maintain adequate RPM during an autorotative descent during a practice power off landing. A factor which contributed to the accident related to the pilot's lack of recent experience…NTSB ATL88LA249Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Saluda, SCThe instructor pilot reported that they were conducting autorotation training. During an autorotation the crew delayed initiating the power recovery. The helicopters struck the ground causing substantial damage. The pilots did not report experiencing a system…NTSB MIA83LA087Accident · No injuriesLimited investigationFinal reportHughes 269A · St. Petersburg, FLThe helicopter contacted the ground with a skid during a hover and ended up in a dynamic roll over. This was a dual instructional flt and the student was at the controls in a hover at the runways end awaiting twr instructions when the right skid became stuck…NTSB CHI82DA129Accident · Minor injuriesFinal reportHughes 269A · Lowell, MIDuring the first solo flight in a helicopter the pilot was instructed to make three normal takeoffs and landings. On the second landing, when the aircraft came to a hover, the back of the skid struck the ground during a drift-back. The helicopter rolled and…