NTSB investigations: Hughes 269C, 2005
3 cases on aircraft the registry lists as Hughes 269C. 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 |
|---|---|
| 1971 | 6 |
| 1972 | 8 |
| 1973 | 6 |
| 1974 | 7 |
| 1975 | 8 |
| 1976 | 7 |
| 1977 | 18 |
| 1978 | 16 |
| 1979 | 11 |
| 1980 | 13 |
| 1981 | 13 |
| 1982 | 8 |
| 1983 | 6 |
| 1984 | 7 |
| 1985 | 14 |
| 1986 | 11 |
| 1987 | 6 |
| 1988 | 12 |
| 1989 | 14 |
| 1990 | 11 |
| 1991 | 8 |
| 1992 | 7 |
| 1993 | 3 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 8 |
| 2001 | 6 |
| 2002 | 1 |
| 2003 | 7 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 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\") = 2005
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470504'))
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") = 2005
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470504'))
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 DFW05CA168Accident · No injuriesData collectionFinal reportHughes 269C · Bruceville, TXThe flight instructor's improper flare during autorotation, which resulted in a hard landing. Contributing factor was, the lack of suitable terrain.NTSB DEN05FA080Accident · Serious injuriesField investigationFinal reportSchweizer 269C · Pueblo, COthe flight instructor's failure to maintain control of the helicopter during the attempted autorotation after the loss of engine power for reasons undetermined. Contributing factors include the flight instructor's improper preflight planning, the high density…NTSB DEN05CA052Accident · No injuriesData collectionFinal reportHughes 269C · Englewood, COthe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight. Contributing factors were low rotor rpm, low airspeed, and the instructor's delay in taking remedial action.