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

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

19762026

NTSB investigations: Grumman American Avn. AA-1B, OH per year, 1976–2026: 9 cases
1976	2
1977	1
1979	2
1982	2
1995	1
2018	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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 CEN18LA173Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Hamilton, OHThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.May 15, 2018 · N6550L · Substantial damage NTSB BFO95LA096Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Medina, OHthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. High vegetation (tall corn) in the emergency landing area was a related factor.Sep 19, 1995 · N1424R · Substantial damage NTSB CHI82DA242Accident · No injuriesFinal reportGrumman American AA-1B · Near Zanesville, OHDuring flight in his newly purchased aircraft, the pilot let his right tank run dry. He then switched to his left tank which he believed was more than 1/2 full. After flying about 15 miles further, the engine began running rough and then quit. While landing…Jul 9, 1982 · N32NA · Substantial damage NTSB CHI82DA195Accident · Minor injuriesFinal reportGrumman AA1B · Chesterland, OHThe aircraft collided with trees during low flight maneuvering. The aircraft then collided with terrain and was destroyed. The pilot and passenger received minor injuries.May 31, 1982 · N1631R · Destroyed NTSB CHI80FEK06Accident · No injuriesClosedGrumman AA1-B · Lima, OHDec 29, 1979 · N1445R · Substantial damage NTSB CHI80FEK02Accident · No injuriesClosedGrum-Amer AA1-B · Fredericktown, OHOct 5, 1979 · N1650R · Substantial damage NTSB CHI77FEI21Accident · No injuriesClosedGrum Amer AA-1B · Bowling Green, OHMay 1, 1977 · N8965L · Substantial damage NTSB CHI77FEK04Accident · Serious injuriesClosedGrum Amer AA1-B · Columbus, OHOct 29, 1976 · N8857L · Substantial damage NTSB CHI76AC076Accident · 1 fatalClosedAmer Avco AA1-B · Creston, OHJul 1, 1976 · N9934L · Destroyed