# Fatal NTSB investigations: Snow 600-S2C

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 MKC88DPG02](https://openairdocs.org/ntsb/MKC88DPG02.md): Snow 600-S2C · Almyra, AR · Accident · 2 fatal · Final report · Jul 30, 1988 · N1671S · 2 aircraft · Destroyed
  > Two ag aircraft were spraying the same field. According to several witnesses, 1671S was heading south and 3660X was heading east. Both aircraft were actively engaged in the spraying operation but did not seem to the witnesses to be coordinating with each…
- [NTSB FTW76FRG09](https://openairdocs.org/ntsb/FTW76FRG09.md): Snow S-2C · Donna, TX · Accident · 1 fatal · Closed · Jul 26, 1975 · N1690S · Destroyed
- [NTSB LAX72FVM28](https://openairdocs.org/ntsb/LAX72FVM28.md): Snow 600S2C · Paso Robles, CA · Accident · 1 fatal · Closed · Apr 1, 1972 · N1644S · Destroyed
- [NTSB OAK70F0042](https://openairdocs.org/ntsb/OAK70F0042.md): Snow S2C · Huron, CA · Accident · 1 fatal · Closed · Jul 10, 1969 · N1636S · Destroyed
- [NTSB LAX69F0135](https://openairdocs.org/ntsb/LAX69F0135.md): Snow 600S2C · Winterhaven, CA · Accident · 1 fatal · Closed · Sep 17, 1968 · N1679S · Destroyed
- [NTSB FTW69F0014](https://openairdocs.org/ntsb/FTW69F0014.md): Snow S2C · Ville Platte, LA · Accident · 1 fatal · Closed · Jun 13, 1968 · N1618S · Substantial damage

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8380302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=8380302

---
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.