Champion 7GC
NTSB investigations · 44
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('21101N2')
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 CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB GAA18CA442Accident · No injuriesData collectionFinal reportChampion 7GC · Warren, ARThe pilot’s failure to maintain directional control during landing.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.NTSB GAA18CA025Accident · No injuriesData collectionFinal reportChampion 7GC · Gerlach, NVThe pilot's incorrect pitch control during the landing roll in shifting wind conditions, which resulted in a nose-over.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.NTSB WPR12CA397Accident · No injuriesData collectionFinal reportChampion 7GC · Spanish Fork, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR12LA200Accident · No injuriesLimited investigationFinal reportChampion 7GC · Rexburg, IDA decrease in indicated oil pressure while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Also causal was the pilot’s failure to…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…NTSB DEN03LA091Accident · No injuriesLimited investigationFinal reportChampion 7GC · Casper, WYthe pilot's failure to maintain directional control of the aircraft during the landing. Contributing factors include the inadequate remedial action by the pilot and the pilot's lack of experience in the aircraft.NTSB FTW95LA171Accident · No injuriesLimited investigationFinal reportChampion 7GC · Paragould, ARThe student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.NTSB SEA93LA131Accident · No injuriesLimited investigationFinal reportChampion 7GC · Gillette, WYThe pilot in command's not maintaining directional control and the overload of the left main landing gear. A factor contributing to the accident was the pilot's lack of experience in conventionally geared aircraft.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…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.…NTSB ANC79FA092Accident · 1 fatalClosedBellanca 7GC · Cooper Landing, AKNTSB SEA77DYM36Accident · No injuriesClosedChampion 7GC · Grande Ronde, ORNTSB ANC76DAH23Accident · No injuriesClosedChampion 7GC · Dillingham, AKNTSB DEN76AD020Accident · 2 fatalClosedChampion 7GC · Lordsburg, NMNTSB MKC76AK021Accident · 2 fatalClosedBellanca 7GC · Garrison, MNNTSB ANC75DAG45Accident · No injuriesClosedChampion 7GC · Chitina, AKNTSB SEA75AS012Accident · 2 fatalClosedChampion 7GC · Florence, MTNTSB ANC75DAG46Accident · No injuriesClosedChampion 7GC · Wasilla, AKNTSB ANC74DAH04Accident · No injuriesClosedChampion 7GC-5 · Cordova, AKNTSB DEN74DQA08Accident · No injuriesClosedChampion 7GC · Albuquerque, NMNTSB UNK73X0105Incident · No injuriesClosedChampion 7GC · Claremont, NHNTSB FTW73DRJ20Accident · Serious injuriesClosedChampion 7GCB · Lak Providence, LANTSB ANC73AA020Accident · 3 fatalClosedChampion 7GC · Gakona, AKNTSB ANC72DAG39Accident · No injuriesClosedChampion 7GC · Anchorage, AKNTSB MKC72DER11Accident · No injuriesClosedChampion 7GC · Hibbing, MNNTSB ANC71DAG73Accident · No injuriesClosedChampion 7GC · Anchorage, AKNTSB ANC71DAD02Accident · No injuriesClosedChampion 7GC · Yakutat, AKNTSB MKC71DCD07Accident · No injuriesClosedAeronca 7GC · Cresco, IANTSB ANC70DAA02Accident · No injuriesClosedChampion 7GC · Fairbanks, AKNTSB ANC70D0026Accident · No injuriesClosedChampion 7GC · Palmer, AKNTSB ANC68D0068Accident · No injuriesClosedAeronca 7GC · Willow, AKNTSB DEN68F0040Accident · Serious injuriesClosedChampion 7GC · Albuquerque, NMNTSB FTW68D0116Accident · No injuriesClosedAeronca 7GC · Imperial, TXNTSB MKC68F0035Accident · No injuriesClosedChampion 7GC · Montevideo, MNNTSB MKC68D0023Accident · Minor injuriesClosedChampion 7GC · Sturgis, SDNTSB DEN67F0093Accident · 1 fatalClosedChampion 7GC · Heber, UTNTSB ANC67D0040Accident · No injuriesClosedAeronca 7GC · Sterling, AKNTSB FTW66F0286Accident · No injuriesClosedChampion 7GC · Shreveport, LANTSB MKC66F0239Accident · Minor injuriesClosedChampion 7GC · Silver Bay, MNNTSB UNK64X1965Accident · No injuriesClosedChampion 7GC · Collegeport, TXNTSB UNK64X0110Accident · No injuriesClosedChampion 7GC · Ft Collins, CO
Back to Champion 7GC