# NTSB investigations: Champion 7ECA, 1985

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 LAX86FA024](https://openairdocs.org/ntsb/LAX86FA024.md): Champion 7ECA · Seal Beach, CA · Accident · 1 fatal · Field investigation · Final report · Oct 27, 1985 · N7547F · Substantial damage
  > Based upon prearranged plans, the plt & pax flew over the water for the purpose of photographing friends of theirs in sail boats. The plt rolled his acft into a medium bank & circled over the specified boat while his pax commenced taking photos. The plt,…
- [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.
- [NTSB SEA85LA044](https://openairdocs.org/ntsb/SEA85LA044.md): Bellanca 7ECA · Deer Park, WA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1985 · N996MP · Substantial damage
  > Acft touched down in the displaced threshold which was not plowed clear of snow as the remaining portion of the rwy was. Acft nosed over following touchdwon.

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

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

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