# Fatal, Final NTSB investigations: Aeronca 65-CA

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 CEN17LA234](https://openairdocs.org/ntsb/CEN17LA234.md): Aeronca 65 CA · Mount Vernon, OH · Accident · 1 fatal · Limited investigation · Final report · Jun 17, 2017 · N33778 · Minor damage
  > The pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.
- [NTSB SEA03LA185](https://openairdocs.org/ntsb/SEA03LA185.md): Aeronca 65-CA · Polson, MT · Accident · 1 fatal · Limited investigation · Final report · Sep 4, 2003 · N33865 · Substantial damage
  > The pilot's failure to maintain clearance from an object while maneuvering and alcohol impairment. Transmission wires, dark night conditions, and drug impairment were factors.
- [NTSB FTW96FA243](https://openairdocs.org/ntsb/FTW96FA243.md): Aeronca 65-CA · Lonoke, AR · Accident · 1 fatal · Field investigation · Final report · Jun 10, 1996 · N36513 · Substantial damage
  > The pilot's failure to maintain aircraft control.
- [NTSB SEA80FA012](https://openairdocs.org/ntsb/SEA80FA012.md): Aeronca 65-CA · Mountain Home, ID · Accident · 2 fatal · Closed · Dec 8, 1979 · N31929 · Substantial damage
- [NTSB FTW72FPJ18](https://openairdocs.org/ntsb/FTW72FPJ18.md): Aeronca 11AC · Adams, OK · Accident · 1 fatal · Closed · Oct 9, 1971 · N36605 · Substantial damage
- [NTSB NYC69A0092](https://openairdocs.org/ntsb/NYC69A0092.md): Aeronca 65-C · Phelps, NY · Accident · 1 fatal · Closed · Apr 9, 1969 · N31938 · Destroyed
- [NTSB FTW69A0027](https://openairdocs.org/ntsb/FTW69A0027.md): Aeronca 65-CA · Joshua, TX · Accident · 1 fatal · Closed · Oct 19, 1968 · N31846 · Destroyed
- [NTSB CHI69A0029](https://openairdocs.org/ntsb/CHI69A0029.md): Aeronca 65-CA · New London, OH · Accident · 1 fatal · Closed · Sep 14, 1968 · N36659 · Destroyed
- [NTSB DIA67A0007](https://openairdocs.org/ntsb/DIA67A0007.md): Aeronca 65-CA · Fruitland, MD · Accident · 2 fatal · Closed · Jan 23, 1967 · N31932 · Destroyed

## 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."highestInjuryLevel" = 'Fatal'
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0190922'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=0190922&status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
