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

7 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164B, where the first occurrence was “In flight collision with object”. 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 per year

19902026
NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, AR per year, 1990–2026: 7 cases
19901
19911
19932
19961
20011
20071

Latest cases

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.\"eventStateOrRegion\" = 'AR' 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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.

NTSB CHI07CA131Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Humphrey, ARThe pilot's failure to maintain sufficient clearance between the airplane and the power lines. A factor was the power lines.May 4, 2007 · N668FA · DestroyedNTSB 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 · DestroyedNTSB FTW96LA232Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARfailure of the pilot to maintain clearance from the power line.May 31, 1996 · N6678Q · Substantial damageNTSB FTW93LA172Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate clearance.Jun 2, 1993 · N48659 · DestroyedNTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.May 26, 1993 · N8405K · DestroyedNTSB 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 · DestroyedNTSB FTW90DPG14Accident · Minor injuriesFinal reportGrumman G-164B · Dumas, ARThe inadvertent stall encountered during the turn to reverse direction.Sep 4, 1990 · N48602 · Substantial damage