NTSB investigations: Aeronca 11AC, 2016
5 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.
Cases per year
| 1964 | 18 |
|---|---|
| 1965 | 10 |
| 1966 | 16 |
| 1967 | 25 |
| 1968 | 13 |
| 1969 | 8 |
| 1970 | 20 |
| 1971 | 8 |
| 1972 | 6 |
| 1973 | 4 |
| 1974 | 10 |
| 1975 | 10 |
| 1976 | 10 |
| 1977 | 3 |
| 1978 | 6 |
| 1979 | 7 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 5 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 6 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 5 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 6 |
| 1995 | 2 |
| 1996 | 4 |
| 1998 | 1 |
| 1999 | 6 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 2 |
| 2010 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2016 | 5 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 2016
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 year(c."eventDate") = 2016
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" DESCRun 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 GAA17CA043Accident · No injuriesData collectionFinal reportAeronca 11AC · Winter Haven, FLThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion.NTSB GAA16CA410Accident · No injuriesData collectionFinal reportAeronca 11AC · Gig Harbor, WAThe pilot's failure to maintain directional control during landing, and subsequent wing tip strike, which resulted in substantial damage to the rear spar.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…NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB GAA16CA257Accident · No injuriesData collectionFinal reportAeronca 11AC · Vinton, IAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and ground loop.