# NTSB investigations: Aeronca 7AC: Miscellaneous/other

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 ERA18FA230](https://openairdocs.org/ntsb/ERA18FA230.md): Aeronca 7AC · Hanson, MA · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2018 · N65HM · Substantial damage
  > A loss of engine power due to carburetor icing, the pilot's decision to turn back to the runway shortly after takeoff, and his failure to maintain airspeed during the turn, which resulted in an exceedance of the airplane's critical angle of attack, and…
- [NTSB GAA17CA381](https://openairdocs.org/ntsb/GAA17CA381.md): Aeronca 7AC · Soldotna, AK · Accident · No injuries · Data collection · Final report · Jun 4, 2017 · N82639 · Substantial damage
  > The pilot’s abrupt maneuver to avoid a moose cow and calf during taxi, which resulted in an impact with a tree.
- [NTSB GAA17CA113](https://openairdocs.org/ntsb/GAA17CA113.md): Aeronca 7AC · Compton, CA · Accident · No injuries · Data collection · Final report · Jan 15, 2017 · N1659E · Substantial damage
  > The pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.
- [NTSB ERA11CA324](https://openairdocs.org/ntsb/ERA11CA324.md): Aeronca 7AC · Honea Path, SC · Accident · Minor injuries · Data collection · Final report · Jun 3, 2011 · N84572 · Substantial damage
  > The student pilot's loss of control during the takeoff.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110102')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/900/sequence?model=2110102

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