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

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 NYC87LA267](https://openairdocs.org/ntsb/NYC87LA267.md): Grumman AA-5A · Irwin, PA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N9772U · Substantial damage
  > During taxi operation, the pilot lost directional control of the aircraft and it struck a tree stump which was located to the side of the runway. The aircraft then continued to roll about 500 feet off the rwy where it came to rest with substantial damage.
- [NTSB LAX87LA312](https://openairdocs.org/ntsb/LAX87LA312.md): Gulfstream American AA-5A · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1987 · N26250 · Substantial damage
  > The plt reported that just after takeoff, the engine lost partial power & he was unable to land back at the airport. During an emergency landing, the aircraft collided with a utility line & pole. An exam of the engine revealed that a rocker arm on the #4…
- [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 FTW87FA130](https://openairdocs.org/ntsb/FTW87FA130.md): Grumman AA5A · Malakoff, TX · Accident · No injuries · Field investigation · Final report · May 27, 1987 · N26378 · Substantial damage
  > The acft impacted the terrain near Malakoff, Texas. Following an engine failure the pilot attempted to execute a forced landing to a road crossing a dam. The aircraft touched down and bounced into the lake. Examination of the engine revealed that the exhaust…

## 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 year(c."eventDate") = 1987
  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&year=1987

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