Skip to content

NTSB investigations: Aeronca 7AC, MA

19 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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 ERA18FA230Accident · 1 fatalField investigationFinal reportAeronca 7AC · Hanson, MAA loss of engine power due to carburetor icing, the pilot's decision to turn back to the runway shortly after takeoff, and his failure to maintain airspeed during the turn, which resulted in an exceedance of the airplane's critical angle of attack, and…Aug 24, 2018 · N65HM · Substantial damage NTSB ERA13FA372Accident · 2 fatalField investigationFinal reportAeronca 7AC · Taunton, MAThe pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…Aug 25, 2013 · N83863 · Destroyed NTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.Oct 17, 2011 · N3662E · Substantial damage NTSB BFO94LA069Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Beverly, MAThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground.Apr 15, 1994 · N84409 · Destroyed NTSB NYC84LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chatham, MAAfter landing, as the plt was taxiing to the parking area, the acft hit a rwy identifier sign. The left horizontal stabilizer, elevator & rudder were damaged. The plt said the sign was painted black & was not clearly visible. Also, the sign was not of a…Mar 25, 1984 · N84074 · Substantial damage NTSB NYC77FNA32Accident · No injuriesClosedAeronca 7AC · Stow, MASep 4, 1977 · N84453 · Substantial damage NTSB NYC76FNE12Accident · Serious injuriesClosedAeronca 7AC · Charlton, MADec 7, 1975 · N1244E · Substantial damage NTSB NYC75FNE37Accident · No injuriesClosedAeronca 7AC · Gardner, MAMay 18, 1975 · N85387 · Substantial damage NTSB NYC75FNE24Accident · Minor injuriesClosedAeronca 7AC · Turner Falls, MADec 31, 1974 · N85191 · Substantial damage NTSB NYC73FNA38Accident · Serious injuriesClosedAeronca 7AC · Beverly, MAFeb 19, 1973 · N83022 · Substantial damage NTSB NYC72DNA47Accident · Minor injuriesClosedAeronca 7BCM · Norfolk, MAJun 24, 1972 · N1965E · Substantial damage NTSB NYC71DFD19Accident · No injuriesClosedAeronca 7AC · S.Middleboro, MAOct 25, 1970 · N83457 · Substantial damage NTSB NYC71FFM19Accident · Minor injuriesClosedAeronca 7AC · Lanesboro, MAOct 4, 1970 · N3854E · Substantial damage NTSB NYC70FFM04Accident · No injuriesClosedAeronca 7AC · Turner Falls, MAFeb 1, 1970 · N85191 · Substantial damage NTSB NYC69F0120Accident · No injuriesClosedAeronca 7AC · Amesbury, MAAug 11, 1968 · N1700E · Substantial damage NTSB NYC68A0008Accident · 1 fatalClosedAeronca 7AC · Pembroke, MAJul 13, 1967 · N84425 · Destroyed NTSB NYC67D0476Accident · No injuriesClosedAeronca 7AC · Turners Fall, MAJan 17, 1967 · N85191 · Substantial damage NTSB NYC66F0007Accident · Minor injuriesClosedAeronca 7AC · Hanson, MAJun 6, 1965 · N84436 · Substantial damage NTSB UNK64X1678Accident · No injuriesClosedAeronca 7AC · Fall River, MAMay 9, 1964 · N85104 · Substantial damage