Skip to content

NTSB investigations: Grumman American Avn. AA-5B

172 cases on aircraft the registry lists as Grumman American Avn. AA-5B. 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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960105')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3960105'))
  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 ('3960105'))
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 LAX84LA167Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Lake Havasu Cit, AZIn cruise at 8,500 ft MSL the propeller ass'y forward of the mounting flange separated from the acft. During the forced landing rollout the acft struck a tree. Airworthiness directive 82-27-01 called for inspection of the prop hub and mounting bolt hole areas…Feb 6, 1984 · N81317 · Substantial damage NTSB DEN84FA027Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Boulder, COAccording to witnesses, the plt had made 3 attempts to land & during each attempt he overshot his approach & executed a go-around without touching down. On the fourth attempt he did touch down but appeared to be too fast & the acft skipped & bounced. After…Nov 20, 1983 · N28420 · Destroyed NTSB FTW84LA002Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Midland, TXThe acft stalled and landed hard off the side of the rwy during a forced landing. The plt said the engine was misfiring during initial climb at 150-200 ft AGL. He tried to land on the remaining rwy. The plt later said he thought the power loss was due to…Oct 1, 1983 · N28745 · Substantial damage NTSB NYC83FA110Accident · Serious injuriesField investigationFinal reportGrumman American AA5B · Bedminster, NJThe acft crashed into trees during a forced landing after a loss of power while enroute from white plains. The engine started to shake and the rpms decreased. The plt initiated emergency procedures but the engine continued to run roughly.a decision was made…May 13, 1983 · N28426 · Substantial damage NTSB FTW83LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Nacogdoches, TXDuring arrival, the acft was high on final approach. The plt elected to continue the landing with full flaps, but after touchdown, he was unable to stop on the remaining runway. After overrunning the runway, the acft nosed over in a 10 ft drainage ditch.Jan 16, 1983 · N45344 · Substantial damage NTSB DEN83FTC01Accident · 2 fatalFinal reportGrumman American AA-5B · Albin, WYThe pilot was on personal cross-country. There was no record of a pre-flight or in-flight weather briefing. The weather at the accident site was near blizzard condition. The aircraft was heard circling, but it was not seen due to snow. The winds approached 50…Oct 8, 1982 · N81262 · Destroyed NTSB FTW82FA382Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Paris, TXThe PA-24 had departed rwy 17 at cox field & was climbing at the time of the collision. The plt had reported his intended departure on UNICOM. The AA5B had reported 5 mi sw of the arpt descending through 5,000 ft. for landing. The head-on collision occurred…Sep 16, 1982 · N300AH · 2 aircraft · Destroyed NTSB ATL82DA262Accident · No injuriesFinal reportGrumman AA5B · Darlington, SCWind shifted to tailwind as pilot was landing. He considered a go-around because of speed but thought he could stop. As he went off the end the wing collided with a tree.Sep 2, 1982 · N28311 · Substantial damage NTSB SEA82DA108Accident · No injuriesFinal reportGrumman AA-5B · Corvallis, ORThe aircraft contacted the surface while the pilot was making a low pass over the private airport. Fresh cut hay was windrowed at the edge of the strip. The hay caught on the landing gear and blew up into the elevators and the aircraft was damaged when it…Jul 11, 1982 · N81382 · Substantial damage NTSB MKC82DA119Accident · No injuriesFinal reportGulfstream AA-5B · Mankato, KSDuring a flight from des moines, Iowa to lamar, Colorado, the pilot elected to land at Mankato, Kansas for fuel. Reportedly, the pilot landed on runway 17 with the wind from 190 at 18 gusting 24 knots. The pilot stated that he established a steep, no flap,…Jul 5, 1982 · N74023 · Substantial damage NTSB LAX82DA108Accident · Minor injuriesFinal reportGrum Amer AA-5B · Placerville, CAWhen the pilot arrived at the airport, the top surfaces of the aircraft were covered with about two inches of snow. He stated that his preflight included a complete removal of the snow. However, he also stated that during the takeoff roll, there was a layer…Apr 16, 1982 · N28867 · Substantial damage NTSB SEA82DA041Accident · No injuriesFinal reportGrumman AA-5B · Lebanon, ORThe pilot had about 3 hours of flying experience in this make and model of aircraft. This was his first landing with rear-seat passengers. The pilot reported that the wind was variable and gusting to 15 knots. During the landing flare, the pilot felt a sudden…Mar 21, 1982 · N28791 · Substantial damage NTSB MIA82DA033Accident · No injuriesFinal reportGrumman AA5B · Monticello, FLAfter being denied a special VFR clearance to land at tampa-st. petersburg the pilot elected to cancel his flight plan to tallahassee and fly to new orleans. About 5 1/2 hours into the flight he decided to divert to gulfport, ms and tuned in the gulfport VOR…Jan 13, 1982 · N28607 · Destroyed NTSB LAX82FA040Accident · 2 fatalField investigationFinal reportGrumman AA-5B · 10 Nm W Lee Vin, CAWhile on the ground the pilot was refused a route over the sierra mountains, after departure the pilot requested and was given a change in his flight plan that cleared him over the mountains. At 1654 the pilot advised oakland center that he was climbing…Jan 4, 1982 · N28912 · Destroyed NTSB FTW82FQA17Accident · 4 fatalClosedGrum Amer AA-5B · Truchas, NMDec 31, 1981 · N81350 · Destroyed NTSB FTW82DA024Accident · 1 fatalClosedGrum Amer AA-5B · Eagle Lake, TXNov 29, 1981 · N28781 · Destroyed NTSB FTW82FPM06Accident · Serious injuriesClosedGrumman AA-5B · Bristow, OKNov 11, 1981 · N1581R · Destroyed NTSB ATL82FKG07Accident · No injuriesClosedGrumm Amer AA-5B · Blue Ridge, GANov 8, 1981 · N1508R · Substantial damage NTSB LAX81FA116Accident · 1 fatalClosedGrum Amer AA-5B · Vancouver, WAAug 13, 1981 · N1565R · Destroyed NTSB MKC81FCA23Accident · No injuriesClosedGrumman AA-5B · Wentzville, MOAug 4, 1981 · N28917 · Substantial damage NTSB ATL81FA105Accident · 1 fatalClosedGrum Amer AA-5B · Baxley, GAAug 1, 1981 · N28401 · Destroyed NTSB DEN81FTK16Accident · No injuriesClosedGrum-Amer AA-5B · Custer, SDJul 28, 1981 · N81272 · Substantial damage NTSB DEN81FA049Accident · 4 fatalClosedGulf-Amer AA-5B · Crested Butte, COJul 12, 1981 · N4539Q · Destroyed NTSB LAX81FUJ27Accident · 2 fatalClosedGrum Amer AA-5B · Bullhead City, AZJan 17, 1981 · N74691 · Destroyed NTSB LAX81FUA02Accident · Minor injuriesClosedGrumman AA-5B · Torrance, CANov 29, 1980 · N74494 · Destroyed NTSB LAX80DUK05Accident · Serious injuriesClosedGrumman AA-5B · Phoenix, AZSep 27, 1980 · N1576R · Substantial damage NTSB DEN80FTE72Accident · Serious injuriesClosedGrum-Amer AA-5B · Boulder, COAug 20, 1980 · N28420 · Substantial damage NTSB DEN80FTM37Accident · Serious injuriesClosedGrum-Amer AA-5B · Heber City, UTAug 17, 1980 · N28823 · Substantial damage NTSB CHI80FEK22Accident · No injuriesClosedGrum Amer AA-5B · Columbus, OHJul 16, 1980 · N1524R · Substantial damage NTSB LAX80DVW21Accident · Serious injuriesClosedGrum-Amer AA-5B · Independence, CAJul 12, 1980 · N28844 · Substantial damage NTSB ATL80DKG09Accident · No injuriesClosedGrum Amer AA5-B · Americus, GAJul 5, 1980 · N28862 · Substantial damage NTSB LAX80FA078Accident · 1 fatalClosedGrum Amer AA-5B · Moraga, CAApr 9, 1980 · N78EM · Destroyed NTSB MKC80FA024Accident · 2 fatalClosedGrum-Amer AA-5B · Spencer, IAFeb 21, 1980 · N74028 · Destroyed NTSB LAX80FUG57Accident · Serious injuriesClosedGrum-Amer AA-5B · Elsinore, CAOct 6, 1979 · N81129 · Destroyed NTSB SEA79DYM63Accident · No injuriesClosedGrum-Amer AA-5B · Condon, ORAug 29, 1979 · N74472 · Substantial damage NTSB MKC79FCQ41Accident · No injuriesClosedGrumman AA5B · Hoxie, KSAug 6, 1979 · N28756 · Substantial damage NTSB UNK79X0112Accident · Minor injuriesClosedGrumman AA-5B · Polo, ILJul 13, 1979 · N28411 · Substantial damage NTSB MKC79FCA16Accident · Serious injuriesClosedGrumman AA-5B · Owensville, MOJun 6, 1979 · N28467 · Destroyed NTSB LAX79FUM23Accident · No injuriesClosedGrum-Amer AA-5B · Ramona, CAMay 24, 1979 · N28477 · Substantial damage NTSB MIA79FA050Accident · 1 fatalClosedAmer Avco AA-5B · Plymouth, FLFeb 11, 1979 · N28671 · Destroyed NTSB CHI79FEC11Accident · No injuriesClosedGrum Amer AA-5B · Port Huron, MIJan 28, 1979 · N74560 · Substantial damage NTSB NYC79FNA09Accident · No injuriesClosedGrumman AA-5B · Tewksbury, MADec 23, 1978 · N28941 · Substantial damage NTSB MIA79FA024Accident · 1 fatalClosedGrumman AA-5B · Marianna, FLNov 30, 1978 · N28649 · Destroyed NTSB DEN79FA007Accident · 4 fatalClosedGrum-Amer AA-5B · Meeteetse, WYNov 8, 1978 · N28406 · Destroyed NTSB MIA79F1D09Accident · Serious injuriesClosedGrumman AA-5B · Vero Beach, FLOct 27, 1978 · N28411 · Substantial damage NTSB SEA79FA006Accident · 4 fatalClosedGrum Amer AA-5B · Roche Harbor, WAOct 21, 1978 · N28924 · Destroyed NTSB NYC78FFJ37Accident · Minor injuriesClosedGrum Amer AA-5B · Cortland, NYSep 5, 1978 · N74355 · Substantial damage NTSB NYC78FGT15Accident · No injuriesClosedGrum Amer AA-5B · Marietta, PAAug 26, 1978 · N1519R · Substantial damage NTSB MKC78FA060Accident · 4 fatalClosedAmer Avco AA-5B · North Bend, NEAug 8, 1978 · N81224 · Destroyed NTSB MKC78DER80Accident · No injuriesClosedAmer Avco AA-5B · Cook, MNJul 28, 1978 · N28335 · Substantial damage