Skip to content

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

20 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

Where

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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 MIA01LA167Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Oak Hill, FLA partial loss of engine power while at a low altitude cruise due to fuel contamination, and the subsequent emergency descent and landing to a rural road resulting in collision with tree and mailbox post.Jun 19, 2001 · N8957L · Substantial damage NTSB MIA99LA275Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Dunnellon, FLThe pilot's improper recovery from a bounced landing.Sep 28, 1999 · N9908L · Substantial damage NTSB MIA99FA208Accident · 1 fatalField investigationFinal reportGulfstream American AA-1B · Hilliard, FLthe pilot's failure to obtain notams and his improper planning and decision to use a closed runway for takeoff with tall trees on the departure end, resulting in a subsequent collision with the trees.Aug 1, 1999 · N9888L · Destroyed NTSB MIA93LA149Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Ocala, FLPremature lift off by the pilot during takeoff.Jul 4, 1993 · N8962L · Substantial damage NTSB MIA85FA241Accident · Serious injuriesField investigationFinal reportGrumman AA-1B · Daytona Beach, FLPilot did not know how to turn on the instrument panel lights nor did he have a flash light available. He continued flight into darkness of night at which time he became disoriented and lost. He continued to fly until he exhausted all fuel on the aircraft and…Aug 29, 1985 · N6502L · Substantial damage NTSB MIA83LA134Accident · No injuriesLimited investigationFinal reportGulfstream American AA1B · Moore Haven, FLAccording to the plt he collided with a large ant hill during the takeoff roll, lost directional control, & veered off the rwy into trees.May 1, 1983 · N6286L · Substantial damage NTSB MIA80FA015Accident · 2 fatalClosedAmer Avco AA1-B · Melbourne, FLNov 29, 1979 · N8971L · Destroyed NTSB MIA78DLD39Accident · No injuriesClosedGrum Amer AA-1B · Crystal River, FLApr 29, 1978 · N9865L · Substantial damage NTSB MIA78FKT39Accident · No injuriesClosedGrumman TR-2 · Opa Locka, FLMar 19, 1978 · N8885L · Substantial damage NTSB MIA77FKT86Accident · Minor injuriesClosedGrum Amer AA-1B · Coral Springs, FLOct 29, 1977 · N9979L · Substantial damage NTSB MIA77FA030Accident · 2 fatalClosedGrum Amer AA1B · St Petersburg, FLFeb 14, 1977 · N8851L · Destroyed NTSB MIA77FLA01Accident · Serious injuriesClosedGrum Amer AA1-B · Lee, FLOct 3, 1976 · N1471R · Destroyed NTSB MIA76DKT87Accident · No injuriesClosedGrum Amer AA1-B · La Belle, FLJul 6, 1976 · N1511R · Substantial damage NTSB MIA76DLA49Accident · No injuriesClosedGrum Amer AA1-B · Pensacola, FLMay 25, 1976 · N1428R · Substantial damage NTSB MIA76AM056Accident · 1 fatalClosedGrum Amer AA1-B · Ormond Beach, FLJan 9, 1976 · N8996L · Destroyed NTSB MIA76DKT53Accident · Minor injuriesClosedGrum Amer AA1-B · Pompano Beach, FLDec 26, 1975 · N9868L · Substantial damage NTSB MIA76DKT12Accident · No injuriesClosedGrum Amer AA1-B · Miramar, FLAug 8, 1975 · N9660L · Substantial damage NTSB MIA75FLD76Accident · Minor injuriesClosedGrum Amer AA1-B · Tampa, FLMay 25, 1975 · N6547L · Substantial damage NTSB MIA75DKT27Accident · Minor injuriesClosedAmer Avco AA-5 · Opa Locka, FLNov 10, 1974 · N6549L · Substantial damage NTSB MIA74DKT67Accident · No injuriesClosedAmer Avco AA-1B · Homestead, FLMar 28, 1974 · N6522L · Substantial damage