NTSB investigations: Grumman G-164A
13 cases on aircraft the registry lists as Grumman G-164A, where the first occurrence was “Loss of engine power(partial) - mech failure/malf”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 2000 | 2 |
| 2004 | 1 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952704')
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\" = 352))
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 ('3952704')
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" = 352))
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 LAX05LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Yuba City, CAa partial loss of engine power due to multiple cracks in the number 7 cylinder. The reasons for the cracks were not determinedNTSB IAD04LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chatsworth, NJA blocked internal oil passage, which resulted in inadequate lubrication of the blower impeller shaft, and the subsequent partial loss of engine power.NTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.NTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.NTSB FTW93LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Weiner, ARPartial power loss due to improper installation of the linkage control bracket. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91DPG03Accident · No injuriesFinal reportGrumman G-164A · Earle, ARA power loss for undetrmined reasons. A factor was the muddy/soft terrain in which the forced landing was performed.NTSB MKC90LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARPartial loss of engine power for an undetermined reason.NTSB MKC90LA067Accident · No injuriesLimited investigationFinal reportGrumman AG-CAT G-164A · Parkin, ARTotal failure of the engine's master connecting rod.NTSB CHI89DEX06Accident · No injuriesFinal reportGrumman G-164A · Sullivan, INA failure of the supercharger oil seal which resulted in a partial loss of engine power during takeoff and the uncontrolled touchdown during the forced landing. Factors related to the accident were: partial failure of the supercharger and spark plub fowling.NTSB MKC88LA161Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARWhile en route to engage in an aerial application operation, the plt said the engine began to misfire and cut out. Unable to correct the malfunction, the plt dumped his chemical load and began returning to the departure airstrip. En route, he felt he would…NTSB FTW86LRD12Accident · No injuriesFinal reportGrumman G-164A · Branch, LAShortly after takeoff, a partial power loss occurred & the plt made a forced landing in a soft plowed field, where the acft nosed over onto its back. The plt rprtd the loss of power was due to failure of the eng blower.NTSB FTW85LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Progreso, TXShortly after takeoff, plt heard explosive report from engine and experienced partial pwr loss. Plt attempted to return for landing but could not maintain sufficient altitude. Load not jettisoned. During forced landing roll out in cane field acft nosed over.…NTSB ATL83LA348Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Clinton, KYThe plt reported that he was spraying a field that was bordered by obstacles. When he was about half way thru a procedure turn, the eng began 'backfiring & losing power.' The plt moved the throttle to about the 1/2 power setting, hoping the condition would be…