NTSB investigations: American AA-1A
7 cases on aircraft the registry lists as American AA-1A, 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1994 | 1 |
| 2004 | 1 |
| 2005 | 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 ('0630710')
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 ('0630710')
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 IAD05FA069Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Levittown, PAThe pilot's improper in-flight planning which resulted in a total loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and uncontrolled…NTSB CHI04LA238Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Eudora, KSA loss of engine power due to fuel starvation resulting from the pilot's selection of a fuel tank with an insufficient quantity remaining.NTSB ATL95FA022Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Gastonia, NCThe pilot's failure to adequately plan the fuel requirements for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power. The pilot also failed to maintain flying airspeed which resulted in a loss of control, during the…NTSB FTW85LA216Accident · No injuriesLimited investigationFinal reportGrumman AA1A · Sweetwater, TXThe acft was destroyed when it flipped over during a forced landing following fuel starvation. The fuel selector was positioned on an empty tank. The right fuel tank was full of fuel. The plt stated he must have forgotten to switch tanks.NTSB FTW85LA063Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Spearman, TXPlt had pulled up form a low pass over cattle when eng quit. Plt cited probable carburetor icing but did not use carb heat. In turn to emergency landing area, acft speed decayed and acft mushed into ground, colliding with a ditch.NTSB MKC83LA118Accident · No injuriesLimited investigationFinal reportGulfstream American AA1A · Wichita, KSPrior to the flt to Wichita, the plt received a local night checkout with a CFI at olathe. The flt then departed olthe a 2030. As the plt began his descent for a landing at witchita mid-continent arpt the eng quit. He was given a vector tocol. James jabara…NTSB SEA82DA153Accident · Minor injuriesFinal reportAmerican AA-1A · Paulsbo, WAAfter demonstrating a practice forced landing approach, a climb was started. Short thereafter, the engine lost power and an actual forced landing was made in a wooded area. The aircraft was damaged beyond economical repair when it struck trees during the…