NTSB investigations: Hughes 269B, NC
6 cases on aircraft the registry lists as Hughes 269B. 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
| 1970 | 1 |
|---|---|
| 1973 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1993 | 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\" = 'NC' 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 ('4470502'))
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" = 'NC' 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 ('4470502'))
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 ATL94LA002Accident · No injuriesLimited investigationFinal reportHughes 269B · Linville, NCThe pilot's failure to maintain airspeed that would have avoided a loss of tail rotor effectiveness (lte), and his improper compensation for tailwind condition. A factor was the lack of information in the pilot's operating handbook regarding the conditions…NTSB ATL86LA069Accident · Serious injuriesLimited investigationFinal reportHughes 269B · Council, NCDuring a control burning operation, the plt experienced a complete eng failure. The plt entered an autorotation and collided with trees. The eng examination disclosed that the #4 connecting rod had failed. The failure was determined to have resulted from…NTSB ATL82DA256Accident · No injuriesFinal reportHughes 269B · Angier, NCWhile spaying soy beans, the pilot observed 3 power lines bordering the field, but failed to see a fourth. While on a swath run, the helicopter struck the fourth line with the main and tail rotor blades which resulted in a forced landing.NTSB ATL80FLG18Accident · 1 fatalClosedHughes 269B · Whiteville, NCNTSB IAD73DLJ34Accident · No injuriesClosedHughes 269B · Lumberton, NCNTSB IAD70FKM14Accident · No injuriesClosedHughes 269B · Bryson City, NC