# NTSB investigations, WA: Loading

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 WPR13LA217](https://openairdocs.org/ntsb/WPR13LA217.md): Robinson R44 II · Pomeroy, WA · Accident · No injuries · Limited investigation · Final report · May 2, 2013 · N442RN · Substantial damage
  > The pilot's failure to ensure that the helicopter was properly loaded, which resulted in the helicopter being in excess of its maximum allowable gross weight and led to a loss of main rotor rpm on takeoff. Contributing to the accident were the ground…
- [NTSB WPR12CA294](https://openairdocs.org/ntsb/WPR12CA294.md): Omlin Robert G Exec 162F Rotorway · Quincy, WA · Accident · No injuries · Data collection · Final report · Jul 5, 2012 · N385AR · Substantial damage
  > The pilot’s failure to ensure that a flag attached to the landing skid was properly secured, which resulted in its in-flight separation and contact with the tail rotor.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010115'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010115/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
