# NTSB investigations: Grumman American Avn. AA-1B, KS

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 CHI94LA152](https://openairdocs.org/ntsb/CHI94LA152.md): Grumman American TR-2 · Wichita, KS · Accident · Minor injuries · Limited investigation · Final report · May 8, 1994 · N1639R · Substantial damage
  > was the pilot-in-command not performing an aborted landing after the first porpoise event and bounce into the air. Factors associated with this accident were an excessive airspeed and porpoising encountered by the pilot-in-command.
- [NTSB MKC83LA204](https://openairdocs.org/ntsb/MKC83LA204.md): Grumman American AA-B · Bucklin, KS · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N9620L · Substantial damage
  > The plt took off with a near full load of fuel. An adult passenger was in the right seat & a child was seated in the baggage compartment, which was not an approved seat. The density altitude at the arpt was aprx 4100 ft. the plt indicated that he rotated for…
- [NTSB MKC80DCG20](https://openairdocs.org/ntsb/MKC80DCG20.md): Grumman AA1B · Lebo, KS · Accident · No injuries · Closed · Apr 21, 1980 · N1425R · Substantial damage
- [NTSB MKC79FCG52](https://openairdocs.org/ntsb/MKC79FCG52.md): Grumman AA1B · Garnett, KS · Accident · No injuries · Closed · Jun 29, 1979 · N8861L · Destroyed
- [NTSB MKC77DCQ19](https://openairdocs.org/ntsb/MKC77DCQ19.md): Grumman AA-1B · Newton, KS · Accident · No injuries · Closed · Feb 19, 1977 · N9938L · Substantial damage
- [NTSB MKC76AK048](https://openairdocs.org/ntsb/MKC76AK048.md): Grum Amer AA1-B · Medicine Lodge, KS · Accident · 2 fatal · Closed · Mar 15, 1976 · N1462R · Destroyed
- [NTSB MKC75DCQ23](https://openairdocs.org/ntsb/MKC75DCQ23.md): Amer Avco AA1-B · Norton, KS · Accident · No injuries · Closed · Nov 14, 1974 · N9971L · 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" = 'KS' 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 ('3960103'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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