NTSB investigations: Grumman American Avn. AA-1B, 1984
3 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\") = 1984
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") = 1984
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 MKC85LA003Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B · House Springs, MOThe acft crashed in a cornfield after takeoff. The takeoff was from a 1550 ft long, wet and soft turf rwy. The acft lifted off near the end and would not climb. The acft stalled and crashed.NTSB CHI84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Millstadt, ILThe acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy.NTSB ATL84LA177Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tallassee, ALThe plt stated he departed fulton county arpt with aprx 12 gals of fuel on board. About 20 mins later, the left fuel tank ran dry & the plt selected the right tank & continued the flt with the intention of refueling at either tuskegee ortallassee. Upon…