NTSB investigations: American AA-1A, 1982
4 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\") = 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 ('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") = 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 ('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 NYC83LA009Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Jamestown, NYThe student pilot was practicing touch-and-go landings on runway 13 with a reported wind from 180 degrees at 15 KTS. He reported that during a landing, he flared too high and bounced. Reportedly, power was applied to go-around, but the plane began to…NTSB SEA82DA153Accident · Minor injuriesFinal reportAmerican AA-1A · Paulsbo, WAAfter demonstrating a practice forced landing approach, a climb was started. Short thereafter, the engine lost power and an actual forced landing was made in a wooded area. The aircraft was damaged beyond economical repair when it struck trees during the…NTSB FTW82DA360Accident · No injuriesFinal reportAmerican AA-1A · Georgetown, TXAt 50 feet AGL the instructor pilot closed the throttle to simulate engine failure during takeoff. He expected a low speed, low altitude, steep 120 degree turn to land on runway 29 by the private pilot receiving familiarization on the AA-1A aircraft. The…NTSB LAX82FA156Accident · Minor injuriesField investigationFinal reportBeech A24R · Camarillo, CAThe pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base…