# NTSB investigations: Champion 7KCAB, LA

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 CEN17FA169](https://openairdocs.org/ntsb/CEN17FA169.md): Champion 7KCAB · Collinston, LA · Accident · 2 fatal · Field investigation · Final report · Apr 30, 2017 · N1899G · Destroyed
  > The failure of the flight instructor and the commercial pilot to maintain adequate clearance from a power line during an aerial application training flight.
- [NTSB CEN13FA420](https://openairdocs.org/ntsb/CEN13FA420.md): Champion 7KCAB · Oak Ridge, LA · Accident · 2 fatal · Field investigation · Final report · Jul 18, 2013 · N2978G · Substantial damage
  > The private pilot’s and the flight instructor’s failure to maintain airplane control while performing agricultural operations turns low to the ground, which resulted in a stall/spin. Contributing to the accident was the private pilot’s impairment due to his…
- [NTSB FTW01LA082](https://openairdocs.org/ntsb/FTW01LA082.md): Champion 7KCAB · Ragley, LA · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 2001 · N9017L · Substantial damage
  > the loose clamp (Nicopress fitting) on the elevator control cable due to inadequate quality control during the cable's manufacturing, which allowed the cable to disconnect and restricted the pilot's control of the airplane during landing.
- [NTSB FTW00LA227](https://openairdocs.org/ntsb/FTW00LA227.md): Champion 7KCAB · Rayville, LA · Accident · No injuries · Limited investigation · Final report · Jul 29, 2000 · N2978G · Substantial damage
  > The flight instructor's failure to maintain directional control. A factor was the wind gusts.
- [NTSB FTW73FRJ07](https://openairdocs.org/ntsb/FTW73FRJ07.md): Champion 7KCAB · Shreveport, LA · Accident · No injuries · Closed · Aug 5, 1972 · N7600F · 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" = 'LA' 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=LA

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