# NTSB investigations: American AA-1, OH

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 NYC04LA158](https://openairdocs.org/ntsb/NYC04LA158.md): Grumman American AA-1 · Batavia, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 2004 · N5903L · Substantial damage
  > The pilot's inadequate preflight preparation which failed to assure the takeoff performance needed to out climb obstacles. Factors in this accident were the up sloping runway, the high density altitude, and airplane being loaded above it's maximum gross…
- [NTSB NYC02LA018](https://openairdocs.org/ntsb/NYC02LA018.md): American AA-1 · Batavia, OH · Accident · No injuries · Limited investigation · Final report · Oct 28, 2001 · N5664L · Substantial damage
  > Malfunction of an exhaust valve. A factor was the pilot/owner's failure to comply with the engine manufacturer's service instructions.
- [NTSB BFO95LA008](https://openairdocs.org/ntsb/BFO95LA008.md): American General AA1 · Beach City, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 29, 1994 · N6114L · Substantial damage
  > the pilot-in-command's failure to maintain adequate control of the aircraft during the takeoff. The pilot's inadequate compensation for unfavorable wind conditions is a related factor in this accident.
- [NTSB CHI80FA039](https://openairdocs.org/ntsb/CHI80FA039.md): Grumman AA-1 · Sylvania, OH · Accident · 2 fatal · Closed · May 18, 1980 · N5754L · Destroyed
- [NTSB CHI72FEG20](https://openairdocs.org/ntsb/CHI72FEG20.md): Amer Avco AA1 · Cincinnati, OH · Accident · No injuries · Closed · Oct 10, 1971 · N5728L · Substantial damage
- [NTSB CHI71DGD44](https://openairdocs.org/ntsb/CHI71DGD44.md): Amer Avco AA1 · Ravenna, OH · Accident · Minor injuries · Closed · Mar 2, 1971 · N6102L · Destroyed
- [NTSB CHI71DGD01](https://openairdocs.org/ntsb/CHI71DGD01.md): Amer Avco AA-1 · Painesville, OH · Accident · No injuries · Closed · Jul 4, 1970 · N5702L · 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" = 'OH' 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 ('0630610'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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