# NTSB investigations: Champion 7GC: Loss of control - on ground/water

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ANC04LA041](https://openairdocs.org/ntsb/ANC04LA041.md): Champion 7GC · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Apr 19, 2004 · N8529E · Substantial damage
  > The 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 DEN03LA091](https://openairdocs.org/ntsb/DEN03LA091.md): Champion 7GC · Casper, WY · Accident · No injuries · Limited investigation · Final report · May 30, 2003 · N5923L · Substantial damage
  > the 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 FTW95LA171](https://openairdocs.org/ntsb/FTW95LA171.md): Champion 7GC · Paragould, AR · Accident · No injuries · Limited investigation · Final report · Apr 15, 1995 · N4842E · Substantial damage
  > The student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.
- [NTSB SEA93LA131](https://openairdocs.org/ntsb/SEA93LA131.md): Champion 7GC · Gillette, WY · Accident · No injuries · Limited investigation · Final report · Jun 14, 1993 · N8947R · Substantial damage
  > The 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 ANC87LA133](https://openairdocs.org/ntsb/ANC87LA133.md): Champion 7GC · Central, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1987 · N8507E · Substantial damage
  > The 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

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

This list as a web page: https://openairdocs.org/ntsb?model=21101N2&occurrence=260

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
