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

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 CHI07LA154](https://openairdocs.org/ntsb/CHI07LA154.md): Cessna 421 · Chesterfield, MO · Accident · Serious injuries · Limited investigation · Final report · May 23, 2007 · N4082L · Substantial damage
  > Maintenance personnel failed to comply with an Airworthiness Directive which resulted in the total failure of the starter adapter gear teeth and the crankshaft gear teeth and the pilot failed to follow the published emergency procedures. Contributing to the…
- [NTSB CHI02LA117](https://openairdocs.org/ntsb/CHI02LA117.md): Cessna 411 · Lee's Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 2002 · N411CT · Destroyed
  > The pilot failed to maintain control of the airplane during the inital takeoff climb. Factors associated with the accident were the pilot's inadequate preflight of the airplane, the separation of the emergency exit, and the pilot's lack of a multi-engine…
- [NTSB MKC79FA044](https://openairdocs.org/ntsb/MKC79FA044.md): Cessna 401 · St.Louis, MO · Accident · No injuries · Closed · Jul 26, 1979 · N8299F · Substantial damage
- [NTSB MKC78FCG15](https://openairdocs.org/ntsb/MKC78FCG15.md): Cessna 421B · St.Joseph, MO · Accident · No injuries · Closed · Jan 27, 1978 · N5433J · Substantial damage
- [NTSB MKC74FCG43](https://openairdocs.org/ntsb/MKC74FCG43.md): Cessna 421 · Springfield, MO · Accident · No injuries · Closed · Jun 14, 1974 · N4572L · 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" = 'MO' 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=MO

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