# NTSB investigations: Cirrus Design SR20, 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 FTW03FA029](https://openairdocs.org/ntsb/FTW03FA029.md): Cirrus Design SR20 · Las Vegas, NM · Accident · 1 fatal · Field investigation · Final report · Nov 3, 2002 · N566T · Destroyed
  > The pilot's inadvertent flight into instrument meteorological conditions and failure to maintain clearance with the terrain. A contributing factor was the pilot's failure to obtain an updated preflight weather briefing.
- [NTSB NYC03LA007](https://openairdocs.org/ntsb/NYC03LA007.md): Cirrus Design SR-20 · Point Pleasant, WV · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 2002 · N137CD · Substantial damage
  > An inadvertent collision with wildlife. A factor in the accident was wildlife having access to the runway environment.
- [NTSB FTW02FA162](https://openairdocs.org/ntsb/FTW02FA162.md): Cirrus Design SR-20 · Angel Fire, NM · Accident · 1 fatal · Field investigation · Final report · May 28, 2002 · N901CD · Destroyed
  > The pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,
- [NTSB NYC02LA071](https://openairdocs.org/ntsb/NYC02LA071.md): Cirrus Design SR-20 · Lexington, KY · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 2002 · N244CD · Substantial damage
  > The pilot's failure to maintain aircraft control. Factors in this accident were the undetermined failure of the turn coordinator, as reported by the pilot, and the instrument meteorological conditions.

## 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.aircraft_model_code IN ('2130000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2130000&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.