Skip to content

NTSB investigations: Champion 7ECA, TX

18 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

19672026

Where

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 DFW06CA044Accident · No injuriesData collectionFinal reportChampion 7ECA · Fredericksburg, TXThe pilot's failure to maintain directional control on the landing roll-out. A factor was the crosswind.Dec 29, 2005 · N7569F · Substantial damage NTSB FTW97LA260Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonora, TXThe pilot's failure to maintain control during landing roll. A factor was gusty wind conditions.Jul 9, 1997 · N2583F · Substantial damage NTSB FTW95FA270Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Lake Dallas, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall/spin. A factor was inadequate maintenance resulting in the partial loss of engine power due to the number one cylinder exhaust valve being stuck open.Jul 5, 1995 · N11064 · Substantial damage NTSB DEN93LA048Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Newark, TXAn inadvertent stall. A factor was: the pilot's diverted attention.Apr 25, 1993 · N2510F · Substantial damage NTSB FTW93FA108Accident · 2 fatalField investigationFinal reportChampion 7ECA · Dublin, TXThe pilot's attempted maneuver which led to his entry into an inadvertent stallMar 22, 1993 · N11052 · Destroyed NTSB FTW92LA168Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA-326 · Clifton, TXThe inadvertent stall by the pilot. Factors were the inadequate altitude and the pilot's lack of experience in type aircraft.Jun 18, 1992 · N71528 · Substantial damage NTSB FTW92LA106Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Weatherford, TXThe pilot's failure to maintain directional control during the landing rollout, and the ensuing inadvertent stall during the aborted landing due to the jammed elevator. A factor was the crosswind.Apr 4, 1992 · N9153L · Substantial damage NTSB FTW87FA152Accident · 1 fatalField investigationFinal reportChampion 7ECA · Monahans, TXWitnesses stated that upon departure the pilot pulled the aircraft up abruptly and rolled into a very steep right climbing turn. After about 20 minutes the pilot returned to the airport due to weather conditions along his porposed route of flight. Over the…Jun 27, 1987 · N2500F · Destroyed NTSB FTW79FRA39Accident · Minor injuriesClosedChampion 7ECA · Houston, TXSep 2, 1979 · N7586F · Substantial damage NTSB FTW77FA077Accident · 1 fatalClosedChampion 7ECA · Nacogdoches, TXSep 25, 1977 · N3035G · Destroyed NTSB FTW74FPA02Accident · No injuriesClosedChampion 7ECA · Plano, TXAug 4, 1973 · N7553F · Substantial damage NTSB FTW73FPA10Accident · Minor injuriesClosedChampion 7ECA · Plano, TXAug 31, 1972 · N2587G · Substantial damage NTSB FTW72DPD05Accident · No injuriesClosedChampion 7ECA · Graford, TXJul 29, 1972 · N6386N · Substantial damage NTSB FTW72DQG17Accident · No injuriesClosedChampion 7ECA · Friona, TXSep 4, 1971 · N9647S · Substantial damage NTSB FTW69F0092Accident · No injuriesClosedChampion 7ECA · Lubbock, TXAug 10, 1968 · N1817G · Substantial damage NTSB MKC68A0064Accident · 1 fatalClosedChampion 7ECA · Blanco, TXMay 5, 1968 · N5181T · Substantial damage NTSB FTW68F0570Accident · No injuriesClosedChampion 7ECA · Smithfield, TXMay 4, 1968 · N6308N · Substantial damage NTSB FTW68F0344Accident · Minor injuriesClosedChampion 7ECA · Nevada, TXOct 28, 1967 · N9685S · Substantial damage