Fatal NTSB investigations: Gulfstream American AA-5A
7 cases on aircraft the registry lists as Gulfstream American AA-5A. 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
| 1979 | 1 |
|---|---|
| 1988 | 1 |
| 1994 | 1 |
| 1999 | 1 |
| 2008 | 1 |
| 2015 | 1 |
| 2021 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3970104'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3970104'))
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 ERA21FA232Accident · 1 fatalClass 3 · FieldFinal reportGulfstream American AA-5A · Crossville, TNA partial loss of engine power due to carburetor icing, which resulted in a descent and impact with terrain. Contributing to the accident was the pilot’s failure to apply carburetor heat following the initial loss of engine power.NTSB ERA15FA220Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Rowdy, KYThe noninstrument-rated pilot’s decision to continue visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB DEN08FA152Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Baxter Pass, COThe pilot's failure to maintain adequate airspeed during a turn, resulting in an unrecoverable aerodynamic stall.NTSB ATL99FA127Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Carthage, MSThe pilot-in-command's failure to maintain altitude clearance while maneuvering. A factor was the pine trees.NTSB ATL95FA005Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Lexington, NCThe pilot's operation of the aircraft with a known deficiency (foreign material or particle in the pitot tube), which led to a false airspeed indication and premature lift-off of the aircraft during takeoff, and the pilot's improper remedial action that…NTSB LAX88LA133Accident · 1 fatalLimited investigationFinal reportGulfstream American AA5A · Union City, CADuring a pleasure flight, the airplane collided with a power line tower. The airplane was consumed by fire. The weather at the time of the accident was reported to be instrument meteorological conditions with low fog. The pilot did not file an instrument…NTSB CHI79FA083Accident · 4 fatalClosedGrum Amer AA-5A · Urbana, OH