NTSB investigations: American AA-1A
12 cases on aircraft the registry lists as American AA-1A, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1998 | 2 |
| 2000 | 2 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0630710')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0630710')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 FTW03FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-1A · Shreveport, LAThe pilot's failure to maintain adequate airspeed resulting in a stall.NTSB NYC01LA019Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1A · White Plains, NYAn improperly planned approach which resulted in an inadvertent stall.NTSB IAD00LA048Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Northampton, MAThe student pilot's failure to maintain directional control during takeoff.NTSB NYC98LA144Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Madison, CTWas the failure of the pilot to maintain directional control of the airplane during an aborted landing. A factor was the winds which were variable and gusty.NTSB ATL98LA034Accident · No injuriesLimited investigationFinal reportAmerican General AA-1A · Orlando, FLThe pilot's failure to maintain flying speed.NTSB CHI89DET04Accident · 1 fatalFinal reportAmerican AA-1A · Bluffton, INInadequate airspeed resulting in a stall/spin by the pilot. Factors related to the accident were: a tailwind and wrong runway selected by the pilot.NTSB CHI89FA027Accident · 2 fatalField investigationFinal reportGulfstream AA1A · North Vernon, INThe aircraft was observed to make a high speed low level pass adjacent to the runway and a climbing left turn away from the airport, heading north. A witness in a field north of the airport reported seeing the aircraft descending from a low altitude, level…NTSB FTW87FA041Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Robertson, TXWitnesses stated that the aircraft was circling the top of a 94 ft tall oil well makeover rig when it descended below their line of sight. Another witness a mile away stated that the aircraft began spinning before ground impact. No evidence of any malfunction…NTSB DEN86LA247Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Chinook, MTThe acft took off on a 3900-foot dry asphalt rwy. An uncommanded left yaw developed which the plt was unable to counter. The acft struck a fence off the left side of the rwy and nosed over.NTSB MKC84LA273Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Pleasant Hill, MOThe acft settled into 10-15 ft tall trees during takeoff. The rwy was 1200 ft long and the wind was 2 KTS. The plt said the trees should be cut as a preventive measure. The plt also said there were no problems with the acft.NTSB NYC84FA039Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Wellsville, PAPrior to the flt, the plt stated that he would be flying foraprx 1/2 hr. Aprx 25 min after takeoff, ground witnesses northeast of the arpt observed the acft on a westerly heading, turning toward the arpt. Shortly after that, they saw the acft in an…NTSB SEA83LA150Accident · No injuriesLimited investigationFinal reportGulfstream American AA-1A · Sekiu, WAThe acft collided with a fence during an attempted go-around after a loss of directional control during the approach. The pilot stated that a crosswind carried the acft to the rt of the runway which necessitated the go-around. He further stated his airspeed…