# NTSB investigations: Cirrus Design SR22: In flight collision with terrain/water

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 SEA07CA064](https://openairdocs.org/ntsb/SEA07CA064.md): Cirrus Design SR22 · Glen Canyon Nat, UT · Accident · Minor injuries · Data collection · Final report · Feb 24, 2007 · N224MT · Substantial damage
  > The pilot's intentional flight over water at low altitude and his subsequent failure to maintain adequate clearance from the water. A contributing factor was the glassy surface condition of the lake.
- [NTSB ATL07CA035](https://openairdocs.org/ntsb/ATL07CA035.md): Cirrus Design SR-22 · Siler City, NC · Accident · No injuries · Data collection · Final report · Jan 28, 2007 · N221GW · Substantial damage
  > The pilot's failure to perform an aborted landing which resulted in an inflight collision with the runway.
- [NTSB LAX07FA062](https://openairdocs.org/ntsb/LAX07FA062.md): Cirrus Design SR22 · Young, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2006 · N457S · Destroyed
  > The pilot's failure to maintain terrain clearance during cruise flight while flying at night at an altitude to remain clear of clouds and icing conditions. Contributing to the accident were an inadequate weather evaluation, the clouds, icing conditions, and…
- [NTSB CHI06FA218](https://openairdocs.org/ntsb/CHI06FA218.md): Cirrus Design SR22 · Boyceville, WI · Accident · Serious injuries · Field investigation · Final report · Aug 5, 2006 · N658CD · Substantial damage
  > The pilot's failure to maintain adequate airspeed and the certified flight instructor's delayed remedial action and inadequate supervision of the flight training, which resulted in an inadvertent stall during a base to final turn to the landing runway. An…
- [NTSB LAX05LA210](https://openairdocs.org/ntsb/LAX05LA210.md): Cirrus Design SR-22 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Jun 18, 2005 · N626Z · Substantial damage
  > the pilot's delay in executing a timely go-around and failure to raise the flaps, which resulted in a collision with terrain.
- [NTSB SEA05FA038](https://openairdocs.org/ntsb/SEA05FA038.md): Cirrus SR22 · Hood River, OR · Accident · 3 fatal · Field investigation · Final report · Jan 21, 2005 · N6057M · Destroyed
  > The pilot's failure to maintain terrain clearance. Contributing factors were the mountainous terrain, the low ceiling weather conditions, and dark night light 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 ('2130001')
    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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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