# Final NTSB investigations: Aeronca 7AC, IN

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 CEN11LA614](https://openairdocs.org/ntsb/CEN11LA614.md): Aeronca 7AC · Valparaiso, IN · Accident · No injuries · Limited investigation · Final report · Sep 1, 2011 · N83533 · Substantial damage
  > The pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.
- [NTSB CEN11LA219](https://openairdocs.org/ntsb/CEN11LA219.md): Aeronca 7AC · Delphi, IN · Accident · No injuries · Limited investigation · Final report · Mar 4, 2011 · N82429 · Substantial damage
  > The pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.
- [NTSB CHI88LA172](https://openairdocs.org/ntsb/CHI88LA172.md): Aeronca 7AC · Greenfield, IN · Accident · No injuries · Limited investigation · Final report · Jul 23, 1988 · N83430 · Substantial damage
  > During a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,…
- [NTSB CHI74FEA02](https://openairdocs.org/ntsb/CHI74FEA02.md): Aeronca 7AC · Speedway, IN · Accident · No injuries · Closed · Jul 4, 1973 · N84304 · Substantial damage
- [NTSB CHI69D0395](https://openairdocs.org/ntsb/CHI69D0395.md): Aeronca 7AC · Mccordsville, IN · Accident · No injuries · Closed · Dec 21, 1968 · N85308 · Substantial damage
- [NTSB CHI67F0063](https://openairdocs.org/ntsb/CHI67F0063.md): Aeronca 7AC · English, IN · Accident · Minor injuries · Closed · May 21, 1967 · N1225E · Substantial damage
- [NTSB CHI66F0774](https://openairdocs.org/ntsb/CHI66F0774.md): Aeronca 11AC · Auburn, IN · Accident · No injuries · Closed · May 23, 1966 · N85772 · Substantial damage
- [NTSB CHI66F0004](https://openairdocs.org/ntsb/CHI66F0004.md): Aeronca 7AC · Dyer, IN · Accident · No injuries · Closed · May 24, 1965 · N81468 · Substantial damage
- [NTSB UNK64X2694](https://openairdocs.org/ntsb/UNK64X2694.md): Aeronca 7AC · Ramsey, IN · Accident · No injuries · Closed · Jul 7, 1964 · N81611 · Substantial damage
- [NTSB UNK64X2006](https://openairdocs.org/ntsb/UNK64X2006.md): Aeronca 7AC · Medaryville, IN · Accident · No injuries · Closed · May 29, 1964 · N1537E · Substantial damage
- [NTSB UNK64X1690](https://openairdocs.org/ntsb/UNK64X1690.md): Aeronca 7AC · Lebanon, IN · Accident · Serious injuries · Closed · May 9, 1964 · N84613 · 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."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA'
  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 ('2110102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2110102&state=IN&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.
