Fatal NTSB investigations: Gulfstream American AA-5B
8 cases on aircraft the registry lists as Gulfstream American AA-5B. 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
| 1980 | 2 |
|---|---|
| 1982 | 2 |
| 1991 | 1 |
| 1997 | 1 |
| 2000 | 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.\"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 ('3970106'))
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 ('3970106'))
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 CEN09FA340Accident · 2 fatalField investigationFinal reportGulfstream American AA-5B · Humbird, WIThe pilot's decision to attempt a visual flight rules flight into an area of known instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB FTW00FA235Accident · 4 fatalField investigationFinal reportGulfstream American AA-5B · Barrett, TXthe pilot's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent stall. A contributing factor was the loss of engine power for undetermined reasons.NTSB MIA97FA217Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Naples, FLleaking fuel cap(s), due to inadequate maintenance/repair, which resulted in water contamination of the fuel; inadequate preflight by the flight crew; and improper planning/decision by the flight crew. Factors relating to the accident were: high obstructions…NTSB NYC91FA174Accident · 3 fatalField investigationFinal reportGulfstream American AA5B · Columbia, CTThe decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…NTSB FTW83FPM02Accident · 1 fatalFinal reportAmerican AA-5B · 3 1/2 Nm Ene Di, OKWitnesses stated that the aircraft bounced at touchdown, a go-around was attempted and the aircraft struck a powerline at the end of the runway. The aircraft impacted the ground approximately 1/4 mile southeast of the runway. The accident occurred at dusk.NTSB NYC82FA148Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Newburg, PAThe pilot on a personal cross-country flew into trees on a slope of blue mountain, PA at the 2284 foot level. The weather in the area was foggy and the mountain tops were obscured in clouds. There is no record of a weather briefing or communication by the…NTSB FTW81FA005Accident · 4 fatalClosedGrum Amer AA-5B · Madill, OKNTSB MKC80FA057Accident · 3 fatalClosedGulf-Amer AA-5B · Chesterfield, MO