# NTSB investigations: Grumman Acft ENG Cor-Schweizer G-164B: Unknown or undetermined

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN23LA232](https://openairdocs.org/ntsb/CEN23LA232.md): Grumman Acft ENG Cor-Schweizer G-164B · Bloomfield, NE · Accident · No injuries · Class 3 · Limited · Final report · Jun 7, 2023 · N48485 · Substantial damage
  > A partial loss of engine power during takeoff for reasons that could not be determined.
- [NTSB CEN20LA278](https://openairdocs.org/ntsb/CEN20LA278.md): Grumman G164 · Springfield, CO · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 10, 2020 · N6917K · Destroyed
  > The pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…
- [NTSB CEN14LA301](https://openairdocs.org/ntsb/CEN14LA301.md): Grumman Acft ENG Cor-Schweizer G-164B · Lake City, AR · Accident · No injuries · Limited investigation · Final report · Jun 18, 2014 · N993QC · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN10CA510](https://openairdocs.org/ntsb/CEN10CA510.md): Grumman Acft ENG Cor-Schweizer G-164B · Basile, LA · Accident · No injuries · Data collection · Final report · Aug 27, 2010 · N63E · Substantial damage
  > The loss of directional control during landing due to failure of the right brake for undetermined reasons.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 ('3952802')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/000/sequence?model=3952802

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.