# NTSB investigations: Gulfstream American AA-5B, MA

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 BFO94LA010](https://openairdocs.org/ntsb/BFO94LA010.md): Gulfstream American AA-5B · Sterling, MA · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 1993 · N28215 · Substantial damage
  > Separation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.
- [NTSB NYC85LA249](https://openairdocs.org/ntsb/NYC85LA249.md): Grumman AA-5B · Manchester, MA · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1985 · N88SJ · Substantial damage
  > Plt stated that during cruise flight at an altitude of 1200 ft the engine RPM decreaseed from cruise setting to between 900-1100 RPM. The acft was overwater and 2 miles from the coastline. He was unable to maintain altitude and he started a descent toward…
- [NTSB NYC85FNA01](https://openairdocs.org/ntsb/NYC85FNA01.md): Gulfstream AA-5B · Boxborough, MA · Accident · Serious injuries · Final report · Jun 1, 1985 · N4523B · Destroyed
  > The pilot made six attempts at landing with a left crosswind of 24 knots. On the last attempt he was observed to lose control and crash into the trees off he departure end of the runway. The aircraft burnded and the pilot received serious injuries.
- [NTSB NYC81FNA21](https://openairdocs.org/ntsb/NYC81FNA21.md): Gulf Amer AA-5B · Stow, MA · Accident · Minor injuries · Closed · Jul 8, 1981 · N45152 · Substantial damage

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

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

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