Skip to content

NTSB investigations: American AA-1A, CA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

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 ('0630710')) 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 ('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."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 ('0630710'))
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 WPR20LA148Accident · Serious injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Blythe, CAThe excessive wear of one magneto’s wiring harness, which resulted in a loss of engine power during takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following the loss of engine power, which resulted in exceedance of the…May 15, 2020 · N12YT · Substantial damage NTSB GAA16CA289Accident · No injuriesData collectionFinal reportAmerican AA 1A · Lone Pine, CAThe pilot's incorrect brake and power application during landing, which resulted in a runway overrun, collision with a dirt berm, nose gear collapse, and nose-over.Jun 5, 2016 · N6391L · Substantial damage NTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.Jun 9, 2014 · N9454L · Destroyed NTSB WPR13FA388Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Desert Center, CAThe pilot's abrupt maneuver, which resulted in an accelerated stall and a loss of airplane control at low altitude.Aug 26, 2013 · N61VT · Substantial damage NTSB WPR11FA344Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Corona, CAAn aggressive flight maneuver performed by the pilot during low altitude flight, which resulted in an aerodynamic stall.Jul 23, 2011 · N34299 · Substantial damage NTSB LAX90LA015Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Borrego Springs, CAThe failure of the engine exhaust valve.Oct 29, 1989 · N9330L · Substantial damage NTSB LAX86FA289Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Santa Paula, CAAfter working for over 13.5 hours the pilot attempted to fly 160 miles to his home. The 1.3 hour flt was initiated between 0100 and 0200. It was a dark night and according to persons in the accident area a 200-400 ft broken/overcast cloud layer was present.…Jul 13, 1986 · N6339L · Destroyed 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…May 1, 1982 · N24584 · 2 aircraft · Substantial damage NTSB OAK77FXQ20Accident · Serious injuriesClosedGrum Amer AA-1A · Placerville, CAMay 18, 1977 · N9449L · Destroyed NTSB OAK76FVD47Accident · Serious injuriesClosedGrum Amer AA1-A · Oakland, CAAug 9, 1976 · N6362L · Destroyed NTSB LAX76FWA19Accident · Minor injuriesClosedAmer Avco AA1-A · Huntington Bch, CAJan 6, 1976 · N6441L · Destroyed NTSB OAK76AP037Accident · 1 fatalClosedAmer Avco AA1-A · Angels Camp, CAJan 2, 1976 · N9230L · Destroyed NTSB LAX76FUA11Accident · Serious injuriesClosedAmer Avco AA1 · Sn Jun Cpstrn, CAOct 3, 1975 · N6313L · Substantial damage NTSB LAX76FUA06Accident · No injuriesClosedAmer Avco AA1-A · Huntington Bch, CASep 7, 1975 · N6441L · Substantial damage NTSB OAK75AP028Accident · 1 fatalClosedAmer Avco AA1-A · Newark, CADec 29, 1974 · N9443L · Destroyed NTSB OAK75FVG29Accident · No injuriesClosedAmer Avco AA1-A · Davis, CAOct 14, 1974 · N6399L · Substantial damage NTSB OAK74AP037Accident · 2 fatalClosedAmer Avco AA1-A · Madera, CAFeb 5, 1974 · N6386L · Destroyed NTSB LAX73AL027Accident · 1 fatalClosedAmer Avco AA-1A · Pacoima, CADec 16, 1972 · N9358L · Destroyed NTSB OAK73FVG34Accident · No injuriesClosedAmer Avco AA-1A · Lincoln, CADec 10, 1972 · N9304L · Substantial damage NTSB OAK73FVA32Accident · Serious injuriesClosedAmer Avco AA1 · Chowchilla, CADec 5, 1972 · N7265L · Substantial damage NTSB LAX73AL016Accident · 1 fatalClosedAmer Avco AA-1A · Santa Paula, CAOct 8, 1972 · N9477L · Destroyed NTSB LAX73FUQ01Accident · Minor injuriesClosedAmer Avco AA-1 · Lompoc, CAJul 26, 1972 · N9433L · Destroyed NTSB OAK72AP036Accident · 2 fatalClosedAmer Avco AA-1A · Corcoran, CAApr 2, 1972 · N9327L · Destroyed NTSB LAX72FUG08Accident · Minor injuriesClosedAmer Avco AA1 · Rialto, CAAug 28, 1971 · N9350L · Substantial damage NTSB OAK72FVG19Accident · Serious injuriesClosedAmer Avco AA-1A · Marysville, CAAug 19, 1971 · N9236L · Substantial damage