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

7 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

19742026

NTSB investigations: Grumman American Avn. AA-1B, IN per year, 1974–2026: 7 cases
1974	1
1975	2
1978	2
1983	1
2013	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."eventStateOrRegion" = 'IN' 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 ('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 c.\"eventStateOrRegion\" = 'IN' 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 ('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 c."eventStateOrRegion" = 'IN' 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 ('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 CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.Aug 25, 2013 · N5538B · Substantial damage NTSB CHI83LA355Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Alexandria, INThe acft nosed over while landing after the acft stalled and dragged the right wing. The pilot stated he made a normal approach, heard the stall warning as he leveled off and lost control as the right wing struck the ground. When the nose gear came down it…Aug 3, 1983 · N8952L · Substantial damage NTSB CHI78FET14Accident · No injuriesClosedGrum Amer AA-1B · Fort Wayne, INFeb 18, 1978 · N8973L · Substantial damage NTSB CHI78FET11Accident · No injuriesClosedGrum Amer AA1-B · Fort Wayne, INFeb 5, 1978 · N9892L · Substantial damage NTSB CHI76AC031Accident · Serious injuriesClosedGrum Amer AA1-B · Roachdale, INOct 9, 1975 · N9924L · Destroyed NTSB CHI76FEA08Accident · Minor injuriesClosedGrum Amer AA1B · Eden, INSep 27, 1975 · N8893L · Substantial damage NTSB CHI74DEA36Accident · No injuriesClosedAmer Avco AA-1B · English, INMay 2, 1974 · N8880L · Substantial damage