NTSB investigations: Grumman American Avn. AA-1B, 1982
7 cases on aircraft the registry lists as Grumman American Avn. AA-1B. 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
| 1973 | 9 |
|---|---|
| 1974 | 34 |
| 1975 | 32 |
| 1976 | 31 |
| 1977 | 25 |
| 1978 | 15 |
| 1979 | 13 |
| 1980 | 10 |
| 1981 | 9 |
| 1982 | 7 |
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 6 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2009 | 4 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2022 | 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 ('3960103'))
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 ('3960103'))
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 LAX83FUJ09Accident · 1 fatalFinal reportGrumman American AA-1B · Cornville, AZThe pilot was on a flight from wickenburg to cottonwood, AZ to meet a friend and fly him to phoenix, AZ. During arrival, he made two passes over the top of some homes where his friend was staying, nearby at Cornville, AZ. On the second pass, he made a barrel…NTSB ATL83FA060Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Summerville, WVOn 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…NTSB SEA83LA016Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Ritzville, WAThe pilot reported that during a landing, the aircraft bounced twice and went off the left side of the runway. Reportedly, he initiated a go-around, but the plane struck a fence and crashed.NTSB LAX83FUJ01Accident · 1 fatalFinal reportGrumman American AA-1B · New River, AZAfter entering the traffic pattern, the aircraft was observed in a steep descending turn from downwind to final approach. A witness reported that the pilot kept increasing the bank, while turning to final, as if to keep from overshooting the final approach…NTSB NYC83LA003Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Ipswich, MAThe pilot descended over water at night and elected to fly over a beach area at 100 to 200 ft AGL. He reported that he lowered the nose briefly to see better. At about that time, the aircraft collided with a sand bank.NTSB CHI82DA242Accident · No injuriesFinal reportGrumman American AA-1B · Near Zanesville, OHDuring flight in his newly purchased aircraft, the pilot let his right tank run dry. He then switched to his left tank which he believed was more than 1/2 full. After flying about 15 miles further, the engine began running rough and then quit. While landing…NTSB CHI82DA195Accident · Minor injuriesFinal reportGrumman AA1B · Chesterland, OHThe aircraft collided with trees during low flight maneuvering. The aircraft then collided with terrain and was destroyed. The pilot and passenger received minor injuries.