Skip to content

NTSB investigations: Champion 7GCB, AK

20 cases on aircraft the registry lists as Champion 7GCB. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PC')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PC'))
  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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PC'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.Jun 23, 2012 · N466RV · Substantial damage NTSB ANC07LA064Accident · No injuriesLimited investigationFinal reportChampion 7GCB · King Salmon, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in the right main landing gear collapsing during takeoff. Factors contributing to the accident were rough/uneven terrain, and the collapse of the main landing gear.Jul 11, 2007 · N9897Y · Substantial damage NTSB ANC06CA033Accident · No injuriesData collectionFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane colliding with a snowbank and nosing over.Mar 5, 2006 · N223HW · Substantial damage NTSB ANC03LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Pilot Point, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain control of the airplane that resulted in the left wing striking the ground during the landing roll. A factor contributing to the accident was the presence of wind gusts.Jun 29, 2003 · N9897Y · Substantial damage NTSB ANC98LA088Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hope, AKThe pilot's selection of an unsuitable landing/takeoff area. Contributing factors were the stream crossing the airstrip and the embankment.Jul 1, 1998 · N9809Y · Substantial damage NTSB ANC96LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Dillingham, AKfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop/swerve.May 2, 1996 · N9985Y · Substantial damage NTSB ANC95LA066Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident is the lack of suitable terrain for a forced landing.Jun 7, 1995 · N9958Y · Substantial damage NTSB ANC92LA082Accident · Minor injuriesLimited investigationFinal reportChampion 7GCB · Snow Lake, AKThe pilot's failure to keep the aircraft on the step and he allowed it to become airborne. The pilot subsequently lost depth perception, and his failure to maintain proper rate of descent, resulting in a hard landing and collapse of the float landing gear. A…May 30, 1992 · N9897Y · Substantial damage NTSB ANC88LA076Accident · Minor injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe 70 hour private pilot was attempting to take off from a private turf airstrip with her non-pilot husband onboard. As she advanced the throttle to the one-half open position, the airplane veered sharply to the left. She said that she pulled the airplane…Jun 29, 1988 · N9892Y · Substantial damage NTSB ANC81FA066Accident · 1 fatalClosedChampion 7GCB · Wasilla, AKJun 19, 1981 · N8989R · Substantial damage NTSB ANC77DAA63Accident · Serious injuriesClosedBellanca 7GCBC · Fort Yukon, AKJul 29, 1977 · N8984R · Substantial damage NTSB ANC76DAA14Accident · No injuriesClosedChampion 7GCB · Northway, AKAug 31, 1975 · N9809Y · Substantial damage NTSB ANC75DAG57Accident · No injuriesClosedChampion 7GCB · Glennallen, AKNov 17, 1974 · N9810Y · Substantial damage NTSB ANC75DAG11Accident · Serious injuriesClosedBellanca 7GCB · Kodiak, AKJul 29, 1974 · N8987R · Destroyed NTSB ANC72DAA37Accident · No injuriesClosedChampion 7GCB · Fairbanks, AKJun 17, 1972 · N9918Y · Substantial damage NTSB ANC69F0128Accident · Minor injuriesClosedChampion 7GCB · Ft Yukon, AKMay 9, 1969 · N9918Y · Substantial damage NTSB ANC69F0126Accident · Serious injuriesClosedChampion 7GCB · Cordova, AKFeb 1, 1969 · N8997R · Destroyed NTSB ANC66D0063Accident · No injuriesClosedChampion 7GCB · Tyonek, AKAug 31, 1965 · N8989R · Substantial damage NTSB ANC65D0006Accident · No injuriesClosedChampion 7GCB · Fort Yukon, AKApr 3, 1965 · N9918Y · Substantial damage NTSB UNK64X0804Accident · 2 fatalClosedChampion 7GCB · Farewell, AKMar 5, 1964 · N9887Y · Destroyed