# NTSB investigations: Cirrus Design SR20: In flight encounter with weather

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 ATL07LA115](https://openairdocs.org/ntsb/ATL07LA115.md): Cirrus Design SR20 · Siassconset, MA · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 2007 · N869CD · Substantial damage
  > The non-instrument rated pilot's loss of control at night in instrument flight conditions due to spatial disorientation. A factor was the pilot's in-flight decision not to inform the controller that he was not instrument rated.
- [NTSB DEN06FA131](https://openairdocs.org/ntsb/DEN06FA131.md): Cirrus Design SR20 · Maybell, CO · Accident · 2 fatal · Field investigation · Final report · Sep 15, 2006 · N787SL · Destroyed
  > The pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…
- [NTSB DEN06FA114](https://openairdocs.org/ntsb/DEN06FA114.md): Cirrus Design SR20 · Kremmling, CO · Accident · Serious injuries · Field investigation · Final report · Aug 16, 2006 · N8127J · Destroyed
  > The pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…
- [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 LAX01FA145](https://openairdocs.org/ntsb/LAX01FA145.md): Cirrus Design SR20 · Sierra Vista, AZ · Accident · 3 fatal · Field investigation · Final report · Apr 11, 2001 · N116CD · Destroyed
  > the pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in an in-flight collision with mountainous terrain. Factors in the accident included the adverse weather conditions and the dusk lighting 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 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" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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