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

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 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 MKC85LA204](https://openairdocs.org/ntsb/MKC85LA204.md): Grumman AA5 · Boone, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1985 · N16LB · Substantial damage
  > After departing laporte city airport the plt of the acft proceeded to his destination airport despite deteriorating weather conditions at this destination. The plt stated he should not have proceeded into poor weather conditions. Weather conditions at the…
- [NTSB FTW85LA284](https://openairdocs.org/ntsb/FTW85LA284.md): Grumman AA5B · Sonora, TX · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N4520B · Substantial damage
  > While landing at an unfamiliar strip, the plt observed a rough surface at the apch end, and landed one halfway down the down-sloping 2300 ft rwy. He tried to go around, but could not accelerate enough, and the acft rolled thru 2 fences, trees, then stopped…
- [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.

## 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") = 1985
  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&year=1985

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