NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164A, FL
13 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 | 1 |
|---|---|
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 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\" = 'FL' 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" = 'FL' 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 MIA99LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Orlando, FLThe pilots misjudgment of altitude during an attempted banner tow pick-up. This resulted in the banner becoming entangled around the main landing gear. The pilot made a go-around. On landing rollout the banner became entangled around a runway light, and the…NTSB ATL98LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Marianna, FLThe failure of maintenance personnel to secure the magneto cover that resulted in water contamination and the subsequent loss of engine power. A factor was rough and uneven terrain.NTSB MIA95LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Zellwood, FLA loss of aircraft climb capability after the banner pickup for an undetermined reason. A factor related to the accident was: soft terrain in the emergency landing area.NTSB MIA91LA183Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenwood, FLThe inadequate preflight which resulted in debris in the cockpit which reduced the pilot's visual lookout. Unsuitable terrain encountered during the landing was a factor.NTSB MIA87FA022Accident · 1 fatalField investigationFinal reportGrumman G-164A · Orlando, FLWhile the plt was making a banner pick-up, witnesses saw the acft engage the banner & enter a climb. The plt released the banner, then the acft mushed into a partially built hangar, crashed & burned. The plt, who was on fire, exited the rgt canopy hatch.…NTSB MIA83LA135Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Clewiston, FLThe plt had just washed the acft & went for a short local flt to dry it. He made a low pass at the arpt & the acft stalled during the pull-up.NTSB MIA79DKT32Accident · No injuriesClosedGrumman G-164A · Moore Haven, FLNTSB MIA79DKT26Accident · No injuriesClosedGrumman G-164A · Belle Glade, FLNTSB MIA77DKT66Accident · No injuriesClosedGrumman G-164A · Clewistown, FLNTSB MIA76DLD85Accident · No injuriesClosedGrumman G-164A · Bushnell, FLNTSB MIA76FLD31Accident · No injuriesClosedGrumman G-164A · Zellwood, FLNTSB MIA74DLD87Accident · No injuriesClosedGrumman G-164A · Leesburg, FLNTSB MIA74DLD11Accident · No injuriesClosedGrumman G-164A · Zolfo Springs, FL