# NTSB investigations: Hughes 269C, TN

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ATL89FA035](https://openairdocs.org/ntsb/ATL89FA035.md): Hughes 269C · Mohawk, TN · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1988 · N9575F · Destroyed
  > The helicopter had landed at a private airstrip and the instructor deplaned. The dual student remained in the helicopter with the engine running. The CFI reboarded and the student made the takeoff. Later, on downwind in traffic pattern, a witness reported a…
- [NTSB ATL81FLT08](https://openairdocs.org/ntsb/ATL81FLT08.md): Hughes 269C · Ridgely, TN · Accident · No injuries · Closed · May 3, 1981 · N7487F · Substantial damage
- [NTSB ATL80FLT07](https://openairdocs.org/ntsb/ATL80FLT07.md): Hughes 269C · Martin, TN · Accident · No injuries · Closed · May 3, 1980 · N9665F · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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" = 'TN' 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 ('4470504'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=4470504&state=TN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.