NTSB investigations: Gulfstream-Schweizer A/C GULFSTREAM AM G-164B
14 cases on aircraft the registry lists as Gulfstream-Schweizer A/C GULFSTREAM AM G-164B, where the first occurrence was “Loss of engine power”. 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 | 3 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1994 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2007 | 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 ('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\" = 350))
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" = 350))
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 CHI07CA206Accident · No injuriesData collectionFinal reportGrumman G-164B · Alicia, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the low altitude at which the loss of power occurred and the flooded rice field in which the airplane was landed.NTSB FTW04LA182Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eagle Lake, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA232Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eunice, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pollard, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.NTSB FTW94LA131Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Delaplaine, ARThe loss of engine power for undetermined reasons. A factor was the low altitude at which the power loss occurred.NTSB FTW92DPG16Accident · No injuriesFinal reportGulfstream G-164B · Holly Grove, ARLoss of engine power undetermined. Factor was unsuitable terrain.NTSB MIA92LA184Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Poplarville, MSA reported loss of engine power for undetermined reasons resulting in a forced landing and in flight collision with trees.NTSB FTW91DPG13Accident · Serious injuriesFinal reportGrumman G-164B · Mc Crory, ARLoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.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 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 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 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…