NTSB investigations: Champion 7ECA, 1988
6 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\") = 1988
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") = 1988
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 NYC88LA220Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Lakeville, MAAccording to the acft owner, N9022L'S fuel tanks were only one quarter full of fuel when the plt took off. The pax said that after about an hour of flying the engine began to run roughly and then it finally quit. The plt made an unsuccessful forced landing.…NTSB NYC88LA194Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bally, PAThe plt was taking off with a left tailwind/crosswind. At liftoff, the left wing dropped and the pilot attempted to correct with rudder. The acft collided with the terrain.NTSB BFO88LA059Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Talcott, WVAccording to a witness, the acft was maneuvering at a low altitude when it contacted trees. The acft then descended, impacting the terrain 45 ft from the trees and slid aprx 110 ft before coming to rest. The plt stated that due to injuries he is unable to…NTSB ANC88LA072Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Creek, AKAccording to the pilot he made a landing on the gravel bar. Shortly after touchdown the pilot lost directional control and ground looped. The acft struck a tree stump and collapsed the left lndg gear.NTSB MIA88LA130Accident · No injuriesLimited investigationFinal reportChampion 7ECA · La Belle, FLDuring the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.NTSB SEA88LA053Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Othello, WAThe student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft.