NTSB investigations: Grumman G-164A
15 cases on aircraft the registry lists as Grumman G-164A, where the first occurrence was “Loss of engine power(total) - 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 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\" = 351))
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" = 351))
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 NYC05LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Felton, DEThe mechanic's inadequate annual inspection, and failure to comply with an airworthiness directive, which resulted in a total failure of the second stage turbine rotor.NTSB ATL00LA087Accident · No injuriesLimited investigationFinal reportGrumman G164A · Dillon, SCA total loss of engine power due to a cracked cylinder head. A factor was the emergency landing into unsuitable terrain, and the subsequent nose over.NTSB NYC00LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Toms River, NJThe failure of the number 9 cylinder connecting rod, due to a primer leak initiation of a partial hydraulic lock. A factor in the accident was the unsuitable terrain, to which the forced landing had to be made.NTSB FTW96LA329Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burlington, COThe total loss of engine power resulting from a cracked cylinder. A factor was the unsuitable terrain for the forced landing.NTSB ATL93LA134Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ashford, ALThe failure of the engine supercharger assembly, which resulted in a loss of engine power. A factor was the trees at the forced landing site.NTSB LAX91LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wasco, CAA total loss of engine power due to a fracture of the camshaft and the subsequent forced landing into a soft field.NTSB LAX90DVG07Accident · Serious injuriesFinal reportGrumman G-164A · Gridley, CAFailure of the no.7 cylinder head which led to a forced landing and substantial damage to the aircraft when it nosed over after colliding with a ditch.NTSB FTW90DRA04Accident · No injuriesFinal reportGrumman 164A · Garwood, TXFailure of the number 8 cylinder.NTSB SEA87LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Viola, IDDuring an aerial applications maneuver a total loss of power occurred due to the internal failure of the supercharger impeller. During the forced landing the left main gear collapsed causing the aircraft to nose over inverted.NTSB SEA85LA187Accident · No injuriesLimited investigationFinal reportGrumman 164A · Shelley, IDThe safety broke in the carburetor and the seat backed out causing fuel starvation. The carburetor had been overhauled 350 hours prior to the accident.NTSB DEN84LA235Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chamerlain, SDThe pilot experienced an engine failure and executed an emergency landing on a narrow road which resulted in one of the landing gear touching down on the soft shoulder. The landing gear failed and substantial damage resulted. Examination of the engine…NTSB DEN84LA204Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Page, NDEngine siezed during takeoff climb at alt of aprx 100 ft AGL. Acft contacted trees during the forced landing. Examination of engine turbo section revealed the blower section had separated as a result of bearing failure. According to a mechanic who…NTSB LAX84LA311Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Williams, CAShortly after departing the airfield, the eng lost power & the plt was unable to restart it. He landed in a soft, freshly plowed field. After rolling about 50 ft, the acft nosed over. An exam revealed that the shaft which holds the float assembly in the…NTSB ATL83LA326Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hatley, GAThe pilot reported that while spraying a cotton field at aprx 60 feet AGL when the engine made a popping sound and then lost power. The pilot landed in a cotton field where the aircraft rolled over on its back and was destroyed by the post impact fire.…NTSB ATL82DA188Accident · No injuriesFinal reportGrumman G-164A · Doddsville, MSThe pilot reported that at the end of a swath run, he noticed the smell of burned oil and saw smoke when the engine began a hard miss. He reported that these occurred when the number five cylinder failed. He made a forced landing in a flooded rice field where…