NTSB investigations: Gulfstream American AA-5B, 1982
6 cases on aircraft the registry lists as Gulfstream American 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.
Cases per year
| 1980 | 5 |
|---|---|
| 1981 | 3 |
| 1982 | 6 |
| 1983 | 3 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2009 | 1 |
| 2017 | 1 |
| 2021 | 2 |
| 2024 | 1 |
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 year(c.\"eventDate\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3970106'))
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 year(c."eventDate") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3970106'))
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 FTW83FPM02Accident · 1 fatalFinal reportAmerican AA-5B · 3 1/2 Nm Ene Di, OKWitnesses stated that the aircraft bounced at touchdown, a go-around was attempted and the aircraft struck a powerline at the end of the runway. The aircraft impacted the ground approximately 1/4 mile southeast of the runway. The accident occurred at dusk.NTSB ATL82DA271Accident · No injuriesFinal reportGrumman AA-5B · Moulton, ALAccording to the pilot, after touchdown he applied brakes and the right brake seemed to lock intermittently during the roll out. Black marks on the landing surface reveal the aircraft departed the right side and impacted an embankment and steel post. This was…NTSB NYC82DA171Accident · No injuriesFinal reportGrumman AA-5B · Madison, CTThe pilot stated that he experienced a sudden wind shift when over the runway threshold. The aircraft was landed to the right of the runway after an attempted go-around was aborted because of trees and buildings at the departure end/left side of the runway.NTSB DEN82DA141Accident · Minor injuriesFinal reportAmerican AA5B · Broomfield, COThe pilot was conducting local area pleasure sightseeing flights when the aircraft failed to climb during a normal departure. She landed the aircraft in a plowed field. Investigation revealed the flight was conducted at a density altitude approximately 8,750…NTSB NYC82FA148Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Newburg, PAThe pilot on a personal cross-country flew into trees on a slope of blue mountain, PA at the 2284 foot level. The weather in the area was foggy and the mountain tops were obscured in clouds. There is no record of a weather briefing or communication by the…NTSB SEA82DA061Accident · No injuriesFinal reportGrumman AA-5B · Sunriver, ORAfter terminating his first approach in a go-around the pilot commenced a second approach. Just before touchdown the pilot stated that a gust of wind shoved the plane to the left. The pilot attempted to abort the landing by adding full power but the aircraft…