NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B, IL
7 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164B. 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
| 1980 | 2 |
|---|---|
| 1990 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2018 | 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\" = 'IL' 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 ('3952802'))
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" = 'IL' 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 ('3952802'))
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 GAA18CA401Accident · No injuriesData collectionFinal reportGrumman G164 · Rochelle, ILThe pilot’s failure to move the power lever to the proper position before takeoff, which resulted in insufficient airspeed and a subsequent aerodynamic stall.NTSB CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB CHI04LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Bradford, ILThe pilot's misjudgment of speed and distance, and his failure to perform a go-around. Additional factors were the wet runway and the ditch.NTSB CHI98LA251Accident · No injuriesLimited investigationFinal reportGrumman G-164B · New Haven, ILWater contamination of the fuel system. A related factor was the swampy terrain.NTSB CHI90DEV04Accident · No injuriesFinal reportGrumman G-164B · Princeton, ILThe pilot-in-command's failure to maintain adequate clearance from obstacles during flight at low altitude, resulting in wire strike.NTSB CHI80FEV31Accident · No injuriesClosedGrumman 164B · Maroa, ILNTSB CHI80FEV27Accident · No injuriesClosedGrumman G-164B · Atlanta, IL