Skip to content

NTSB investigations: Aeronca 7AC, GA

30 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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA15FA017Accident · 1 fatalField investigationFinal reportAeronca 7EC · Cordele, GAAn in-flight loss of control for reasons that could not be determined based on the available evidence.Oct 16, 2014 · N946DR · Substantial damage NTSB ERA10LA314Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sandersville, GAA total loss of engine power for undetermined reasons.Jun 16, 2010 · N84362 · Substantial damage NTSB ATL03LA013Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Warner Robins, GAThe pilot's failure to follow engine start procedures for a overprimed engine, and his improper use of the throttle control during an attempted start.Oct 31, 2002 · N83651 · Substantial damage NTSB MIA91FA209Accident · 2 fatalField investigationFinal reportAeronca 7AC · Dawson, GAThe pilot in command's failure to maintain altitude while maneuvering.Aug 28, 1991 · N84216 · Destroyed NTSB ATL91LA159Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Newton, GAThe failure of the pilot-in-command to maintain an adequate visual lookout for obstacles.Aug 15, 1991 · N84692 · Substantial damage NTSB ATL89LA211Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Screven, GAFailure of maintenance personnel to correct right brake adjustment problems during brake repairs which led to a failure of the right brake, and the pilot's delay in taking remedial action to correct the veering initiated by the brake failure.Sep 10, 1989 · N82705 · Substantial damage NTSB ATL89FA019Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Austell, GAPIC was obtaining bfr; stalls & flt at min control airspeed were completed. PIC began descent from 2500 MSL to his pvt strip for simulated engine out landing. In a subsequent interview PIC said carb heat was applied & removed after 30 sec. In his rpt he said…Oct 29, 1988 · N83045 · Substantial damage NTSB ATL87FA111Accident · 1 fatalField investigationFinal reportAeronca 7AC · Sharpsburg, GAPlt dep a pvt grass airstrip for a LCL VFR flt. Acft was observed to lift off the grass rwy at about 1000 ft. it climbed to about 30 ft AGL and leveled off. At about the end of the 1800 ft rwy the acft nosed up into a 'fairly steep' climb attitude. The ground…Apr 12, 1987 · N1823E · Destroyed NTSB ATL86FA148Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Stone Mountain, GAWhile on a bfr flt, the owner/plt was considered to be the plt-in-command. Drg departure, he took off on rwy 35 with a x-wind from the left. According to the instructor (CFI) & a witness, the takeoff was normal until shortly after lift-off, then the acft…May 30, 1986 · N3675E · Substantial damage NTSB ATL82FKG15Accident · 1 fatalFinal reportAeronca 7AC · Cedartown, GAThe acft stalled & crashed into trees from an altitude of approximately 60 feet AGL. The elevator trim tab control was found in the full nose up position.Jun 2, 1982 · N2475E · Destroyed NTSB MIA79FLA16Accident · No injuriesClosedAeronca 7AC · Blakely, GAMar 6, 1979 · N83796 · Substantial damage NTSB MIA79FKG07Accident · No injuriesClosedAeronca 7AC · Hampton, GAOct 28, 1978 · N1823E · Substantial damage NTSB MIA76FKG44Accident · 1 fatalClosedAeronca 7AC · Griffin, GAFeb 29, 1976 · N1911E · Destroyed NTSB MIA76FKG21Accident · No injuriesClosedAeronca 7AC · Stone Mountain, GASep 1, 1975 · N81939 · Substantial damage NTSB MIA75FKG36Accident · No injuriesClosedAeronca 7AC · Jonesboro, GAOct 13, 1974 · N83644 · Substantial damage NTSB MIA74AM101Accident · 2 fatalClosedAeronca 7AC · Macon, GAJun 16, 1974 · N81908 · Destroyed NTSB MIA72FKH11Accident · No injuriesClosedAeronca 7AC · Winder, GAJun 10, 1972 · N3481E · Substantial damage NTSB MIA72FKG59Accident · No injuriesClosedAeronca 7AC · Hampton, GANov 30, 1971 · N83644 · Substantial damage NTSB MIA71FKG83Accident · No injuriesClosedChampion 7AC · Thomasville, GAMay 2, 1971 · N82628 · Substantial damage NTSB MIA71DKG59Accident · No injuriesClosedAeronca 7AC · Douglas, GAJan 31, 1971 · N82720 · Substantial damage NTSB MIA71AM009Accident · 2 fatalClosedAeronca 7AC · Hampton, GAJul 26, 1970 · N84850 · Destroyed NTSB MIA70F0117Accident · 1 fatalClosedAeronca 7AC · Dacula, GAJun 28, 1969 · N2655E · Destroyed NTSB MIA69F0299Accident · Serious injuriesClosedAeronca 7AC · Lafayette, GASep 28, 1968 · N2023E · Substantial damage NTSB MIA68F0173Accident · No injuriesClosedAeronca 7AC · Cairo, GASep 13, 1967 · N85416 · Substantial damage NTSB MIA68A0010Accident · 1 fatalClosedAeronca 7BCM · Albany, GAJul 19, 1967 · N81791 · Destroyed NTSB MIA66D0444Accident · No injuriesClosedAeronca 7AC · Winder, GAFeb 19, 1966 · N2363E · Substantial damage NTSB MIA66F0387Accident · 1 fatalClosedAeronca 7AC · Claxton, GADec 5, 1965 · N81509 · Destroyed NTSB MIA66D0006Accident · No injuriesClosedAeronca 7AC · Marietta, GAJun 13, 1965 · N2610E · Substantial damage NTSB MIA65D0028Accident · No injuriesClosedAeronca 7AC · Stone Mountain, GAApr 11, 1965 · N3064E · Substantial damage NTSB UNK64X2736Accident · No injuriesClosedAeronca 7BM · Augusta, GAJul 9, 1964 · N81545 · Substantial damage