# NTSB investigations: Continental GTSI0-520-F-K, 2002

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 FTW03FA055](https://openairdocs.org/ntsb/FTW03FA055.md): Cessna 421C · Tajique, NM · Accident · 1 fatal · Field investigation · Final report · Dec 4, 2002 · N3855C · Destroyed
  > The pilot's failure to maintain terrain clearance. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making.
- [NTSB MIA02LA089](https://openairdocs.org/ntsb/MIA02LA089.md): Cessna 421C · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 2002 · N237SM · Substantial damage
  > the fracture of the landing gear upper barrel due to fatigue cracking, caused by improper machining after the barrel was assembled during the manufacturing process, resulting in damage to the airplane.
- [NTSB SEA02LA046](https://openairdocs.org/ntsb/SEA02LA046.md): Cessna 421C · Hailey, ID · Accident · No injuries · Limited investigation · Final report · Mar 2, 2002 · N421DG · Substantial damage
  > Water contamination within the aircraft's landing gear hydraulic line(s) which froze and blocked the line(s) preventing extension of the right main gear. A factor was the below freezing environmental conditions which the aircraft was operating in prior to and…

## 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 year(c."eventDate") = 2002
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17031'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17031&year=2002

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