# Final NTSB investigations: Continental TSIO-520 series, 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 ERA23LA101](https://openairdocs.org/ntsb/ERA23LA101.md): Cessna 340A · Atlantic Ocean, Turks & Caicos Islands · Accident · No injuries · Class 4 · Limited · Final report · Jan 3, 2023 · N824BC · Substantial damage
  > A fuel system malfunction for reasons that could not be determined, which resulted in fuel starvation to both engines.
- [NTSB MIA07LA073](https://openairdocs.org/ntsb/MIA07LA073.md): Piper PA-46-310P · Bird Cay, Bahamas · Accident · 2 fatal · Limited investigation · Final report · Apr 10, 2007 · N444JH · Destroyed
  > The pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.
- [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 MIA78DA082](https://openairdocs.org/ntsb/MIA78DA082.md): Cessna T210 · Great Inagua, Burkina Faso · Accident · 2 fatal · Closed · Apr 5, 1978 · N761EM · Destroyed
- [NTSB LAX77OA005](https://openairdocs.org/ntsb/LAX77OA005.md): Cessna 210 · Santa Inez, Mexico · Accident · No injuries · Closed · Feb 15, 1977 · N999PC · Minor damage
- [NTSB LAX77OA004](https://openairdocs.org/ntsb/LAX77OA004.md): Cessna 210L · Puerta Vlarta, Mexico · Accident · Serious injuries · Closed · Jan 27, 1977 · N5121V · Destroyed
- [NTSB LAX75OL013](https://openairdocs.org/ntsb/LAX75OL013.md): Cessna 210T · Buena Vista, Mexico · Accident · No injuries · Closed · Jun 7, 1974 · N6109R · Substantial damage
- [NTSB LAX67D0078](https://openairdocs.org/ntsb/LAX67D0078.md): Cessna 206 · Guaymas, Mexico · Accident · No injuries · Closed · Mar 22, 1966 · N4801F · 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."eventCountry" <> 'USA'
  AND c."completionStatus" = 'Completed'
  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&status=final

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