NTSB investigations: American AA-1A, 1985
3 cases on aircraft the registry lists as American AA-1A. 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
| 1971 | 13 |
|---|---|
| 1972 | 34 |
| 1973 | 12 |
| 1974 | 15 |
| 1975 | 16 |
| 1976 | 10 |
| 1977 | 9 |
| 1978 | 11 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 3 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1998 | 5 |
| 2000 | 4 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0630710'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0630710'))
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 DEN86LA052Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA-1A Yankee · Cloudcroft, NMThe plt stated that he was following a highway from alamogordo, NM to roswell, NM. The plt continued to state that the highway lead him into an area of high terrain that his acft could not climb over. The plt was unable to turn around and executed an emerg…NTSB ATL85LA200Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Hatteras, NCWhile on a flt to Hatteras, NC, the eng ran rough, so after landing, the plt got an auto mechanic to remove the spark plugs. The lower plugs on the left side were lead fowled & were cleaned with a wire brush. During takeoff on the next flt, the eng lost…NTSB FTW85LA216Accident · No injuriesLimited investigationFinal reportGrumman AA1A · Sweetwater, TXThe acft was destroyed when it flipped over during a forced landing following fuel starvation. The fuel selector was positioned on an empty tank. The right fuel tank was full of fuel. The plt stated he must have forgotten to switch tanks.