# NTSB investigations: American AA-5, 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 CEN23LA207](https://openairdocs.org/ntsb/CEN23LA207.md): American AA-5 · Fort Worth, TX · Accident · No injuries · Class 4 · Limited · Final report · May 23, 2023 · N1972G · Substantial damage
  > An inflight collision with a bird.
- [NTSB FTW87FA219](https://openairdocs.org/ntsb/FTW87FA219.md): Grumman American AA-5A · Corpus Christi, TX · Accident · 4 fatal · Field investigation · Final report · Sep 16, 1987 · N6035L · Destroyed
  > The aircraft exceeded maximum allowable takeoff weight and aft center of gravity limits. The aircraft had two passengers in the rear seats. The operator's manual states that no passengers are permitted in the rear seats during aerobatic maneuvers. The pilot…
- [NTSB FTW79FPA30](https://openairdocs.org/ntsb/FTW79FPA30.md): Grum-Amer AA-5 · Princeton, TX · Accident · No injuries · Closed · Sep 16, 1979 · N9503L · Substantial damage
- [NTSB FTW77FRA32](https://openairdocs.org/ntsb/FTW77FRA32.md): Grumman AA5 · League City, TX · Accident · Minor injuries · Closed · Aug 20, 1977 · N5897L · Substantial damage
- [NTSB FTW76AF015](https://openairdocs.org/ntsb/FTW76AF015.md): Grum Amer AA5 · Liberty, TX · Accident · 3 fatal · Closed · Aug 8, 1975 · N5827L · 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 ('0631410', '0630711'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0631410&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.