NTSB investigations: Gulfstream-Schweizer A/C GULFSTREAM AM G-164B
76 cases on aircraft the registry lists as Gulfstream-Schweizer A/C GULFSTREAM AM G-164B. 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, newest first
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 ('3979904'))
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'))
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 FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.NTSB FTW89DRD10Accident · 1 fatalFinal reportGrumman G-164-B · Mer Rouge, LAThe failure of the individual struck by the taxiing airplane's propeller to visually perceive and avoid the airplane.NTSB MKC89LA129Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Wynne, ARUnsuitable terrain selected by the pilot. A contributing factor was the rough/uneven landing area.NTSB ATL88DKG18Accident · No injuriesFinal reportGrumman G-164B · Smithville, GASoon after takeoff from a private sod airstrip for aerial application maneuvering, the engine lost power. The plt was forced to land in soft muddy terrain where the acft nosed over. Post acc invest revealed that the float assy in the carburetor jammed which…NTSB FTW88DRA08Accident · No injuriesFinal reportGrumman G-164 · Palacios, TXThe plt stated that following a normal landing, he applied too much brake, causing the wheels to lock up. This, in turn, caused dead grass and mud to accumulate in front of the wheels. The acft subsequently flipped over and slid to a stop inverted.NTSB MIA87LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pope, MSThe plt stated that after he made a swath run he was turning back for another run when the eng coughed & quit. He then landed in a field & on rollout he was closing in on some trees so he applied the brakes & the acft nosed over & came to rest inverted. Post…NTSB ATL87DLT02Accident · Minor injuriesFinal reportGulfstream-Schweizer G164B-600 · Union City, TNThe ag-acft lost power while turning, shortly after departure from a field. During the subsequent forced ldg, the acft struck a fence and nosed over. The engine was torn from the acft during the impact sequence. Post-crash examination of the acft engine by an…NTSB LAX85LA332Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer Gulfstream AM G-164B · Poston, AZThe plt reported weather conditions during the night aerial application flt were 'clear and winds of 15 KTS with gusts to 20 KTS. After three unsuccessful attempts to line up for the spray run, the plt said he allowed the acft to 'get too low and slow' while…NTSB MKC85LA095Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Earle, ARDuring takeoff from a farm strip, the eng lost power shortly after lift-off. The plt landed straight ahead; however, during the landing roll, the acft encountered a low, wet area & nosed over. An exam of the eng revealed about a cup of water in the carburetor…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.NTSB MKC84LA210Accident · No injuriesLimited investigationFinal reportGrumman G164B · Mc Gehee, ARThe acft was engaged in an aerial application flt when the eng lost power. The plt made a forced landing in a bean field. During the landing roll, the acft struck a levee that was obscured by high vegetation & nosed over. A post-accident investigation…NTSB LAX83FUJ17Accident · No injuriesFinal reportGulfstream-Schweizer G-164B · Queen Creek, AZThe eng lost power & the acft nosed over in a soft plowed field. The #1 cylinder articulating rod had separated.NTSB FTW83LA029Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Pine Bluff, ARPilot just loaded seeds and tookoff when he noticed smoke and the engine lost power. During a forced landing the aircraft nosed over. Cause of power loss undetermined.NTSB ATL82DA204Accident · No injuriesFinal reportGulfstream G-164B · Edison, GAWhile landing on a private sod strip to reload, the aircraft began pulling to the right. The pilot stated that all efforts to counteract with left brake, rudder, and power had no effect. Subsequently, the right wing struck a fence and the plane flipped over…NTSB FTW82DA237Accident · Minor injuriesFinal reportGrumman G164B · Beedeville, ARThe agricultural aircraft lost power during takeoff. The pilot jettisoned the load and made a forced landing in a rice field. During the landing, the aircraft nosed over in soft muddy terrain.NTSB FTW82DA217Accident · No injuriesFinal reportGrumman G164B · Bono, ARThe aircraft was loaded with 1700 pounds of fertilizer and 70 gallons of fuel. The aircraft would not climb out of ground effect. During the forced landing the aircraft nosed over. The aircraft burned after impact.NTSB FTW82DA164Accident · No injuriesFinal reportGrumman G-164B · Houston, TXAfter takeoff the engine lost power and the aircraft was landed in a plowed field. During the landing roll the aircraft nosed over. An engine teardown revealed water and contamination of the fuel system.NTSB FTW82DA094Accident · No injuriesFinal reportGulfstream American G-164B · Holly Grove, ARThe agricultural pilot was aligning the aircraft to begin a swath run when the engine began to lose power. He noted a loss of manifold and oil pressure as well as black smoke from the exhaust. He turned away from the field and collided with trees rather than…NTSB FTW81DPG55Accident · Minor injuriesClosedGrumman G-164B · Bono, ARNTSB FTW81DRA42Accident · No injuriesClosedGrumman G-164B · Sealy, TXNTSB MKC81DCJ20Accident · No injuriesClosedGrumman G-164B · Ravenna, NENTSB FTW81DPG22Accident · No injuriesClosedGrumman G-164B · Coy, ARNTSB LAX81FVG18Accident · Serious injuriesClosedGrumman G-164B · Robbins, CANTSB SEA80FYP40Accident · Minor injuriesClosedGulf-Schwzr G-164B · Ritzville, WANTSB MIA81DKT58Accident · No injuriesClosedGrumman G-164 · South Bay, FLNTSB FTW80FPG29Accident · 1 fatalClosedGrumman G-164B · Minturn, AR