NTSB investigations: Schweizer G-164B, FL
6 cases on aircraft the registry lists as 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 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 ('8059055'))
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 ('8059055'))
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 MIA95LA008Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLFailure of the pilot to refuel resulting in loss of engine power due to fuel exhaustion.NTSB MIA93LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in a stall/mush.NTSB MIA91LA169Accident · No injuriesLimited investigationFinal reportGrumman G164B · Immokalee, FLLoss of enine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encounteered during the forced landing.NTSB MIA86LA084Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Homestead, FLThe plt stated that she had completed one spray pass with one ton of fertilizer aboard & pulled up in a turn to about 200 ft. at that time the acft 'hit a pocket of dead air.' The acft nosed down and although the plt dumped the chemical load, she could not…NTSB MIA85LA091Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Panama City, FLPlt was landing on a city street so the acft could be put on display. When the acft overran the end of the street the plt locked the brakes to avoid contacting buildings and vehicles and the acft nosed over.NTSB MIA84LA020Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Ormond Beach, FLThe acft is a twin-engine conversion of the Grumman G-164B. The plt was on a local test flt with the hopper filled with water to simulate flt conditions near the operating gross weight of the acft. After lift-off a partial power loss was experienced on the #2…