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

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 CEN09LA132](https://openairdocs.org/ntsb/CEN09LA132.md): Grumman American Avn. AA-5B · Milford, IN · Accident · No injuries · Limited investigation · Final report · Jan 5, 2009 · N28862 · Substantial damage
  > A loss of engine thrust due to the separation of a section of one of the propeller blades as a result of fatigue failure of the propeller because of corrosion. Contributing to the accident was the failure of the mechanic to detect and address the propeller…
- [NTSB CHI98LA311](https://openairdocs.org/ntsb/CHI98LA311.md): Grumman American AA-5B · Decatur, IN · Accident · No injuries · Limited investigation · Final report · Aug 13, 1998 · N74827 · Substantial damage
  > the pilot's failure to maintain adequate airspeed during the takeoff and his premature raising of the flaps which resulted in the stall/mush condition.
- [NTSB CHI88LA013](https://openairdocs.org/ntsb/CHI88LA013.md): Grumman AA-5B · Leavenworth, IN · Accident · No injuries · Limited investigation · Final report · Nov 2, 1987 · N28483 · Substantial damage
  > According to the pilot, the aircraft was taking off from a 'bumpy' grass private strip. The pilot stated he discussed aborted takeoff procedures with the pilot rated passenger who was sitting in the right seat and stated if the aircraft did not reach takeoff…
- [NTSB CHI78FET29](https://openairdocs.org/ntsb/CHI78FET29.md): Grum Amer AA-5B · Kentland, IN · Accident · No injuries · Closed · Jul 27, 1978 · N74613 · Substantial damage
- [NTSB CHI78FEX25](https://openairdocs.org/ntsb/CHI78FEX25.md): Grumman AA5B · Bedford, IN · Accident · Serious injuries · Closed · Jul 15, 1978 · N28463 · 2 aircraft · Minor 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" = 'IN' 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=IN

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