NTSB investigations: Aeronca 7AC, SC

10 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

NTSB investigations: Aeronca 7AC, SC per year, 1964–2026: 10 cases
1964	2
1965	1
1966	1
1972	1
1974	1
1978	1
2008	1
2009	1
2011	1

Where

Open the map

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" = 'SC' 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\" = 'SC' 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" = 'SC' 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 ERA11CA324Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Honea Path, SCThe student pilot's loss of control during the takeoff.Jun 3, 2011 · N84572 · Substantial damage NTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.Feb 1, 2009 · N3066E · Substantial damage NTSB NYC08CA325Accident · No injuriesData collectionFinal reportAeronca 7AC · Mt. Pleasant, SCThe pilot's failure to maintain aircraft control during an emergency maneuver. Contributing to the accident was the failure of the left magneto.Sep 28, 2008 · N2504E · Substantial damage NTSB MIA78FLG18Accident · No injuriesClosedAeronca 7AC · Loris, SCApr 15, 1978 · N83649 · Substantial damage NTSB MIA74DLG38Accident · No injuriesClosedAeronca 7AC · Bennettsville, SCJun 23, 1974 · N1664E · Substantial damage NTSB MIA72FLG42Accident · No injuriesClosedAeronca 7AC · White Rock, SCJun 3, 1972 · N4328E · Substantial damage NTSB MIA67D0089Accident · Minor injuriesClosedAeronca 7AC · Denmark, SCJun 30, 1966 · N85026 · Substantial damage NTSB MIA65F0127Accident · No injuriesClosedAeronca 7AC · Rock Hill, SCApr 29, 1965 · N82989 · Substantial damage NTSB UNK64X4154Accident · Minor injuriesClosedAeronca 7AC · Newberry, SCSep 26, 1964 · N81939 · Destroyed NTSB UNK64X3441Accident · No injuriesClosedAeronca 7AC · Newberry, SCAug 17, 1964 · N81939 · Substantial damage