NTSB investigations: Champion 7GCBC, 1987
4 cases on aircraft the registry lists as Champion 7GCBC. 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
| 1966 | 3 |
|---|---|
| 1967 | 7 |
| 1968 | 8 |
| 1969 | 3 |
| 1970 | 9 |
| 1971 | 15 |
| 1972 | 6 |
| 1973 | 11 |
| 1974 | 6 |
| 1975 | 12 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 5 |
| 1979 | 1 |
| 1980 | 6 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 4 |
| 1991 | 2 |
| 1992 | 3 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 6 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 3 |
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2024 | 2 |
| 2025 | 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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PK'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PK'))
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 ANC87LA141Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Talkeetna, AKThe pilot attempted to take off from an unimproved site while the inside of the airplane's windows were partially obscured with condensation. The airplane struck a rock with its main gear during the take off roll and became prematurely airborne. The pilot…NTSB NYC87LA194Accident · Serious injuriesLimited investigationFinal reportChampion 7GCB · Sullivan, NHThe pilot of the float equipped citabria 7GCBC experienced a power loss when he added power and raised his nose for a cruise climb from 3500 ft. he set up for a forced landing in a pond. As he neared touchdown, the engine regained power and responded to the…NTSB DEN87LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Rock Rover, WYThe plt was using a pasture for takeoff. The winds were calm and the takeoff run was slightly uphill. There was a low spot in the pasture which was soft from melting snow. The acft did not reach takeoff speed before reaching the end of the pasture. During the…NTSB ANC87LA049Accident · No injuriesLimited investigationFinal reportChampion &GCBC · Talkeetna, AKThe pilot stated that during the initial climb out he lost directional control of the aircraft causing the plane to stall and strike a small tree next to the runway. At the time of the accident the wind was 330 degrees at 3 knots.