Final NTSB investigations: Gulfstream-Schweizer A/C GULFSTREAM AM G-164D
6 cases on aircraft the registry lists as Gulfstream-Schweizer A/C GULFSTREAM AM G-164D. 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 |
|---|---|
| 1992 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2019 | 1 |
| 2023 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3979908'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3979908'))
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 CEN23LA197Accident · No injuriesClass 4 · LimitedFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Gueydan, LAThe failure of both pilots to see and avoid each other resulting in a collision on the airstrip. Contributing was the pilots’ failure to announce their intentions over their radios as they were taking off and landing.NTSB WPR19FA145Accident · 2 fatalClass 3 · FieldFinal reportGrumman G164 · Pleasant Grove, CAThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.NTSB DFW05LA134Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Jennings, LAThe failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.NTSB LAX98LA162Accident · No injuriesLimited investigationFinal reportSchweizer G164D · Richvale, CAThe separation of four compressor/turbine blades resulting in a sudden loss of engine power with a subsequent forced landing into unsuitable terrain.NTSB FTW92LA132Accident · No injuriesLimited investigationFinal reportSchweizer G-164D · Welsh, LAThe engine failure at liftoff due to the failure of multiple turbine blades and the pilot's inability to maintain directional control during the aborted takeoff.NTSB MIA80DKG08Accident · No injuriesClosedGrumman G-164 · Springfield, GA