Skip to content

NTSB investigations: American AA-1, FL

18 cases on aircraft the registry lists as American AA-1. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Where

Latest cases

Query with 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" = 'FL' 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

duckdb -csv -c "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\" = 'FL' 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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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" = 'FL' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB GAA18CA343Accident · Serious injuriesData collectionFinal reportAmerican AA · Port Orange, FLThe pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.May 24, 2018 · N5787L · Substantial damage NTSB MIA07CA012Accident · No injuriesData collectionFinal reportAmerican AA-1 · Lakeland, FLThe pilot's misjudgment of the landing flare/touchdown which resulted in a hard landing.Nov 5, 2006 · N5657L · Substantial damage NTSB MIA04CA001Accident · Minor injuriesData collectionFinal reportAmerican General AA-1 · Bartow, FLA loss of engine power due to oil starvation. Also causal was the pilot's improper maintenance.Oct 8, 2003 · N5668L · Substantial damage NTSB ATL98LA027Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Monticello, FLthe pilot's inadequate preflight planning/preparation, and failure to ensure that the airplane would be able to clear trees during takeoff. Related factors were: the high/wet vegetation on the grass runway, and the proximity of trees to the runway.Dec 19, 1997 · N5789L · Destroyed NTSB MIA95LA219Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sarasota, FLThe pilot's failure to abort the takeoff resulting in a premature takeoff, and subsequent in-flight collision with terrain. The pilot's failure to perform the necessary performance data computations for the flight and his diverted attention due to…Sep 10, 1995 · N112FA · Substantial damage NTSB MIA93LA026Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Groveland, FLThe pilot's encounter with shifting winds on the takeoff roll, that caused the airplane to overrun the runway. Contributing to the accident was the failure of the pilot in command to perform an aborted takeoff.Dec 5, 1992 · N5915L · Substantial damage NTSB MIA92LA078Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Leesburg, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an in flight loss of control (stall) and in flight collision with terrain. Contributing to the accident was the pilot-in-command's inadequate…Feb 9, 1992 · N6222L · Substantial damage NTSB MIA76DLA42Accident · No injuriesClosedAmer Avco AA1 · Pensacola, FLApr 18, 1976 · N5669L · Substantial damage NTSB MIA76DLD08Accident · No injuriesClosedAmer Avco AA1 · Windemere, FLJul 27, 1975 · N5640L · Substantial damage NTSB MIA76DKT01Accident · Minor injuriesClosedAmer Avco AA1 · Ft Lauderdale, FLJul 9, 1975 · N5662L · Destroyed NTSB MIA74FLA01Accident · Minor injuriesClosedAmer Avco AA1 · Florahome, FLJul 8, 1973 · N6193L · Destroyed NTSB MIA72DLD56Accident · No injuriesClosedAmer Avco AA-1 · Knights, FLMar 18, 1972 · N6133L · Substantial damage NTSB MIA72FKT59Accident · Minor injuriesClosedAmer Avco AA1 · La Belle, FLFeb 27, 1972 · N5714L · Substantial damage NTSB MIA72DKT05Accident · Minor injuriesClosedAmer Avco AA1 · Tavernier, FLAug 13, 1971 · N5713L · Substantial damage NTSB MIA71FKT59Accident · No injuriesClosedAmer Avco AA-1 · Ft Myers, FLMay 2, 1971 · N6155L · Substantial damage NTSB MIA71FKT24Accident · No injuriesClosedAmer Avco AA-1A · Belle Glade, FLDec 5, 1970 · N5633L · Destroyed NTSB MIA70DLD37Accident · No injuriesClosedAmer Avco AA-1 · Sanford, FLJun 29, 1970 · N6155L · Substantial damage NTSB MIA69F0280Accident · No injuriesClosedAmer Avco AA-1 · Dania, FLNov 24, 1968 · N221Y · Substantial damage