NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, AZ
14 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 per year
| 1973 | 2 |
|---|---|
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1983 | 3 |
| 1984 | 2 |
| 1989 | 1 |
| 1991 | 1 |
Where
Open the mapLatest 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\" = 'AZ' 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 ('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."eventStateOrRegion" = 'AZ' 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 ('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 LAX91LA413Accident · Minor injuriesLimited investigationFinal reportGrumman G164A-450 · Queen Creek, AZFailure of the engine cylinder, producing a loss of power. Contributing to the accident was the location of an irrigation ditch next to the landing area and a dark night light condition.NTSB LAX89DUJ11Accident · No injuriesFinal reportGrumman G-164 · Mohave Valley, AZA loss of engine power for undetermined reasons.NTSB LAX84LA474Accident · No injuriesLimited investigationFinal reportGrumman 164A · Goodyear, AZPlt reported pwr loss occurred during night aerial application. Acft nosed over during forced landing in crop field. Investigation failed to reveal any evidence of a mechanical failure/malfunction. Engine was test run to extent permitted by damage and no…NTSB LAX84LA380Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · El Mirage, AZThe plt was practicing takeoffs & landings with about 800 lbs of water on board. After turning downwind for his second landing, he experienced a loss of airspeed & the acft started to sink into power lines. He released the emergency dump gate, at which time,…NTSB LAX83LA385Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mohave Valley, AZDuring takeoff after reaching about 15 ft AGL, the plt heard a 'loud bang' & the acft shuddered. Immediately thereafter a substantial loss of power occurred. The plt stated he decreased the acft's pitch attitude to avoid stalling. Seconds later the left wing…NTSB LAX83LA332Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Buckeye, AZAfter takeoff the acft flew about 1/4 mile when the engine started running rough. The pilot jettisoned his load but could not maintain alt. The acft made a forced landing in a plowed field 3/4 mile from the service strip. An examinationof the engine revealed…NTSB LAX83LA128Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Williams Afb, AZWhile on a spray run, the eng lost power. Subsequently, the acft was damaged during a forced landing.NTSB LAX80DUJ86Accident · No injuriesClosedGrumman G-164A · Cotton Center, AZNTSB LAX79FUK23Accident · Serious injuriesClosedGrumman G-164A · Roll, AZNTSB LAX77DUJ77Accident · No injuriesClosedGrumman G-164A · Elfrida, AZNTSB LAX76DUK03Accident · No injuriesClosedGrumman G-164A · Gila Bend, AZNTSB LAX75DUJ22Accident · No injuriesClosedGrumman G-164A · Buckeye, AZNTSB LAX74DUJ16Accident · No injuriesClosedGrumman G-164A · Arlington, AZNTSB LAX73DUJ90Accident · No injuriesClosedGrumman G-164A · Chandlr Hts, AZ