NTSB investigations: Aeronca 7AC, KS

13 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, KS per year, 1964–2026: 13 cases
1964	1
1965	5
1966	1
1967	1
1972	2
1974	1
1984	1
1986	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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 MKC87LA001Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tribune, KSThe PIC rptd eng failure while in cruise flt. The student PIC suspected carb icing as the cause of the eng failure. No mechanical pblm was discovered during the eng inspection. The icing probability charts indicated that carburetor icing was likely in the…Oct 6, 1986 · N84911 · Substantial damage NTSB MKC84LA073Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lawrence, KSThe dual student allowed the acft to porpoise & yaw and lost control of the acft as it veered into a ditch. The CFI on board tried to correct the situation with rudder and throttle but was unsucessful in the attempt.Feb 13, 1984 · N83032 · Substantial damage NTSB MKC74AK055Accident · 2 fatalClosedAeronca 7AC · Colony, KSMar 28, 1974 · N1864E · Destroyed NTSB MKC73AK024Accident · 1 fatalClosedAeronca 7AC · Ulysses, KSOct 1, 1972 · N1720E · Destroyed NTSB MKC72FCG57Accident · No injuriesClosedAeronca 7AC · Leawood, KSJun 4, 1972 · N1483E · Substantial damage NTSB MKC67D0579Accident · No injuriesClosedAeronca 7AC · Dodge City, KSApr 29, 1967 · N84506 · Substantial damage NTSB MKC67D0068Accident · No injuriesClosedAeronca 7AC · Junction City, KSJul 12, 1966 · N3521E · Substantial damage NTSB MKC66D0348Accident · No injuriesClosedAeronca 7AC · Lincoln, KSDec 8, 1965 · N83703 · No damage NTSB MKC65F0118Accident · Minor injuriesClosedAeronca 7AC · Lyons, KSApr 13, 1965 · N84180 · Destroyed NTSB MKC66D0028Accident · No injuriesClosedAeronca 7AC · Kansas City, KSMar 20, 1965 · N84554 · Substantial damage NTSB MKC65F0060Accident · Serious injuriesClosedAeronca 7AC · Natoma, KSJan 17, 1965 · N2883E · Destroyed NTSB MKC65F0001Accident · Minor injuriesClosedAeronca 7AC · Wakeeny, KSJan 1, 1965 · N85485 · Destroyed NTSB UNK64X1880Accident · No injuriesClosedAeronca 7AC · Syracuse, KSMay 22, 1964 · N84795 · Substantial damage