# NTSB investigations: Continental TSIO-520 series, 2003, Outside the U.S.

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 MIA03FA141](https://openairdocs.org/ntsb/MIA03FA141.md): Cessna 402C · Treasure Cay, Bahamas · Accident · 2 fatal · Class 1 · Field · Final report · Jul 13, 2003 · N314AB · Substantial damage
  > the in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…
- [NTSB CHI03WA198](https://openairdocs.org/ntsb/CHI03WA198.md): Beech BE-58TC · Toronto, Canada · Accident · 1 fatal · Foreign investigation · Jul 7, 2003 · N6058T · Substantial damage
- [NTSB LAX03WA205](https://openairdocs.org/ntsb/LAX03WA205.md): Cessna T210L · Anahim Lake, Canada · Accident · No injuries · Foreign investigation · Jun 18, 2003 · N210VC · Substantial damage
- [NTSB MIA03WA126](https://openairdocs.org/ntsb/MIA03WA126.md): Cessna 402B · LittleWhale Cay, Bahamas · Accident · No injuries · Foreign investigation · Jun 17, 2003 · N3748C · 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 year(c."eventDate") = 2003
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17040&state=OF&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.