American AA-1B
NTSB investigations · 40
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('0630820')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('0630820')
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 CEN25LA054Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1B · Brenham, TXA partial loss of engine power due to an obstructed induction system from a mud dauber nest.NTSB WPR21LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-1B · St Johns, AZThe pilot’s decision to operate with a demonstrated crosswind velocity above the airplane’s performance capabilities which resulted in a loss of airplane control and collision with terrain.NTSB WPR17LA175Accident · Serious injuriesLimited investigationFinal reportGrumman AA1 · Phoenix, AZThe partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…NTSB MIA08CA087Accident · No injuriesData collectionFinal reportAmerican Grumman AA 1B · State College, PAA partial loss of engine power for an undetermined reason.NTSB LAX05FA090Accident · 1 fatalField investigationFinal reportAmerican AA1B · Petaluma, CAThe pilot's failure to maintain an adequate airspeed above the stall speed (Vso) while maneuvering to a landing area that resulted in a stall-spin. Factors in the accident were the fuel starvation induced loss of engine power due to the pilot's fuel system…NTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.NTSB CHI96LA220Accident · 1 fatalLimited investigationFinal reportGrumman AA5B · Fryburg, NDthe pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.NTSB NYC92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tewksbury, MAThe failure of the pilot to compensate for adverse winds, which resulted in a bounced landing, subsequent loss of airspeed and airplane control.NTSB FTW88LA163Accident · No injuriesLimited investigationFinal reportAmerican AA1B · Houston, TXShortly after liftoff, the engine lost power and the pilot turned toward a field. The nose wheel struck a levee and the airplane flipped inverted. During a post-crash inspection, a large mud dauber nest was found inside the air induction system, just behind…NTSB ATL83FA133Accident · Minor injuriesField investigationFinal reportGrumman American AA-1B · Chesapeake, VAThe plt took off on rwy 4 & made a climbing left turn for a downwind departure. At aprx 900 ft, there was a partial loss of power to about idle RPM. The plt stated that he switched fuel tanks, applied carburetor heat & pumped the throttle, all to no avail. He…NTSB ATL83FIG02Accident · 2 fatalFinal reportGrumman AA1B · Delmar, MDPilot making steep turns near his home at low altitude stalled and crashed. No malfunctions found. Witnesses said engine sounded normal in flight.NTSB CHI82FEC02Accident · 1 fatalClosedGulfstream AA-1B · Carsonville, MINTSB CHI80FEV07Accident · 1 fatalClosedAmerican AA-1B · Charleston, ILNTSB MKC79FTK23Accident · Minor injuriesClosedGrumman AA-1B · Brookings, SDNTSB CHI78FEC45Accident · Serious injuriesClosedGrum Amer AA1-B · Milford, MINTSB MIA78FA085Accident · 1 fatalClosedAmer Avco AA-1B · Clearwater, FLNTSB CHI78DEG06Accident · Minor injuriesClosedGrum Amer AA1-B · Lawrence City, OHNTSB NYC77DNA12Accident · No injuriesClosedGrum Amer AA-1B · Tewksbury, MANTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRNTSB MIA77DLD09Accident · No injuriesClosedGrum Amer AA-1B · Moss Bluff, FLNTSB CHI76FEM52Accident · No injuriesClosedGrum Amer AA-1B · Bay City, MINTSB NYC76FFA39Accident · Minor injuriesClosedGrum Amer AA-1B · Waterford, NYNTSB MKC76AK042Accident · 2 fatalClosedGrum Amer AA1-B · Cuba, MONTSB NYC76FNA29Accident · No injuriesClosedGrum Amer AA1-B · Billerica, MANTSB IAD75FIG13Accident · No injuriesClosedGrum Amer AA1-B · Stevensville, MDNTSB NYC75FHJ24Accident · No injuriesClosedAmer Avco AA1-B · Melville, NYNTSB OAK75AP009Accident · 1 fatalClosedAmer Avco AA1-B · El Cajon, CANTSB MKC75FCG07Accident · 1 fatalClosedAmer Avco AA1-B · St Joseph, MONTSB NYC75AN013Accident · 2 fatalClosedAmer Avco AA1-B · Holbrook, NYNTSB CHI74FEA44Accident · Serious injuriesClosedAmer Avco AA1-B · Fillmore, INNTSB FTW74FPJ27Accident · Serious injuriesClosedAmer Avco AA1-B · Oklahoma Cty, OKNTSB SEA74AS035Accident · 2 fatalClosedAmer Avco AA1-B · Enumclaw, WANTSB LAX74DUQ17Accident · Minor injuriesClosedAmer Avco AA1-B · Santa Paula, CANTSB IAD74AI019Accident · 1 fatalClosedAmer Avco AA-1B · Jackson, TNNTSB CHI74FEI07Accident · Serious injuriesClosedAmer Avco AA1-B · Painsville, OHNTSB MKC73AK074Accident · 2 fatalClosedAmer Avco AA1-B · Kansas City, MONTSB OAK73AP043Accident · 1 fatalClosedAmer Avco AA1-B · Fairfield, CANTSB MIA73DKT95Accident · Minor injuriesClosedAmer Avco AA1-B · N.Atlantic Ocean (Atlantic Ocean)NTSB LAX73FUJ72Accident · Serious injuriesClosedAmer Avco AA-1A · Yuma, AZNTSB MIA73DLG34Accident · No injuriesClosedAmer Avco AA-1B · Aiken, SC
Back to American AA-1B