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

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 CHI84LA200](https://openairdocs.org/ntsb/CHI84LA200.md): Grumman AA-1B · Millstadt, IL · Accident · Minor injuries · Limited investigation · Final report · May 20, 1984 · N8973L · Substantial damage
  > The acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy.
- [NTSB CHI78FEE40](https://openairdocs.org/ntsb/CHI78FEE40.md): Grum Amer AA1-B · Antioch, IL · Accident · 1 fatal · Closed · May 29, 1978 · N1505R · Destroyed
- [NTSB CHI77FEE35](https://openairdocs.org/ntsb/CHI77FEE35.md): Grumman AA1B · Crestwood, IL · Accident · Serious injuries · Closed · Jul 19, 1977 · N9885L · Substantial damage
- [NTSB CHI77FEV29](https://openairdocs.org/ntsb/CHI77FEV29.md): Grum Amer AA-1B · Danville, IL · Accident · No injuries · Closed · Jun 26, 1977 · N1448R · Substantial damage
- [NTSB CHI75DEE60](https://openairdocs.org/ntsb/CHI75DEE60.md): Grum Amer AA1-B · Rockford, IL · Accident · No injuries · Closed · May 3, 1975 · N9885L · Substantial damage
- [NTSB CHI74DEE60](https://openairdocs.org/ntsb/CHI74DEE60.md): Amer Avco AA1-B · Sugar Grove, IL · Accident · No injuries · Closed · Mar 10, 1974 · N6543L · 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" = 'IL' 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=IL

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