NTSB investigations: Champion AERONCA 7GC
7 cases on aircraft the registry lists as Champion AERONCA 7GC. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110164'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110164'))
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 MKC88FA007Accident · 2 fatalField investigationFinal reportChampion Aeronca 7GC · Columbia, MOWitnesses reported the pilot had planned to practice 'taildragger' takeoffs and landings. They reported the aircraft operated routinely from engine start through the final approach segment of a VFR traffic pattern. While stabilized at about 400 ft AGL on…NTSB MKC84LA177Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7GC · Columbia, MOThe student plt was practicing emergency procedures during a solo flt. During a simulated forced landing apch to a field of tall fescue grass, he descended too low & the wheels encountered the grass which was 3 to 4 ft tall. The grass slowed the acft, it…NTSB DEN84FA031Accident · 1 fatalField investigationFinal reportChampion 7GC · Douglas, WYThe plt took off on an aerial observation flt to spot cattle in a mountainous area. When he failed to return, a search was initiated. The plane was found in a valley between 2 mountain ranges. An investigation revealed that the acft had crashed while in a…NTSB FTW72FPG69Accident · No injuriesClosedChampion 7GC · Flippin, ARNTSB MKC71FCJ75Accident · No injuriesClosedChampion 7GC · Ord, NENTSB NYC66D0448Accident · No injuriesClosedChampion 7GC · Leesburg, VANTSB UNK64X3339Accident · No injuriesClosedChampion 7GC · Leesburg, VA