NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A
652 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164A. 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, newest first
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 ('3952801'))
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 ('3952801'))
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 DFW05CA207Accident · No injuriesData collectionFinal reportGrumman G-164 · Knobel, ARThe loss of engine power due to the failure of the #1 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA220Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Boston, ILThe loss of engine power due to a cylinder failure and the unsuitable terrain encountered by the pilot during the forced landing.NTSB NYC05LA129Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Penn Yan, NYThe loss of engine power due to a fatigue fractured pushrod.NTSB CHI05LA211Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Buchanan, NDThe pilot failed to maintain obstacle clearance from the power lines. Factors included the glare on the windshield and the power lines.NTSB CHI05CA207Accident · No injuriesData collectionFinal reportAllied Ag Cat Productions G-164A · Trufant, MIThe pilot's inadequate visual lookout and not maintaining clearance from the watering pivot during the aerial application maneuver and the unsuitable terrain he encountered during the emergency landing. A factor was the sunglare encountered.NTSB DFW05CA186Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Tallulah, LAThe partial loss of engine power as result of the fracture of the number five-cylinder exhaust valve rocker arm mounting boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA05LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jerome, IDFailure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.NTSB IAD05CA098Accident · No injuriesData collectionFinal reportGrumman G164A · Williamstown, NJThe pilot's misjudgment of distance/altitude, and his failure to maintain obstacle clearance.NTSB DFW05CA094Accident · No injuriesData collectionFinal reportGrumman G-164A · Tuckerman, ARThe loss of engine power as result of the failure of the number nine cylinder.NTSB FTW04CA246Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe failure of a piston connecting rod for undetermined reasons resulting in the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA04LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Nyssa, ORThe failure (fracture) of the number four cylinder head during an aerial application run. Factors include the soft crop-covered terrain.NTSB SEA04LA065Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Nezperce, IDThe circumferential fracture of the number seven cylinder head while en route to an aerial fertilizer application, leading to a forced landing on soft terrain, resulting in the collapse of the right main gear leg. Factors include soft terrain at the location…NTSB CHI03LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Seneca, KSThe pilot's failure to maintain directional control while landing. Factors contributing to the accident were the collapse of the left main landing gear strut and the ditch.NTSB FTW02LA221Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Roads, LAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin of the airplane.NTSB FTW02LA194Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Basile, LAthe loss of engine power as a result of fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA111Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARThe inadequate supervision by the flight instructor of the pilot who was receiving instruction resulting in the excessive application of the brakes during the landing roll resulting in a nose over. A factor was the gusty crosswind conditions.NTSB CHI02LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164A · Cascade, IAThe pilot's inadequate preflight planning/preparation and his failure to maintain clearance with the wire. A factor associated with the accident was the wire that the airplane contacted.NTSB DEN01LA163Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Parowan, UTthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush into terrain. Contributing factors were the pilot's diverted attention, the rising terrain, and the high density altitude weather condition.NTSB CHI01LA286Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Petersburg, NEThe failure of the engine cylinder, and the unsuitable terrain for landing encountered by the pilot. Factors were the low altitude and the muddy field.NTSB CHI01LA229Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge Center, MNThe pilot not maintaining directional control on the ground during the takeoff roll. Factors relating to this accident were the total failure of the propeller governor and the corn crop.NTSB CHI01LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mandan, NDthe pilot failed to maintain clearance from the powerline. Additional factors were the thermal lift and the powerline.NTSB MIA01LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Poplarville, MSa loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.NTSB SEA01LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waitsburg, WAThe pilot's failure to maintain clearance from the power lines during a pull-up, resulting in an in-flight collision with the lines, loss of control and subsequent in-flight collision with terrain. Contributing factors were the power lines and the pilot's…NTSB MIA00LA245Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Berlin, GAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB FTW00LA097Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Gillett, ARThe cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.NTSB DEN99LA169Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Animas, NMA inadvertent stall during initial climb following takeoff. Factor were: high gross weight, high density altitude, inadequate preflight planning and preparation, and soft terrain.NTSB FTW99LA252Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Seminole, TXThe pilot's failure to maintain clearance with powerlines. A factor was the pilot's diverted attention to the light bar for the electronic swath guidance system installed in the airplane.NTSB SEA99LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · New Plymouth, IDLoss of engine power due to failure of the supercharger impeller. A contributing factor was the ditch.NTSB SEA99LA074Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAThe pilot-in-command's failure to maintain directional control during the takeoff roll and overloading of the right landing gear strut. Contributing factors were the soft takeoff surface, confined (narrow) takeoff surface, and high vegetation.NTSB MIA99LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Orlando, FLThe pilots misjudgment of altitude during an attempted banner tow pick-up. This resulted in the banner becoming entangled around the main landing gear. The pilot made a go-around. On landing rollout the banner became entangled around a runway light, and the…NTSB LAX99LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Maxwell, CAFailure of the pilot to attain and maintain the proper reference climb airspeed during the rotation and initial climb, which resulted in a stall/mush condition.NTSB FTW99LA095Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARThe pilot's failure to maintain terrain clearance during the downwind departure. Factors were the tailwind and the wet soft grass airstrip.NTSB ATL98LA128Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Goodway, ALThe pilot's continued approach into known adverse weather which resulted in the pilot's loss of control, and subsequent inflight collision with terrain. A factor was the weather conditions.NTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.NTSB LAX98LA255Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Nelson, CAThe pilot's failure to maintain an adequate ground clearance altitude while applying chemicals to a rice field.NTSB LAX98LA240Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tracy, CAThe failure of the pilot to maintain an adequate clearance with the telephone wires.NTSB FTW98LA292Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Lubbock, TXThe loss of engine power due to the collapsed of the engine induction air ducting. Factors were the inadequate maintenance inspection and the lack of suitable terrain for the pilot to execute the forced landing.NTSB FTW98LA258Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Lazbuddie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA249Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Iowa, LApartial loss of engine power during takeoff for undetermined reason(s). The obstructions (trees & dirt bank) were related factors.NTSB CHI98LA230Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Red Lake Falls, MNa locked brake for undetermined reasons.NTSB CHI98LA114Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Benton, MOan engine fire for undetermined reasons.NTSB ATL98LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Marianna, FLThe failure of maintenance personnel to secure the magneto cover that resulted in water contamination and the subsequent loss of engine power. A factor was rough and uneven terrain.NTSB FTW98LA016Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Altus, OKThe loss of engine power due to the cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA001Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Sylvania, GAThe pilots failure to maintain clearance from transmission wires.NTSB FTW97LA336Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Muleshoe, TXfailure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.NTSB MIA97LA210Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Woodeberry, TNin-flight collision with a fence during takeoff. Factors in this accident were the pilot's inadequate pre-flight by not calculating the total weight of the airplane, and high temperatures.NTSB CHI97LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Benton, MOthe pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…NTSB FTW97LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Woodsboro, TXThe loss of engine power as result of fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the unsuitable terrain available for the pilot to execute the forced landing.NTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.