# NTSB investigations: Continental GTSIO-520-C, NY

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 ERA22LA317](https://openairdocs.org/ntsb/ERA22LA317.md): Cessna T210F · Monticello, NY · Accident · No injuries · Class 3 · Limited · Final report · Jul 15, 2022 · N6195R · Destroyed
  > Maintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.
- [NTSB NYC06FA015](https://openairdocs.org/ntsb/NYC06FA015.md): Cessna 411 · East Hampton, NY · Accident · 1 fatal · Field investigation · Final report · Oct 23, 2005 · N7345U · Destroyed
  > The pilot's failure to maintain airspeed, while maneuvering with the left engine inoperative. Contributing to the accident were the failure of the left engine, and the pilot's lack of multiengine certification.
- [NTSB NYC91LA108](https://openairdocs.org/ntsb/NYC91LA108.md): Cessna 402A · Albany, NY · Accident · No injuries · Limited investigation · Final report · Apr 7, 1991 · N104EC · Substantial damage
  > A collapse of the nose gear due to a failure of the nose gear trunion.
- [NTSB NYC74DFA29](https://openairdocs.org/ntsb/NYC74DFA29.md): Beech V35 · Monticello, NY · Accident · No injuries · Closed · Apr 27, 1974 · N9456S · Substantial damage
- [NTSB NYC74FHJ20](https://openairdocs.org/ntsb/NYC74FHJ20.md): Cessna 421 · Farmingdale, NY · Accident · No injuries · Closed · Jan 27, 1974 · N3126K · Substantial damage
- [NTSB NYC73AN084](https://openairdocs.org/ntsb/NYC73AN084.md): Cessna 421 · Cheektowaga, NY · Accident · 3 fatal · Closed · Dec 16, 1972 · N121X · Destroyed
- [NTSB NYC73FFA11](https://openairdocs.org/ntsb/NYC73FFA11.md): Cessna 210 · Hudson, NY · Incident · No injuries · Closed · Aug 23, 1972 · N6176R · Minor damage
- [NTSB NYC68F0053](https://openairdocs.org/ntsb/NYC68F0053.md): Cessna 210T · Elmira, NY · Accident · No injuries · Closed · Jun 3, 1967 · N6176R · 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 c."eventStateOrRegion" = 'NY' 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 ('17035'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17035&state=NY

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