# NTSB investigations: Champion 7ECA: On ground/water encounter with terrain/water

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 CHI05CA096](https://openairdocs.org/ntsb/CHI05CA096.md): Champion 7ECA · Mexico, MO · Accident · No injuries · Data collection · Final report · Apr 9, 2005 · N11177 · Substantial damage
  > The pilot inadvertently using the wrong runway for takeoff, which resulted in a tailwind condition. Factors to the accident were the tailwind, the aborted takeoff, the wet grass runway, and the road embankment.
- [NTSB ANC01LA115](https://openairdocs.org/ntsb/ANC01LA115.md): Champion 7ECA · Palmer, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 2001 · N5189X · Substantial damage
  > The pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.
- [NTSB ANC99LA144](https://openairdocs.org/ntsb/ANC99LA144.md): Champion 7ECA · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · Sep 13, 1999 · N3017G · Substantial damage
  > The pilot's selection of unsuitable terrain for landing.
- [NTSB ANC96LA036](https://openairdocs.org/ntsb/ANC96LA036.md): Bellanca 7ECA · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Mar 22, 1996 · N5169X · Substantial damage
  > the pilot's selection of an unsuitable area for landing.
- [NTSB ATL85LA098](https://openairdocs.org/ntsb/ATL85LA098.md): Bellanca 7ECA · Pontotoc, MS · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 1985 · N2512F · Substantial damage
  > The pilot ran off the end of the 1500 ft wet & soggy sod rwy during takeoff ground run. The plt stated that he did not realize that he was not going to liftoff, until the acft was too FAR down the rwy to stop on the remaining rwy surface.

## 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 ('21101NN')
    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" = 320))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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