# NTSB investigations: Engineering & Research 415-C, WA

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 SEA86FA239](https://openairdocs.org/ntsb/SEA86FA239.md): Ercoupe 415-C · Auburn, WA · Accident · No injuries · Field investigation · Final report · Sep 5, 1986 · N99313 · Destroyed
  > The plt reported he was climbing after a touch and go, during the climb the 'blown fuse' light came on for the generator. After replacing the fuse sparks started coming from behind the instrument panel. Smoke filled the cockpit as the plt tried to smother the…
- [NTSB SEA79DYE14](https://openairdocs.org/ntsb/SEA79DYE14.md): Erco 415-C · Auburn, WA · Accident · No injuries · Closed · Feb 18, 1979 · N3276H · Substantial damage
- [NTSB SEA74FYC37](https://openairdocs.org/ntsb/SEA74FYC37.md): Erco 415-C · Vancouver, WA · Accident · Serious injuries · Closed · Mar 9, 1974 · N2243H · Substantial damage
- [NTSB SEA72AS006](https://openairdocs.org/ntsb/SEA72AS006.md): Erco 415-C · Cle Elum, WA · Accident · 2 fatal · Closed · Aug 14, 1971 · N99265 · Destroyed

## 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" = 'WA' 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 ('0420302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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