Skip to content

NTSB investigations: American AA-1, CA

26 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Where

Latest cases

Query with SQL

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" = 'CA' 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

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\" = 'CA' 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" = 'CA' 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

Run 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 WPR13LA251Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Truckee, CAThe pilot's failure to lean the fuel mixture during takeoff in high-density altitude conditions, which resulted in a loss of engine power.May 23, 2013 · N5909L · Substantial damage NTSB LAX04LA156Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Selma, CAThe pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.Mar 13, 2004 · N6175L · Substantial damage NTSB LAX04LA022Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · San Martin, CAThe absence of compression in two of the airplane's four cylinders, and the pilot/mechanic's failure to maintain the engine in an airworthy condition, which resulted in a loss of engine power during takeoff-initial climb, and subsequent forced landing.Oct 22, 2003 · N5968L · Substantial damage NTSB LAX96LA305Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Rosamond, CAThe pilot's inadequate preflight planning and his delayed decision to reverse the airplane's direction.Aug 12, 1996 · N5616L · Destroyed NTSB LAX95LA051Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Oasis, CAthe pilot's improper inflight decision by selecting an inadequate terrain clearance altitude over mountainous terrain.Dec 15, 1994 · N6236L · Destroyed NTSB LAX90FA111Accident · Serious injuriesField investigationFinal reportAmerican AA-1 · Borego Springs, CAImproper in-flight planning/decision by the pilot, and his failure to maintain sufficient airspeed and altitude, which resulted in a stall/mush into rising mountainous terrain. Factors related to the accident were: the terrain and weather conditions, and…Mar 10, 1990 · N5655L · Destroyed NTSB LAX88LA210Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Hemet, CADuring the landing while on a solo (instructional) night cross country flight, the airplane touched down, bounced, and veered left. During the second bounce between the runway and the taxiway, the pilot added power. The airplane continued in a straight path…Jun 4, 1988 · N6181L · Substantial damage NTSB LAX83LA381Accident · No injuriesLimited investigationFinal reportGrumman American AA1 · Bishop, CAThe acft landed hard during a forced landing and collapsed the landing gear pilot reported that 10-15 minutes after takeoff he experienced pitch control problems. He was unable to turn the acft and made a forced landing straight ahead. The pilot stated that…Aug 10, 1983 · N6105L · Substantial damage NTSB LAX80FVG58Accident · Serious injuriesClosedGrum-Amer AA-1 · Lincoln, CAJul 26, 1980 · N326AA · Substantial damage NTSB LAX77DUQ18Accident · No injuriesClosedAmer Avco AA1 · Santa Maria, CAFeb 13, 1977 · N6153L · Substantial damage NTSB LAX76FUG53Accident · Serious injuriesClosedAmer Avco AA1 · Palm Springs, CAMay 28, 1976 · N5696L · Substantial damage NTSB OAK75FVM05Accident · No injuriesClosedAmer Avco AA1 · Palo Alto, CAAug 3, 1974 · N5926L · Substantial damage NTSB OAK74FVG33Accident · Minor injuriesClosedAmer Avco AA1 · Angwin, CAMar 23, 1974 · N6254L · Substantial damage NTSB OAK74AP001Accident · 2 fatalClosedAmer Avco AA1 · Garberville, CAJul 4, 1973 · N5692L · Destroyed NTSB OAK72FVA73Accident · Serious injuriesClosedAmer Avco AA-1 · Lindsay, CAMay 29, 1972 · N5947L · Destroyed NTSB OAK72FVM31Accident · 1 fatalClosedAmer Avco AA-1 · Salinas, CAApr 25, 1972 · N5630L · Substantial damage NTSB LAX72AL048Accident · 1 fatalClosedAmer Avco AA-1 · Devore, CAJan 26, 1972 · N5647L · Destroyed NTSB OAK71DVG47Accident · No injuriesClosedAmer Avco AA-1 · Wilton, CAJan 17, 1971 · N6131L · Destroyed NTSB LAX71FUQ24Accident · Serious injuriesClosedAmer Avco AA1 · Agua Dulce, CAOct 3, 1970 · N5666L · Destroyed NTSB LAX71FUQ05Accident · Minor injuriesClosedAmer Avco AA-1 · Solvang, CAJul 18, 1970 · N5730L · Destroyed NTSB LAX70FUQ32Accident · No injuriesClosedAmer Avco AA-1 · Oxnard, CAJun 17, 1970 · N69MP · Substantial damage NTSB LAX70AL060Accident · 2 fatalClosedAmer Avco AA-1 · Mt Baldy, CAMar 21, 1970 · N5994L · Destroyed NTSB LAX70FUQ11Accident · Minor injuriesClosedAmer Avco AA-1 · Goleta, CAFeb 20, 1970 · N5761L · Substantial damage NTSB LAX70D0079Accident · No injuriesClosedChampion 7ECA · El Monte, CAAug 9, 1969 · N2977G · 2 aircraft · Substantial damage NTSB LAX70F0038Accident · Minor injuriesClosedAmer Avco AA-1 · El Cajon, CAJul 5, 1969 · N5674L · Destroyed NTSB LAX69F0301Accident · No injuriesClosedAmer Avco AA-1 · La Verne, CAMar 27, 1969 · N5647L · Substantial damage