NTSB investigations: Champion 7ECA, 1999
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\") = 1999
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") = 1999
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 LAX00LA056Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Oxnard, CAThe pilot's inadequate compensation for the variable crosswind condition and subsequent failure to maintain directional control of the airplane.NTSB ATL00LA014Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ridgeland, SCThe pilot's failure to obtain/maintain adequate airspeed during the takeoff/initial climb which resulted in an inadvertent stall and subsequent collision with terrain.NTSB CHI00LA011Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Grand Ledge, MIthe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind and the tree which the airplane contacted.NTSB ANC99LA144Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Heiden, AKThe pilot's selection of unsuitable terrain for landing.NTSB CHI99LA331Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Forest Lake, MNthe pilot's misjudging the proper glidepath, and his not maintaining airspeed. Factors were the pilot's lack of recent experience, the airplane's inadvertent stall, and the fence.NTSB CHI99FA167Accident · 1 fatalField investigationFinal reportChampion 7ECA · Comstock, WIThe pilot's failure to maintain aircraft control. A factor contributing to this accident was the airplane's low altitude.NTSB CHI99LA126Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Atchison, KSThe loss of engine power for unknown reasons.