NTSB investigations: Champion 7FC, 1966
18 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 | 27 |
|---|---|
| 1965 | 26 |
| 1966 | 18 |
| 1967 | 11 |
| 1968 | 9 |
| 1969 | 6 |
| 1970 | 7 |
| 1971 | 7 |
| 1972 | 6 |
| 1973 | 3 |
| 1974 | 4 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 3 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2020 | 2 |
| 2022 | 2 |
| 2023 | 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 year(c.\"eventDate\") = 1966
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 year(c."eventDate") = 1966
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 NYC67D0371Accident · No injuriesClosedChampion 7EC · Lakewood, NJNTSB CHI67D0347Accident · Minor injuriesClosedChampion 7FC · Elcho, WINTSB CHI67D0292Accident · No injuriesClosedChampion 7FC · Hales Corners, WINTSB MKC67D0249Accident · No injuriesClosedAeronca 7FC · Sikeston, MONTSB MIA67F0241Accident · No injuriesClosedAeronca 7FC · Destin, FLNTSB MIA67F0003Accident · No injuriesClosedAeronca 7FC · Greensboro, NCNTSB MKC67F0049Accident · No injuriesClosedChampion 7FC · Mankato, MNNTSB OAK67F0021Accident · No injuriesClosedChampion 7FC · Concord, CANTSB CHI66F0758Accident · No injuriesClosedAeronca 7FC · Palmyra, WINTSB MIA66D0561Accident · No injuriesClosedChampion 7FC · Opa Locka, FLNTSB MKC66D0518Accident · Minor injuriesClosedChampion 7FC · White Bear Lk, MNNTSB MIA66D0476Accident · Minor injuriesClosedChampion 7FC · Millington, TNNTSB CHI66F0667Accident · No injuriesClosedChampion 7FC · Champaign, ILNTSB FTW66F0537Accident · No injuriesClosedChampion 7FC · Kaplan, LANTSB CHI66F0698Accident · No injuriesClosedChampion 7FC · Savoy, ILNTSB CHI66F0572Accident · Minor injuriesClosedChampion 7FC · Bryan, OHNTSB MKC66D0469Accident · No injuriesClosedChanpion 7FC · Hopkins, MNNTSB SEA66D0216Accident · No injuriesClosedAeronca 7FC · Snohomish, WA