Skip to content

NTSB investigations: Aeronca 7AC, MN

33 cases on aircraft the registry lists as Aeronca 7AC. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with 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" = '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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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

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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.Jul 29, 2018 · N85506 · Substantial damage NTSB CEN09CA210Accident · No injuriesData collectionFinal reportAeronca 7AC · Bagley, MNThe pilot's delayed aborted takeoff, which resulted in the ski-equipped airplane running aground and striking trees. Contributing to the accident was the slush layer that had formed since the previous landing.Mar 15, 2009 · N1831E · Substantial damage 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 · Destroyed NTSB 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 · Destroyed NTSB 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 damage NTSB CHI00FA107Accident · 1 fatalField investigationFinal reportAeronca 7AC · Embarrass, MNthe inadvertent stall/spin the pilot encountered. A factor was the wind gusts.Apr 8, 2000 · N84424 · Destroyed NTSB CHI94LA199Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Clear Lake, MNthe private pilot's failure to maintain directional control during the landing roll. Related factors are the rough/uneven terrain, and excessive brake application.Jun 11, 1994 · N83019 · Substantial damage NTSB MKC90LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Deer River, MNAirspeed not maintained and stall/spin encountered by the pilot in command.Jun 9, 1990 · N83555 · Destroyed NTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.May 31, 1989 · N85459 · Substantial damage NTSB 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 NTSB CHI83LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garden City, MNThe pilot elected to land to the west on a blacktop road. After touchdown, he initiated a go-around. During the go-around, the aircraft collided with the top wire of a power line on the right side of the road and crashed. The pilot estimated that the wind was…Mar 12, 1983 · N1907E · Substantial damage NTSB CHI82FER22Accident · Serious injuriesFinal reportAeronca 7AC · Maple Plain, MNThe pilot reported that he circled the farm area several times to find a suitable landing site. He decided on a portion of the farmer's field next to the house and made a final pass to inspect the area. During the pass, he saw some trees and reportedly…Jun 24, 1982 · N84554 · Substantial damage NTSB CHI80FER42Accident · No injuriesClosedAeronca 7AC · Mora, MNMay 7, 1980 · N3737E · Substantial damage NTSB MKC79FA038Accident · 2 fatalClosedAeronca 7AC · Eveleth, MNJul 4, 1979 · N84906 · Destroyed NTSB MKC78DER78Accident · No injuriesClosedAeronca 7AC · Brandon, MNJul 25, 1978 · N81534 · Substantial damage NTSB MKC77FA040Accident · 2 fatalClosedAeronca 7AC · Grand Rapids, MNSep 18, 1977 · N3702E · Substantial damage NTSB MKC74FER65Accident · No injuriesClosedAeronca 7EC · Silver Bay, MNJun 29, 1974 · N2139E · Substantial damage NTSB MKC72DER61Accident · No injuriesClosedAeronca 7AC · Buffalo, MNMay 20, 1972 · N2786E · Substantial damage NTSB MKC71DDM03Accident · No injuriesClosedCessna C-34 · Pennock, MNJul 5, 1970 · N12599 · 2 aircraft · Substantial damage NTSB MKC70DDM31Accident · No injuriesClosedAeronca 7AC · Lydia, MNMay 25, 1970 · N82117 · Substantial damage NTSB MKC70AK040Accident · 2 fatalClosedAeronca 7AC · Motley, MNJan 31, 1970 · N84969 · Destroyed NTSB MKC69D0362Accident · No injuriesClosedAeronca 7AC · Roseau, MNMar 21, 1969 · N2974E · Substantial damage NTSB MKC69D0325Accident · No injuriesClosedAeronca 7AC · Clitherall, MNJan 17, 1969 · N3340E · Substantial damage NTSB MKC69D0197Accident · No injuriesClosedAeronca 7AC · Alexandria, MNJul 9, 1968 · N83315 · Substantial damage NTSB MKC68D0489Accident · No injuriesClosedAeronca 7AC · Babbitt, MNJan 28, 1968 · N3446E · Substantial damage NTSB MKC68F0058Accident · Serious injuriesClosedAeronca 7AC · Twin Valley, MNJun 30, 1967 · N2706E · Substantial damage NTSB MKC67F0585Accident · Serious injuriesClosedAeronca 7AC · Lesueur, MNMay 14, 1967 · N83428 · Substantial damage NTSB MKC67F0376Accident · Serious injuriesClosedChampion 7AC · Moose Lake, MNDec 26, 1966 · N82838 · Substantial damage NTSB MKC66A0044Accident · 2 fatalClosedAeronca 7AC · W.Afton, MNFeb 13, 1966 · N82475 · Destroyed NTSB MKC66A0008Accident · 2 fatalClosedAeronca 7AC · Forest Alke, MNAug 8, 1965 · N84008 · Destroyed NTSB MKC66F0006Accident · No injuriesClosedAeronca 7AC · Albert Lea, MNApr 16, 1965 · N83445 · Substantial damage NTSB UNK64X0839Accident · Minor injuriesClosedAeronca 7AC · Lake Ann, MNMar 7, 1964 · N1410E · Destroyed NTSB UNK64X0357Accident · Serious injuriesClosedAeronca 7BCM · Hasty, MNJan 26, 1964 · N85758 · Destroyed