NTSB investigations: Grumman American Avn. AA-1B
263 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.
Cases, newest first
Query with SQL
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.\"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."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" DESCRun 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 SEA91LA097Accident · 1 fatalLimited investigationFinal reportGrumman AA-1B · Douglas, WYAn inadvertent stall with inadequate terrain clearance. Factors include flight in mountainous terrain at an altitude where remedial action was not possible.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.NTSB DEN91LA025Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Roswell, NMLow cylinder compression and fouled spark plug.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,…NTSB NYC91LA012Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Wildwood, NJThe student pilot's failure to maintain control of the airplane during landing.NTSB NYC90FA179Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Springfield, NJThe pilot's failure to maintain airspeed and the inadvertent stall of the airplane at an altitude from which recovery was not possible.NTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.NTSB MIA90LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Juan, PRFailure of the student pilot to maintain directional control of the aircraft while taxiing.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.NTSB ANC88LA091Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Nikolai Creek, AKA pilot reported that he was attempting to taxi off the dirt road that he had just used as a landing site in a rural area of Alaska, when the airplane's left main landing gear wheel became mired in a soft spot. The aircraft veered off the road into a ditch.NTSB NYC88LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Dover, PALoss of engine power for an unknown reason. Contributing factors were: failure of the pilot to maintain runway alignment obstructions near the end of the runway (sign, stone fence & tree).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…NTSB ATL88LA153Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Memphis, TNThe pilot reported that the engine lost pwr in-flt due to fuel exhaustion. A forced ldg was made in a plowed field. The airplane nosed over during the ldg. The plt noted after the accident that he should have topped off the fuel tanks prior to departure. The…NTSB NYC88LA038Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Tewksbury, MAThe student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…NTSB SEA87LA161Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Ocean Shores, WAThe plt landed his acft onto a golf course which had been the previous site for the airport. The airport had been closed since December 1985 and relocated close by. The pavement at the old airport had been replaced by sod. During landing roll, the aircraft…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…NTSB NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.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…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…NTSB SEA85LA092Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Hampton, ORThe student plt made a precautionary landing due to being lost and low on fuel. The airstrips surface was 1000 ft of dirt and sand with a fence at the departure end. Takeoff data based on gross weight, zero wind, 4000 ft elevation at 80 degrees, on a hard…NTSB MKC85LA003Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B · House Springs, MOThe acft crashed in a cornfield after takeoff. The takeoff was from a 1550 ft long, wet and soft turf rwy. The acft lifted off near the end and would not climb. The acft stalled and crashed.NTSB CHI84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Millstadt, ILThe acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy.NTSB ATL84LA177Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tallassee, ALThe plt stated he departed fulton county arpt with aprx 12 gals of fuel on board. About 20 mins later, the left fuel tank ran dry & the plt selected the right tank & continued the flt with the intention of refueling at either tuskegee ortallassee. Upon…NTSB MKC83LA204Accident · No injuriesLimited investigationFinal reportGrumman American AA-B · Bucklin, KSThe plt took off with a near full load of fuel. An adult passenger was in the right seat & a child was seated in the baggage compartment, which was not an approved seat. The density altitude at the arpt was aprx 4100 ft. the plt indicated that he rotated for…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…NTSB LAX83LA328Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Boulder City, NVThe acft collided with rising terrain during a go-around. The pilot attempted a landing at Boulder City in a 20-30 kt. Wind. When the acft bounced the pilot decided to go-around. Instead of climbing into the wind he turned downwind at low altitude where he…NTSB FTW83FA319Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Newport, ARThe acft remained low after takeoff and after a turn continued north out of sight of witnesses and did not reappear. It collided with the bottom two strands of a powerline which were severed by the propeller. The acft fuselage came to rest 162 ft beyond the…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.NTSB LAX83FUJ09Accident · 1 fatalFinal reportGrumman American AA-1B · Cornville, AZThe pilot was on a flight from wickenburg to cottonwood, AZ to meet a friend and fly him to phoenix, AZ. During arrival, he made two passes over the top of some homes where his friend was staying, nearby at Cornville, AZ. On the second pass, he made a barrel…NTSB ATL83FA060Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Summerville, WVOn 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…NTSB SEA83LA016Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Ritzville, WAThe pilot reported that during a landing, the aircraft bounced twice and went off the left side of the runway. Reportedly, he initiated a go-around, but the plane struck a fence and crashed.NTSB LAX83FUJ01Accident · 1 fatalFinal reportGrumman American AA-1B · New River, AZAfter entering the traffic pattern, the aircraft was observed in a steep descending turn from downwind to final approach. A witness reported that the pilot kept increasing the bank, while turning to final, as if to keep from overshooting the final approach…NTSB NYC83LA003Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Ipswich, MAThe pilot descended over water at night and elected to fly over a beach area at 100 to 200 ft AGL. He reported that he lowered the nose briefly to see better. At about that time, the aircraft collided with a sand bank.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…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.NTSB LAX82FVG11Accident · Minor injuriesClosedGrum Amer AA-1B · Vacaville, CANTSB FTW81DQD35Accident · Minor injuriesClosedGrum Amer AA-1B · Weed, NMNTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PANTSB NYC81FA082Accident · 2 fatalClosedGulf Amer AA-1B · Richmond, NHNTSB NYC81FNA27Accident · Serious injuriesClosedGrum Amer AA-1B · Tewksbury, MANTSB FTW81FPD33Accident · No injuriesClosedGrumman AA-1B · Lake Dallas, TXNTSB LAX81FA087Accident · 2 fatalClosedGrum Amer AA1B · Solana Beach, CANTSB NYC81FFJ08Accident · No injuriesClosedAmer Avco AA-1B · Albion, NYNTSB FTW81DRD19Accident · No injuriesClosedGrum Amer AA-1B · Grand Isle, LANTSB SEA80FYP37Accident · Serious injuriesClosedGrum-Amer AA-1B · Coeur D'Alene, IDNTSB MKC80FCA27Accident · No injuriesClosedGrum-Amer AA-1B · Farmington, MONTSB LAX80FA123Accident · 1 fatalClosedGrum Amer AA-1B · Lake Hughes, CANTSB ATL80FIJ04Accident · Minor injuriesClosedGrum Amer AA1-B · Philippi, WVNTSB NYC80DHA25Accident · No injuriesClosedGrum Amer AA-1 · Sussex, NJNTSB DEN80FTM17Accident · Minor injuriesClosedGrum-Amer AA-1B · Bullfrog Basin, UT