NTSB investigations: Champion 7GCBC, WY

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

NTSB investigations: Champion 7GCBC, WY per year, 1967–2026: 9 cases
1967	3
1968	2
1973	1
1974	1
1977	1
1987	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."eventStateOrRegion" = 'WY' 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 ('21101PK')) 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\" = 'WY' 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 ('21101PK'))
  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" = 'WY' 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 ('21101PK'))
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 DEN87LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Rock Rover, WYThe plt was using a pasture for takeoff. The winds were calm and the takeoff run was slightly uphill. There was a low spot in the pasture which was soft from melting snow. The acft did not reach takeoff speed before reaching the end of the pasture. During the…Apr 3, 1987 · N1653G · Destroyed NTSB DEN77FA060Accident · 2 fatalClosedBellanca 7GCBC · Tensleep, WYSep 27, 1977 · N8363V · Substantial damage NTSB DEN74DTC40Accident · Minor injuriesClosedChampion 7GCBC · Lingle, WYJun 28, 1974 · N5138X · Substantial damage NTSB DEN74DTC04Accident · No injuriesClosedChampion 7GCBC · Colony, WYJul 23, 1973 · N5130T · Substantial damage NTSB DEN69A0021Accident · 2 fatalClosedChampion 7GCBC · Osage, WYOct 22, 1968 · N5131T · Destroyed NTSB DEN68D0209Accident · No injuriesClosedChampion 7GCBC · Powell, WYFeb 6, 1968 · N8363V · Substantial damage NTSB DEN68F0101Accident · No injuriesClosedChampion 7GCBC · Buffalo, WYAug 23, 1967 · N6327N · Substantial damage NTSB DEN68D0100Accident · No injuriesClosedAeronca 7GCBC · Ten Sleep, WYAug 23, 1967 · N9698S · Substantial damage NTSB DEN67D0234Accident · No injuriesClosedChampion 7GCBC · Gillette, WYFeb 28, 1967 · N8363V · Substantial damage