OpenAirDocs.org

NTSB investigations: Grumman American Avn. AA-5

8 cases on aircraft the registry lists as Grumman American Avn. AA-5, where the first occurrence was “Loss of control - in flight”. 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.

Cases per year

19842026

Where

Open the map

Latest cases

Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960104')
      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\" = 250))
  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.

NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.Mar 13, 2005 · N6511L · DestroyedNTSB NYC00FA225Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Cherry Valley, NYThe pilot's improper decision to continue the flight into deteriorating weather, which resulted in his failure to maintain control of the airplane. Factors in the accident were the dark night, fog, low ceiling, and the pilot's inadequate preflight planning.Aug 12, 2000 · N9570L · DestroyedNTSB IAD96LA139Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Annapolis, MDfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall and subsequent collision with water.Aug 23, 1996 · N9525L · Substantial damageNTSB DEN93LA067Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Watkins, COSpatial disorientation which prevented the pilot from maintaining control. A factor was: low ceiling.Jun 6, 1993 · N7129L · Substantial damageNTSB BFO91LA070Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Oakland, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jul 20, 1991 · N9599L · DestroyedNTSB DEN88FA119Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Maljamar, NMWhile in slow flt at low level on a oil pipeline patrol demonstration flt, the acft entered a left turn and, according to witnesses, the nose suddenly dropped and the acft crashed in a vertical attitude. The acft was destroyed in the accident and both…Jun 2, 1988 · N1393R · DestroyedNTSB 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 · DestroyedNTSB CHI84FA308Accident · 4 fatalField investigationFinal reportGrumman AA-5 · Little Falls, MNThe acft collided with the ground during a takeoff attempt. The low time plt was using a grass rwy for the 1st time without an instructor. The acft was rotated prematurely and assumed a nose high attitude. According to one witness the acft was 'behind the…Jul 24, 1984 · N1338R · Destroyed