NTSB investigations: Champion 7ECA, 1992
7 cases on aircraft the registry lists as Champion 7ECA. 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
| 1965 | 16 |
|---|---|
| 1966 | 18 |
| 1967 | 25 |
| 1968 | 29 |
| 1969 | 17 |
| 1970 | 22 |
| 1971 | 26 |
| 1972 | 21 |
| 1973 | 12 |
| 1974 | 14 |
| 1975 | 14 |
| 1976 | 14 |
| 1977 | 13 |
| 1978 | 11 |
| 1979 | 5 |
| 1980 | 8 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 7 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 6 |
| 1987 | 9 |
| 1988 | 6 |
| 1989 | 4 |
| 1991 | 5 |
| 1992 | 7 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 8 |
| 1998 | 3 |
| 1999 | 7 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2024 | 2 |
| 2025 | 3 |
| 2026 | 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\") = 1992
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101NN'))
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") = 1992
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101NN'))
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 CHI93LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Carroll, IAThe pilot's failure to maintain aircraft directional control while landing in crosswind conditions.NTSB SEA92LA210Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Arlington, WYThe pilot in command's failure to touch down at the proper landing point on the road. A factor contributing to the accident was high density altitude.NTSB ANC92LA165Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Talkeetna, AKThe student pilot's failure to maintain directional control on landing roll.NTSB FTW92LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Angel Fire, NMThe pilot's inadequate evaluation of the environmental conditions which resulted in exceeding the climb capability of the aircraft. The inadvertent stall was also a cause. Factors were the downdraft and high density altitude.NTSB FTW92LA168Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA-326 · Clifton, TXThe inadvertent stall by the pilot. Factors were the inadequate altitude and the pilot's lack of experience in type aircraft.NTSB LAX92LA198Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lake Havasu, AZThe failure of the pilot to maintain directional control of the aircraft during the landing touch down.NTSB FTW92LA106Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Weatherford, TXThe pilot's failure to maintain directional control during the landing rollout, and the ensuing inadvertent stall during the aborted landing due to the jammed elevator. A factor was the crosswind.