# NTSB investigations: Grumman American Avn. AA-5B, NE

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 MKC84LA078](https://openairdocs.org/ntsb/MKC84LA078.md): Gulfstream American AA5B · Papillion, NE · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N28673 · Substantial damage
  > The plt overran during an attempted takeoff on the water covered rwy. The acft failed to attain the proper airspeed for lift off. During the overrun the nose gear sheared off. The plt said the standing water on the turf rwy prevented proper acceleration.
- [NTSB MKC78FA060](https://openairdocs.org/ntsb/MKC78FA060.md): Amer Avco AA-5B · North Bend, NE · Accident · 4 fatal · Closed · Aug 8, 1978 · N81224 · Destroyed

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

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

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