# NTSB investigations: Grumman American Avn. AA-5A, OK

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 FTW87LA153](https://openairdocs.org/ntsb/FTW87LA153.md): Grumman American AA-5A · Marietta, OK · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N9874U · Substantial damage
  > The plt rprtd that drg takeoff fm a grass rwy, the acft stalled after climbing about 10 ft AGL. He said that torque pulled the nose of the acft to the left & he tried to recover. However, there was insufficient alt & the acft hit the tops of trees, then fell…
- [NTSB FTW83LA378](https://openairdocs.org/ntsb/FTW83LA378.md): Grumman AA-5A · Grove, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1983 · N26468 · Substantial damage
  > The acft was high & fast on final apch & touched down about 1/3 of the way down the rwy. The nosewheel touched down 1st & the acft began to porpoise. The plt applied power to stop the porpoise, then elected to go around. In order to avoid trees near the end…
- [NTSB FTW82DA386](https://openairdocs.org/ntsb/FTW82DA386.md): Grumman AA-5A · Tulsa, OK · Accident · No injuries · Final report · Sep 22, 1982 · N26171 · Substantial damage
  > The student pilot stated that he made several touch-and-go landings without incident, when the engine started "cutting out" on final approach. He reported that carburetor heat was not applied until after the power loss began. He was unable to restore power…

## 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" = 'OK' 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 ('3960106'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3960106&state=OK

---
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.