Skip to content

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

32 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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 WPR16FA124Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 1B · Hawthorne, CAThe failure of both pilots to land the airplane on the remaining runway when a sufficient rate of climb could not be attained. Contributing to the accident was a reduction of available engine power due to severe camshaft lobe wear.Jun 11, 2016 · N4SU · Destroyed NTSB LAX02FA097Accident · 1 fatalField investigationFinal reportGrumman American AA1B · Pomona, CAa total loss of engine power due to an excessively rich mixture setting in the carburetor. The overly rich operation of the carburetor was due to the overhaul shop's failure to obtain the proper clearance between the float and chamber walls, which allowed the…Feb 27, 2002 · N1628R · Substantial damage NTSB LAX94LA298Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Corona, CAAn undetermined partial loss of engine power.Jul 27, 1994 · N8972L · Substantial damage NTSB LAX94LA088Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B-TR2 · Riverside, CAThe pilot's improper recovery from a bounced landing. A factor related to the accident was: the pilot's improper flare for landing.Dec 31, 1993 · N1413R · Destroyed NTSB LAX91LA064Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Truckee, CA1) The pilots improper flare maneuver; 2) his failure to perform a bounced landing recovery; and 3) his failure to maintain directional control of the aircraft.Jan 1, 1991 · N1641R · Substantial damage NTSB LAX91FA020Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Solana Beach, CAThe inadvertent stall/spin. Factors in the accident were: the pilot's decision to allow the reporter passenger to fly the aircraft in a critical flight situation, his decision to allow the aircraft to descend to an altitude too low to allow for contingencies,…Nov 1, 1990 · N9956L · Destroyed NTSB LAX89LA084Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Westlake, CAImproper planning and decision by the pilot which resulted in fuel exhaustion. Contributing factors were: faulty fuel indication, utility pole & uneven terrain.Jan 15, 1989 · N7174L · Destroyed NTSB LAX88LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Carlos, CADuring a post maintenance test flight prior to sign off of an annual inspection, the engine quit and the pilot performed a forced landing in a mud field colliding with a dike. Examination of the engine revealed that a fuel pressure line had disconnected from…May 15, 1988 · N9601L · Substantial damage NTSB LAX87LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Tracy, CAJust after takeoff while climbing through 200 ft AGL the engine quit. The pilot made a forced landing in a gravel pit where the aircraft collided with a bank. Examination of the engine revealed that the #1 cylinder and piston had moderate to severe scuffing…Jan 26, 1987 · N1408R · Substantial damage NTSB LAX85LA318Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Paso Robles, CAThe Paso Robles (prb) flight service station air traffic control specialist reptd that the pilot radioed that the aircraft ran out of fuel abt 5 miles so of prb. Examination of the wreckage disclsed both wing fuel tanks contained less that 1 gallon of fuel in…Jul 13, 1985 · N8964L · Destroyed NTSB LAX82FVG11Accident · Minor injuriesClosedGrum Amer AA-1B · Vacaville, CADec 22, 1981 · N1632R · 2 aircraft · Substantial damage NTSB LAX81FA087Accident · 2 fatalClosedGrum Amer AA1B · Solana Beach, CAMay 16, 1981 · N6282L · Destroyed NTSB LAX80FA123Accident · 1 fatalClosedGrum Amer AA-1B · Lake Hughes, CAJul 19, 1980 · N7173L · Destroyed NTSB LAX80FUM16Accident · No injuriesClosedGrum Amer AA1-B · San Diego, CAMar 22, 1980 · N8964L · Substantial damage NTSB OAK79DVG07Accident · No injuriesClosedGrumman AA1-B · Auburn, CADec 13, 1978 · N32RB · Substantial damage NTSB LAX78FUG47Accident · Minor injuriesClosedGrum Amer AA1-B · Corona, CAAug 20, 1978 · N9953L · Substantial damage NTSB OAK78FVD13Accident · Minor injuriesClosedGrumman AA1-B · Concord, CAJan 25, 1978 · N9952L · Substantial damage NTSB OAK78FVD01Accident · Minor injuriesClosedGrumman AA1B · Tracy, CAOct 9, 1977 · N1633R · Substantial damage NTSB OAK77DVG61Accident · No injuriesClosedGrumman AA-1B · Hamilton City, CAAug 20, 1977 · N1629R · Substantial damage NTSB OAK77DVG57Accident · No injuriesClosedGrum Amer AA1B · Elk Grove, CAAug 1, 1977 · N1436R · Substantial damage NTSB OAK77DVD29Accident · Minor injuriesClosedGrumman AA-1B · Mckinleyville, CAMar 25, 1977 · N1417R · Substantial damage NTSB OAK76AP055Accident · 2 fatalClosedAmer Avco AA1-B · Bear Valley, CAMay 20, 1976 · N5503L · Destroyed NTSB LAX76FUQ36Accident · Minor injuriesClosedAmer Avco AA1-B · Gorman, CAApr 27, 1976 · N9948L · Substantial damage NTSB OAK76DVG54Accident · No injuriesClosedAmer Avco AA1-B · Chico, CAMar 16, 1976 · N1451R · Destroyed NTSB LAX76FUM14Accident · Minor injuriesClosedAmer Avco AA1-B · Torrey Pines, CANov 6, 1975 · N9695L · Destroyed NTSB LAX76FUG17Accident · No injuriesClosedAmer Avco AA1B · San Bernardino, CAOct 14, 1975 · N1453R · Substantial damage NTSB OAK75DVD39Accident · No injuriesClosedGrum Amer AA1-B · Tracy, CAMar 16, 1975 · N9601L · Substantial damage NTSB OAK75FVG47Accident · No injuriesClosedGrum Amer AA1-B · Fair Oaks, CAMar 13, 1975 · N6544L · Substantial damage NTSB OAK75AP031Accident · 2 fatalClosedAmer Avco AA1-B · Vacaville, CADec 8, 1974 · N8999L · Destroyed NTSB OAK75DVD06Accident · No injuriesClosedAmer Avco AA1-B · Concord, CAAug 18, 1974 · N9602L · Substantial damage NTSB OAK75DVM01Accident · Serious injuriesClosedAmer Avco AA1-B · San Jose, CAJul 13, 1974 · N9639L · Substantial damage NTSB LAX74DUG35Accident · No injuriesClosedAmer Avco AA-1B · El Monte, CAJan 6, 1974 · N9977L · Substantial damage