# NTSB investigations: Snow 600-S2C, AR

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 FTW72FPG06](https://openairdocs.org/ntsb/FTW72FPG06.md): Snow 600S2C · Waldenburg, AR · Accident · No injuries · Closed · Jul 10, 1971 · N1657S · Substantial damage
- [NTSB FTW69F0516](https://openairdocs.org/ntsb/FTW69F0516.md): Snow S2C · Almyra, AR · Accident · No injuries · Closed · May 27, 1969 · N1678S · Substantial damage
- [NTSB FTW68F0226](https://openairdocs.org/ntsb/FTW68F0226.md): Snow S2C · Harrisburg, AR · Accident · Serious injuries · Closed · Sep 21, 1967 · N1602S · Destroyed
- [NTSB FTW67F0233](https://openairdocs.org/ntsb/FTW67F0233.md): Snow 600S2C · Bay, AR · Accident · No injuries · Closed · Aug 29, 1966 · N1670S · 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."eventStateOrRegion" = 'AR' 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 ('8380302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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