NTSB investigations: Hughes 269B, GA
17 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
| 1966 | 2 |
|---|---|
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 2019 | 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\" = 'GA' 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" = 'GA' 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 ERA19LA173Accident · No injuriesClass 3 · LimitedFinal reportHughes 269B · Hampton, GAGround resonance during landing for reasons that could not be determined based on the available information.NTSB ATL86LA044Accident · No injuriesLimited investigationFinal reportHughes 269B · Stone Mountain, GADuring ground refueling of the aircraft the fuel tank was over- filled and the fuel spilled over onto the ramp. The fuel was ignited and the aircraft was destroyed by fire.NTSB ATL81FLA02Accident · Minor injuriesClosedHughes 269B · Valdosta, GANTSB ATL80DLA13Accident · No injuriesClosedHughes 269B · Meigs, GANTSB MIA78FKG65Accident · No injuriesClosedHughes 269B · Swainboro, GANTSB MIA77FKG67Accident · No injuriesClosedHughes 269B · Montezuma, GANTSB MIA75FKG80Accident · Minor injuriesClosedHughes 269B · Atlanta, GANTSB MIA75DKG29Accident · Minor injuriesClosedHughes 269B · Alma, GANTSB MIA72FKH04Accident · No injuriesClosedHughes 269B · Atlanta, GANTSB MIA72FKG44Accident · No injuriesClosedHughes 269B · Arlington, GANTSB MIA71FKG69Accident · Serious injuriesClosedHughes 269B · Lakeland, GANTSB MIA70FKG41Accident · No injuriesClosedHughes 269B · Atlanta, GANTSB MIA70F0248Accident · No injuriesClosedHughes 269B · Arlington, GANTSB MIA70F0265Accident · No injuriesClosedHughes 269B · Cordele, GANTSB MIA69D0152Accident · No injuriesClosedHughes 269B · Arabi, GANTSB MIA67A0010Accident · No injuriesClosedHughes 269B · Americus, GANTSB MIA66A0148Accident · No injuriesClosedHughes 269B · Cordele, GA