NTSB investigations: American AA-1, NY
9 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.
Cases per year
| 1968 | 2 |
|---|---|
| 1970 | 2 |
| 1972 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1993 | 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.\"eventStateOrRegion\" = 'NY' 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" = 'NY' 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" 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 NYC93FA133Accident · 2 fatalField investigationFinal reportAmerican General AA-1 · Vestal, NYThe loss of engine power due to fuel starvation from a fuel leak caused by inadequate maintenance by unqualified personnel, the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB NYC84FA107Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Scriba, NYAcft was located, after a 4 day search, in a gravel pit 8 miles from point of departure. Wreckage examination revealed acft collided with terrain in vertical descent with nil forward speed. Investigation of power plant revealed no evidence of torque or power…NTSB NYC83LA223Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Dunkirk, NYAt aprx 0955 EDT, the plt took off from schenectady, NY with 24 gal of fuel on board. About 2 1/2 hrs later, while on a downwind to land at Dunkirk, NY, he applied carburetor heat & then the eng lost power. The carburetor heat was shut off & a restart was…NTSB NYC83FA083Accident · 1 fatalField investigationFinal reportGrumman AA-1 · Missing Acft, NYThe non-instrument rated pilot called ground control and requested a VFR departure. He was advised that the field was IFR and an IFR clearance was needed. The pilot filed an IFR flight plan and about 15 min later called for his clearance. He had trouble…NTSB NYC72DHM50Accident · No injuriesClosedAmer Avco AA1 · Montgomery, NYNTSB NYC71FHJ16Accident · Minor injuriesClosedAmer Avco AA-1 · Bohemia, NYNTSB NYC71AN022Accident · 2 fatalClosedAmer Avco AA-1 · Pawling, NYNTSB NYC69D0250Accident · No injuriesClosedAmer Yankee AA-1 · Oneonta, NYNTSB NYC69F0286Accident · No injuriesClosedAmer Avco AA-1 · Bayport, NY