# NTSB investigations: Champion 7KCAB: Airframe/component/system failure/malfunction

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 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 NYC95LA226](https://openairdocs.org/ntsb/NYC95LA226.md): Champion 7KCAB · Auburn, NY · Accident · No injuries · Limited investigation · Final report · Sep 23, 1995 · N6304N · Destroyed
  > the loss of airplane control as a result of a jammed rudder for undetermined reasons.
- [NTSB NYC91LA141](https://openairdocs.org/ntsb/NYC91LA141.md): Champion 7KCAB · Ossipee, NH · Accident · Minor injuries · Limited investigation · Final report · May 25, 1991 · N6342N · Substantial damage
  > An inadequate annual inspection by the mechanic which resulted in the inflight failure of the elevator control cable.
- [NTSB ATL84LA258](https://openairdocs.org/ntsb/ATL84LA258.md): Bellanca 7KCAB · Virginia Beach, VA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1984 · N1717C · Substantial damage
  > After a banner tow pick-up, rudder jammed full right. Plt applied both feet to left rudder pedal in attempt to control direction of flt. Left rudder cable then failed in overload as banner engaged power line and broke free. Directional control requirements on…

## 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 ('21101P3')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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