NTSB investigations: Champion 7EC
12 cases on aircraft the registry lists as Champion 7EC, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1996 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101NM')
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\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101NM')
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" = 260))
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 MIA06LA068Accident · No injuriesLimited investigationFinal reportChampion 7EC · Zellwood, FLA loss of directional control due to the spring connecting the rudder to the tailwheel horn being detached.NTSB IAD05LA011Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Clarksburg, WVThe pilot's inability to operate the airplane's brake pedals which resulted in the loss of aircraft control.NTSB NYC03LA126Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Louisville, KYThe pilots inadequate compensation for the crosswind conditions, and his failure to maintain directional control. A factor related to the accident was the crosswind.NTSB SEA01LA114Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mattawa, WAThe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors were the gusty crosswind condition and the high vegetation (sage brush) which the aircraft rolled into before nosing over.NTSB NYC96LA151Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Rochester, NHthe pilot's inadequate compensation for winds and his failure to maintain directional control, which resulted in a ground loop and dragging of the wing on the runway.NTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.NTSB LAX93LA142Accident · No injuriesLimited investigationFinal reportChampion 7EC · Riverside, CAThe cfi's inadequate supervision of the flight, the dual student's failure to maintain directional control and improper use of the normal brakes. Contributing to this accident was the dual student's improper use of the rudder.NTSB FTW91LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Clinton, ARThe loss of directional control due to locked wheel brake on the left landing gear.NTSB CHI90LA133Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hamilton, OHFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.NTSB DEN89LA125Accident · No injuriesLimited investigationFinal reportChampion 7EC · St George, UTInadequate compensation for the wind conditions by the pilot. The gusty crosswind, soft terrain, and ditch were contributing factors.NTSB ANC88LA080Accident · No injuriesLimited investigationFinal reportChampion 7EC · Anchorage, AKThe private pilot lost directional control of the airplane during the landing roll. The aircraft groundlooped to the left, striking a fence. The pilot reported that he came in high and hurried his approach to fit in with the flow of air traffic at the…NTSB ANC84FA044Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe acft swerved and collided with a snowbank during landing. The wind was calm and the rwy dry. After the collision the right landing gear collapsed.