Skip to content

NTSB investigations: Champion 7GC, AK

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

19662026

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 ('21101N2')) 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 ('21101N2'))
  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 ('21101N2'))
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 ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.Mar 26, 2018 · N4844E · Substantial damage NTSB GAA16CA486Accident · No injuriesData collectionFinal reportChampion 7GC · Palmer, AKThe pilot’s inadequate preflight inspection and failure to assess the airplane’s fuel quantity before departure, which resulted in fuel exhaustion.Sep 4, 2016 · N4831E · Substantial damage NTSB ANC04LA041Accident · No injuriesLimited investigationFinal reportChampion 7GC · Wasilla, AKThe flight instructor's inadequate supervision of the student pilot which resulted in a loss of directional control during the takeoff roll, and subsequent collision with a ditch. A factor contributing to the accident was the student pilot's failure to…Apr 19, 2004 · N8529E · Substantial damage NTSB ANC87LA133Accident · No injuriesLimited investigationFinal reportChampion 7GC · Central, AKThe pilot stated that he was attempting to land in gusty, crosswind conditions and lost control of the airplane. He said the accident could have been avoided by choosing a different airport with less crosswind, or by initiating a go-around when he first…Aug 24, 1987 · N8507E · Substantial damage NTSB ANC82DAG40Accident · Minor injuriesFinal reportAeronca 7GC · Tyonek, AKThe plt stated he departed anchorage for the kustatan river. He encountered ground fog enroute & landed on a beach. About 1-1/2 hrs later the fog cleared & he took off. He again encountered fog at the mcarther river, but it looked clearon the other side.…Aug 4, 1982 · N8933R · Substantial damage NTSB ANC79FA092Accident · 1 fatalClosedBellanca 7GC · Cooper Landing, AKSep 14, 1979 · N7676E · Substantial damage NTSB ANC76DAH23Accident · No injuriesClosedChampion 7GC · Dillingham, AKJun 15, 1976 · N7589E · Substantial damage NTSB ANC75DAG45Accident · No injuriesClosedChampion 7GC · Chitina, AKOct 3, 1974 · N8529E · Substantial damage NTSB ANC75DAG46Accident · No injuriesClosedChampion 7GC · Wasilla, AKJul 26, 1974 · N4831E · Substantial damage NTSB ANC74DAH04Accident · No injuriesClosedChampion 7GC-5 · Cordova, AKMay 28, 1974 · N7530E · Substantial damage NTSB ANC73AA020Accident · 3 fatalClosedPiper PA-18 · Gakona, AKSep 15, 1972 · N3844Z · 2 aircraft · Destroyed NTSB ANC72DAG39Accident · No injuriesClosedChampion 7GC · Anchorage, AKSep 1, 1971 · N7676E · Substantial damage NTSB ANC71DAG73Accident · No injuriesClosedChampion 7GC · Anchorage, AKMar 23, 1971 · N7676E · Substantial damage NTSB ANC71DAD02Accident · No injuriesClosedChampion 7GC · Yakutat, AKAug 21, 1970 · N8529E · Substantial damage NTSB ANC70DAA02Accident · No injuriesClosedChampion 7GC · Fairbanks, AKFeb 22, 1970 · N4871E · Substantial damage NTSB ANC70D0026Accident · No injuriesClosedChampion 7GC · Palmer, AKJul 23, 1969 · N7676E · Substantial damage NTSB ANC68D0068Accident · No injuriesClosedAeronca 7GC · Willow, AKNov 12, 1967 · N4883E · Substantial damage NTSB ANC67D0040Accident · No injuriesClosedAeronca 7GC · Sterling, AKAug 5, 1966 · N4883E · Substantial damage