NTSB investigations: Aeronca 7AC, NV

8 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, NV per year, 1964–2026: 8 cases
1964	1
1965	2
1968	1
1971	1
1974	1
1991	1
2003	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" = 'NV' 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\" = 'NV' 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" = 'NV' 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 LAX03LA062Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Jean, NVThe pilot of the other airplane's use of an improper starting procedure and his failure to obtain appropriate assistance.Jan 9, 2003 · N84889 · 2 aircraft · Substantial damage NTSB LAX91LA145Accident · Serious injuriesLimited investigationFinal reportAeronca 7-AC · No. Las Vegas, NVThe pilot's failure to maintain airspeed.Mar 25, 1991 · N84025 · Destroyed NTSB OAK74DXQ44Accident · No injuriesClosedAeronca 7AC · Elko, NVJun 17, 1974 · N82269 · Substantial damage NTSB OAK71DVW32Accident · No injuriesClosedAeronca 7AC · N.Las Vegas, NVMay 12, 1971 · N84025 · Substantial damage NTSB UNK68X0145Accident · No injuriesClosedAeronca 7AC · Sutcliffe, NVJun 2, 1968 · N2659E · Substantial damage NTSB LAX66D0146Accident · No injuriesClosedAeronca 7AC · Minden, NVOct 21, 1965 · N84755 · Substantial damage NTSB DEN66D0108Accident · No injuriesClosedAeronca 7AC · Boulder City, NVJul 5, 1965 · N83376 · Destroyed NTSB UNK64X2945Accident · No injuriesClosedAeronca 7AC · Elko, NVJul 20, 1964 · N2216E · Substantial damage