NTSB investigations: American AA-1A, OH
12 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 | 4 |
|---|---|
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 2 |
| 1989 | 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.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
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 CHI89LA193Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Medina, OHThe pilot's improper flare and recovery from a bounced landing and his improper planning/decision which resulted in a situation from which an overrun occurred. Contributing factors were: the weather conditions, failure of the pilot to obtain a weather…NTSB CHI76FEG14Accident · Minor injuriesClosedGrum Amer AA1-A · Dayton, OHNTSB CHI76AC043Accident · 1 fatalClosedGrum Amer AA1-A · Rockford, OHNTSB CHI74FEG22Accident · No injuriesClosedAmer Avco AA1-A · Dayton, OHNTSB CHI74AC082Accident · 1 fatalClosedAmer Avco AA1-A · Rattlesnk Is, OHNTSB CHI73FEI47Accident · No injuriesClosedAmer Avco AA1-A · North Canton, OHNTSB CHI73FEG12Accident · Serious injuriesClosedAmer Avco AA1A · Dayton, OHNTSB CHI72FEG33Accident · No injuriesClosedAmer Avcd AA1 · New Lebanon, OHNTSB CHI72AC024Accident · 2 fatalClosedAmer Avco AA1A · Litchfield, OHNTSB CHI72FEG12Accident · Minor injuriesClosedAmer Avco AA1-A · Manchester, OHNTSB CHI72FEI16Accident · No injuriesClosedAmer Avco AA1A · Ashland, OHNTSB CHI72DEI06Accident · No injuriesClosedAmer Avco AA1-1A · Stow, OH