NTSB investigations: Gulfstream American AA-5B
5 cases on aircraft the registry lists as Gulfstream American AA-5B, where the first occurrence was “Hard landing”. 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 | 2 |
| 1989 | 1 |
| 1990 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3970106')
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\" = 200))
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 ('3970106')
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" = 200))
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 DEN91LA021Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Erie, COImproper flare by the pilot, which resulted in a hard landing. A realted factor was: low light condition at dusk.NTSB NYC89LA210Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · South Harpswell, MEA delay by the pilot in aborting a late go-around. Factors related to the accident were: the pilot's improper flare for landing, his improper recovery from the subsequent bounced landing, and tree(s) near the runway.NTSB CHI83FA353Accident · No injuriesField investigationFinal reportGulfstream AA-5B · West Chicago, ILThe plt reported that during a night landing, the acft began to porpoise. He applied power to go around, but the plane went off the left side of the rwy. Subsequently, it collided with brush & a chain link fence & came to rest on residential property. The plt…NTSB CHI83LA293Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Kentland, INDuring arrival, the plt landed on rwy 27 with a left x-wind from the south. He stated that he had no indication of excessive x-winds or gusts until the acft was about to touch down. He stated that at that time, the plane encountered heavy gusts & a downdraft.…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.