NTSB investigations: American Champion 7ECA
5 cases on aircraft the registry lists as American 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
| 2004 | 1 |
|---|---|
| 2020 | 1 |
| 2024 | 2 |
| 2025 | 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 ('2120003'))
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 ('2120003'))
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 CEN25LA086Incident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe failure of the lower hinge barrel due to fatigue cracking. Contributing to the failure of the lower hinge barrel was increased stress from end face contact likely associated with worn bushings or displaced needle bearings.NTSB CEN24LA171Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7ECA · Lakeport, TXThe student pilot’s failure to maintain adequate airspeed during the final approach, which resulted in an inadvertent aerodynamic stall. Contributing to the accident the flight instructor’s delayed remedial action.NTSB CEN24LA162Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe rudder post’s failure due to corrosion fatigue. Contributing to the accident were the misalignment of the rudder hinge components, which produced mechanical binding and elevated localized stress, and a compromised the protective coating, which allowed…NTSB CEN21LA033Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe improper installation of a clevis pin in the rudder system which led to a loss of directional control during landing.NTSB LAX04LA292Accident · No injuriesLimited investigationFinal reportAmerican Champion 7ECA · Manchester, CAmaintenance personnel's failure to adequately torque the top spark plug on the number one cylinder, which resulted in a separation of that plug and a loss of engine power.