# NTSB investigations: Champion 7GCAA, TX

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB GAA15CA188](https://openairdocs.org/ntsb/GAA15CA188.md): Champion 7GCAA · Kingsland, TX · Accident · No injuries · Data collection · Final report · Jul 15, 2015 · N8305V · Substantial damage
  > The pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.
- [NTSB CEN14CA512](https://openairdocs.org/ntsb/CEN14CA512.md): Champion 7GCAA · Alpine, TX · Accident · No injuries · Data collection · Final report · Sep 7, 2014 · N2535F · Substantial damage
  > The loss of airplane control during a precautionary landing resulting in a hard landing.
- [NTSB FTW93LA166](https://openairdocs.org/ntsb/FTW93LA166.md): Champion 7GCAA · Mount Vernon, TX · Accident · No injuries · Limited investigation · Final report · May 25, 1993 · N7554F · Substantial damage
  > The pilot's inadequate compensation for the crosswind.
- [NTSB FTW93LA038](https://openairdocs.org/ntsb/FTW93LA038.md): Champion 7GCAA · Joshua, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 16, 1992 · N9614S · Destroyed
  > The pilot's failure to maintain a proper descent rate during the approach and his inadequate visual lookout.
- [NTSB FTW85LA240](https://openairdocs.org/ntsb/FTW85LA240.md): Champion 7GCAA · Hillsboro, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1985 · N7595F · Destroyed
  > The 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 FTW82FRG37](https://openairdocs.org/ntsb/FTW82FRG37.md): Champion 7GCAA · Killeen, TX · Accident · 2 fatal · Final report · Aug 25, 1982 · N2541F · Destroyed
  > The 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 FTW81DQG41](https://openairdocs.org/ntsb/FTW81DQG41.md): Champion 7GCAA · Canyon, TX · Accident · No injuries · Closed · Jul 7, 1981 · N5133T · Substantial damage
- [NTSB FTW68A0088](https://openairdocs.org/ntsb/FTW68A0088.md): Champion 7GCAA · Jacksboro, TX · Accident · 2 fatal · Closed · Apr 13, 1968 · N9592S · Destroyed
- [NTSB FTW68F0182](https://openairdocs.org/ntsb/FTW68F0182.md): Champion 7GCAA · Wildorado, TX · Accident · No injuries · Closed · Jul 29, 1967 · N8305V · Substantial damage
- [NTSB FTW68A0008](https://openairdocs.org/ntsb/FTW68A0008.md): Champion 7GCA · Ft Worth, TX · Accident · 1 fatal · Closed · Jul 22, 1967 · N6301N · Destroyed
- [NTSB FTW67D0647](https://openairdocs.org/ntsb/FTW67D0647.md): Champion 7GCAA · San Antonio, TX · Accident · No injuries · Closed · Jun 18, 1967 · N8383V · Substantial damage
- [NTSB FTW67A0097](https://openairdocs.org/ntsb/FTW67A0097.md): Champion 7GCAA · Martindale, TX · Accident · 1 fatal · Closed · Apr 6, 1967 · N9622S · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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" = '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
```

This list as a web page: https://openairdocs.org/ntsb?model=21101N8&state=TX

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
