Fatal NTSB investigations: American AA-5
11 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
| 1973 | 1 |
|---|---|
| 1974 | 4 |
| 1975 | 2 |
| 1978 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 2002 | 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 c.\"highestInjuryLevel\" = 'Fatal'
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 c."highestInjuryLevel" = 'Fatal'
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 MIA02FA131Accident · 2 fatalField investigationFinal reportAmerican General AA-5 · Boca Raton, FLThe owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.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 MKC81FA020Accident · 2 fatalClosedGrum-Amer AA-5 · Thayer, MONTSB DEN79FA002Accident · 2 fatalClosedGrum Amer AA5 · Littleton, CONTSB FTW76AF015Accident · 3 fatalClosedGrum Amer AA5 · Liberty, TXNTSB SEA75AS031Accident · 2 fatalClosedAmer Avco AA5 · Newberg, ORNTSB NYC75AN030Accident · 3 fatalClosedAmer Avco AA-5 · Roxbury, CTNTSB OAK74AP069Accident · 2 fatalClosedAmer Avco AA5 · Missing AircraftNTSB NYC74AN097Accident · 3 fatalClosedPiper PA-28R · Tewksbury, MANTSB LAX74AL070Accident · 2 fatalClosedAmer Avco AA5 · Rimrock, AZNTSB SEA74AS002Accident · 4 fatalClosedAmer Avco AA5 · Shelley, ID