NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B
426 cases on aircraft the registry lists as Grumman Acft ENG Cor-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, 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 ('3952802'))
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 ('3952802'))
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 CHI95LA217Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Kenmare, NDthe pilot's not obtaining/maintaining proper climb rate.NTSB SEA95LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Helena, MTThe loss of engine power for undetermined reasons.NTSB FTW95LA392Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Springlake, TXThe loss of engine power due to the uncontained failure of the third stage turbine wheel. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB LAX95LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAa loss of engine power due to a separation of the number 6 cylinder, and the nose over during the subsequent forced landing.NTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.NTSB SEA95LA094Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Stayton, ORA power loss for undetermined reason(s). A factor was the soft terrain.NTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.NTSB FTW95FA047Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G-164B · Wisner, LAThe pilot's failure to maintain minimum required airspeed for flight. A factor was the pilot's lack of total experience in the type of aircraft.NTSB FTW95LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Oak Grove, LAThe pilot misjudged clearance from the vehicle.NTSB MIA94LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Greenwood, MSThe improper decision of the pilot to execute a precautionary landing to an unprepared field due to a supercharger shaft failure.NTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.NTSB FTW94LA266Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Matagorda, TXA power loss due to cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA262Accident · 1 fatalField investigationFinal reportGrumman G-164B · Henderson, LAThe pilot's failure to maintain clearance from a known object.NTSB FTW94FA241Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Foules, LAThe pilot's failure to maintain obstacle clearance.NTSB SEA94LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Wilder, IDThe failure of the left brake master cylinder and the pilot's inadequate remedial action when the aircraft collided with an embankment during an intentional ground loop.NTSB CHI94DCA02Accident · Minor injuriesFinal reportSchweizer G-164B · Harviell, MOthe separation of the oil supply line to the propeller governor, which resulted in the propeller inadvertently going into feather. Factors were the pilots intentional ground loop of the airplane to avoid impacting obstructions at the end of the runway.NTSB FTW94LA187Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Carlisle, ARThe loss of engine power for undetermined reason. A factor ws the lack of suitable terrain at the pilot's disposal for the forced landing.NTSB FTW94LA178Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Antonito, COThe pilot's improper compensation for wind conditions. A factor was the gusty crosswind and the pilot inadvertently becoming lost.NTSB FTW94LA177Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Casscoe, ARThe inadvertent stall and power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Memphis, TNThe pilot's failure to maintain clearance from the earthen dike during the swath run.NTSB LAX94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe pilot's improper use of the brakes.NTSB ATL94LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ozark, ALA loss of engine power for undetermined reasons. A factor was the soft terrain.NTSB SEA94LA092Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Levan, UTThe left main landing gear wheel bearing broke resulting in the wheel jamming and the airplane nosing over.NTSB LAX94LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Chico, CAthe failure of the pilot to obtain/maintain sufficient flying speed during a downwind takeoff and climb, compounded by his reluctance to use full available takeoff power.NTSB SEA94LA072Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Walla Walla, WAUnsuitable terrain for a forced landing after a loss of power due to a failed engine cylinder. Factors include a partial magneto failure.NTSB MIA93LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Benton, MSThe pilot-in-command's failure to maintain proper visual outlook.NTSB FTW93LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pioneer, LAThe failure by both pilots to maintain visual lookout. Factors were the inadequate radio communications by both pilots, and the departing pilot's failure to follow procedures and directives.NTSB SEA93LA168Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Ephrata, WAInadequate visual lookout by both pilots, resulting in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: failure of the Grumman 164B pilot to adequately monitor the UNICOM frequency.NTSB CHI93LA303Accident · No injuriesLimited investigationFinal reportSchweizer G167B · Borup, MNthe loss of engine power due to a cracked cylinder head.NTSB CHI93LA263Accident · No injuriesLimited investigationFinal reportGrumman G164B · Wyndmere, NDthe pilot's decision to land on unsuitable terrain. Factors in the accident are the wet and soft turf runway.NTSB CHI93LA254Accident · No injuriesLimited investigationFinal reportGrumman G164B · Eldred, MNthe pilot's failure to maintain directional control during the takeoff roll.NTSB FTW93LA179Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe pilot's failure to have the airplane properly attended during start when people were available. A factor was the inadequate tie down rope.NTSB FTW93LA175Accident · No injuriesLimited investigationFinal reportGrumman G-164B · St. Martinville, LAThe pilot's and tractor driver's inadequate visual lookoutNTSB FTW93LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARThe pilot's selection of the downwind runway for landing. Factors were the wind conditions and the left brake malfunction for undetermined reasonsNTSB FTW93LA172Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate clearance.NTSB LAX93LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Madera, CAThe pilot's failure to maintain directional control. A factor related to this accident was the left quartering tailwind.NTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.NTSB FTW93LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arnaudville, LAThe loss of engine power for undetermined reasons. A factor was the unsuitable terrainNTSB FTW93LA089Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Indian Village, LALanding performed short of the runway threshold. Factor was wet grassy terrainNTSB CHI92DTG04Accident · No injuriesFinal reportGrumman G-164B · Grandin, NDThe cracked cylinder which resulted in a forced landing. The lack of suitable terrain on which to make an emergency landing was a factor.NTSB CHI92DCJ05Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Atkinson, NEA cracked engine cylinder.NTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.NTSB LAX92LA325Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Visalia, CAThe pilot's improper stowage of an aerosol spray can in the cockpit which caused an electrical short and an ensuing fire, and his failure to maintain directional control of the aircraft during the subsequent aborted takeoff.NTSB LAX92LA259Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe failure of the pilot to maintain an adequate wing tip clearance between the aircraft and a dirt bank paralleling the airstrip.NTSB FTW92DPG02Accident · Minor injuriesFinal reportGrumman G-164-B · Mcdougal, ARThe pilots failure to properly plan his take off. A factor was his lack of familiarity with the chemical dispensing equipment.NTSB FTW92LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which the ensuing forced landing could be executed.NTSB LAX92LA215Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAThe pilot's failure to maintain directional control and improper use of the brakes.NTSB FTW92LA143Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate terrain clearance. A factor was the loss of power as result of the uncoupling of the engine and the propeller.NTSB FTW92LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roanoke, LAThe locking of the main landing gear brakes.