# NTSB investigations: Grumman American Avn. AA-5A: 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 FTW99LA219](https://openairdocs.org/ntsb/FTW99LA219.md): Grumman American AA-5A · Wayton, AR · Accident · Serious injuries · Limited investigation · Final report · Aug 12, 1999 · N9775U · Substantial damage
  > The pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during a go-around. Factors were the gusty wind condition, and the high density altitude. Factors associated with the accident were gusty winds, and a…
- [NTSB DEN88FA054](https://openairdocs.org/ntsb/DEN88FA054.md): Gulfstream American AA-5A · Elbert, CO · Accident · 3 fatal · Field investigation · Final report · Jan 17, 1988 · N9937U · Destroyed
  > The acft collided with slightly rising terrain with the rt wing slightly down and the nose attitude level. Following the first contact, the acft skipped about 90 ft and the 2nd impact was in a more pronounced rt wing low and nose down attitude. The canopy was…
- [NTSB LAX85FA071](https://openairdocs.org/ntsb/LAX85FA071.md): Grumman American AA-5A · Gorman, CA · Accident · 2 fatal · Field investigation · Final report · Dec 13, 1984 · N26131 · Destroyed
  > The plt was on a night x-country flt. When the acft did not arrive at its destination, a search was initiated. On 12/12/84, the plane was found where it had impacted an area of rising terrain while approaching the tehachapi mountains. Impact occurred on a…
- [NTSB LAX83FA314](https://openairdocs.org/ntsb/LAX83FA314.md): Grumman American AA-5A · Livermore, CA · Accident · Serious injuries · Field investigation · Final report · Jul 1, 1983 · N9945U · Destroyed
  > The acft collided with rising terrain during a cross-country in IMC weather. No flt plan was filed for the flt. No weather briefing was obtained by the pilot before takeoff. The distance to be flown was 72 miles and the pilot flew this route about 3 times a…
- [NTSB ATL82DA234](https://openairdocs.org/ntsb/ATL82DA234.md): Grumman American AA-5A · Providence, KY · Accident · No injuries · Final report · Aug 12, 1982 · N9722U · Substantial damage
  > Dense ground fog developed before the plt returned to land. He made two approaches & go-arounds before the accident, & each time he had to fly very low to see the rwy lights. The plt stated that during the third approach he was looking for the arpt & not…

## 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 ('3960106')
    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=3960106&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.
