# NTSB investigations: Cirrus Design SR20, 2003

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 ATL04WA043](https://openairdocs.org/ntsb/ATL04WA043.md): Cirrus Design SR-20 · Teuge, Netherlands · Accident · Minor injuries · Foreign investigation · Aug 15, 2003 · N209CD · Substantial damage
- [NTSB SEA03LA137](https://openairdocs.org/ntsb/SEA03LA137.md): Cirrus Design SR-20 · Fish Haven, ID · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 2003 · N27SJ · Substantial damage
  > The pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, an inadvertent raising of the flaps for unknown reasons, and low altitude were factors.
- [NTSB LAX03FA072](https://openairdocs.org/ntsb/LAX03FA072.md): Cirrus Design SR 20 · San Jose, CA · Accident · 1 fatal · Field investigation · Final report · Jan 24, 2003 · N893MK · Destroyed
  > The pilot's failure to maintain the course for the published approach procedure due to his diverted attention. The distraction responsible for the pilot's diverted attention was the erroneous frequency assignment provided by ATC and the resultant task…

## 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") = 2003
  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=2003

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