Skip to content

Fatal NTSB investigations: Champion 7GCAA

30 cases on aircraft the registry lists as Champion 7GCAA. 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

19662026

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101N8')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101N8'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101N8'))
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 CEN18FA242Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Arthur, NEThe pilot's failure to recover from a spin for reasons that could not be determined based on the available information.Jun 29, 2018 · N9026L · Substantial damage NTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.Aug 13, 2013 · N9607S · Destroyed NTSB NYC00FA183Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to maintain airspeed, resulting in an inadvertent stall. Factors were the entanglement of the tow rope with the rudder horn, restricted rudder movement, the pilot's lack of total experience in the type of operation, and no stall warning…Jul 3, 2000 · N8384V · Substantial damage NTSB CHI92LA175Accident · 1 fatalLimited investigationFinal reportChampion 7GCAA · Brainerd, MNAn excessive pull up and failure to maintain an airspeed above stalling speed by the pilot in command.Jun 13, 1992 · N2519F · Destroyed NTSB CHI90FA239Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Clark Lake, MIPoor judgement of the pilot due to consumption of alcohol, and his failure to maintain proper altitude and clearance above water, while performing aerobatic maneuvers.Aug 25, 1990 · N2521F · Destroyed NTSB SEA86FA004Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Oakley, IDLow time private pilot had borrowed aircraft for personal trip to nearby airport. On arrival, pilot made fly by of friend's ranch to signal for pick up at airport. Friend got into auto and headed for airport,stated he was driving 60 mph and saw aircraft in…Oct 6, 1985 · N9623S · Destroyed NTSB ATL85FA143Accident · 2 fatalField investigationFinal reportChampion 7GCA · Collinsville, MSWitnesses, friends of the plt, reported seeing the acft engaged in aerobatics at altitudes between 500 ft AGL and 2000 ft AGL, aprx 1/4 mile from their outdoor social function. They continued to report, the acft entered a spin and after aprx 2 3/4 revolutions…Apr 20, 1985 · N9636S · Destroyed NTSB DEN85FA088Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Cornville, AZThe acft was on a local flt with the owner/private plt & a student plt on board. While in aerobatic flt over a narrow canyon/gully area, the acft collided with & severed 3 power lines & a static line, located aprx 100 ft above the ground. The acft then…Feb 28, 1985 · N6328N · Destroyed NTSB FTW82FRG37Accident · 2 fatalFinal reportChampion 7GCAA · Killeen, TXThe majority of the wreckage was contained within a small area except for the left wing tip which was found about 125 yds from the wreckage & some pieces of fabric from the left wing that were found about 525 yds from the wreckage. Both wings had separated…Aug 25, 1982 · N2541F · Destroyed NTSB NYC82FA007Accident · 1 fatalClosedChampion 7GCAA · Scituate, MANov 8, 1981 · N1829G · Destroyed NTSB SEA82FA001Accident · 1 fatalClosedChampion 7GCAA · Goldendale, WAOct 17, 1981 · N9606S · Destroyed NTSB FTW80FRD24Accident · 2 fatalClosedChampion 7GCAA · Maurice, LAApr 20, 1980 · N2894G · Destroyed NTSB NYC77FHJ33Accident · 1 fatalClosedChampion 7GCAA · Shirley, NYAug 4, 1977 · N6336N · Substantial damage NTSB CHI77FEG13Accident · 1 fatalClosedChampion 7GCAA · Jamestown, OHMar 25, 1977 · N919RN · Destroyed NTSB MKC74AK047Accident · 1 fatalClosedChampion 7GCAA · Warroad, MNFeb 9, 1974 · N2577F · Destroyed NTSB MKC74AK037Accident · 1 fatalClosedChampion 7GCAA · Andover, IAJan 15, 1974 · N9609S · Destroyed NTSB CHI74AC047Accident · 1 fatalClosedChampion 7GCAA · South Haven, MIDec 8, 1973 · N1122 · Destroyed NTSB MIA73AM107Accident · 1 fatalClosedChampion 7GCAA · Walls, MSJun 10, 1973 · N2758G · Destroyed NTSB DEN73AD054Accident · 1 fatalClosedChampion 7GCAA · Blanding, UTJun 10, 1973 · N3039G · Destroyed NTSB NYC73AN025Accident · 1 fatalClosedChampion 7GCAA · Sherrills Ford, NCAug 12, 1972 · N6398N · Destroyed NTSB CHI70A0010Accident · 2 fatalClosedChampion 7GCAA · Salem, INJul 26, 1969 · N9625S · Destroyed NTSB DEN69A0049Accident · 1 fatalClosedChampion 7GCAA · Jackson, WYMay 22, 1969 · N8381V · Destroyed NTSB LAX69A0008Accident · 2 fatalClosedChampion 7GCAA · Compton, CAJul 25, 1968 · N9603S · Destroyed NTSB OAK69A0002Accident · 1 fatalClosedChampion 7GCAA · Orovada, NVJul 5, 1968 · N5138T · Destroyed NTSB FTW68A0088Accident · 2 fatalClosedChampion 7GCAA · Jacksboro, TXApr 13, 1968 · N9592S · Destroyed NTSB LAX68A0060Accident · 2 fatalClosedChampion 7GCAA · Lucerne Vly, CADec 10, 1967 · N9683S · Destroyed NTSB FTW68A0008Accident · 1 fatalClosedChampion 7GCA · Ft Worth, TXJul 22, 1967 · N6301N · Destroyed NTSB LAX68A0002Accident · 2 fatalClosedChampion 7GCAA · Amboy, CAJul 4, 1967 · N8340V · Destroyed NTSB FTW67A0097Accident · 1 fatalClosedChampion 7GCAA · Martindale, TXApr 6, 1967 · N9622S · Destroyed NTSB CHI67A0048Accident · 1 fatalClosedChampion 7GCAA · Olney, ILOct 8, 1966 · N8347V · Destroyed