NTSB investigations: Champion 7ECA, MN

9 cases on aircraft the registry lists as Champion 7ECA. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Champion 7ECA, MN per year, 1965–2026: 9 cases
1965	1
1966	1
1967	1
1974	1
1976	1
1997	1
1999	1
2003	1
2004	1

Where

Open the map

Latest cases

Query with 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" = 'MN' 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

duckdb -csv -c "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\" = 'MN' 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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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" = 'MN' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI04WA235Accident · 2 fatalForeign investigationChampion 7ECA · Angle Inlet, MNAug 23, 2004 · N11083 · Destroyed NTSB CHI03LA089Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Raymond, MNThe altitude/clearance not maintained by the pilot and his ostentatious display. The power lines and the pilot's maneuvering at low altitude were contributing factors.Mar 22, 2003 · N1814G · Substantial damage NTSB CHI99LA331Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Forest Lake, MNthe pilot's misjudging the proper glidepath, and his not maintaining airspeed. Factors were the pilot's lack of recent experience, the airplane's inadvertent stall, and the fence.Sep 6, 1999 · N9549S · Substantial damage NTSB CHI97LA092Accident · No injuriesLimited investigationFinal reportChampion 7ECA · South St. Paul, MNThe pilot's inadequate compensation for wind and his failure to maintain adequate obstacle clearance which resulted in collision with a snowbank. The pilot's lack of recent experience, the crosswind, and snowbank are contributing factors.Mar 27, 1997 · N11023 · Substantial damage NTSB MKC76FER85Accident · No injuriesClosedChampion 7ECA · Westbrook, MNJul 30, 1976 · N2593F · Substantial damage NTSB MKC74DER38Accident · No injuriesClosedChampion 7ECA · Austin, MNJan 30, 1974 · N11065 · Substantial damage NTSB MKC68D0310Accident · No injuriesClosedChampion 7ECA · Caribou, MNOct 15, 1967 · N11040 · Substantial damage NTSB MKC67D0023Accident · No injuriesClosedAeronca 7ECA · Hutchinson, MNMay 26, 1966 · N2527F · Substantial damage NTSB MKC66A0009Accident · 1 fatalClosedChampion 7ECA · 3n Floodwood, MNAug 14, 1965 · N2528F · Destroyed