NTSB investigations: Champion 7ECA, WA
13 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.
Cases per year
| 1967 | 3 |
|---|---|
| 1971 | 1 |
| 1974 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2015 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'WA' 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" = 'WA' 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" DESCRun 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 GAA15CA065Accident · No injuriesData collectionFinal reportChampion 7ECA · Quincy, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB SEA07LA093Accident · No injuriesLimited investigationFinal reportChampion 7ECA · East Wenatchee, WASeparation of the left main landing gear shock absorbing strut during takeoff. A missing screw was a factor.NTSB SEA02LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kittitas, WAThe pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.NTSB SEA91LA070Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Everett, WAThe pilot did not maintain control of the airplane during the landing roll. Factors tot he accient were the pilot inadequately planned the approach, and uncontrolled ground-loop, and the pilot's lack of total experience in this type of aircraft.NTSB SEA88LA053Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Othello, WAThe student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft.NTSB SEA85LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Deer Park, WAAcft 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.NTSB SEA84LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pullman, WAAccording to the student plt, the winds were prevailing from the southeast at 5 to 10 KTS, but were shifting & gusting to 20 KTS. During a landing on rwy 5, the acft veered off the right side side of the rwy, then struck a ditch & nosed over.NTSB SEA83LA199Accident · No injuriesLimited investigationFinal reportBellanca Gcbc · Spokane, WAAccording to the operator, the plt was practicing touch & go landings. During a landing, the acft ground looped & the left horizontal stabilizer struck a VASI light. The plt reported that he had 4.2 hrs in this make & model.NTSB SEA75AS013Accident · 1 fatalClosedChampion 7ECA · Seattle, WANTSB SEA71FYE38Accident · No injuriesClosedChampion 7ECA · Auburn, WANTSB SEA68F0067Accident · No injuriesClosedAeronca 7EC · Albion, WANTSB SEA67F0305Accident · No injuriesClosedChampion 7ECA · Mose Lake, WANTSB SEA67F0259Accident · No injuriesClosedChampion 7ECA · Yakima, WA