NTSB investigations: American AA-5, 1987
3 cases on aircraft the registry lists as American AA-5. 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
| 1972 | 5 |
|---|---|
| 1973 | 6 |
| 1974 | 14 |
| 1975 | 7 |
| 1976 | 3 |
| 1977 | 3 |
| 1978 | 4 |
| 1979 | 4 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 3 |
| 1988 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2002 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2026 | 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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0631410', '0630711'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0631410', '0630711'))
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 FTW87FA219Accident · 4 fatalField investigationFinal reportGrumman American AA-5A · Corpus Christi, TXThe aircraft exceeded maximum allowable takeoff weight and aft center of gravity limits. The aircraft had two passengers in the rear seats. The operator's manual states that no passengers are permitted in the rear seats during aerobatic maneuvers. The pilot…NTSB CHI87LA094Accident · No injuriesLimited investigationFinal reportAmerican AA5 · Flint, MIDuring a forced landing on an interstate highway about two miles from bishop airport, the aircraft collided with a signpost and a concrete bridge. The pilot had reported that he was out of fuel when he was about nine miles away from the airport. The pilot…NTSB NYC87LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Beverly, MAStudent pilot became lost and disoriented during enroute flight to the manchester area and landed at Beverly airport instead. During landing roll, the aircraft drifted to the left of the runway and collided with a snowbank, breaking off the nose gear and…