NTSB investigations: Champion 7FC, 2006
3 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\") = 2006
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") = 2006
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 MIA06LA127Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Palmetto, FLThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall.NTSB NYC06CA194Accident · Serious injuriesData collectionFinal reportChampion 7FC · Harmonsburg, PAThe pilot's failure to maintain the proper altitude/clearance on final approach, which resulted in an in-flight collision with trees.NTSB NYC06LA070Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Dover-Foxcroft, METhe pilot's inadequate preflight inspection, which failed to detect ice in the fuel system, resulting in a loss of engine power during takeoff-initial climb, and an in-flight collision with trees.