NTSB investigations: Grumman G-164A
18 cases on aircraft the registry lists as Grumman G-164A, 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
| 1982 | 3 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 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\" = 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.
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" = 220))
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 SEA98LA140Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Caldwell, IDThe pilot-in-command's misjudgment of clearance with a power line, resulting in a collision with the line. Factors included a power line and dark night light conditions in the spray area.NTSB SEA97LA172Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pingree, IDThe pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.NTSB CHI96LA310Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Galesburg, ILfailure of the pilot to maintain clearance from trees that protruded into the field that he was spraying.NTSB LAX91LA186Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Madera, CAFailure of the pilot to maintain adequate clearance from the guy wire.NTSB LAX91LA088Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Merced, CAA disoriented and intoxicated automobile driver entering the runway in front of the departing aircraft.NTSB NYC90DHA01Accident · 1 fatalFinal reportGrumman G-164A · Hunlock Creek, PAThe pilot's failure to maintain adequate clearance from obtacles, and his failure to see and avoid the electrical transmission line.NTSB FTW89DRD05Accident · Minor injuriesFinal reportGrumman G-164A · Gueydan, LAVisual lookout was not maintained by the pilot in command, which resulted in the collision with a power transmission line during a swath run.NTSB MKC88LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hebron, NEWhile making a aerial application swath run, the pilot was checking his spray booms because of some malfunctioning nozzles. Exiting the field between two groups of trees on the border he failed to see power line poles. He struck the wires, then the terrain,…NTSB FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…NTSB BFO88DIG03Accident · Serious injuriesFinal reportGrumman G-164A · Sleepy Creek, MDDuring the aerial application flight the airplane struck and severed three power lines. The pilot stated he did not see the lines until it was too late. The airplane caught fire and continued on its flight path crossing a highway and a river. The airplane…NTSB ATL87DKG07Accident · Serious injuriesFinal reportGrumman G-164A · Alamo, GAThe acft was rprtd to be on an agricultural spraying assignment. The plt took off in the single seat acft with a passenger aboard. About 5 min after depg the arpt, the acft collided with trees & crashed after making an unscheduled low pass over an open field.…NTSB ATL87DEI08Accident · Minor injuriesFinal reportGrumman G-164A · Bucyrus, OHAs the plt was apchg a field to spread fertilizer, the acft collided with a tree & crashed to the ground. The plt received a head injury & said he could not recall the acdnt. According to hospital records, he was suffering from pneumonia & had a 101 deg temp…NTSB MKC87LA050Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A-600 · Hazen, ARThe pilot stated that he had flown six loads of wheat seeds and was returning to a private airstrip for another load when he ran out of daylight while on final approach to a landing. During the time he was considering the option of a rejected landing and a…NTSB LAX87DVA02Accident · No injuriesFinal reportSchweizer G-164A · Fresno, CAThe airplane collided with telephone lines while conducting an aerial application operation. The pilot reported that he was familiar with the area. He surveyed the field, in flight, before he commenced the spraying activities. The pilot did not report, nor…NTSB FTW85FPJ01Accident · Serious injuriesFinal reportGrumman AG CAT G-164 · Norman, OKThe acft collided with a high static wire on an electric transmission line before colliding out of control with the ground. The plt stated after the accident that he forgot about the static line and flew into it during a maneuver for aerial spraying.NTSB LAX82DA271Accident · Minor injuriesFinal reportGrumman G-164A · Chandler, AZWhile spraying at night & during the fourth pass under power lines crossing the field, the acft contacted the wires. After the accident the flagger at the field informed the plt that the wind was causing the wires to whip up & down at times.NTSB FTW82DA257Accident · No injuriesFinal reportGrumman G-164A · Epps, LAThe pilot stated that while he was spraying crops, he looked into the cockpit during a turn to check the amount of solution that was remaining. He stated that when he looked up, he was too low to complete the turn and miss the trees. He went to full power and…NTSB MKC82DA093Accident · Minor injuriesFinal reportGrumman G-164A · Red Cloud, NEThe aircraft struck the top wire of an electrical transmission line and crashed. The pilot reported that he misjudged the "wire distance" as he let down over a pond to begin a swath run. The pond was at the edge of the field that he was seeding. The pilot…