# NTSB investigations: Champion 7ECA, CO

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 DEN05CA073](https://openairdocs.org/ntsb/DEN05CA073.md): Champion 7ECA · Fort Collins, CO · Accident · Minor injuries · Data collection · Final report · May 10, 2005 · N11065 · Destroyed
  > the pilot's inadequate preflight planning/preparation which failed to assure adequate takeoff performance to clear obstacles. Contributing factors included the miscalculated weight and balance and the high density altitude.
- [NTSB DEN83LA024](https://openairdocs.org/ntsb/DEN83LA024.md): Bellanca 7ECA · Erie, CO · Accident · No injuries · Limited investigation · Final report · Nov 22, 1982 · N9611S · Substantial damage
  > The pilot reported that he made a wheel landing on runway 33 with the wind variable from 360 deg at 15 gusting 25 knots. As the tailwheel was lowered, the aircraft veered to the right. He corrected back to the left and initiated a go-around, but the aircraft…
- [NTSB DEN81FTE66](https://openairdocs.org/ntsb/DEN81FTE66.md): Aeronca 7ECA · Akron, CO · Accident · Serious injuries · Closed · Aug 7, 1981 · N1665G · Substantial damage
- [NTSB DEN79FTE65](https://openairdocs.org/ntsb/DEN79FTE65.md): Champion 7ECA · Boulder, CO · Accident · No injuries · Closed · Jul 25, 1979 · N2518F · Substantial damage
- [NTSB DEN76DTE16](https://openairdocs.org/ntsb/DEN76DTE16.md): Champion 7ECA · Calhan, CO · Accident · Minor injuries · Closed · Aug 16, 1975 · N9506S · Substantial damage
- [NTSB DEN75FTE19](https://openairdocs.org/ntsb/DEN75FTE19.md): Champion 7ECA · Englewood, CO · Accident · Serious injuries · Closed · Aug 25, 1974 · N11032 · Substantial damage
- [NTSB DEN70F0107](https://openairdocs.org/ntsb/DEN70F0107.md): Aeronca 7ECA · Lyons, CO · Accident · No injuries · Closed · Sep 28, 1969 · N2571F · 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" = 'CO' 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 ('21101NN'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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