NTSB investigations: Gulfstream-Schweizer A/C GULFSTREAM AM G-164B
6 cases on aircraft the registry lists as Gulfstream-Schweizer A/C GULFSTREAM AM G-164B, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1995 | 1 |
| 2000 | 2 |
| 2004 | 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\" = 351))
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" = 351))
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 FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA178Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Welsh, LAThe excessive wear of the reduction gearbox's 1st stage sungear, which resulted in its subsequent fatigue fracture and failure. Factors were the operator not performing the recommended overhaul of the engine, and a lack of suitable terrain for the forced…NTSB SEA00LA082Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Ephrata, WALoss of engine power due to failure of the number three cylinder exhaust valve push rod. Soft terrain encountered during the landing roll-out was a factor.NTSB FTW95LA185Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Morse, LAPower loss due to a cracked intake valve pipe assembly. A factor was the lack of suitable terrain for the forced landing.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.