# NTSB investigations: Snow 600-S2C: Fire

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 ATL83LA347](https://openairdocs.org/ntsb/ATL83LA347.md): Snow 600-S2C · Blackshear, GA · Accident · No injuries · Limited investigation · Final report · Aug 31, 1983 · N1635S · Substantial damage
  > The pilot stated that during a spray run, a vibration was felt, the engine backfired and flames erupted from the right underside of the cowling. Power was lost continuously until over the landing strip at 50 feet AGL when all power was lost. The acft landed…
- [NTSB CHI83LA341](https://openairdocs.org/ntsb/CHI83LA341.md): Snow 600-S2C · Plainfield, WI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1983 · N1678S · Destroyed
  > The acft caught fire in the air after a power loss. A forced landing was accomplished and the pilot escaped without injury but the acft was destroyed by the fire. It was reported that the fire was so intense that all evidence of cause was destroyed. The acft…

## 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 ('8380302')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 171))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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