NTSB investigations: Schweizer G-164B
13 cases on aircraft the registry lists as Schweizer G-164B, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2025 | 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA25LA342Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Dover, DEThe pilot’s exceedance of the critical angle of attack which resulted in an aerodynamic stall at an altitude too low to recover.NTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA277Accident · Serious injuriesData collectionFinal reportGrumman G164 · Pearsall, TXThe pilot's failure to maintain clearance from power lines during low-altitude maneuvering.NTSB WPR19LA137Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sutter, CAA loss of engine power due to the in-flight separation of the fuel control unit interconnect rod for reasons that could not be determined due to lack of available evidence.NTSB WPR18LA113Accident · 1 fatalLimited investigationFinal reportSchweizer G 164B · Stockton, CAThe pilot's failure to maintain clearance with power lines while maneuvering during an aerial application flight.NTSB WPR18LA015Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Tracy, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB GAA16CA326Accident · No injuriesData collectionFinal reportSchweizer G 164 · Cummings, NDThe pilot's failure to maintain an adequate rate of descent while landing, which resulted in a hard landing, short of the runway.NTSB GAA15CA266Accident · Minor injuriesData collectionFinal reportSchweizer G 164B · Paxton, NEThe pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.NTSB WPR14LA322Accident · 1 fatalLimited investigationFinal reportSchweizer G 164B · Tulelake, CAThe pilot's failure to maintain clearance from power lines while maneuvering during low-altitude operations.NTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.NTSB WPR10CA444Accident · Minor injuriesData collectionFinal reportSchweizer 164B · Murtaugh, IDThe pilot’s inadequate compensation for the wind and failure to maintain directional control during the takeoff roll.NTSB WPR10LA365Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Prescott, WAThe airplane’s inability to maintain a positive rate of climb after takeoff for undetermined reasons. Contributing to the accident was the pilot’s delayed reaction to initiate an emergency release of the spray mixture.NTSB CHI08CA262Accident · No injuriesData collectionFinal reportSchweizer G-164B · Nielsville, MNThe pilot's failure to maintain directional control of the airplane during the crosswind landing. Factors associated with the accident were the crosswind and the rough terrain.