NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A
17 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164A, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 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 ('3952801')
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\" = 130))
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 ('3952801')
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" = 130))
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 CHI97LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Benton, MOthe pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…NTSB DEN93LA076Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAFailure of the spray rig which sprayed chemicals into the pilot's eyes temporarily blinding him.NTSB FTW92LA020Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Epps, LAThe loss of 1/2 of a propeller blade. Factors were powerplant vibration and resultant powerplant separation.NTSB FTW89DRD14Accident · No injuriesFinal reportGrumman G-164A · Franklin, LAFatigue failure of the propeller blade, which resulted in separation of the blade's tip and severe engine vibration. The soft terrain was a related factor.NTSB SEA89LA096Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Hermiston, ORFailure and separation of the left main landing wheel.NTSB LAX88DVA15Accident · No injuriesFinal reportSchweizer G-164A · Laton, CANTSB FTW88DRD09Accident · No injuriesFinal reportGrumman G-164A · Basile, LADuring or after lift-off, the right landing gear axle assembly separated from the landing gear leg when the mounting bolts sheared. During landing, the airplane ground-looped and then flipped to the inverted position.NTSB FTW88DRD06Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe ag plt had finished spreading his load of chemicals & was landing when the left brake failed to operate. He started to apply pwr for a go-around, but the eng coughed & did not respond properly. The plt then closed the throttle & appliedrgt brake to avoid…NTSB MIA88LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wayside, MSWhile on an aerial application flt on short final, the plt pulled the throttle lever to reduce airspeed but it broke at the power control quadrant. The apch was continued & after acft traveled aprx 1/2 the length of the rwy, he turned the magneto switch off.…NTSB FTW87DRD08Accident · No injuriesFinal reportGrumman G-164A · Lacassine, LAThe pilot stated the aircraft's tail wheel broke during the takeoff roll causing the aircraft to veer to the right. The right wing contacted a small tree and the right main gear wheel dropped into a ditch which was parallel with the runway. Directional…NTSB CHI85FER02Accident · No injuriesFinal reportGrumman 164A · Becker, MNThe plt reported the eng pwr dropped from 2000 to 1550 RPM during the aerial application flt. The plt increased throttleand advanced the prop with no increase in pwr. The acft then settled to ground impact and nosed over. Post accident inspection disclosed…NTSB FTW84LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bell City, LAA propeller counterweight bearing shaft failed after takeoff at max gross weight. A vibration occurred & the plt began dumping his load, but he was unable to maintain altitude. The aircraft landed in soft mud and nosed over when it collided with a rice levee…NTSB SEA84LA109Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Craigmont, IDDuring aerial application the engine lost power & a forced landing was initiated to a wheat field. During the landing approach the acft stalled at about 10 to 20 feet AGL. The acft landed hard and flipped over. Examination of the engine revealed a broken…NTSB MKC84LA101Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Biscoe, ARAfter spraying operations acft propeller would be pressure sprayed. Water entered propeller pitch change bearings which corroded bearings. Eventually pitch movement was hindered by rust corrosion. The blade counterweight bolt broke allowing the propeller…NTSB FTW83LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hayes, LAThe acft ran off the rt side of the rwy and collided with a dirt embankment drng lndg roll. Brake fluid was found on the l main gear following the accd. Investigation revealed the source of the leak to be a popped o-ring in the brake actuating cylinder.NTSB ATL83LA019Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Adel, GAFollowing maintenance performed on the aircraft the pilot conducted a check flight. After takeoff the pilot discovered fuel splashing on the windshield and proceeded to abort the takeoff. Upon landing the pilot lost control of the aircraft. The aircraft…NTSB FTW82DA160Accident · No injuriesFinal reportGrumman G-164A · Oberlin, LAThe pilot reported that during landing, his left brake failed. He elected to go-around. However, while maneuvering to avoid a building, the aircraft struck a rice dike and crashed. The pilot reported that the left brake thrust plate had broken during the…