Fatal NTSB investigations: Champion 7GCB

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

19642026

Fatal NTSB investigations: Champion 7GCB per year, 1964–2026: 12 cases
1964	3
1969	2
1970	1
1972	1
1979	1
1981	2
1986	1
1995	1

Where

Open the map

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 ('21101PC')) 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 ('21101PC'))
  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 ('21101PC'))
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 CHI95FA310Accident · 1 fatalField investigationFinal reportChampion 7GCB · Howard, WIa loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.Sep 3, 1995 · N9838Y · Destroyed NTSB SEA86FA217Accident · 2 fatalField investigationFinal reportAeronca 7GCB · Stanley, IDWitnesses reported the aircraft came from the direction of Stanley (8 miles to the north). Circled over the guest lodge, made one or more low (100 to 300 foot) passes. On the last pass the acft was heading away from the lodge towards highway 75. The acft…Aug 21, 1986 · N9940Y · Destroyed NTSB CHI81FA071Accident · 2 fatalClosedBellanca 7GCB · Viking, MNJul 4, 1981 · N8992R · Destroyed NTSB ANC81FA066Accident · 1 fatalClosedChampion 7GCB · Wasilla, AKJun 19, 1981 · N8989R · Substantial damage NTSB MKC79FA022Accident · 2 fatalClosedChampion 7GCB · Waverly, KSMar 16, 1979 · N9835Y · Destroyed NTSB NYC73AN062Accident · 1 fatalClosedChampion 7GCB · Honesdale, PANov 5, 1972 · N9881Y · Destroyed NTSB LAX70AL051Accident · 1 fatalClosedChampion 7GCB · San Ysidro, CAFeb 28, 1970 · N9895Y · Destroyed NTSB MKC70A0017Accident · 1 fatalClosedChampion 7GCB · Kismet, KSOct 9, 1969 · N9882Y · Destroyed NTSB FTW69F0479Accident · 1 fatalClosedChampion 7GCB · Mt.View, OKApr 2, 1969 · N9870Y · Destroyed NTSB UNK64X0804Accident · 2 fatalClosedChampion 7GCB · Farewell, AKMar 5, 1964 · N9887Y · Destroyed NTSB UNK64X0696Accident · 2 fatalClosedChampion 7GCB · Split Rock, WYFeb 26, 1964 · N9909Y · Destroyed NTSB UNK64X0448Accident · 2 fatalClosedChampion 7GCB · Lithonia, GAFeb 3, 1964 · N9972Y · Destroyed