# NTSB investigations: Hughes 269A, NY

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 NYC01LA167](https://openairdocs.org/ntsb/NYC01LA167.md): Hughes 269A · Clay, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2001 · N7028V · Substantial damage
  > Failure of the left aft cluster fitting due to a fatigue crack. Factors in the accident were the mechanic's failure to identify the crack at the last annual inspection, and the pilot's failure to identify the crack during the last daily inspection
- [NTSB NYC80FFJ06](https://openairdocs.org/ntsb/NYC80FFJ06.md): Hughes 269A · Rochester, NY · Accident · Minor injuries · Closed · May 12, 1980 · N8748F · Substantial damage
- [NTSB NYC75FFJ11](https://openairdocs.org/ntsb/NYC75FFJ11.md): Hughes 269A · Groveland, NY · Accident · Serious injuries · Closed · Sep 12, 1974 · N8733F · Substantial damage
- [NTSB NYC72FHM54](https://openairdocs.org/ntsb/NYC72FHM54.md): Hughes 269A · Livngstn Manor, NY · Accident · Minor injuries · Closed · May 30, 1972 · N8866F · Destroyed
- [NTSB NYC72FFJ10](https://openairdocs.org/ntsb/NYC72FFJ10.md): Hughes 269A · Gainesville, NY · Accident · No injuries · Closed · Aug 5, 1971 · N8716F · Substantial damage
- [NTSB NYC70F0092](https://openairdocs.org/ntsb/NYC70F0092.md): Hughes 269A · West Seneca, NY · Accident · No injuries · Closed · Jul 30, 1969 · N8725F · Substantial damage
- [NTSB NYC69A0075](https://openairdocs.org/ntsb/NYC69A0075.md): Hughes 269A · Batavia, NY · Accident · No injuries · Closed · Jan 22, 1969 · N8770F · Destroyed
- [NTSB NYC69F0117](https://openairdocs.org/ntsb/NYC69F0117.md): Hughes 269A · N.Tonawanda, NY · Accident · No injuries · Closed · Aug 3, 1968 · N8759F · Substantial damage
- [NTSB NYC67A0051](https://openairdocs.org/ntsb/NYC67A0051.md): Hughes 269A · Schuylerville, NY · Accident · No injuries · Closed · Sep 24, 1966 · N8788F · Destroyed
- [NTSB NYC65A0135](https://openairdocs.org/ntsb/NYC65A0135.md): Hughes 269A · Westerlo, NY · Accident · 3 fatal · Closed · May 2, 1965 · N8905F · 2 aircraft · Destroyed
- [NTSB NYC65A0103](https://openairdocs.org/ntsb/NYC65A0103.md): Hughes 269A · Rochester, NY · Accident · Minor injuries · Closed · Feb 11, 1965 · N8815F · Substantial damage
- [NTSB UNK64X3187](https://openairdocs.org/ntsb/UNK64X3187.md): Hughes 269A · Buffalo, NY · Accident · Minor injuries · Closed · Aug 2, 1964 · N8873F · 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" = 'NY' 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 ('4470402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.
