NTSB investigations: Champion 7GCBC, CA
16 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.
Cases per year
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 3 |
| 1973 | 2 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1991 | 1 |
| 1997 | 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.\"eventStateOrRegion\" = 'CA' 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" = 'CA' 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" 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 LAX97LA267Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · San Jose, CAThe pilot's failure to maintain directional control, and excessive remedial action, which resulted in an inadvertent swerve off the runway.NTSB LAX91LA340Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Lake Elsinore, CAThe in-flight failure of the right elevator. Factors relating to this accident was the pilot's decision to perform aerobatics at an improper altitude.NTSB LAX82DA184Accident · No injuriesFinal reportCitabria 7GCBC · Willits, CAThe student pilot stated that on approach the winds were from the west. After touchdown and on the rollout the wind caught the right wing and turned the aircraft.NTSB LAX78DUG51Accident · No injuriesClosedBellanca 7GCBC · 29 Palms, CANTSB OAK78FVD10Accident · Serious injuriesClosedBellanca 7GCBC · Tracy, CANTSB OAK76FVG41Accident · Serious injuriesClosedChampion 7GCBC · Rutherford, CANTSB OAK7LFXQ03Accident · Minor injuriesClosedChampion 7GCBC · Trukee, CANTSB LAX75AUG03Accident · Minor injuriesClosedAeronca 7GCBC · Barstow, CANTSB OAK73DVM41Accident · No injuriesClosedChampion 7GCBC · Palo Alto, CANTSB LAX73FUM29Accident · 1 fatalClosedChampion 7GCBC · La Jolla, CANTSB LAX72DUG46Accident · No injuriesClosedChampion 7GCBC · La Verne, CANTSB LAX71DUG88Accident · No injuriesClosedChampion 7GCBC · Elsinore, CANTSB OAK71DVG69Accident · No injuriesClosedChampion 7KC-AB · Wheatland, CANTSB LAX70FUG38Accident · No injuriesClosedChampion 7GCBC · Apple Vally, CANTSB LAX70F0055Accident · Serious injuriesClosedChampion 7GCBC · Santa Susana, CANTSB OAK68D0319Accident · No injuriesClosedChampion 7GCBC · Hilt, CA