# NTSB investigations: Cirrus Design SR20: In flight collision with object

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 NYC08FA041](https://openairdocs.org/ntsb/NYC08FA041.md): Cirrus Design SR20 · New Windsor, NY · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2007 · N108GD · Substantial damage
  > The pilot's failure to maintain the proper glidepath during an instrument-landing-system approach in fog. Contributing to the accident were pilot fatigue and air traffic control's failure to issue a minimum safe altitude warning.
- [NTSB DCA07MA003](https://openairdocs.org/ntsb/DCA07MA003.md): Cirrus Design SR-20 · Manhattan, NYC, NY · Accident · 2 fatal · Class 1 · Major · Final report · Oct 11, 2006 · N929CD · Destroyed
  > The pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.
- [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…
- [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,

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2130000')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2130000&occurrence=220

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