NTSB investigations: American Champion 7GCBC
10 cases on aircraft the registry lists as American Champion 7GCBC, where the sequence of events included Loss of control on ground. 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
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2018 | 2 |
| 2020 | 3 |
| 2022 | 1 |
| 2023 | 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 ('21101PL')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('21101PL')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Sanford, METhe pilot’s loss of directional control during landing and the flight instructor’s inadequate remedial action, which resulted in a ground loop.NTSB WPR23LA355Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Woodland, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA22LA152Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Plainville, CTThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA21LA150Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Montgomery, NYThe pilot’s failure to maintain directional control during landing, resulting in a ground loop and structural damage to the airframe.NTSB CEN20CA281Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Houston, TXThe flight instructor and student pilot did not properly transfer airplane control during ground rollout, which resulted in the airplane exiting the runway and impacting a ditch.NTSB WPR20CA227Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · McCall, IDThe pilot's decision to land with excessive approach airspeed, which resulted in the airplane landing long, the application of additional braking action to stop and subsequent nose over.NTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.NTSB GAA18CA120Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Paula, CAThe pilot’s failure to maintain directional control during landing due to being distracted by another airplane and her delayed initiation of a go-around, during which the right wing struck a parked helicopter.NTSB CEN11CA450Accident · Minor injuriesData collectionFinal reportAmerican Champion 7GCBC · Sugar Land, TXThe pilot's failure to maintain directional control during landing.NTSB CEN10CA328Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Arcola, TXThe student pilot’s failure to maintain directional control of the tailwheel-equipped airplane during the landing roll.