NTSB investigations: Grumman American Avn. AA-5

7 cases on aircraft the registry lists as Grumman American Avn. AA-5, where the first occurrence was “In flight collision with object”. 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

19852026

NTSB investigations: Grumman American Avn. AA-5 per year, 1985–2026: 7 cases
1985	1
1987	1
1993	1
1998	1
1999	1
2004	1
2007	1

Where

Open the map

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."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" = 220)) 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.\"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\" = 220))
  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."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" = 220))
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 CHI07CA311Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 Traveler · Warrenton, MOThe low airspeed gust factor by the pilot, the altitude/clearance not maintained by the pilot, and the inadequate compensation for wind conditions by the pilot during the landing approach. Contributing factors were the trees and wind gusts.Sep 29, 2007 · N9583L · Substantial damage NTSB NYC04CA129Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 · Greene, RIThe pilots improper decision to depart with the flaps set to 10 degrees, and his failure to obtain proper airspeed, which resulted in a collision with trees.May 23, 2004 · N7132L · Substantial damage NTSB DEN99FA148Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Newcastle, WYThe pilot's inadequate visual lookout and inadequate altitude/clearance from the transmission wires.Aug 17, 1999 · N1370R · Destroyed NTSB FTW98LA123Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Conroe, TXThe pilot's delay in aborting the landing due to excessive airspeed during the approach.Feb 7, 1998 · N7117L · Substantial damage NTSB LAX93LA216Accident · No injuriesLimited investigationFinal reportGrumman American AA5 · Visalia, CAThe pilot's failure to see and avoid the wires due to alcohol impairment. A factor which contributed to the accident was unwarranted low flying over the river.May 16, 1993 · N9520L · Destroyed NTSB ATL88LA041Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Thomson, GAThe airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…Nov 22, 1987 · N7109L · Substantial damage NTSB NYC85LA214Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Montgomery, NYThe plt reported that the flt was uneventful until he was in a descent about 12 mi from the destination arpt. He said that a large bird suddenly appeared in front of the acft & collided with the right wing. The bird strike put a large hole in the right wing…Aug 16, 1985 · N5405L · Substantial damage