# Fatal NTSB investigations: Champion 7GCB

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 CHI95FA310](https://openairdocs.org/ntsb/CHI95FA310.md): Champion 7GCB · Howard, WI · Accident · 1 fatal · Field investigation · Final report · Sep 3, 1995 · N9838Y · Destroyed
  > a loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.
- [NTSB SEA86FA217](https://openairdocs.org/ntsb/SEA86FA217.md): Aeronca 7GCB · Stanley, ID · Accident · 2 fatal · Field investigation · Final report · Aug 21, 1986 · N9940Y · Destroyed
  > Witnesses reported the aircraft came from the direction of Stanley (8 miles to the north). Circled over the guest lodge, made one or more low (100 to 300 foot) passes. On the last pass the acft was heading away from the lodge towards highway 75. The acft…
- [NTSB CHI81FA071](https://openairdocs.org/ntsb/CHI81FA071.md): Bellanca 7GCB · Viking, MN · Accident · 2 fatal · Closed · Jul 4, 1981 · N8992R · Destroyed
- [NTSB ANC81FA066](https://openairdocs.org/ntsb/ANC81FA066.md): Champion 7GCB · Wasilla, AK · Accident · 1 fatal · Closed · Jun 19, 1981 · N8989R · Substantial damage
- [NTSB MKC79FA022](https://openairdocs.org/ntsb/MKC79FA022.md): Champion 7GCB · Waverly, KS · Accident · 2 fatal · Closed · Mar 16, 1979 · N9835Y · Destroyed
- [NTSB NYC73AN062](https://openairdocs.org/ntsb/NYC73AN062.md): Champion 7GCB · Honesdale, PA · Accident · 1 fatal · Closed · Nov 5, 1972 · N9881Y · Destroyed
- [NTSB LAX70AL051](https://openairdocs.org/ntsb/LAX70AL051.md): Champion 7GCB · San Ysidro, CA · Accident · 1 fatal · Closed · Feb 28, 1970 · N9895Y · Destroyed
- [NTSB MKC70A0017](https://openairdocs.org/ntsb/MKC70A0017.md): Champion 7GCB · Kismet, KS · Accident · 1 fatal · Closed · Oct 9, 1969 · N9882Y · Destroyed
- [NTSB FTW69F0479](https://openairdocs.org/ntsb/FTW69F0479.md): Champion 7GCB · Mt.View, OK · Accident · 1 fatal · Closed · Apr 2, 1969 · N9870Y · Destroyed
- [NTSB UNK64X0804](https://openairdocs.org/ntsb/UNK64X0804.md): Champion 7GCB · Farewell, AK · Accident · 2 fatal · Closed · Mar 5, 1964 · N9887Y · Destroyed
- [NTSB UNK64X0696](https://openairdocs.org/ntsb/UNK64X0696.md): Champion 7GCB · Split Rock, WY · Accident · 2 fatal · Closed · Feb 26, 1964 · N9909Y · Destroyed
- [NTSB UNK64X0448](https://openairdocs.org/ntsb/UNK64X0448.md): Champion 7GCB · Lithonia, GA · Accident · 2 fatal · Closed · Feb 3, 1964 · N9972Y · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=21101PC

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