NTSB investigations: American AA-1
10 cases on aircraft the registry lists as American AA-1, 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
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1986 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 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 ('0630610')
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 ('0630610')
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 FTW04LA174Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Gordonville, TXThe pilot's premature lift-off and his failure to abort the takeoff. Contributing factors were the soft and muddy runway conditions and the unfavorable winds.NTSB NYC02LA125Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · York, PAThe pilot's failure to maintain proper airspeed, which resulted in a stall/mush into a corn field. A factor was the high density altitude.NTSB CHI00LA142Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sandstone, MNthe pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.NTSB NYC99FA033Accident · 1 fatalField investigationFinal reportGulfstream American AA-1 · Brooklyn, CTThe student pilot's failure to maintain control of the airplane, resulting in an inadvertent stall/spin.NTSB CHI95LA165Accident · 1 fatalLimited investigationFinal reportGrumman AA-1 · Osage Beach, MOa low altitude maneuver performed by the pilot and the pilot not maintaining the airplane's airspeed. A factor in this accident was the pilot encountering a stall/mush.NTSB CHI86FA183Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Plainfield, ILWitnesses who spoke with plt of N6135L prior to accident stated that he was acting out of character. He had a loss of appetite and his complexion was ashen grey. The plt stated that he did not feel well before the flt. Witnesses observed the acft takeoff,…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…NTSB NYC83LA138Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Mechanicsburg, PAThe acft crashed during takeoff and was destroyed when it slid over logs in the roll-out area. The pilot had 3 hours in the make and model of acft. Takeoff was from a private grass airstrip which was rough and uphill in the direction of takeoff. When a crash…NTSB DEN83LA014Accident · Minor injuriesLimited investigationFinal reportGrumman AA1 · Bicknell, UTThe pilot stated that shortly after departing the Bicknell airport, a strong downdraft forced the aircraft into the ground while approaching the lee side of a ridge line. He indicated the aircraft was at about 100 mph indicated airspeed when ground contact…NTSB DEN82DA183Accident · 1 fatalFinal reportAmerican AA1 · Opheim, MTThe pilot tookoff and made a pass over the airport. At about 500 feet the aircraft began to roll and spun to ground impact. Investigation revealed the pilot was apparently maneuvering and wing dipping for his friends on the ground when the stall occurred.