NTSB investigations: Grumman American Avn. AA-5
149 cases on aircraft the registry lists as Grumman American Avn. AA-5. 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 ('3960104'))
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 ('3960104'))
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 ATL88LA041Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Thomson, GAThe airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…NTSB LAX88LA003Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Big Bear City, CAThe student pilot bounced during landing and collided with runway lights and a taxiway sign. He landed on runway 25 with winds reported 040 degrees at 8 knots. He said he could not receive wind information because he had inadvertantly turned off his radio.NTSB MIA87LA230Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Vega Baja, PRThe plt stated that he had descended from 4500 ft to get out of the clouds & at 1300 ft, the eng became rough. He stated the RPM dropped from 2300 to 1000. He also stated that he did not use carb heat prior to or during the descent. The plt stated that when…NTSB CHI87FA140Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Middleton, WIThe pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind…NTSB MIA86IA018Incident · No injuriesIncident investigationFinal reportGrumman American AA-5 · Live Oak, FLThe acft made a downwind landing touching down long on the rwy. The acft could not be stopped & ran off the end of the rwy. The plt stated that he misread the windsock.NTSB ATL86FA002Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Hurricane, WVN9629U crashed in a wooded area near Hurricane, west Virginia while conducting a visual flight from millwood, WV to grundy, Virginia. The pilot and aircraft were certificated in accordance with current FARS. The pilot received a weather briefing for the…NTSB NYC85LA214Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Montgomery, NYThe plt reported that the flt was uneventful until he was in a descent about 12 mi from the destination arpt. He said that a large bird suddenly appeared in front of the acft & collided with the right wing. The bird strike put a large hole in the right wing…NTSB MIA85LA173Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · High Springs, FLThe plt stated that he made a normal takeoff with 2200 RPM, but shortly after rotation, the RPM started to decrease & the acft lost altitude & landed in the top of a large oak tree. An investigation revealed that the carburetor inlet finger screen had a 75%…NTSB MIA85FA106Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Horseshoe Beach, FLThe acft crashed in the gulf of Mexico while the plt was on a night x-country flt. The wx at the destination had been forcast to be IFR. However, in the area of the accident, witnesses stated the wx was good with no fog & it was a dark night. When the acft…NTSB ATL85FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman American AA-5 · Dayton, OHAircraft missing on a flight from Dayton, OH to gallipolis, OH two persons on board.NTSB CHI84LA382Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · New Carlisle, OHThe acft collided with trees after overrunning a 2000 ft wet sod airstrip. The plt reported that braking action was poorthe acft went into an evergreen tree nursery before stopping.NTSB SEA84LA192Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Klamath Falls, ORThe pilot stated that the run-up and takeoff were normal but during the climbout the engine lost power. A small fire, confined to the engine compartment erupted. Power could not be restored and an emergency landing was accomplished in an open field.…NTSB CHI84FA308Accident · 4 fatalField investigationFinal reportGrumman AA-5 · Little Falls, MNThe acft collided with the ground during a takeoff attempt. The low time plt was using a grass rwy for the 1st time without an instructor. The acft was rotated prematurely and assumed a nose high attitude. According to one witness the acft was 'behind the…NTSB NYC84FA233Accident · 1 fatalField investigationFinal reportGrumman AA-5 · Woodstock, NYAcft was on a VFR personal flight. Witness on mountain slope heard sounds of approaching acft, observed brief glimpse of acft wheel and wing through cloud and fog about 100 ft away, at tree-top level. A few seconds later. Witness heard eng sound cease.…NTSB DCA83IA027Incident · No injuriesIncident investigationFinal reportGrumman AA-5 · Clinton, MDThe student pilot ballooned during the flare, then landed hared on runway. The nosegear failed and the acft slid down the runway.NTSB ATL83LA038Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Clinton, MDThe pilot was on final approach behind a Cessna 150 and thought the Cessna would turn off at the first taxiway. The Cessna continued to the second taxiway and the pilot of N5442L elected to go-around. The pilot stated the aircraft seemed to mush as it flew…NTSB LAX81FVA61Accident · Minor injuriesClosedGulf Amer AA-5 · Independence, CANTSB CHI81DEP29Accident · Minor injuriesClosedGrumman AA-5 · Summit Lake, WINTSB NYC81FFJ13Accident · No injuriesClosedGrumman AA-5A · Batavia, NYNTSB ATL81FA063Accident · 1 fatalClosedGrumman AA-5 · No.Sandbridge, VANTSB FTW81FRG14Accident · Serious injuriesClosedGrum-Amer AA-5 · Sinton, TXNTSB NYC80DNC46Accident · No injuriesClosedGrum-Amer AA-5 · Manchester, NHNTSB LAX80FA116Accident · 4 fatalClosedGrum-Amer AA-5 · San Diego, CANTSB CHI80FEI22Accident · No injuriesClosedGrumman AA-5 · Ravenna, OHNTSB MIA80FLD68Accident · No injuriesClosedGrum-Amer AA-5 · Clearwater, FLNTSB MIA80FA034Accident · 1 fatalClosedGrum-Amer AA-5 · Miami, FLNTSB DEN79FTE74Accident · No injuriesClosedGrumman AA-5A · Gunnison, CONTSB UNK79X0113Accident · Minor injuriesClosedGrum-Amer AA-5 · Au Gres, MINTSB IAD79FIA14Accident · No injuriesClosedGrum Amer AA-5 · Warrenton, VANTSB NYC79FFA26Accident · Serious injuriesClosedGrum Amer AA5 · Mechanicville, NYNTSB CHI79DEE57Accident · No injuriesClosedGrumman AA5 · Harvard, ILNTSB MIA79FA069Accident · 1 fatalClosedAmer Avco AA-5 · Marathon, FLNTSB NYC79FA032Accident · 4 fatalClosedGrum Amer AA-5 · Pompey, NYNTSB LAX79DUJ54Accident · No injuriesClosedGrumman AA-5 · Prescott, AZNTSB IAD79FLJ07Accident · No injuriesClosedGrumman AA-5 · Oxford, NCNTSB DEN79FQA18Accident · Minor injuriesClosedGrumman AA5 · Albuquerque, NMNTSB CHI79FEP09Accident · No injuriesClosedGrumman AA-5 · Portage, WINTSB CHI79FEK01Accident · 1 fatalClosedGrum Amer AA-5 · Reno, OHNTSB CHI79FA017Accident · 2 fatalClosedGrumman AA-5 · Norway, MINTSB MKC78DER94Accident · Minor injuriesClosedGrumman AA-5 · Milaca, MNNTSB IAD78FA108Accident · 1 fatalClosedGrum Amer AA-5 · Jackson, TNNTSB MKC78FTK22Accident · No injuriesClosedGrum Amer AA5 · Brookings, SDNTSB LAX78FUD06Accident · Minor injuriesClosedGrum Amer AA-5 · Santa Monica, CANTSB CHI78FEG07Accident · No injuriesClosedGrumman AA-5 · Vandali, OHNTSB IAD78IA054Incident · No injuriesClosedGruman AA5 · Raleigh, NCNTSB MKC78FER11Accident · Minor injuriesClosedGrumman AA-5 · Caledonia, MNNTSB MKC78FA002Accident · 2 fatalClosedGrumann AA-5A · Pierce, NENTSB FTW78DRD03Accident · No injuriesClosedGrumman AA-5 · Lafayette, LANTSB OAK77DVA48Accident · Minor injuriesClosedGrumman AA5 · Oakland, CANTSB MIA77FKQ12Accident · Serious injuriesClosedGrumman AA5 · Hattiesburg, MS