# NTSB investigations: American AA-1A: Midair collision

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 ATL93FA082](https://openairdocs.org/ntsb/ATL93FA082.md): American AA-1A · Statesboro, GA · Accident · 2 fatal · Field investigation · Final report · Apr 28, 1993 · N9317L · 2 aircraft · Substantial damage
  > Inadequate visual lookout by the pilots of both aircraft. Factors related to the accident were: failure of the pilot of N9317L to illuminate his aircraft navigation lights, and improper radio communications by the pilot of N47WD by selecting the wrong UNICOM…
- [NTSB MIA90FA067](https://openairdocs.org/ntsb/MIA90FA067.md): Piper PA-28-161 · Sebastian, FL · Accident · 1 fatal · Field investigation · Final report · Feb 3, 1990 · N473FT · 2 aircraft · Destroyed
  > Failure of the AA-1A pilot to see-and-avoid the Piper PA-28 which had entered traffic first. A factor related to the accident was: failure of the PA-28 pilot to see the American AA-1A, when the AA-1A was on a base leg and the PA-28 was further out on final…
- [NTSB LAX82FA156](https://openairdocs.org/ntsb/LAX82FA156.md): Beech A24R · Camarillo, CA · Accident · Minor injuries · Field investigation · Final report · May 1, 1982 · N24584 · 2 aircraft · Substantial damage
  > The pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0630710')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 270))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0630710&occurrence=270

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