NTSB investigations: Grumman American Avn. AA-5B
13 cases on aircraft the registry lists as Grumman American Avn. AA-5B, where the first occurrence was “Loss of control - in flight”. 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 per year
| 1984 | 3 |
|---|---|
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2007 | 1 |
Where
Latest cases
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 ('3960105')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC07LA098Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5B · Danville, VAThe passenger's inadvertent interference with the flight controls due to his physiological condition. Contributing to the accident was the pilot's inability to maintain aircraft control.NTSB DEN03FA133Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Steamboat Sprng, COThe pilot's failure to maintain terrain clearance. Contributing factors include the pilot's inadequate preflight planning/preparation, high density altitude, and mountainous conditions.NTSB IAD02LA032Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Harwinton, CTpilot's failure to obtain adequate airspeed during take-off, which resulted in an aerodynamic stall.NTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.NTSB NYC98LA183Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chatham, MAthe failure of the pilot to maintain airspeed during a go-around and which resulted in an inadvertent stall. Factors in the accident were the pilot's lack of total experience and the gusting crosswinds.NTSB CHI98LA311Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Decatur, INthe pilot's failure to maintain adequate airspeed during the takeoff and his premature raising of the flaps which resulted in the stall/mush condition.NTSB LAX98LA245Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Torrance, CAThe failure of the pilot to maintain an adequate airspeed margin during the go-around attempt, which resulted in a stall/mush.NTSB MIA97FA175Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · Avon Park, FLthe pilot's failure to maintain airspeed (Vso) during an approach in instrument flight conditions.NTSB SEA96LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Rexburg, IDthe pilot's failure to maintain directional control. Factors relating to the accident were: the pilot's failure to verify whether the flaps had raised, the resultant premature lift-off, and trees on the adjacent golf course.NTSB ATL94FA121Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Youngstown, FLSpatial disorientation experienced by the pilot, which resulted in his failure to maintain aircraft control. Factors were the conditions conducive to spatial disorientation (dark night lighting conditions, high cloud cover, thunderstorms), and the pilot's…NTSB ATL84LA201Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Williamsburg, VAThe acft collided with a dirt mound during a go-around. The plt recalled that the wind was variable & gusty, but generally, the wind sock showed a x-wind of 30 to 90 degs. After bouncing on 1 wheel & then on another, the plt initiated a go-around. The acft…NTSB LAX84LA302Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5B · Ruth, CAWhile attempting to land on rwy 31, the plt elected to go-around. He made a low pass down the rwy, pulled up at the end of the rwy for a downwind entry & began to mush. The acft hit a tall tree & impacted the ground.NTSB FTW84FA209Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Pryor, OKThe student plt taxied upwind & took off downwind. Witnesses reported that the acft lifted off at the departure end & never left ground effect. After about 1/2 mi, the acft stalled as the plt attempted to clear electric lines. The acft then crashed, hitting a…