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

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 CEN24LA315](https://openairdocs.org/ntsb/CEN24LA315.md): Grumman American Avn. AA-5B · Camdenton, MO · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2024 · N23JK · Substantial damage
  > The inadequate maintenance of the seat locking mechanism, which resulted in the pilot’s seat sliding back during takeoff and a subsequent loss of control.
- [NTSB MKC88LA009](https://openairdocs.org/ntsb/MKC88LA009.md): Grumman American AA5B · Branson, MO · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N499GT · Substantial damage
  > During a lndg on a 3600 ft strip, the acft touched down long. The acft ran off the departure end of the rwy and collided with the terrain causing substantial damage to the acft. Witnesses said they could not find any skid marks along the path taken by the…
- [NTSB MKC81FCA23](https://openairdocs.org/ntsb/MKC81FCA23.md): Grumman AA-5B · Wentzville, MO · Accident · No injuries · Closed · Aug 4, 1981 · N28917 · Substantial damage
- [NTSB MKC79FCA16](https://openairdocs.org/ntsb/MKC79FCA16.md): Grumman AA-5B · Owensville, MO · Accident · Serious injuries · Closed · Jun 6, 1979 · N28467 · Destroyed
- [NTSB MKC75DCG48](https://openairdocs.org/ntsb/MKC75DCG48.md): Grum Amer AA-5B · Edwards, MO · Accident · No injuries · Closed · May 25, 1975 · N1169H · 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" = 'MO' 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=MO

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