# NTSB investigations: Continental TSIO-520 series, CT

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 NYC05LA074](https://openairdocs.org/ntsb/NYC05LA074.md): Beech A36TC · Southbury, CT · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2005 · N3810X · Substantial damage
  > The failure of the counter weight aft snap ring to hold the associated plate and pin in place, which resulted in a total loss of engine power.
- [NTSB IAD02LA090](https://openairdocs.org/ntsb/IAD02LA090.md): Cessna T210N · Glastonbury, CT · Accident · No injuries · Limited investigation · Final report · Aug 26, 2002 · N4908C · Substantial damage
  > A partial loss of engine power for undetermined reasons. A factor in the airplane's damage was the standing corn.
- [NTSB NYC83FA228](https://openairdocs.org/ntsb/NYC83FA228.md): Beech 58PA · Danbury, CT · Accident · Serious injuries · Field investigation · Final report · Aug 28, 1983 · N158JB · Destroyed
  > Inbound to Danbury the plt was advised that the arpt was closed, & was given the last wx which was an hour old. The acft was observed to pass over the arpt 300-400 ft AGL & circle to land rwy 8. The acft turned base & final in a tight turn with the gear down.…
- [NTSB NYC83LA079](https://openairdocs.org/ntsb/NYC83LA079.md): Cessna T210L · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Mar 20, 1983 · N121RJ · Substantial damage
  > According to an FAA interview, while on approach the plt did not identify the runway lights properly and landed to the left of the edge lights to runway 34. The acft landed off the runway in soft turf and the nose gear collapsed.

## 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" = 'CT' 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=CT

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