NTSB investigations: Cirrus Design SR22, 2005
11 cases on aircraft the registry lists as Cirrus Design SR22. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2001 | 1 |
|---|---|
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 18 |
| 2007 | 11 |
| 2008 | 15 |
| 2009 | 17 |
| 2010 | 16 |
| 2011 | 16 |
| 2012 | 14 |
| 2013 | 11 |
| 2014 | 13 |
| 2015 | 14 |
| 2016 | 13 |
| 2017 | 13 |
| 2018 | 12 |
| 2019 | 18 |
| 2020 | 10 |
| 2021 | 12 |
| 2022 | 15 |
| 2023 | 9 |
| 2024 | 11 |
| 2025 | 22 |
| 2026 | 13 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\") = 2005
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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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") = 2005
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL06FA029Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Sylva, NCThe pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.NTSB CHI06FA043Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Arco, MNThe pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…NTSB DFW06LA038Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot's excessive taxi speed and his excessive use of brakes.NTSB IAD05CA131Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Lincoln Park, NJThe pilot's failure to obtain the proper touchdown point during landing which resulted in a runway overrun. A factor was the pilot's misjudgment of speed/distance during the approach.NTSB NYC05LA110Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-22 · Haverstraw, NYThe pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.NTSB LAX05LA210Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Phoenix, AZthe pilot's delay in executing a timely go-around and failure to raise the flaps, which resulted in a collision with terrain.NTSB CHI05CA085Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Atkinson, NEThe pilot's failure to compensate for the wind condition which resulted in a loss of aircraft control while landing. A factor associated with the accident was the gusty crosswind condition that existed at the time of the accident.NTSB LAX05LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Half Moon Bay, CAThe pilot's excessive braking during taxi that resulted in the right brake overheating and a fire. A factor in the accident was the pilot's continued operation with known deficiencies.NTSB LAX05FA088Accident · 1 fatalField investigationFinal reportCirrus Design SR22 G2 · Norden, CAthe pilot's in-flight loss of control following an inadvertent encounter with unforecast severe icing conditions. A factor in the accident was the inaccurate icing forecast developed by the NWS Aviation Weather Center.NTSB SEA05FA038Accident · 3 fatalField investigationFinal reportCirrus SR22 · Hood River, ORThe pilot's failure to maintain terrain clearance. Contributing factors were the mountainous terrain, the low ceiling weather conditions, and dark night light conditions.NTSB IAD05FA032Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Coconut Creek, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent to the ground. Factors included an avionics failure, pilot disorientation, and instrument meteorological conditions. A factor in the severity of the impact was the…