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 FTW97LA136Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Swifton, ARthe pilot's improper in-flight planning/decision and failure to maintain positive control of the airplane, while performing an aerobatic maneuver.NTSB LAX96LA299Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Caruthers, CAthe loss of engine power due to the failure of a cylinder. The road's soft surface was a factor.NTSB CHI96LA281Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164 · Grant, NEfatigue failure and subsequent catastrophic failure of the number nine cylinder. A factor was the corn.NTSB ATL96LA117Accident · No injuriesLimited investigationFinal reportGrumman G164 · Dawson, GAloss of engine power for undetermined reason(s), which resulted in an overrun, an encounter with soft terrain, and a nose over.NTSB SEA96LA176Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Belgrade, MTloss of engine power for undetermined reason(s). A factor relating to the accident was: a ditch in the field where the forced landing was executed.NTSB ATL96LA116Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mayersville, MSfailure of the pilot to maintain adequate clearance from an object (vehicle) on the ground.NTSB SEA96LA172Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dubois, IDfailure of the pilot to remain clear of an irrigation spray device, which resulted in inadvertent water ingestion and flameout of the aircraft's turboprop engine. Factors relating to the accident were: the proximity of the irrigation spray device (close to…NTSB CHI96LA265Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Macksville, KSfailure of the pilot to allow the airplane to achieve sufficient airspeed for takeoff, and the resultant loss of aircraft control. Factors relating to the accident were: the rough runway, and the mound of dirt at the end of the runway.NTSB CHI96LA247Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dighton, KSloss of engine power for undetermined reason(s). The crop and soft terrain in the emergency landing area were related factors.NTSB SEA96LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164A · New Plymouth, IDa cracked cylinder head, which resulted in partial loss of engine power during takeoff. Factors relating to the accident were: the pilot allowed the gross weight of the airplane to be exceeded, and tall wheat (crop) in the emergency landing area.NTSB FTW96LA272Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Holyoke, COthe total failure of the engine main bearing. A factor was the soft terrain condition on which the forced landing was made.NTSB SEA96LA112Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAfailure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.NTSB LAX96LA204Accident · 1 fatalLimited investigationFinal reportGrumman G-164 · Colusa, CAfailure of the pilot to remain clear of the power lines. Factors relating to the accident were: Lack of visual cues at dawn, and the power lines.NTSB NYC96LA105Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Vineland, NJfailure of the number 8 cylinder, which resulted in loss of engine power, a forced landing in soft terrain, and subsequent nose over of the airplane.NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dewitt, ARa loss of engine power due to the malfunction of the carburetor as a result of an improper overhaul. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA007Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamburg, ARLoss of engine power due to a cylinder failure. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB ATL95LA172Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lynchburg, SCThe failure of the magneto mount pad, which resulted in a malfunction of the magneto timing and partial loss of engine power. A factor relating to the accident was: high vegetation in the emergency landing area.NTSB FTW95LA361Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Holyoke, COthe pilot's failure to maintain terrain clearance.NTSB FTW95LA371Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot to execute the forced landing.NTSB CHI95LA260Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A-450 · Grand Forks, NDthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the sunglare.NTSB SEA95LA165Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Buhl, IDThe loss of power due to the failure of an engine cylinder. The chemical load was not dumped for undetermined reasons and contributed to the severity of injuries.NTSB FTW95LA317Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA297Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe loss of engine power due to a failed supercharger/blower. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA293Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Simmesport, LAThe loss of engine power as result of the failure of the number 7 cylinder. A factor was the lack suitable terrain for the forced landing.NTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB FTW95LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cheneyville, LAThe pilot's failure to maintain adequate airspeed at a low altitude.NTSB FTW95LA254Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cash, ARThe loss of engine power for undetermined reasons. Factors were the low altitude at which the power loss occurred and the lack of suitable terrain for a forced landing.NTSB FTW95LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAThe pilot's failure to clear a levee during the approach. A factor was a truck parked on the runway.NTSB MIA95LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Zellwood, FLA loss of aircraft climb capability after the banner pickup for an undetermined reason. A factor related to the accident was: soft terrain in the emergency landing area.NTSB LAX95LA192Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Colusa, CAthe pilot's misjudged flare height and timing, which resulted in an inadvertent stall and hard landing. Factors in the accident were the loss of engine power for undetermined reasons and the lack of a suitable forced landing area.NTSB FTW95LA202Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Joes, COA total loss of power due to fuel exhaustion. Factors were: a malfunction in the fuel measuring system, the pilot's failure to perform fuel consumption calculations, and soft and unsuitable terrain for a forced landing.NTSB FTW95LA197Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe inadvertent stall.NTSB LAX95LA186Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Richvale, CAthe pilot's failure to maintain a glidepath adequate to avoid an obstacle, and his inadequate compensation for the wind.NTSB LAX95LA126Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Robbins, CAA failure of the engine master rod. A factor in the accident was the soft, wet condition of the field available for the forced landing.NTSB ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.NTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.NTSB ATL94LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vanceboro, NCThe pilot's improper use of wheel brakes.NTSB FTW94LA211Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dumas, ARThe pilot's failure to establish the proper airspeed before beginning a turn after takeoff.NTSB LAX94LA247Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Bakersfield, CAThe in-flight fire due to the spontaneous combustion of sulfur dust and subsequent forced landing. A factor was the high temperature.NTSB ATL94GA111Accident · No injuriesFinal reportGrumman G-164A · Savannah, GAThe pilot's improper landing flare which resulted in a hard landing. A factor was the operators failure to provide a formal emergency dump procedure.NTSB FTW94LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWas the pilots failure to maintain terrain clearance.NTSB FTW94LA145Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXThe partial loss of engine power due to one magneto being weak and the other magneto arcing inside its case. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Alexandria, NEThe pilot's failure to maintain clearance with wires.NTSB FTW94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lindon, COInaccurate preflight planning and preparation for the flight. A factor was soft terrain on the landing strip.NTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.NTSB LAX94LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Davis, CAwas that the pilot misjudged the airplane's altitude during the swath run.NTSB FTW94LA042Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB NYC94LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Madisonville, KYthe pilot's inadequate preflight preparation and his inadequate visual lookout in flight which resulted in the collision with wires.NTSB SEA93LA198Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164A · Dayton, WAThe pilot in command's failure to maintain proper clearance from the power lines. The unmarked power lines were a factor.