NTSB investigations: Hughes 269A, 1971
18 cases on aircraft the registry lists as Hughes 269A. 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
| 1964 | 47 |
|---|---|
| 1965 | 31 |
| 1966 | 32 |
| 1967 | 22 |
| 1968 | 27 |
| 1969 | 15 |
| 1970 | 15 |
| 1971 | 18 |
| 1972 | 9 |
| 1973 | 16 |
| 1974 | 11 |
| 1975 | 13 |
| 1976 | 8 |
| 1977 | 9 |
| 1978 | 8 |
| 1979 | 7 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 7 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 6 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 5 |
| 1990 | 4 |
| 1991 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 5 |
| 1997 | 6 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 3 |
| 2005 | 5 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 4 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 1971
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470402'))
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 year(c."eventDate") = 1971
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470402'))
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 CHI72FET10Accident · No injuriesClosedHughes 269A · Griffith, INNTSB LAX72FUG18Accident · No injuriesClosedHughes 269A · Irwindale, CANTSB MKC72DCD24Accident · No injuriesClosedHughes 269A · Nevada, IANTSB DEN72DTE10Accident · No injuriesClosedHughes 269A · Ft Collins, CONTSB NYC72FFJ10Accident · No injuriesClosedHughes 269A · Gainesville, NYNTSB MKC71FCQ46Accident · Minor injuriesClosedHughes 269-A · Wichita, KSNTSB LAX71FUA70Accident · No injuriesClosedHughes 269A · Long Beach, CANTSB LAX71FUG94Accident · No injuriesClosedHughes 269A · Ontario, CANTSB MKC71FER69Accident · No injuriesClosedHughes 269A · Montevideo, MNNTSB SEA71FYC41Accident · No injuriesClosedHughes 269A · Wilsonville, ORNTSB OAK71FJA17Accident · No injuriesClosedHughes 269A · Ewa, HINTSB OAK71FXQ37Accident · No injuriesClosedHughes 269A · Verdi, NVNTSB OAK71FVM50Accident · No injuriesClosedHughes 269A · San Jose, CANTSB IAD71FIA18Accident · Serious injuriesClosedHughes 269A · Washington, DCNTSB DEN71DXA18Accident · No injuriesClosedHughes 269A-1 · Laramie, WYNTSB FTW71DRG88Accident · No injuriesClosedHughes 269A · Llano, TXNTSB FTW71AQG53Accident · Serious injuriesClosedHughes 269A · Spearman, TXNTSB OAK71FJA10Accident · No injuriesClosedHughes 269A · Waipahu, HI