Skip to content

NTSB investigations: Grumman American Avn. AA-5, FL

15 cases on aircraft the registry lists as Grumman American Avn. AA-5. 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

19742026

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 ('3960104')) 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 ('3960104'))
  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 ('3960104'))
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 ERA22LA266Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5 · Sarasota, FLThe pilot’s inadequate preflight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a loss of engine power on approach.Jun 13, 2022 · N9577L · Substantial damage NTSB ERA20LA271Accident · 1 fatalClass 3 · LimitedFinal reportAmerican AA 5 · Dunnellon, FLA total loss of engine power due to fuel starvation as a result of improper installation and inspection of the airplane’s fuel system. Contributing to the accident was the pilot’s lack of certification and knowledge in aircraft maintenance.Aug 1, 2020 · N7192L · Substantial damage NTSB MIA00LA263Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Zephyrhills, FLthe intentional stall/mush by the pilot-in-command due to obstructions ahead resulting in a hard landing. Contributing to the accident was the partial loss of engine power due to fuel starvation caused by wear, fatigue, then overstress separation of the…Sep 16, 2000 · N7196L · Substantial damage NTSB MIA94LA193Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5 · Ormond Beach, FLThe improper maintenance work done on the carburetor by a local mechanic that resulted in loss of engine power over unsuitable terrain. A contributing factor was the dirt and moisture that contaminated the carburetor.Aug 10, 1994 · N1392R · Substantial damage NTSB MIA86IA018Incident · No injuriesIncident investigationFinal reportGrumman American AA-5 · Live Oak, FLThe acft made a downwind landing touching down long on the rwy. The acft could not be stopped & ran off the end of the rwy. The plt stated that he misread the windsock.Oct 25, 1985 · N9558L · Minor damage NTSB MIA85LA173Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · High Springs, FLThe plt stated that he made a normal takeoff with 2200 RPM, but shortly after rotation, the RPM started to decrease & the acft lost altitude & landed in the top of a large oak tree. An investigation revealed that the carburetor inlet finger screen had a 75%…May 17, 1985 · N9541L · Substantial damage NTSB MIA85FA106Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Horseshoe Beach, FLThe acft crashed in the gulf of Mexico while the plt was on a night x-country flt. The wx at the destination had been forcast to be IFR. However, in the area of the accident, witnesses stated the wx was good with no fog & it was a dark night. When the acft…Feb 28, 1985 · N9228L · Destroyed NTSB MIA80FLD68Accident · No injuriesClosedGrum-Amer AA-5 · Clearwater, FLMay 19, 1980 · N1370R · Substantial damage NTSB MIA80FA034Accident · 1 fatalClosedGrum-Amer AA-5 · Miami, FLFeb 15, 1980 · N1614R · Destroyed NTSB MIA79FA069Accident · 1 fatalClosedAmer Avco AA-5 · Marathon, FLApr 11, 1979 · N7373L · Destroyed NTSB MIA76DLD51Accident · No injuriesClosedGrum Amer AA-5 · Tampa, FLApr 12, 1976 · N9558L · Substantial damage NTSB MIA76AM071Accident · 2 fatalClosedGrum Amer AA-5 · Lake Placid, FLMar 5, 1976 · N6508L · Destroyed NTSB MIA76DLD33Accident · No injuriesClosedGrum-Amer AA5 · Orlando, FLDec 12, 1975 · N5874L · Substantial damage NTSB MIA75DLA49Accident · No injuriesClosedGrum Amer AA-5 · Pensacola, FLJun 24, 1975 · N5425L · Substantial damage NTSB MIA75DKT12Accident · No injuriesClosedAmer Avco AA5 · Homestead, FLAug 22, 1974 · N5452L · Substantial damage