NTSB investigations: Champion 7GCBC
7 cases on aircraft the registry lists as Champion 7GCBC, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PK')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PK')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.NTSB ANC99LA081Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Anchorage, AKThe pilot's failure to maintain an adequate airspeed, and subsequent inadvertent stall.NTSB CHI98LA361Accident · 2 fatalLimited investigationFinal reportChampion BL-7-GCBC · Upham, NDThe pilot's steep pull and failure to maintain adequate airspeed, which resulted in a stall/spin. Contributing factors were the pilot's lack of familiarity with the airplane's handling qualities, and a lack of recent experience in the airplane.NTSB FTW96LA382Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Edgewood, NMThe pilot's failure to maintain aircraft control. A factor was a whirlwind.NTSB SEA92FA130Accident · 1 fatalField investigationFinal reportChampion 7GCBC · Prosser, WAInadequate inflight planning/preparation and airspeed was not maintained. A factor to the accident was: an uncontrolled stall/spin.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.NTSB MIA82DA087Accident · No injuriesFinal reportChampion 7GCBC · New Smyrna Beac, FLThe pilot reported that during a banner pick up, he missed the banner, and on climb out, he encounter windshear and stalled. The plane crashed before recovering from the stall. He reported that the wind was gusting to 20 knots.