NTSB investigations: American AA-1A
192 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, newest first
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'))
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'))
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 FTW85LA216Accident · No injuriesLimited investigationFinal reportGrumman AA1A · Sweetwater, TXThe acft was destroyed when it flipped over during a forced landing following fuel starvation. The fuel selector was positioned on an empty tank. The right fuel tank was full of fuel. The plt stated he must have forgotten to switch tanks.NTSB FTW85LA063Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Spearman, TXPlt had pulled up form a low pass over cattle when eng quit. Plt cited probable carburetor icing but did not use carb heat. In turn to emergency landing area, acft speed decayed and acft mushed into ground, colliding with a ditch.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 MIA84LA155Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Lake Harbor, FLThe plt adjusted the mixture twice during his descent from 2500 ft MSL. The second adjustment killed the engine and a forced landing was made in a sugar cane field. Post accident examination revealed that the engine mixture control cable was broken. A…NTSB FTW84LA161Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Smithville, TXThe pvt non-instrument plt received two wx briefings for his route of flt from madison, MS, to lufkin, TX, to college station, TX, to san antonio, TX. The last briefing from college station fss informed the plt that marginal VFR conditions exsisted along the…NTSB CHI84LA089Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Hawley, MNThe acft ran into a snowbank during the landing roll and flipped over. The plt stated that the right brake pedal cylinder froze but this could not be confirmed during the investigation.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…NTSB MKC83LA118Accident · No injuriesLimited investigationFinal reportGulfstream American AA1A · Wichita, KSPrior to the flt to Wichita, the plt received a local night checkout with a CFI at olathe. The flt then departed olthe a 2030. As the plt began his descent for a landing at witchita mid-continent arpt the eng quit. He was given a vector tocol. James jabara…NTSB NYC83LA009Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Jamestown, NYThe student pilot was practicing touch-and-go landings on runway 13 with a reported wind from 180 degrees at 15 KTS. He reported that during a landing, he flared too high and bounced. Reportedly, power was applied to go-around, but the plane began to…NTSB SEA82DA153Accident · Minor injuriesFinal reportAmerican AA-1A · Paulsbo, WAAfter demonstrating a practice forced landing approach, a climb was started. Short thereafter, the engine lost power and an actual forced landing was made in a wooded area. The aircraft was damaged beyond economical repair when it struck trees during the…NTSB FTW82DA360Accident · No injuriesFinal reportAmerican AA-1A · Georgetown, TXAt 50 feet AGL the instructor pilot closed the throttle to simulate engine failure during takeoff. He expected a low speed, low altitude, steep 120 degree turn to land on runway 29 by the private pilot receiving familiarization on the AA-1A aircraft. The…NTSB LAX82FA156Accident · Minor injuriesField investigationFinal reportBeech A24R · Camarillo, CAThe pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base…NTSB ATL81DIA04Accident · No injuriesClosedGrum Amer AA1A · Culpeper, VANTSB MKC81FA022Accident · 2 fatalClosedAmer Avco AA-1A · Council Bluffs, IANTSB FTW81DRD09Accident · No injuriesClosedGrum-Amer AA-1A · Clinton, LANTSB CHI80FA051Accident · 1 fatalClosedGrum Amer AA-1A · Troy, MINTSB NYC80FA023Accident · 1 fatalClosedGrum Amer AA-1B · Morganville, NJNTSB MKC80FA008Accident · 1 fatalClosedAmer Avco AA1-A · New Boston, MONTSB MKC79FTK03Accident · No injuriesClosedAmer Avco AA-1A · Redfield, SDNTSB MKC79FA041Accident · 1 fatalClosedAmer Avco AA-1A · Versailles, MONTSB NYC79FGT15Accident · 1 fatalClosedGrumman AA1 · Mountville, PANTSB LAX79DUJ38Accident · No injuriesClosedGrum Amer AA1-A · Aguila, AZNTSB CHI79FEP06Accident · Serious injuriesClosedGrumman AA1-A · Milwaukee, WINTSB MIA78FA120Accident · 2 fatalClosedGrum-Amer AA1A · Toa Baja, PRNTSB CHI78FEE49Accident · Serious injuriesClosedGrum Amer AA1-A · Hillsdale, ILNTSB NYC78FNA32Accident · No injuriesClosedGrum Amer AA1-A · Lincoln, RINTSB MIA78FKG39Accident · Serious injuriesClosedGrum Amer AA1-A · Atlanta, GANTSB MIA78FKT34Accident · Serious injuriesClosedGrumman TR2 · N.Bay Village, FLNTSB MIA78DLA17Accident · No injuriesClosedAmer Avco AA1A · Havana, FLNTSB DEN78DTC14Accident · Minor injuriesClosedGrum Amer AA1A · Laramie, WYNTSB CHI78DEM10Accident · No injuriesClosedGrumman AA1-A · Bay City, MINTSB MIA78FA034Accident · 1 fatalClosedAmer Avco AA1-A · Ormond Beach, FLNTSB FTW78FRG03Accident · No injuriesClosedAmer Avco AA-1A · San Antonio, TXNTSB IAD77FLQ17Accident · Minor injuriesClosedAmerican AA-1A · Elliotville, KYNTSB FTW77FA059Accident · 2 fatalClosedAmerican AA-1A · Marion, TXNTSB MIA77FA060Accident · 1 fatalClosedGrum Amer AA-1A · Atlanta, GANTSB OAK77FXQ20Accident · Serious injuriesClosedGrum Amer AA-1A · Placerville, CANTSB FTW77FRG41Accident · No injuriesClosedGrum Amer AA-1A · San Antonio, TXNTSB MKC77FCQ29Accident · Serious injuriesClosedGrum Amer AA1-A · Junction City, KSNTSB LAX77DUJ30Accident · Minor injuriesClosedAmer Avco AA-1A · Tucson, AZNTSB LAX77DUJ23Accident · Minor injuriesClosedAmer Avco AA1-A · Mesa, AZNTSB MIA77FLD21Accident · No injuriesClosedGrum Amer AA-1B · St.Cloud, FLNTSB NYC76FNE34Accident · Minor injuriesClosedGrum Amer AA-1A · Voluntown, CTNTSB MKC76FER89Accident · No injuriesClosedAmerican AA1-A · Pine City, MNNTSB MIA76FLA61Accident · Minor injuriesClosedGrum Amer AA-1A · Keystone Higts, FLNTSB OAK76FVD47Accident · Serious injuriesClosedGrum Amer AA1-A · Oakland, CANTSB CHI76FEG14Accident · Minor injuriesClosedGrum Amer AA1-A · Dayton, OHNTSB SEA76FYC28Accident · No injuriesClosedAmer Avco AA1-A · Goldendale, WANTSB LAX76FWA19Accident · Minor injuriesClosedAmer Avco AA1-A · Huntington Bch, CA