Skip to content

NTSB investigations: Aeronca 7AC, NC

22 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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA22LA063Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Denver, NCThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.Nov 13, 2021 · N3063E · Substantial damage NTSB GAA16CA383Accident · No injuriesData collectionFinal reportAeronca 7AC · Lenoir, NCThe pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to…Jul 18, 2016 · N84690 · Substantial damage NTSB ERA10CA168Accident · No injuriesData collectionFinal reportAeronca 7AC · Roanoke Rapids, NCThe pilot’s failure to maintain directional control during a crosswind landing/rollout.Mar 7, 2010 · N84694 · Substantial damage NTSB ATL04CA169Accident · No injuriesData collectionFinal reportAeronca 7AC · Spring Hope, NCThe binding of the right aileron control cable, which resulted in a loss in aileron control, and subsequent collision with trees and terrain.Aug 22, 2004 · N84399 · Substantial damage NTSB ATL92LA021Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Wilson, NCThe intentional operation of the aircraft with a known deficiency and inadequate preflight inspection by the pilot.Nov 8, 1991 · N84399 · Substantial damage NTSB ATL85LA187Accident · No injuriesLimited investigationFinal reportChampion 7AC · Barnardsville, NCDuring a supervised solo x-country flt, the student acft experienced a loss of pwr at cruise. After reaching his first check point, the student reversed course because he departed on the wrong heading. Before reaching the first check point for the second…Jun 15, 1985 · N83678 · Substantial damage NTSB IAD78FLJ23Accident · Serious injuriesClosedAeronca 7AC · Fayetteville, NCAug 26, 1978 · N82466 · Substantial damage NTSB IAD78FA076Accident · 2 fatalClosedAeronca 7AC · Vanceboro, NCJul 4, 1978 · N81452 · Destroyed NTSB IAD78FLJ11Accident · Minor injuriesClosedAeronca 7BCM · Wendell, NCApr 29, 1978 · N1302E · Substantial damage NTSB IAD78DLJ04Accident · No injuriesClosedAeronca 7AC · Watha, NCDec 18, 1977 · N2406E · Substantial damage NTSB IAD76FKM35Accident · Minor injuriesClosedAeronca 7AC · Statesville, NCJun 8, 1976 · N2831E · Substantial damage NTSB IAD74FLJ39Accident · Minor injuriesClosedAeronca 7AC · Erwin, NCApr 27, 1974 · N84538 · Substantial damage NTSB IAD74DKM35Accident · No injuriesClosedAeronca 7AC · Charlotte, NCJan 18, 1974 · N1946E · Substantial damage NTSB IAD73DKM26Accident · No injuriesClosedAeronca 7AC · Indian Trail, NCMar 4, 1973 · N2840E · Substantial damage NTSB NYC72AN134Accident · 1 fatalClosedAeronca 7AC · Charlotte, NCApr 23, 1972 · N83762 · Destroyed NTSB DIA69F0182Accident · No injuriesClosedAeronca 7AC · Charlotte, NCApr 27, 1969 · N1946E · Substantial damage NTSB DIA69D0095Accident · Minor injuriesClosedAeronca 7AC · Pensacola, NCNov 2, 1968 · N1129E · Substantial damage NTSB DIA69F0040Accident · Serious injuriesClosedAeronca 7AC · Benson, NCJul 27, 1968 · N84893 · Substantial damage NTSB DIA68A0013Accident · 1 fatalClosedAeronca 7AC · Harkers Is., NCSep 22, 1967 · N85297 · Destroyed NTSB UNK65X0750Accident · Minor injuriesClosedAeronca 7AC · Hendersonville, NCNov 18, 1964 · N1250E · Substantial damage NTSB UNK65X0740Accident · No injuriesClosedAeronca 7AC · Monroe, NCNov 16, 1964 · N84851 · Substantial damage NTSB UNK64X0454Accident · No injuriesClosedAeronca 7AC · Charlotte, NCFeb 4, 1964 · N83189 · Destroyed