NTSB investigations: American AA-1A, 1975
16 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\") = 1975
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") = 1975
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 SEA76DYC23Accident · No injuriesClosedAmer Avco AA1-A · Goldendale, WANTSB IAD76FID15Accident · Minor injuriesClosedAmer Avco AA-1A · Ashland, VANTSB LAX76FUA11Accident · Serious injuriesClosedAmer Avco AA1 · Sn Jun Cpstrn, CANTSB CHI76DEA09Accident · No injuriesClosedAmer Avco AA1-A · Anderson, INNTSB DEN7LAD017Accident · 1 fatalClosedAmer Avco AA1-A · Rawlins, WYNTSB MIA76FKG23Accident · Serious injuriesClosedGrum-Amer AA1A · Subligna, GANTSB LAX76FUA06Accident · No injuriesClosedAmer Avco AA1-A · Huntington Bch, CANTSB NYC76FNA08Accident · No injuriesClosedAmer Avco AA1-A · Ayer, MANTSB NYC76AN014Accident · 2 fatalClosedAmer Avco AA1-A · Niagara Falls, NYNTSB CHI76DEP10Accident · Minor injuriesClosedGrum Amer AA1-A · Portage, WINTSB IAD76DKW01Accident · No injuriesClosedAmer Avco AA1-A · Collegedale, TNNTSB CHI75DEE71Accident · Minor injuriesClosedGrum Amer AA1-A · Geneseo, ILNTSB SEA75FYE40Accident · No injuriesClosedAmer Avco AA1A · Stuart Island, WANTSB IAD75AIG18Accident · No injuriesClosedGrum Amer AA1-B · Stevensville, MDNTSB MIA75DLG21Accident · No injuriesClosedAmer Avco AA1-A · Aiken, SCNTSB MKC75DEG27Accident · Minor injuriesClosedAmer Avco AA1-A · Richmond, MO