Skip to content

NTSB investigations: Aeronca 11AC, MI

23 cases on aircraft the registry lists as Aeronca 11AC. 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" = 'MI' 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 ('0191102')) 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\" = 'MI' 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 ('0191102'))
  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" = 'MI' 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 ('0191102'))
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 GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.Jun 16, 2017 · N9404E · Substantial damage NTSB CEN16FA269Accident · 2 fatalField investigationFinal reportAeronca 11AC · Ishpeming, MIThe pilot's failure to maintain airspeed following a loss of engine power due to carburetor icing while turning from base to final at a low altitude, which resulted in the airplane's wing exceeding its critical angle of attack and a subsequent aerodynamic…Jul 19, 2016 · N85893 · Substantial damage NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.Jul 3, 2016 · N86078 · Destroyed NTSB CEN14LA387Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Flushing, MIThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…Jul 22, 2014 · N4453P · Substantial damage NTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.Sep 5, 2009 · N3383E · Substantial damage NTSB CHI03LA235Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Brighton, MIThe pilot's directional control not possible resulting from the rudder control assembly separation during the landing. A factor was the construction vehicle that the airplane impacted.Jul 29, 2003 · N86233 · Substantial damage NTSB CHI02LA057Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lake Leelanau, MIThe improper planning/decision in runway selection. The soft runway condition and wet snow were contributing factors.Jan 3, 2002 · N302AC · Substantial damage NTSB CHI99LA318Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Watervliet, MIthe pilot not maintaining aircraft control during takeoff, and the pilot not correcting for the porpoise.Aug 28, 1999 · N9404E · Substantial damage NTSB CHI96FA290Accident · 2 fatalField investigationFinal reportAeronca 11AC · Charlotte, MIthe pilot's improper use of engine controls (carburetor heat and/or throttle), while making a relatively high speed approach, low pass, and pull-up, which resulted in partial loss of engine power; and failure of the pilot to maintain sufficient airspeed after…Aug 9, 1996 · N85825 · Destroyed NTSB CHI91DEM06Accident · 1 fatalFinal reportAeronca 11-AC · Central Lake, MIA result of the pilot in command not maintaining aircraft control and not performing remedial action after the airplane entered the steep descent. A factor contributing to this accident was the pilot in command's lack of recent experience.Jul 11, 1991 · N86083 · Destroyed NTSB CHI75DEM32Accident · No injuriesClosedAeronca 11AC · Ontonagon, MIMar 19, 1975 · N85931 · Substantial damage NTSB CHI74FEM55Accident · Minor injuriesClosedAeronca 11AC · Grand Rapids, MIApr 27, 1974 · N9572E · Substantial damage NTSB CHI74FEM36Accident · No injuriesClosedAeronca 11AC · Charlotte, MIJan 12, 1974 · N86078 · Substantial damage NTSB CHI70DBM10Accident · No injuriesClosedAeronca 11AC · Niles, MIApr 5, 1970 · N86353 · Substantial damage NTSB CHI70F0220Accident · No injuriesClosedAeronca 11AC · Reed City, MIAug 29, 1969 · N86031 · Substantial damage NTSB CHI70D0119Accident · No injuriesClosedAeronca 11AC · Grand Haven, MIJul 18, 1969 · N9671E · Substantial damage NTSB CHI69A0085Accident · 1 fatalClosedAeronca 11AC · Alto, MIApr 7, 1969 · N9674E · Destroyed NTSB CHI69F0050Accident · No injuriesClosedAeronca 11AC · Newport, MIJul 4, 1968 · N3644E · Substantial damage NTSB CHI67F0238Accident · No injuriesClosedAeronca 11AC · Greenville, MIOct 9, 1966 · N9808E · Substantial damage NTSB CHI67F0032Accident · No injuriesClosedAeronca 11AC · Kalamo, MIJun 12, 1966 · N85825 · Substantial damage NTSB UNK65X0714Accident · No injuriesClosedAeronca 11AC · Ontanagon, MINov 15, 1964 · N3264E · Substantial damage NTSB UNK64X0375Accident · No injuriesClosedAeronca 11AC · East Tawas, MIJan 26, 1964 · N9813E · Substantial damage NTSB UNK64X0166Accident · No injuriesClosedAeronca 11AC · Napoleon, MIJan 5, 1964 · N9172E · Substantial damage