NTSB investigations: Champion 7KCAB, 1989
3 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\") = 1989
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") = 1989
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 ANC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Montague Island, AKSelection of unsuitable terrain by the pilot. Contributing factors were: rough terrain, gusty winds, high vegetation, and trees.NTSB LAX89LA322Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria · Auburn, CAThe pilot's inadvertent activation of nose down trim which resulted in a loss of control and collision with a tree. Contributing factor(s) was: the pilot's lack of experience in this type of airplane.NTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.