NTSB investigations: Champion 7KCAB, 1984
5 cases on aircraft the registry lists as Champion 7KCAB. 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
| 1967 | 6 |
|---|---|
| 1968 | 3 |
| 1969 | 8 |
| 1970 | 11 |
| 1971 | 20 |
| 1972 | 15 |
| 1973 | 9 |
| 1974 | 5 |
| 1975 | 5 |
| 1976 | 8 |
| 1977 | 4 |
| 1978 | 6 |
| 1979 | 4 |
| 1980 | 4 |
| 1981 | 4 |
| 1982 | 2 |
| 1983 | 4 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 3 |
| 2013 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2022 | 2 |
| 2023 | 2 |
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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101P3'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101P3'))
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 ANC84LA186Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Anchorage, AKThe float equipped acft crashed while maneuvering near a small lake. The plt stated that while at 1000 ft AGL the eng 'coughed a few times and died'. The plt told the rescue crew that his eng iced-up while was at low alt. The passenger stated that the acft…NTSB ATL84LA258Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Virginia Beach, VAAfter a banner tow pick-up, rudder jammed full right. Plt applied both feet to left rudder pedal in attempt to control direction of flt. Left rudder cable then failed in overload as banner engaged power line and broke free. Directional control requirements on…NTSB NYC84LA222Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Egg Harbor Town, NJAccording to the pilot at 350 to 400 ft AGL and aprx 85 KTS the acft abruptly pitched nose down. Recovery was attempted but, the pilot related, the flt controls were jammed. Impact occurred in 30 ft deep water about 45 degrees nose down. During recovery the…NTSB FTW84LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Putnam, OKThe acft bounced during landing and the plt attempted to abort the landing. A truck was parked near the end of the field. The acft collided with the truck which it failed to clear in an attempt to fly over it. There were no reported malfunctions of equipment.NTSB LAX84LA157Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Santa Ana, CAWhile taxiing after landing, a gust of wind overturned the acft. The winds were gusting to 40 KTS.