NTSB investigations: Grumman American Avn. AA-1B, 1981

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

19732026

NTSB investigations: Grumman American Avn. AA-1B, 1981 per year, 1973–2026: 263 cases
1973	9
1974	34
1975	32
1976	31
1977	25
1978	15
1979	13
1980	10
1981	9
1982	7
1983	5
1984	3
1985	3
1986	1
1987	3
1988	4
1989	1
1990	6
1991	3
1992	1
1993	3
1994	4
1995	2
1996	5
1997	2
1998	3
1999	2
2000	1
2001	3
2002	2
2004	1
2005	3
2006	1
2009	4
2012	3
2013	1
2014	1
2015	1
2016	2
2017	2
2018	1
2022	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 year(c."eventDate") = 1981 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960103')) 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 year(c.\"eventDate\") = 1981
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960103'))
  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 year(c."eventDate") = 1981
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960103'))
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 LAX82FVG11Accident · Minor injuriesClosedGrum Amer AA-1B · Vacaville, CADec 22, 1981 · N1632R · 2 aircraft · Substantial damage NTSB FTW81DQD35Accident · Minor injuriesClosedGrum Amer AA-1B · Weed, NMSep 26, 1981 · N9978L · Destroyed NTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PASep 21, 1981 · N8969L · Substantial damage NTSB NYC81FA082Accident · 2 fatalClosedGulf Amer AA-1B · Richmond, NHSep 7, 1981 · N1446R · Destroyed NTSB NYC81FNA27Accident · Serious injuriesClosedGrum Amer AA-1B · Tewksbury, MASep 6, 1981 · N6283L · Substantial damage NTSB FTW81FPD33Accident · No injuriesClosedGrumman AA-1B · Lake Dallas, TXAug 4, 1981 · N1624R · Substantial damage NTSB LAX81FA087Accident · 2 fatalClosedGrum Amer AA1B · Solana Beach, CAMay 16, 1981 · N6282L · Destroyed NTSB NYC81FFJ08Accident · No injuriesClosedAmer Avco AA-1B · Albion, NYApr 23, 1981 · N1512R · Substantial damage NTSB FTW81DRD19Accident · No injuriesClosedGrum Amer AA-1B · Grand Isle, LAApr 23, 1981 · N8985L · Substantial damage