# NTSB investigations: Champion 7KCAB, OK

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 FTW85LA292](https://openairdocs.org/ntsb/FTW85LA292.md): Champion 7KCAB · Chattanooga, OK · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N1642G · Substantial damage
  > The plt lost directional control while landing in a crosswind and the acft ground looped after the left main landing gear contacted soft terrain alongside of the runway. The nearest official aviation weather reporting station was at lawton, OK, located 16…
- [NTSB FTW85LA217](https://openairdocs.org/ntsb/FTW85LA217.md): Champion 7KCAB · Chattanooga, OK · Accident · 1 fatal · Limited investigation · Final report · May 11, 1985 · N5285X · Substantial damage
  > The pilot was tow launching a glider. When about 200 feet above ground level and for unknown reasons the glider suddenly gained unwanted altitude and climbed above the tow plane. This pitched the nose of the tow plane downward before the tow line could be…
- [NTSB FTW84LA221](https://openairdocs.org/ntsb/FTW84LA221.md): Champion 7KCAB · Putnam, OK · Accident · Minor injuries · Limited investigation · Final report · May 4, 1984 · N5194X · Substantial damage
  > The acft bounced during landing and the plt attempted to abort the landing. A truck was parked near the end of the field. The acft collided with the truck which it failed to clear in an attempt to fly over it. There were no reported malfunctions of equipment.
- [NTSB FTW76AF102](https://openairdocs.org/ntsb/FTW76AF102.md): Champion 7KCAB · Goldsby, OK · Accident · 1 fatal · Closed · Jun 15, 1976 · N5198X · Destroyed
- [NTSB FTW74DPM26](https://openairdocs.org/ntsb/FTW74DPM26.md): Bellanca 7KCAB · Okemah, OK · Accident · No injuries · Closed · May 12, 1974 · N5099X · Substantial damage
- [NTSB FTW72FPJ19](https://openairdocs.org/ntsb/FTW72FPJ19.md): Champion 7KCAB · Oklahoma Cty, OK · Accident · No injuries · Closed · Oct 11, 1971 · N5099X · 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" = 'OK' 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 ('21101P3'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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