NTSB investigations: Aeronca 7AC, MN

5 cases on aircraft the registry lists as Aeronca 7AC, where the first occurrence was “Loss of control - in flight”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19882026
NTSB investigations: Aeronca 7AC, MN per year, 1988–2026: 5 cases
19881
20002
20011
20031

Latest cases

Query with SQL
duckdb -csv -c "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\" = 'MN' 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CHI03LA112Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Grand Rapids, MNThe pilot's failure to obtain adequate airspeed which resulted in a stall. The short, soft, takeoff area, and the trees were contributing factors.Feb 28, 2003 · N84868 · DestroyedNTSB CHI02LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Erhard, MNThe pilot not maintaining adequate airspeed while maneuvering in the turn. Factors relating to this accident were the low airspeed, the inadvertent stall, and the low altitude.Oct 1, 2001 · N1746E · DestroyedNTSB CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.Jun 24, 2000 · N81681 · Substantial damageNTSB CHI00FA107Accident · 1 fatalField investigationFinal reportAeronca 7AC · Embarrass, MNthe inadvertent stall/spin the pilot encountered. A factor was the wind gusts.Apr 8, 2000 · N84424 · DestroyedNTSB CHI88FA192Accident · 1 fatalField investigationFinal reportAeronca 7AC · Pierz, MNPilot failed to maintain adequate control of the aircraft while maneuvering at a low altitude, resulting in a stall and collision with the ground. A factor contributing to the accident was the pilot's lack of recent flight experience and training.Aug 7, 1988 · N3001E · Destroyed