# NTSB investigations: Cirrus Design SR22, IA

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 CEN25LA351](https://openairdocs.org/ntsb/CEN25LA351.md): Cirrus Design SR22 · Nora Springs, IA · Accident · No injuries · Class 4 · Limited · Final report · Aug 28, 2025 · N45JN · Substantial damage
  > The pilot’s improper decision-making for the attempted landing, which resulted in a runway overrun due to inadequate runway landing distance with a quartering tailwind. Contributing to the accident was the wet condition of the runway.
- [NTSB CEN21FA299](https://openairdocs.org/ntsb/CEN21FA299.md): Cirrus Design SR22 · Lamoni, IA · Accident · 2 fatal · Class 3 · Field · Final report · Jul 1, 2021 · N123RE · Destroyed
  > The pilot did not maintain aircraft control during an attempted go-around after a bounced landing, which resulted in impact with terrain and a postimpact fire.
- [NTSB CEN17LA263](https://openairdocs.org/ntsb/CEN17LA263.md): Cirrus Design SR22 · Corydon, IA · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2017 · N929DE · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.

## 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."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2130001'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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