# Fatal NTSB investigations: American AA-5

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 MIA02FA131](https://openairdocs.org/ntsb/MIA02FA131.md): American General AA-5 · Boca Raton, FL · Accident · 2 fatal · Field investigation · Final report · Jul 12, 2002 · N6024L · Minor damage
  > The owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.
- [NTSB FTW87FA219](https://openairdocs.org/ntsb/FTW87FA219.md): Grumman American AA-5A · Corpus Christi, TX · Accident · 4 fatal · Field investigation · Final report · Sep 16, 1987 · N6035L · Destroyed
  > The aircraft exceeded maximum allowable takeoff weight and aft center of gravity limits. The aircraft had two passengers in the rear seats. The operator's manual states that no passengers are permitted in the rear seats during aerobatic maneuvers. The pilot…
- [NTSB MKC81FA020](https://openairdocs.org/ntsb/MKC81FA020.md): Grum-Amer AA-5 · Thayer, MO · Accident · 2 fatal · Closed · Feb 18, 1981 · N6092L · Destroyed
- [NTSB DEN79FA002](https://openairdocs.org/ntsb/DEN79FA002.md): Grum Amer AA5 · Littleton, CO · Accident · 2 fatal · Closed · Oct 4, 1978 · N6071L · Destroyed
- [NTSB FTW76AF015](https://openairdocs.org/ntsb/FTW76AF015.md): Grum Amer AA5 · Liberty, TX · Accident · 3 fatal · Closed · Aug 8, 1975 · N5827L · Destroyed
- [NTSB SEA75AS031](https://openairdocs.org/ntsb/SEA75AS031.md): Amer Avco AA5 · Newberg, OR · Accident · 2 fatal · Closed · Feb 15, 1975 · N6063L · Destroyed
- [NTSB NYC75AN030](https://openairdocs.org/ntsb/NYC75AN030.md): Amer Avco AA-5 · Roxbury, CT · Accident · 3 fatal · Closed · Sep 1, 1974 · N7114L · Destroyed
- [NTSB OAK74AP069](https://openairdocs.org/ntsb/OAK74AP069.md): Amer Avco AA5 · Missing Aircraft · Accident · 2 fatal · Closed · Jun 21, 1974 · N5885L · Destroyed
- [NTSB NYC74AN097](https://openairdocs.org/ntsb/NYC74AN097.md): Piper PA-28R · Tewksbury, MA · Accident · 3 fatal · Closed · May 20, 1974 · N4MB · 2 aircraft · Destroyed
- [NTSB LAX74AL070](https://openairdocs.org/ntsb/LAX74AL070.md): Amer Avco AA5 · Rimrock, AZ · Accident · 2 fatal · Closed · Apr 12, 1974 · N5841L · Destroyed
- [NTSB SEA74AS002](https://openairdocs.org/ntsb/SEA74AS002-188463.md): Amer Avco AA5 · Shelley, ID · Accident · 4 fatal · Closed · Oct 27, 1973 · N9267L · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0631410', '0630711'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=0631410

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