NTSB investigations: American AA-1
7 cases on aircraft the registry lists as American AA-1, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2003 | 1 |
Where
Latest 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\" = 353))
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" = 353))
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 MIA04CA001Accident · Minor injuriesData collectionFinal reportAmerican General AA-1 · Bartow, FLA loss of engine power due to oil starvation. Also causal was the pilot's improper maintenance.NTSB IAD97LA074Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Lewisburg, WVThe pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.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 MIA92LA078Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Leesburg, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an in flight loss of control (stall) and in flight collision with terrain. Contributing to the accident was the pilot-in-command's inadequate…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 MKC84LA020Accident · No injuriesLimited investigationFinal reportAmerican AA1 · Wiota, IAThe acft was in cruise flt at aprx 2500 ft when the eng lost power. The plt was able to restart the eng, but it ran only momentarily, then quit again. The best available place for a forced landing was a muddy, plowed field. During the landing roll, the acft…NTSB ATL83FA230Accident · Serious injuriesField investigationFinal reportGrumman AA1 · Locust Grove, GAThe acft crashed during a forced landing after the engine quit while the flt was in cruise at 3000 ft. the pilot stated that he experienced what was described as a drop in oil pressure followed by a complete power failure. The pilot attempted a forced landing…