NTSB investigations: Schweizer G-164B
10 cases on aircraft the registry lists as Schweizer 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
| 1986 | 1 |
|---|---|
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 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 ('8059055')
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 ('8059055')
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 DEN06CA105Accident · No injuriesData collectionFinal reportSchweizer G-164B · Joes, COA loss of engine power due to the failure of the supercharger. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB SEA04LA125Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wendell, IDA cracked cylinder head which resulted in a loss of engine power while maneuvering. High vegetation was a factor.NTSB CHI02LA238Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Sturgis, MIThe failure of the turbine section of the engine, and the unsuitable terrain encountered for the forced landing. The low altitude was a factor.NTSB LAX00LA278Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons.NTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.NTSB FTW98LA275Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hazen, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB CHI95LA080Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brule, NELoss of engine power due to undetermined reasons.NTSB LAX94LA019Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Arvin, CAthe loss of power for undetermined reasons.NTSB MIA91LA169Accident · No injuriesLimited investigationFinal reportGrumman G164B · Immokalee, FLLoss of enine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encounteered during the forced landing.NTSB MIA86LA150Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Shelby, MSAfter departure while making a turn the pilot reported the engine lost power and the aircraft settled into the trees. There was no evidence of a preexisting mechanical failure/malfunction.