# NTSB investigations: Champion 7GCAA, CO

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 DEN99LA021](https://openairdocs.org/ntsb/DEN99LA021.md): Champion 7GCAA · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Nov 22, 1998 · N9632S · Substantial damage
  > The pilot's failure to maintain directional control. Factors were the gusty crosswind and terrain.
- [NTSB DEN86LA104](https://openairdocs.org/ntsb/DEN86LA104.md): Champion 7GCAA · Falcon, CO · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N9614S · Substantial damage
  > According to the plt, when the acft slowed after landing, it turned 'sharply to the right.' The plt stated he experienced 'extreme tailwheel shudder' prior to this during the landing roll. During the investigation, it was ascertained that the tailwheel spring…
- [NTSB DEN86LA001](https://openairdocs.org/ntsb/DEN86LA001.md): Champion 7GCAA · Cortez, CO · Accident · No injuries · Limited investigation · Final report · Oct 1, 1985 · N9614S · Substantial damage
  > After 3.9 hrs flt time on a x-country flt from cheyenne, WY, to Cortez, CO, the plt experienced an eng failure due to fuel exahustion. He executed a forced landing in a mountain meadow that was not adequate in length for the landing. The acft impacted trees…
- [NTSB DEN73FTE78](https://openairdocs.org/ntsb/DEN73FTE78.md): Champion 7CGAA · Longmont, CO · Accident · No injuries · Closed · May 21, 1973 · N11087 · Substantial damage
- [NTSB DEN71DXD52](https://openairdocs.org/ntsb/DEN71DXD52.md): Champion 7GCAA · Wray, CO · Accident · No injuries · Closed · Feb 16, 1971 · N1685G · Substantial damage
- [NTSB DEN71DXD21](https://openairdocs.org/ntsb/DEN71DXD21.md): Champion 7ECA · Aurora, CO · Accident · No injuries · Closed · Aug 16, 1970 · N9561S · Substantial damage
- [NTSB DEN67D0166](https://openairdocs.org/ntsb/DEN67D0166.md): Champion 7GCBC · Steamboat Sp, CO · Accident · No injuries · Closed · Jul 4, 1966 · N8322V · Substantial damage

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

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

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