# NTSB investigations: Champion 7GCAA, 2000

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 LAX00LA295](https://openairdocs.org/ntsb/LAX00LA295.md): Champion 7GCAA · Newell, CA · Accident · No injuries · Limited investigation · Final report · Aug 12, 2000 · N9648S · Substantial damage
  > A hidden depression in the ground that resulted in the collapse of the landing gear during the forced landing roll.
- [NTSB NYC00FA183](https://openairdocs.org/ntsb/NYC00FA183.md): Champion 7GCAA · Lakewood, NJ · Accident · 1 fatal · Field investigation · Final report · Jul 3, 2000 · N8384V · Substantial damage
  > The pilot's failure to maintain airspeed, resulting in an inadvertent stall. Factors were the entanglement of the tow rope with the rudder horn, restricted rudder movement, the pilot's lack of total experience in the type of operation, and no stall warning…
- [NTSB CHI00LA108](https://openairdocs.org/ntsb/CHI00LA108.md): Champion 7GCAA · Arlington, SD · Accident · No injuries · Limited investigation · Final report · Mar 31, 2000 · N8371V · Substantial damage
  > the CFI's improper use of the throttle control during a simulated loss of engine power emergency. A factor associated with the accident was the rough terrain on which the forced landing was conducted.

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

This list as a web page: https://openairdocs.org/ntsb?model=21101N8&year=2000

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