# NTSB investigations: Aeronca 7AC, ID

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 SEA98LA107](https://openairdocs.org/ntsb/SEA98LA107.md): Aeronca 7AC · Murphy, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1998 · N8030P · Substantial damage
  > The pilot's decision to initiate an aborted landing at an airport where, due to the high density altitude, his aircraft was unable to outclimb the rising terrain that surrounded airport. Factors include a high density altitude and crosswinds.
- [NTSB SEA94LA239](https://openairdocs.org/ntsb/SEA94LA239.md): Aeronca 7AC · Nampa, ID · Accident · No injuries · Limited investigation · Final report · Sep 13, 1994 · N85564 · Substantial damage
  > Directional control was not maintained. A factor to the accident was: inadequate supervision.
- [NTSB SEA89LA133](https://openairdocs.org/ntsb/SEA89LA133.md): Aeronca 7AC · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Jul 16, 1989 · N1636E · Substantial damage
  > An engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.
- [NTSB SEA84LA074](https://openairdocs.org/ntsb/SEA84LA074.md): Aeronca 7AC · Hailey, ID · Accident · No injuries · Limited investigation · Final report · Mar 22, 1984 · N85763 · Substantial damage
  > The student plt attempted to taxi back on the active rwy after landing and groundlooped. During the swerve the left wingcontacted a snow bank. The student plt recommended no tail-up taxiing.
- [NTSB SEA77DYP28](https://openairdocs.org/ntsb/SEA77DYP28.md): Aeronca 7AC · Athol, ID · Accident · Serious injuries · Closed · Apr 24, 1977 · N1363E · Substantial damage
- [NTSB SEA72DYA08](https://openairdocs.org/ntsb/SEA72DYA08.md): Aeronca 7AC · Twin Falls, ID · Accident · Serious injuries · Closed · Aug 13, 1971 · N83896 · Destroyed
- [NTSB UNK64X3895](https://openairdocs.org/ntsb/UNK64X3895.md): Aeronca 7AC · Firth, ID · Accident · No injuries · Closed · Sep 10, 1964 · N85635 · 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" = 'ID' 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 ('2110102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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