# NTSB investigations: Champion 7CCM

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 WPR13CA179](https://openairdocs.org/ntsb/WPR13CA179.md): Aeronca 7CCM · Caldwell, ID · Accident · No injuries · Data collection · Final report · Apr 3, 2013 · N4687E · Substantial damage
  > The pilot's loss of directional control after an encounter with a wind gust during takeoff.
- [NTSB LAX88LA173](https://openairdocs.org/ntsb/LAX88LA173.md): Champion 7CCM · Cameron Park, CA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1988 · N6712C · Substantial damage
  > While practicing touch and go landings, the pilot reported that a wind from behind caught the tail of the aircraft. The pilot overcorrected and ground looped the aircraft. The aircraft veered off the runway and nosed over. The pilot reported that there were…
- [NTSB NYC75FGM44](https://openairdocs.org/ntsb/NYC75FGM44.md): Aeronca 7DC · Ducansville, PA · Accident · Minor injuries · Closed · Jun 17, 1975 · N2095A · Substantial damage
- [NTSB OAK75DVG38](https://openairdocs.org/ntsb/OAK75DVG38.md): Champion 7AC · Manton, CA · Accident · No injuries · Closed · Nov 30, 1974 · N4995 · Substantial damage
- [NTSB ANC72AA036](https://openairdocs.org/ntsb/ANC72AA036.md): Aeronca 7CCM · Kasilof, AK · Accident · 2 fatal · Closed · Feb 23, 1972 · N2940E · Destroyed
- [NTSB MKC70FDD03](https://openairdocs.org/ntsb/MKC70FDD03.md): Champion 7CCM · Verona, ND · Accident · No injuries · Closed · Jan 1, 1970 · N4449E · Substantial damage
- [NTSB IAD70D0087](https://openairdocs.org/ntsb/IAD70D0087.md): Aeronca S-7CCM · Annapolis, MD · Accident · No injuries · Closed · Oct 12, 1969 · N2398E · Substantial damage
- [NTSB DIA69F0046](https://openairdocs.org/ntsb/DIA69F0046.md): Aeronca 7CCM · Abingdon, VA · Accident · No injuries · Closed · Jul 6, 1968 · N83249 · Destroyed
- [NTSB MKC67A0090](https://openairdocs.org/ntsb/MKC67A0090.md): Champion 7CCM · Johnson, KS · Accident · 1 fatal · Closed · Jun 28, 1967 · N4587E · Destroyed
- [NTSB UNK64X2117](https://openairdocs.org/ntsb/UNK64X2117.md): Aeronca 7DC · Hollister, CA · Accident · Serious injuries · Closed · Jun 4, 1964 · N83050 · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101MW'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=21101MW

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