NTSB investigations: Hughes 269B, FL
12 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
| 1965 | 1 |
|---|---|
| 1971 | 2 |
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1979 | 2 |
| 1982 | 1 |
| 2015 | 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\" = 'FL' 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" = 'FL' 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 ERA15LA376Accident · Serious injuriesLimited investigationFinal reportHughes 269 · Eustis, FLThe pilot's failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB MIA82DA096Accident · Minor injuriesFinal reportHughes 269B · Near Kissimmee, FLThe engine lost power while the pilot was on a low altitude aerial observation flight over trees. He attempted to land on a nearby road. While approaching the road at 10 to 15 ft AGL, he ran out of RPM. He hit the ground flat, but did not roll over.NTSB MIA80DLD09Accident · No injuriesClosedHughes 269B · Winter Haven, FLNTSB MIA79FLD85Accident · No injuriesClosedHughes 269B · Winter Park, FLNTSB MIA77FLA06Accident · No injuriesClosedHughes 269B · Gainesville, FLNTSB MIA76DLD84Accident · No injuriesClosedHughes 269B · Holmes Beach, FLNTSB MIA76FLA65Accident · Minor injuriesClosedHughes 269B · Pensacola, FLNTSB MIA75DKT77Accident · No injuriesClosedHughes 269B · Port Charlotte, FLNTSB MIA73FLA16Accident · Minor injuriesClosedHughes 269B · Jacksonville, FLNTSB MIA71FLD48Accident · No injuriesClosedHughes 269B · Tampa, FLNTSB MIA71FLA33Accident · Minor injuriesClosedHughes 269B · Jacksonville, FLNTSB MIA66A0043Accident · No injuriesClosedHughes 269B · Jacksonville, FL