# NTSB investigations: Champion 7GCBC, MN

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 CHI06CA104](https://openairdocs.org/ntsb/CHI06CA104.md): American Champion 7GCBC · Tower, MN · Accident · No injuries · Data collection · Final report · Mar 25, 2006 · N1856G · Substantial damage
  > The unsuitable landing area selected by the pilot which led to the subsequent nose-over. The terrain condition was a factor.
- [NTSB CHI98LA273](https://openairdocs.org/ntsb/CHI98LA273.md): Champion 7GCBC · Clearwater, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1998 · N21262 · Destroyed
  > The inadequate visual lookout by the pilot-in-command. The unmarked transmission wire was a contributing factor.
- [NTSB CHI86LA080](https://openairdocs.org/ntsb/CHI86LA080.md): Champion Citabria 7GCBC · Ely, MN · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1986 · N1856G · Substantial damage
  > During a descent from 1000 ft AGL to 200 ft AGL to photograph wildlife the pilot applied carb heat. When he advanced the throttle at 200 ft to level off the engine did not respond. The aircraft then settled into trees. Temperature at the time was -5 deg f.,…

## 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."eventStateOrRegion" = 'MN' 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 ('21101PK'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=21101PK&state=MN

---
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.