Skip to content

NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, NE

18 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

Where

Latest cases

Query with SQL

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" = 'NE' 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 ('3952802')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'NE' 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 ('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."eventStateOrRegion" = 'NE' 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 ('3952802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN23LA232Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Bloomfield, NEA partial loss of engine power during takeoff for reasons that could not be determined.Jun 7, 2023 · N48485 · Substantial damage NTSB CEN20CA347Accident · Minor injuriesClass 4 · Data collectionFinal reportGrumman G164 · Scottsbluff, NEThe pilot’s loss of visual reference during agricultural low-level flight, resulting in collision with power lines.Aug 18, 2020 · N48416 · Substantial damage NTSB CEN15LA271Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Foster, NEThe total loss of engine power during a low-level aerial application flight due to fuel exhaustion following the pilot’s inadequate preflight inspection that led to his assumption that sufficient fuel was on board for the flight based on his reliance on a…Jun 12, 2015 · N48687 · Substantial damage NTSB CEN12LA497Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Big Springs, NEThe total loss of engine power as a result of the pilot inadvertently shutting the engine off. Contributing to the accident was the modification to the engine control layout.Jul 30, 2012 · N6676Q · Substantial damage NTSB CHI04LA184Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · York, NEA loss of engine power for undetermined reasons. Contributing to the accident were the low altitude at the time of power loss and the unsuitable landing area encountered during the forced landing.Jul 16, 2004 · N48675 · Destroyed NTSB CHI02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hordville, NEA loss of engine power due to a fractured rocker arm shaf. Contributing to the accident was the soft, furrowed field.May 10, 2002 · N48485 · Substantial damage NTSB CHI99LA046Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Naponee, NEthe pilot's failure to identify the wires prior to spraying the field and the low altitude at which the pilot was flying. A factor was the wires which the airplane contacted.Dec 3, 1998 · N6676Q · Substantial damage NTSB CHI96LA287Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wellfleet, NEfailure of the pilot to maintain aircraft control, while maneuvering at low latitude. The hilly (rolling) terrain and unfavorable wind were related factors.Aug 9, 1996 · N6966K · Destroyed NTSB CHI95LA266Accident · No injuriesLimited investigationFinal reportGrumman G164B · Bloomington, NEthe disintegration of the engine's super charger bearings. Factors associated with the accident were the total failure of the engine's super charger and the unsuitable terrain surrounding the airplane's departure path encountered by the pilot.Aug 10, 1995 · N6771Q · Substantial damage NTSB CHI92DCJ05Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Atkinson, NEA cracked engine cylinder.Aug 11, 1992 · N48672 · Substantial damage NTSB CHI90LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Columbus, NEStanding water on the approach end of the runway.Aug 9, 1990 · N6745K · Substantial damage NTSB MKC89LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stockville, NETotal failure of the powerplant caused by a broken cylinder.Jul 2, 1989 · N6629Q · Substantial damage NTSB MKC84LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brule, NEAccording to the pilot, during the swath run the left wing dropped and the acft flew into the corn field. Density altitude was aprx 5,200 ft.Jul 13, 1984 · N6825K · Substantial damage NTSB MKC84LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Silver Creek, NEThe plt stated he was making an end pass while spraying a pasture & collided with a hilltop on the opposite side of a draw. This occurred while the sun was obstructing his vision.May 23, 1984 · N6677Q · Substantial damage NTSB MKC82DA116Accident · No injuriesFinal reportGrumman G164A · Ericson, NEThe aircraft was flown from the loading area to the field intended for treatment. Upon arrival, the pilot reduced power and entered an observation fly-by. When the aircraft started to settle the pilot's application of power failed to arrest the descent. The…Jul 4, 1982 · N48534 · Substantial damage NTSB MKC81DCJ25Accident · Serious injuriesClosedGrumman G-164B · Ewing, NEAug 5, 1981 · N6681Q · Destroyed NTSB MKC80DCJ28Accident · No injuriesClosedGrumman G-164B · Cambridge, NEAug 9, 1980 · N6648Q · Destroyed NTSB MKC78DCJ42Accident · No injuriesClosedGrumman G-164 · Naper, NEAug 19, 1978 · N48484 · Substantial damage