Skip to content

NTSB investigations: Aeronca 7AC, WA

32 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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 WPR22LA237Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Auburn, WAThe pilot's failure to maintain directional control during the landing roll, and the flight instructor’s delayed remedial action.Jun 21, 2022 · N82579 · Substantial damage NTSB SEA06LA130Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Snohomish, WAThe loss of engine power for undertermined reasons. Conditions for carburetor icing were present at the time of the accident. Factors included the fence and the berm.Jun 28, 2006 · N243K · Substantial damage NTSB SEA06CA014Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Yelm, WAThe complete loss of engine power during the initial climb for undetermined reasons, and the excessive descent rate during the ensuing forced landing.Oct 27, 2005 · N85534 · Substantial damage NTSB SEA96LA135Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Vancouver, WAfailure of the pilot to maintain directional control of the airplane during take-off, which resulted in an inadvertent ground swerve and subsequent dragging of the right wing. The pilot's lack of experience in the make/model of aircraft was a related factor.Jun 23, 1996 · N81966 · Substantial damage NTSB SEA95FA072Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brush Prairie, WAUndetermined.Mar 31, 1995 · N85094 · Destroyed NTSB SEA93LA111Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Walla Walla, WAThe premature landing flare by the pilot which resulted in a hard landing and the pilot's failure to maintain airspeed above stall speed during the balked landing.May 18, 1993 · N81829 · Substantial damage NTSB SEA86LA077Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East Sound, WAUpon rollout, a loss of directional control occurred during a wind gust. The pilot elected to go-around. Shortly after lift off, the main gear of the aircraft struck VASI lights. The aircraft then struck the ground.Mar 10, 1986 · N84842 · Substantial damage NTSB SEA85LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Ridgefield, WAThe acft stalled at an alt of aprx 15 AGL and contacted the terrain hard during a landing at a pvt airstrip. The acft does not have a stall warning system. The plt stated that he should have maintained a proper airspeed.Sep 22, 1985 · N84844 · Substantial damage NTSB SEA82DA128Accident · Serious injuriesFinal reportAeronca 7AC · Kent, WADuring practice steep turns the aircraft encountered its wake turbulence. Manuevers to regain control were not effective. The aircraft contacted trees in a nose low attitude.Jul 24, 1982 · N82651 · Destroyed NTSB SEA80DYE49Accident · No injuriesClosedAeronca 7AC · Kent, WAAug 3, 1980 · N3011E · Substantial damage NTSB SEA80FA017Accident · 1 fatalClosedAeronca 7AC · Stevenson, WAJan 23, 1980 · N83586 · Destroyed NTSB SEA74DYG45Accident · No injuriesClosedAeronca 7AC · Walla Walla, WAJun 6, 1974 · N84607 · Substantial damage NTSB SEA73DYE38Accident · Minor injuriesClosedAeronca 7AC · Maple Valley, WAJun 17, 1973 · N2492E · Substantial damage NTSB SEA72AS047Accident · 2 fatalClosedAeronca 7AC · Mead, WAApr 22, 1972 · N2218E · Destroyed NTSB SEA71FWD18Accident · No injuriesClosedAeronca 7AC · Fircrest, WAOct 13, 1970 · N1229E · Substantial damage NTSB SEA71FWA15Accident · Minor injuriesClosedAeronca 7AC · Orchards, WASep 6, 1970 · N81933 · Substantial damage NTSB SEA70AS040Accident · 2 fatalClosedAeronca 7AC · Woodinville, WAMay 10, 1970 · N85445 · Destroyed NTSB SEA70AS032Accident · 1 fatalClosedAeronca 7AC · Snohomish, WAFeb 8, 1970 · N83800 · 2 aircraft · Substantial damage NTSB SEA69A0059Accident · 3 fatalClosedAeronca 7AC · Snohomish, WAJun 2, 1969 · N85071 · 2 aircraft · Destroyed NTSB SEA70F0005Accident · No injuriesClosedAeronca 7AC · Kent, WAMay 31, 1969 · N2943E · Substantial damage NTSB SEA69D0095Accident · No injuriesClosedAeronca 7AC · Tekoa, WASep 2, 1968 · N2218E · Substantial damage NTSB SEA68D0325Accident · No injuriesClosedAeronca 7AC · Edmonds, WAMay 18, 1968 · N83800 · Substantial damage NTSB SEA68D0318Accident · No injuriesClosedAeronca 7AC · Deer Park, WAMay 11, 1968 · N2273E · Substantial damage NTSB SEA68F0028Accident · No injuriesClosedAeronca 7AC · Snohomish, WAApr 15, 1967 · N84842 · Substantial damage NTSB SEA67D0150Accident · No injuriesClosedAeronca 7AC · Auburn, WASep 1, 1966 · N2004E · Substantial damage NTSB SEA67D0001Accident · No injuriesClosedAeronca 7AC · Ocean Shores, WAApr 17, 1966 · N84312 · Substantial damage NTSB SEA66D0254Accident · No injuriesClosedAeronca 7AC · Kent, WAMar 25, 1966 · N82651 · Substantial damage NTSB SEA66D0257Accident · No injuriesClosedAeronca 7AC · Spanaway, WAMar 22, 1966 · N2132E · Substantial damage NTSB SEA66F0176Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WANov 17, 1965 · N81933 · Substantial damage NTSB SEA65F0068Accident · Minor injuriesClosedAeronca 7AC · Seattle, WAMay 22, 1965 · N1363E · Substantial damage NTSB UNK64X2747Accident · No injuriesClosedAeronca 7ACS · Kenmore, WAJul 10, 1964 · N82554 · Substantial damage NTSB UNK64X0921Accident · No injuriesClosedAeronca 7AC · Woodlawn, WAMar 15, 1964 · N3133E · Destroyed