Final NTSB investigations: Champion AERONCA 7AC
16 cases on aircraft the registry lists as Champion 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 | 3 |
| 1966 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1980 | 1 |
| 1989 | 1 |
| 1996 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2022 | 1 |
| 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 c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110140'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110140'))
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 CEN25LA161Accident · No injuriesClass 4 · LimitedFinal reportChampion Aeronca 7AC · Estherwood, LAThe non-certificated pilot’s failure to maintain altitude while maneuvering at low altitude that resulted in a descent and impact into terrain.NTSB ERA22FA426Accident · 2 fatalClass 3 · FieldFinal reportChampion Aeronca 7AC · Bridgeton, NJThe pilot's exceedance of the airplane’s critical angle of attack shortly after takeoff, which resulted in an aerodynamic stall, loss of control, and impact with terrain.NTSB GAA16CA311Accident · Minor injuriesData collectionFinal reportChampion Aeronca 7AC · Groveland, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a collision with a concrete barrier wall.NTSB ERA14CA267Accident · No injuriesData collectionFinal reportChampion Aeronca 7AC · Port Gibson, MSThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was sun glare.NTSB LAX96LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lamont, CAfailure of the pilot to see-and-avoid a guy wire along the border of a field that was being agriculturally treated. The sunglare, guy wire, and lack of visual cues were related factors.NTSB LAX89LA162Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAThe pilots improper use of carburetor heat in conditions that were conducive to the formation of carburetor ice.NTSB CHI80DEX24Accident · No injuriesClosedAeronca 7AC · Morristown, INNTSB DEN72FTM09Accident · No injuriesClosedAeronca 7AC · Woods Cross, UTNTSB CHI72FEV01Accident · Serious injuriesClosedChampion 7AC · Breese, ILNTSB MIA69F0461Accident · No injuriesClosedAeronca 7AC · Cleveland, TNNTSB SEA66D0266Accident · No injuriesClosedAreonca 7AC · Harrisburg, ORNTSB LAX66D0168Accident · No injuriesClosedAeronca 7AC · Piru, CANTSB CHI66F0335Accident · Minor injuriesClosedAeronca 7AC · Poplar Plains, KYNTSB MKC65A0065Accident · 1 fatalClosedAeronca 7AC · Hallock, MNNTSB UNK64X1229Accident · Serious injuriesClosedAeronca 7AC · Ames, OKNTSB UNK64X1104Accident · Serious injuriesClosedAeronca 7AC · San Diego, CA