NTSB investigations: American AA-1A, FL
14 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.
Cases per year
| 1972 | 1 |
|---|---|
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 2 |
| 1978 | 3 |
| 1984 | 1 |
| 1990 | 1 |
| 1998 | 1 |
| 2007 | 1 |
| 2009 | 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\" = 'FL' 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" = 'FL' 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" 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 ERA10CA046Accident · Minor injuriesData collectionFinal reportAmerican AA1 · Lake Placid, FLThe pilot's failure to maintain clearance from a power line.NTSB MIA07LA072Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Lakeland, FLThe pilot's inadequate preflight. Contributing to the pilot's injuries was his failure to wear the installed shoulder harness.NTSB ATL98LA034Accident · No injuriesLimited investigationFinal reportAmerican General AA-1A · Orlando, FLThe pilot's failure to maintain flying speed.NTSB MIA90FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Sebastian, FLFailure of the AA-1A pilot to see-and-avoid the Piper PA-28 which had entered traffic first. A factor related to the accident was: failure of the PA-28 pilot to see the American AA-1A, when the AA-1A was on a base leg and the PA-28 was further out on final…NTSB MIA84LA155Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Lake Harbor, FLThe plt adjusted the mixture twice during his descent from 2500 ft MSL. The second adjustment killed the engine and a forced landing was made in a sugar cane field. Post accident examination revealed that the engine mixture control cable was broken. A…NTSB MIA78FKT34Accident · Serious injuriesClosedGrumman TR2 · N.Bay Village, FLNTSB MIA78DLA17Accident · No injuriesClosedAmer Avco AA1A · Havana, FLNTSB MIA78FA034Accident · 1 fatalClosedAmer Avco AA1-A · Ormond Beach, FLNTSB MIA77FLD21Accident · No injuriesClosedGrum Amer AA-1B · St.Cloud, FLNTSB MIA76FLA61Accident · Minor injuriesClosedGrum Amer AA-1A · Keystone Higts, FLNTSB MIA74FLD62Accident · Minor injuriesClosedAmer Avco AA-1A · Tampa, FLNTSB MIA74AM032Accident · No injuriesClosedAmer Avco AA1-A · Venice, FLNTSB MIA74DLD31Accident · No injuriesClosedAmer Avco AA-1A · Tampa, FLNTSB MIA72DKT58Accident · No injuriesClosedAmer Avco AA-1A · Boca Raton, FL