NTSB investigations: Champion 7GCAA, TX
12 cases on aircraft the registry lists as Champion 7GCAA. 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
| 1967 | 4 |
|---|---|
| 1968 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 2014 | 1 |
| 2015 | 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\" = 'TX' 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 ('21101N8'))
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" = 'TX' 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 ('21101N8'))
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 GAA15CA188Accident · No injuriesData collectionFinal reportChampion 7GCAA · Kingsland, TXThe pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.NTSB CEN14CA512Accident · No injuriesData collectionFinal reportChampion 7GCAA · Alpine, TXThe loss of airplane control during a precautionary landing resulting in a hard landing.NTSB FTW93LA166Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Mount Vernon, TXThe pilot's inadequate compensation for the crosswind.NTSB FTW93LA038Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Joshua, TXThe pilot's failure to maintain a proper descent rate during the approach and his inadequate visual lookout.NTSB FTW85LA240Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Hillsboro, TXThe pilot had just taken off on runway 16 at the municipal airport in Hillsboro, TX. This wind, as reported by the pilotwas 220 degrees at 16 knots with gusts to 22 knots and the temperature was 102 degrees. Two persons and 16 gallons of fuel were aboard.…NTSB FTW82FRG37Accident · 2 fatalFinal reportChampion 7GCAA · Killeen, TXThe majority of the wreckage was contained within a small area except for the left wing tip which was found about 125 yds from the wreckage & some pieces of fabric from the left wing that were found about 525 yds from the wreckage. Both wings had separated…NTSB FTW81DQG41Accident · No injuriesClosedChampion 7GCAA · Canyon, TXNTSB FTW68A0088Accident · 2 fatalClosedChampion 7GCAA · Jacksboro, TXNTSB FTW68F0182Accident · No injuriesClosedChampion 7GCAA · Wildorado, TXNTSB FTW68A0008Accident · 1 fatalClosedChampion 7GCA · Ft Worth, TXNTSB FTW67D0647Accident · No injuriesClosedChampion 7GCAA · San Antonio, TXNTSB FTW67A0097Accident · 1 fatalClosedChampion 7GCAA · Martindale, TX