NTSB investigations: Schweizer G-164B, TX
6 cases on aircraft the registry lists as Schweizer 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 per year
| 1989 | 1 |
|---|---|
| 1994 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2019 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8059055'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8059055'))
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 GAA19CA277Accident · Serious injuriesData collectionFinal reportGrumman G164 · Pearsall, TXThe pilot's failure to maintain clearance from power lines during low-altitude maneuvering.NTSB FTW03CA180Accident · No injuriesData collectionFinal reportSchweizer G-164B · Vega, TXThe failure of the left brake for undetermined reasons.NTSB FTW00LA200Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Moscow, TXthe failure of the power output reduction gear to the propeller. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Collegeport, TXThe pilot's improper planning/decision by attempting to takeoff in an overweight condition from an 1,800 foot runway. Factors were the wet and soft condition of the runway.NTSB FTW94LA122Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Mount Bellvue, TXThe pilot's failure to maintain directional control. Factors were the soft runway and gusty winds.NTSB FTW89DRG04Accident · No injuriesFinal reportSchweizer G-164B · Austwell, TXPilot's selection of an unsuitable landing area (terrain). High vegetation and rough terrain were contributing factors.