# NTSB investigations: Wright R-1820 series, 2003

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 ATL03FA147](https://openairdocs.org/ntsb/ATL03FA147.md): Grumman HU-16C · Fort Pierce, FL · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2003 · N70258 · Destroyed
  > A loss of engine power due to the pilot placing the fuel selector in the off position which resulted in fuel starvation to the left engine, after the pilot intentionally shut down the right engine.
- [NTSB LAX03FA162](https://openairdocs.org/ntsb/LAX03FA162.md): North American T28C · Sherman Oaks, CA · Accident · 2 fatal · Field investigation · Final report · May 24, 2003 · N537Z · Destroyed
  > The pilot's in-flight loss of control due to spatial disorientation. Factors in the accident were the distraction caused by the malfunctioning mode C altitude reporting system, and the location of the transponder control head, which necessitated repeated…
- [NTSB FTW03WA137](https://openairdocs.org/ntsb/FTW03WA137.md): Grumman HU-16 · Chetumal, Mexico · Accident · 3 fatal · Foreign investigation · Apr 14, 2003 · N7026Y · 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 year(c."eventDate") = 2003
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=67020&year=2003

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