NTSB investigations: Grumman American Avn. AA-5A
10 cases on aircraft the registry lists as Grumman American Avn. AA-5A, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 2 |
| 1992 | 1 |
| 1996 | 2 |
Where
Open the mapLatest 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 ('3960106')
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\" = 220))
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 ('3960106')
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" = 220))
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 LAX97LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Banning, CAThe pilot's intentional low flight in an area of foothills and canyons at an altitude insufficient to maintain clearance from obstacles.NTSB SEA96LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Klamath Falls, ORthe pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…NTSB SEA92LA163Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Battleground, WAThe pilot in command's delayed decision to execute a go around. Factors contributing the accident were: a tailwind, trees, and the improper use of the carburetor heat and flaps by the pilot in command.NTSB MIA89FA027Accident · 2 fatalField investigationFinal reportGrumman AA5A · Tampa, FLWitnesses stated the acft was flying at low alt in the area of lake thonotosassa just before it struck the top static wire of a group of power lines. Impact occurred while the acft was on a southerly heading. The acft then crashed into an orange grove. An…NTSB CHI88FA067Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Martinsville, INPilot to take into caonsideration the wind direction and velocity before selecting his takeoff direction.NTSB FTW87LA153Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Marietta, OKThe plt rprtd that drg takeoff fm a grass rwy, the acft stalled after climbing about 10 ft AGL. He said that torque pulled the nose of the acft to the left & he tried to recover. However, there was insufficient alt & the acft hit the tops of trees, then fell…NTSB CHI85LA206Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · New Hudson, MIThe pilot inadvertently attempted to take off with at least 21 deg. Of flaps. The acft climbed to approximately 30-50 8T. AGL and passed over a hangar on the left side of the runway. Once past the hangar the acft began a rapid descent. Post impact fire…NTSB MIA85LA172Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Orlando, FLThe plt reported that after he arrived & was on an apch to land, he noted 'tape' across the rwy. He remained airborne until the acft passed over 'the taped off area.' He then landed the acft on the rwy which was rough & bumpy. The plt stated that the acft was…NTSB FTW83LA378Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Grove, OKThe acft was high & fast on final apch & touched down about 1/3 of the way down the rwy. The nosewheel touched down 1st & the acft began to porpoise. The plt applied power to stop the porpoise, then elected to go around. In order to avoid trees near the end…NTSB NYC82DA141Accident · No injuriesFinal reportGrumman American AA-5A · Marstons Mills, MAThe pilot stated that the aircraft was slow to gain normal lift-off speed due to the surface of the airstrip. He also stated that after prematurely vaulting the aircraft into the air the aircraft never gained sufficient airspeed for a climb. The aircraft…