NTSB investigations: Grumman American Avn. AA-5B, 1987
8 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.
Cases per year
| 1975 | 3 |
|---|---|
| 1976 | 3 |
| 1977 | 8 |
| 1978 | 17 |
| 1979 | 8 |
| 1980 | 9 |
| 1981 | 10 |
| 1982 | 9 |
| 1983 | 4 |
| 1984 | 10 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 8 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 6 |
| 1991 | 2 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 5 |
| 2003 | 3 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 3 |
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 4 |
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\") = 1987
AND 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 year(c."eventDate") = 1987
AND 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" 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 NYC88LA057Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Rome, NYThe flight was enroute from watertown to glens falls, new york when snow squalls of varying intensity and gusty wind conditions were encountered. The pilot stated that forward visibility was marginal. The engine failed shortly after changing heading towards…NTSB CHI88LA013Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Leavenworth, INAccording to the pilot, the aircraft was taking off from a 'bumpy' grass private strip. The pilot stated he discussed aborted takeoff procedures with the pilot rated passenger who was sitting in the right seat and stated if the aircraft did not reach takeoff…NTSB NYC88LA016Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Barre, MAThe aircraft was in the traffic pattern when it experienced a power loss. The plt made an off-airport landing in a wooded area. The pilot reported that he was in a slip prior to and at the time of the reported power loss. The FAA reported that the engine…NTSB MKC88LA009Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Branson, MODuring a lndg on a 3600 ft strip, the acft touched down long. The acft ran off the departure end of the rwy and collided with the terrain causing substantial damage to the acft. Witnesses said they could not find any skid marks along the path taken by the…NTSB LAX87LA273Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Lake Tahoe, CAWhile taxiing to the rwy, the plt stated that the right brake failed. The acft rolled off the taxiway and collided with a transformer. Inspection of the brake revealed that the brake linings were worn and that the piston in the hydraulic cylinder had traveled…NTSB BFO87FA046Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Abingdon, VAFss advised the plt that VFR flight was not recommended due to obscured mountains along the flight route. There also were thundershowers west of the flight route. The plt said he had to leave to stay ahead of the thundershowers. He said that he would fly the…NTSB NYC87LA175Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Croton Fall, NYAbt 15 minutes aft tkof, the eng started to lose pwr. All efforts to restart it were unsuccessful and the acft was forced to land in a landfill. During lndg roll the acft collided with a hole and the gear sheared off. Exam of the eng revealed a burned piece…NTSB FTW87FA105Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Eagle Lake, TXOn April 25,1987 a Grumman American AA5B, N28846, impacted the terrain near Eagle Lake, Texas. The private pilot and her husband received fatal injuries. The aircraft was destroyed. Visual meteorological conditions prevailed at the time of the accident. The…