NTSB investigations: American Champion 8GCBC
6 cases on aircraft the registry lists as American Champion 8GCBC, where the defining event was Nose over/nose down. 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
| 2011 | 1 |
|---|---|
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2025 | 1 |
| 2026 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2121004', '2121005')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '096'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2121004', '2121005')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '096'))
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 WPR26LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Carefree, AZThe pilot reported that he landed the tailwheel equipped airplane at a backcountry airstrip, and while taxiing on rough terrain, the tailwheel spring failed and the tailwheel assembly separated from the airplane. The pilot shut down the airplane and exited to…NTSB ANC25LA102Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Unalakleet, AKThe pilots encounter with an obstructed dip in the landing surface during the landing roll out on a remote airstrip, which resulted in a noseover.NTSB WPR22LA074Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Jordan Valley, ORThe pilot’s decision to takeoff on remote snow covered terrain which, resulted in a nose-over.NTSB WPR21LA196Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Wallowa, ORThe pilots failure to maintain airplane control during the landing roll after experiencing a tailwind gust which required excessive braking and resulted in the airplane nosing over.NTSB GAA20CA011Accident · No injuriesData collectionFinal reportChampion 8GCBC · Henrys Lake, IDThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over.NTSB WPR12CA041Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Ashton, IDThe student pilot’s poor decision-making when he decided to land on a snowy grass airstrip, which resulted in an encounter with deep snow during the landing roll and a subsequent nose-over.