Skip to content

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

24 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

19812026

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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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 CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…Jul 10, 2020 · N6917K · Destroyed NTSB CHI04LA220Accident · 1 fatalLimited investigationFinal reportAllied Ag Cat Productions G-164B · Moville, IAThe pilot's inadequate in-flight planning/decision by his failure to maintain obstacle clearance. Contributing factors were low altitude flying and the tree.Aug 11, 2004 · N48424 · Destroyed NTSB FTW01LA203Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Lydia, LAthe pilot's failure to maintain clearance with a marked tower while maneuvering.Sep 5, 2001 · N48655 · Destroyed NTSB CHI01LA273Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Hazelton, NDthe pilot's ostentatious display when he performed a low level manuever and stalled the airplane.Aug 11, 2001 · N48624 · Destroyed NTSB FTW01LA136Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Powhatan, ARthe pilot's failure to maintain obstacle clearance while maneuvering after takeoff.Jun 6, 2001 · N48721 · Destroyed NTSB LAX00LA285Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Tracy, CAThe pilot's failure to maintain adequate clearance from obstacles while maneuvering during an aerial application flight.Aug 1, 2000 · N6737K · Destroyed NTSB FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.Jul 15, 2000 · N428KG · Destroyed NTSB FTW99FA150Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G164-B · Brinkley, ARThe pilot's inadvertent VFR flight into instrument meteorological conditions. Contributing factors were the pilots failure to maintain control of the aircraft, spatial disorientation, and the fog.May 26, 1999 · N8285K · Destroyed NTSB SEA98LA138Accident · 2 fatalLimited investigationFinal reportRockwell S-2R · Burley, IDA failure of both pilots to see and avoid each other's aircraft due to inadequate visual lookout.Jul 16, 1998 · N5036X · 2 aircraft · Substantial damage NTSB CHI97LA278Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Larimore, NDthe pilot delaying the swath run turnaround maneuver at the end of the field boundary, and his failure to maintain clearance between the airplane and the high tension wires. A factor was the pilot's inattentiveness regarding the time to begin the swath run…Sep 3, 1997 · N8326K · Destroyed 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.Nov 16, 1994 · N48398 · Substantial damage NTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.Aug 12, 1994 · N48664 · Destroyed NTSB FTW94FA262Accident · 1 fatalField investigationFinal reportGrumman G-164B · Henderson, LAThe pilot's failure to maintain clearance from a known object.Aug 5, 1994 · N6804Q · Destroyed NTSB FTW94FA241Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Foules, LAThe pilot's failure to maintain obstacle clearance.Jul 21, 1994 · N6617Q · Destroyed NTSB MIA92WA023Accident · 1 fatalForeign investigationGrumman G-164B · La Romana, Dominican RepublicNov 6, 1991 · N90514 · Destroyed NTSB LAX91LA332Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Arizona City, AZFailure of the pilot to maintain an adequate visual outlook to avoid the collision with the power transmission lines. Contributing to the accident was the dark night light conditions that prevailed at the time of the accident.Jul 28, 1991 · N6681Q · Destroyed NTSB FTW91LA103Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Brighton, AR(1) The pilot's failure to maintain adequate clearance from the wires and (2) the wire's subsequent interference with the flight controls.Jun 19, 1991 · N48370 · Destroyed NTSB LAX90DUG05Accident · 1 fatalFinal reportGrumman G-164B · Blythe, CAFailure of the pilots of N6708K and N10222 to maintain adequate visual lookout and failure of the pilot of N6708K to follow a prearanged procedure for reversing the direction of flight.Apr 19, 1990 · N6708K · 2 aircraft · Destroyed NTSB LAX90DVG04Accident · 1 fatalFinal reportGrumman G-164B · Esparto, CAThe pilot misjudged the airplane's clearance with the transmission wires.Apr 4, 1990 · N8011K · Destroyed NTSB MIA86FA202Accident · 1 fatalField investigationFinal reportGrumman G-164B · Sidon, MSThe right wings of the ag operator's bi-plane collided with the ground support cables of a 322 ft high microwave tower while on a base leg for landing. The right wings separated & the acft crashed & burned killing the plt. The 25000 hr plt knew of the tower…Jul 10, 1986 · N48593 · Destroyed NTSB MIA86FA200Accident · 1 fatalField investigationFinal reportGrumman G-164B · Vega Baja, PRThe plt of the Grumman ag cat allowed 2 parachutists to board the resticted catagory acft for a parachute jumping flt. Each parachutist was positioned on a wing with his arm crooked around the respective wing center strut. After takeoff, the parachutist on…Jul 5, 1986 · N6915K · No damage NTSB ATL84FA105Accident · 1 fatalField investigationFinal reportGrumman G-164B · Dawson, GAA failed cylinder head assembly resulted in a total power loss very shortly after takeoff. Witnesses observed the aerial application acft at 30-50 ft AGL over the rwy before it pulled up steeply, rolled and entered a near vertical uncontrolled descent to…Feb 19, 1984 · N6558K · Destroyed NTSB SEA81FYP18Accident · 1 fatalClosedGrumman G-164B · Harrison, IDMay 23, 1981 · N48574 · Substantial damage NTSB FTW81DA093Accident · 2 fatalClosedGrumman G-164B · Danbury, TXMay 19, 1981 · N6821K · Destroyed