# NTSB investigations: Continental TSIO-520 series, DC

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 BFO88IA065](https://openairdocs.org/ntsb/BFO88IA065.md): Cessna T210R · Washington, DC · Incident · No injuries · Incident investigation · Final report · Jul 2, 1988 · N6286U · Minor damage
  > Improper maintenance resulting in the routing of wire which caused an electrical short and inflight smoke.
- [NTSB BFO86LA025](https://openairdocs.org/ntsb/BFO86LA025.md): Cessna 340A · Washington, DC · Accident · Minor injuries · Limited investigation · Final report · May 17, 1986 · N6828P · Substantial damage
  > The acft was reportedly too high to land on the rwy initially assigned by ATC. ATC directed the acft to fly over the arpt and enter downwind traffic for another rwy. The plt was later asked by ATC if he could make a short apch and he replied affirmative. The…
- [NTSB IAD78IA085](https://openairdocs.org/ntsb/IAD78IA085.md): Douglas DC-9 · Washington, DC · Incident · No injuries · Closed · Jul 26, 1978 · N943 · 2 aircraft · No 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 c."eventStateOrRegion" = 'DC' 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=DC

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