NTSB investigations: American AA-1, TX
15 cases on aircraft the registry lists as American AA-1. 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
| 1969 | 1 |
|---|---|
| 1970 | 3 |
| 1971 | 3 |
| 1972 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 2004 | 1 |
| 2012 | 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\" = 'TX' 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 ('0630610'))
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" = 'TX' 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 ('0630610'))
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 CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…NTSB FTW04LA174Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Gordonville, TXThe pilot's premature lift-off and his failure to abort the takeoff. Contributing factors were the soft and muddy runway conditions and the unfavorable winds.NTSB FTW86LA140Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Roanoke, TXThe pilot took off during darkness on an early morning flt & arrived at the destn arpt prior to sunrise. He was unable to activate the rwy lights, but since the ground features could be seen, he elected to land. During the landing, the acft touched down…NTSB FTW82DA352Accident · Minor injuriesFinal reportGrumman AA-1 · Pearland, TXThe pilot reported that during an engine run-up, before takeoff, the engine ran rough on one magneto. He did not state which. He reported that after the engine was leaned, the roughness disappeared and a takeoff was made. He stated that after lift off, thrust…NTSB FTW77FPA02Accident · No injuriesClosedAmerican AA1 · Plano, TXNTSB FTW76FPD44Accident · No injuriesClosedAmer Avco AA1 · Moran, TXNTSB FTW73AF058Accident · 1 fatalClosedAmer Avco AA-1 · La Porte, TXNTSB FTW72DPD39Accident · No injuriesClosedAmer Avco AA1 · Vernon, TXNTSB FTW72DRG34Accident · No injuriesClosedAmer Avco AA1 · San Antonio, TXNTSB FTW72DPD02Accident · No injuriesClosedAmer Avco AA1 · Muenster, TXNTSB FTW71FRA39Accident · No injuriesClosedAmer Avco AA1 · Friendswood, TXNTSB FTW71FRA23Accident · Serious injuriesClosedAmer Avco AA-1 · Houston, TXNTSB FTW71FPD02Accident · No injuriesClosedAmer Avco AA-1 · Arlington, TXNTSB FTW70FQG22Accident · No injuriesClosedAmer Avco AA-1 · Lubbock, TXNTSB FTW70D0221Accident · No injuriesClosedAmer Avco AA-1 · Crockett, TX