# NTSB investigations: Gulfstream American AA-5B: In flight encounter with weather

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 NYC91FA174](https://openairdocs.org/ntsb/NYC91FA174.md): Gulfstream American AA5B · Columbia, CT · Accident · 3 fatal · Field investigation · Final report · Jul 8, 1991 · N43ER · Destroyed
  > The decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…
- [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 NYC82FA148](https://openairdocs.org/ntsb/NYC82FA148.md): Gulfstream American AA-5B · Newburg, PA · Accident · 1 fatal · Field investigation · Final report · Jul 11, 1982 · N28970 · Destroyed
  > The pilot on a personal cross-country flew into trees on a slope of blue mountain, PA at the 2284 foot level. The weather in the area was foggy and the mountain tops were obscured in clouds. There is no record of a weather briefing or communication by the…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3970106')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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