NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164C, 1983
2 cases on aircraft the registry lists as Grumman Acft ENG Cor-Schweizer G-164C. 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
| 1979 | 1 |
|---|---|
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1985 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2008 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952803'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3952803'))
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 FTW83LA382Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Newport, ARThe acft caught fire during takeoff roll and continued to burn after the aborted takeoff. Prior to this flt the operatorhad experienced difficulty with the carburator on this engine. On this flt the acft was being ferried for carburetor maintenance. During…NTSB LAX83LA249Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164C · Live Oak, CAThe plt was on a flight to seed a rice field with 2 sets of power lines located near its west edge. The plt had seeded the field many times before, & reportedly, was familiar with the area. During the 1st swath run, which was from east to west, the acft…