Skip to content

Champion AERONCA 7AC

NTSB investigations · 16

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2110140') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2110140')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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.Apr 19, 2025 · N83871 · Substantial damage 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.Sep 19, 2022 · N2716E · Substantial damage 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.May 27, 2016 · N2675E · Substantial damage 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.Apr 19, 2014 · N82206 · Substantial damage 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.Jun 21, 1996 · N2456E · Substantial damage 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.Apr 16, 1989 · N84745 · Substantial damage NTSB CHI80DEX24Accident · No injuriesClosedAeronca 7AC · Morristown, INJul 13, 1980 · N3687E · Substantial damage NTSB DEN72FTM09Accident · No injuriesClosedAeronca 7AC · Woods Cross, UTFeb 17, 1972 · N81718 · Substantial damage NTSB CHI72FEV01Accident · Serious injuriesClosedChampion 7AC · Breese, ILJul 1, 1971 · N2515E · Destroyed NTSB MIA69F0461Accident · No injuriesClosedAeronca 7AC · Cleveland, TNMay 3, 1969 · N2665E · Substantial damage NTSB SEA66D0266Accident · No injuriesClosedAreonca 7AC · Harrisburg, ORApr 19, 1966 · N84745 · Substantial damage NTSB LAX66D0168Accident · No injuriesClosedAeronca 7AC · Piru, CAOct 26, 1965 · N85350 · Substantial damage NTSB CHI66F0335Accident · Minor injuriesClosedAeronca 7AC · Poplar Plains, KYOct 3, 1965 · N84001 · Destroyed NTSB MKC65A0065Accident · 1 fatalClosedAeronca 7AC · Hallock, MNMay 2, 1965 · N1581E · Destroyed NTSB UNK64X1229Accident · Serious injuriesClosedAeronca 7AC · Ames, OKApr 8, 1964 · N83867 · Substantial damage NTSB UNK64X1104Accident · Serious injuriesClosedAeronca 7AC · San Diego, CAMar 29, 1964 · N82082 · Destroyed

Back to Champion AERONCA 7AC