NTSB investigations: Gulfstream-Schweizer A/C GULFSTREAM AM G-164B

9 cases on aircraft the registry lists as Gulfstream-Schweizer A/C GULFSTREAM AM G-164B, where the first occurrence was “In flight collision with object”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations: Gulfstream-Schweizer A/C GULFSTREAM AM G-164B per year, 1985–2026: 9 cases
1985	1
1990	1
1993	2
1994	1
1997	1
1999	1
2006	1
2007	1

Where

Open the map

Latest cases

Query with SQL

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 ('3979904') 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" = 220)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('3979904')
      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\" = 220))
  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 ('3979904')
    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" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI07CA230Accident · Minor injuriesData collectionFinal reportGulfstream-Schweizer Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's improper decision to takeoff with a tailwind which resulted in a collision with terrain immediately after liftoff. Factors contributing to the accident were the tailwind and the levee.Jul 23, 2007 · N8402K · Substantial damage NTSB DFW06CA150Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Alex, OKThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.Jun 2, 2006 · N8225K · Destroyed NTSB CHI99LA216Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Fisher, MNthe pilot's failure to maintain clearance from the crop during an aerial application spray run.Jul 6, 1999 · N8029K · Substantial damage NTSB FTW97LA276Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Palestine, ARThe pilot's failure to maintain clearance with the wire transmission line due to his diverted attention.Jul 21, 1997 · N8031K · Destroyed NTSB LAX94LA254Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Live Oak, CAFailure of the pilot to remain clear of power lines. A factor related to the accident was: the pilot's impairment due to use of drugs that were not approved for use while flying.Jun 15, 1994 · N8392K · Destroyed NTSB LAX93LA361Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Buttonwillow, CAThe pilot's failure to avoid wires.Sep 20, 1993 · N8133K · Substantial damage NTSB ATL93LA123Accident · 1 fatalLimited investigationFinal reportGulfstream G-164B · Selmer, TNThe pilot's failure to maintain adequate clearance from the power lines.Jul 2, 1993 · N8163K · Destroyed NTSB MKC90LA051Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Conway, ARThe pilot failed to attain the proper touchdown point and the delayed initiation of the go-around. Contributing to the accident was the fence struck during the aborted landing.Jan 24, 1990 · N8298K · Substantial damage NTSB MKC85FA080Accident · 1 fatalField investigationFinal reportGulfstream-Schweizer G-164B · Garland, ARThe plt was beginning a spray run over a wheat field when the acft impacted the top 3 strands of a 4 strand, high voltage power line. The acft then descended uncontrolled until impact with the terrain.Apr 1, 1985 · N8418K · Destroyed