NTSB investigations: Aeronca 11AC, 1988
6 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 |
| 2026 | 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\") = 1988
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") = 1988
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 MIA89LA047Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Tampa, FLThe plt stated that he failed to maintain directional control during landing in a crosswind. He further stated that he aggravated the loss of control by over-application of the controls and adding full throttle which led to the aircraft departing the rwy and…NTSB NYC89FA003Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Barnstead, NHThe Aeronca 11AC was maneuvering downwind for landing. The pilot made a left turn towards the runway to tighten the pattern. While in close proximity to a house and the runway, at a low altitude the pilot elected to make a steep left 270 degree turn, opposite…NTSB BFO88LA074Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Gaithersburg, MDThe pilot reported that the local winds were varying from 340 degrees to 360 degrees at 12 knots gusting to 20 knots. The pilot stated that he lost directional control due to gusty winds while on landing roll. The aircraft contacted a VASI light and then a…NTSB CHI88LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Portage, WIDuring taxi from landing the pilot failed to maintain adequate visual lookout and taxied onto a runway in front of an aircraft on its landing roll. The pilot stated that as he approached the other runway his visibility was restricted by a stand of trees, and…NTSB MKC88DCQ03Accident · Serious injuriesFinal reportAeronca 11AC · Ada, KSThe a/c contacted powerlines about 25 feet AGL, contacted a tree, broke another powerline, and then crashed into a pickup truck. No evidence of preimpact mechanical problems were found with either airframe or powerplant. A toxicological test of the pilot…NTSB LAX88LA092Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lakeport, CADuring ldg rollout the acft veered off the rwy, went into a ditch & collided with terrain causing substantial damage. The surface winds were estimated at only 5 KTS. The plt acknowledged that the accident might have been prevented if he had been less…