NTSB investigations: Aeronca 7AC, IA
18 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 | 2 |
|---|---|
| 1965 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 2 |
| 2015 | 1 |
| 2018 | 1 |
| 2020 | 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 c.\"eventStateOrRegion\" = 'IA' 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" = 'IA' 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" 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 CEN20CA120Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Ankeny, IAThe pilot's improper starting procedure, which allowed the airplane to move forward over the wheel chocks and impact him and a hangar when he subsequently hand propped the engine.NTSB GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.NTSB GAA15LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garrison, IAThe malfunction of the right brake for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB MKC81FCD40Accident · Serious injuriesClosedAeronca 7AC · Larchwood, IANTSB MKC81FCD35Accident · No injuriesClosedAeronca 7AC · Blakesburg, IANTSB MKC80DCD02Accident · No injuriesClosedAeronca 7AC · Lamotte, IANTSB MKC78DCD42Accident · Minor injuriesClosedAeronca 7AC · Corning, IANTSB MKC76FCD66Accident · Serious injuriesClosedAeronca 7AC · Prairieburg, IANTSB MKC76FCD50Accident · No injuriesClosedCessna T210 · Iowa Falls, IANTSB MKC75FCD27Accident · Serious injuriesClosedAeronca 7AC · Graf, IANTSB MKC73DCD28Accident · No injuriesClosedAeronca 7AC · Carroll, IANTSB MKC73DCD19Accident · No injuriesClosedAeronca 7AC · Decorah, IANTSB MKC72DCD25Accident · No injuriesClosedAeronca 7AC · Monticello, IANTSB MKC70FCD07Accident · Serious injuriesClosedAeronca 7AC · Nevada, IANTSB MKC69D0380Accident · No injuriesClosedAeronca 7AC · Osage, IANTSB MKC66F0048Accident · Serious injuriesClosedAeronca 7AC · Richville, IANTSB UNK64X2151Accident · Minor injuriesClosedAeronca 7AC · Red Oak, IANTSB UNK64X0398Accident · No injuriesClosedAeronca 7AC · Washburn, IA