NTSB investigations: Aeronca 7AC, 1987
7 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.
Cases per year
| 1964 | 79 |
|---|---|
| 1965 | 69 |
| 1966 | 49 |
| 1967 | 44 |
| 1968 | 48 |
| 1969 | 44 |
| 1970 | 34 |
| 1971 | 33 |
| 1972 | 37 |
| 1973 | 23 |
| 1974 | 32 |
| 1975 | 24 |
| 1976 | 20 |
| 1977 | 26 |
| 1978 | 20 |
| 1979 | 16 |
| 1980 | 9 |
| 1981 | 17 |
| 1982 | 11 |
| 1983 | 12 |
| 1984 | 12 |
| 1985 | 12 |
| 1986 | 12 |
| 1987 | 7 |
| 1988 | 10 |
| 1989 | 10 |
| 1990 | 4 |
| 1991 | 9 |
| 1992 | 6 |
| 1993 | 9 |
| 1994 | 8 |
| 1995 | 10 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 7 |
| 2005 | 6 |
| 2006 | 3 |
| 2007 | 8 |
| 2008 | 4 |
| 2009 | 9 |
| 2010 | 5 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 5 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 9 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 6 |
| 2026 | 4 |
Where
Latest 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\") = 1987
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 year(c."eventDate") = 1987
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" 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 ANC87LA150Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Island Lake, AKThe pilot stated that during the initial climbout the aircraft lost power, stalled, and crashed into a row of trees near the lake. The pilot also stated it was fuel contamination which caused a partial power loss.NTSB FTW87LA215Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Batesvile, TXA witness to the accident reported the pilot was 'buzzing' personnel in a cotton field and on the third pass did not pull up in time. The belly struck the ground while the aircraft was in a 'fairly steep angle of descent.' The witness stated the engine…NTSB ATL87LA220Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Columbus, OHThe plt experienced a loss of directional control on ldg as the tailwheel touched down, and he executed a go-around. On the 2nd ldg attempt, the airplane veered off the rwy, traveled across a grassy area, and impacted a parked C-172. Post-crash exam of the…NTSB BFO87FA048Accident · No injuriesField investigationFinal reportAeronca 7AC · Saluda, VAWhile climbing thru aprx 400 to 500 ft after takeoff, the plt made a slight rgt turn which was flwd by a left bank. After moving the control stick for a left bank, it jammed to the left & was restricted in fore & aft movement. The plt applied full rgt rudder…NTSB NYC87LA195Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Jamestown, NYThe student plt rented the acft & flew to a field aprx 40 mi from the dep arpt. After landing, a passenger boarded the acft. The student started to takeoff again. Drg takeoff, the acft lifted off, but would not climb sufficiently to clear trees at the dep end…NTSB ATL87FA111Accident · 1 fatalField investigationFinal reportAeronca 7AC · Sharpsburg, GAPlt dep a pvt grass airstrip for a LCL VFR flt. Acft was observed to lift off the grass rwy at about 1000 ft. it climbed to about 30 ft AGL and leveled off. At about the end of the 1800 ft rwy the acft nosed up into a 'fairly steep' climb attitude. The ground…NTSB FTW87LA091Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Horizon City, TXThe pilot delayed in initiating recovery from a simulated forced landing. Then when the throttle was advanced from idle to full open the engine hesitated briefly and full power was restored too late to recover. A hard left bank was initiated to align the…