NTSB investigations: American AA-1
5 cases on aircraft the registry lists as American AA-1, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 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\" = 260))
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" = 260))
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 NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.NTSB CHI98LA234Accident · No injuriesLimited investigationFinal reportAmerican AA-1TW · Point Lookout, MOthe failure of the tailwheel assembly due to corrosion. A factor associated with the accident was the overload failure of the right main landing gear.NTSB ATL95LA104Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Rock Hill, SCAn inoperative left main wheel brake that resulted in a loss of directional control. A factor was the wet, grass runway.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…NTSB LAX84FUJ05Accident · No injuriesFinal reportGrumman American AA1 · Mesa, AZThe acft went off the rwy during a landing in a 15-25 kt wind. The plt said a gust of wind swerved the acft off the rwy. The plt attempted a go-around but realized he could not make it in the dirt so he cut the throttle. The acft rolled intoa ditch and nosed…