NTSB investigations: Champion 7FC, IL
13 cases on aircraft the registry lists as Champion 7FC. 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 | 3 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1977 | 1 |
| 2004 | 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\" = 'IL' 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 ('21101NX'))
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" = 'IL' 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 ('21101NX'))
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 CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…NTSB CHI77DEE47Accident · No injuriesClosedChampion 7FC · Moline, ILNTSB CHI72DCA03Accident · No injuriesClosedChampion 7FC · Columbia, ILNTSB CHI71DEE68Accident · No injuriesClosedChampion 7FC · Joliet, ILNTSB CHI70F0242Accident · Serious injuriesClosedChampion 7FC · Danville, ILNTSB CHI68F0767Accident · No injuriesClosedChampion 7FC · Pleasant Hill, ILNTSB CHI68D0489Accident · No injuriesClosedChampion 7FC · Savoy, ILNTSB CHI68D0439Accident · Minor injuriesClosedChampion 7FC · Monticello, ILNTSB CHI66F0667Accident · No injuriesClosedChampion 7FC · Champaign, ILNTSB CHI66F0698Accident · No injuriesClosedChampion 7FC · Savoy, ILNTSB UNK65X1174Accident · No injuriesClosedAeronca 7FC · Oswego, ILNTSB UNK64X4081Accident · Serious injuriesClosedChampion 7FC · Columbia, ILNTSB UNK64X1577Accident · Minor injuriesClosedChampion 7FC · Champaign, IL