NTSB investigations: Cirrus Design SR22, 2007
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 | 14 |
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\") = 2007
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") = 2007
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 LAX08FA043Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Paso Robles, CAThe pilot's encounter with isolated moderate (or greater) turbulence, updrafts, and downdrafts associated with localized mountain wave conditions at low altitude, and, his failure to maintain adequate airspeed during the encounter that resulted in an…NTSB MIA08LA024Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Hendersonville, NCThe pilot's improper recovery from a bounced landing resulting in a loss of directional control.NTSB CHI08FA039Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Faribault, MNThe pilot not maintaining adequate airspeed for the gusty crosswind conditions and the stall/spin encountered during the go-around. Contributing to the accident were the crosswinds and wind gusts.NTSB NYC08LA004Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hartford, CTThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the proximity of the parked airplanes to the taxiway and the failure of the marshaller to provide adequate guidance.NTSB SEA07IA201Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Reno, NVThe failure of the left turbocharger as a result of a production defect in the unit's compressor due to a machining process change by the manufacturer that was made without formal documentation or substantiation.NTSB OPS07IA005Incident · No injuriesIncident investigationFinal reportPiaggio Industrie P180 · Teterboro, NJThe TEB local controller's failure to ensure separation between two aircraft departing intersecting runways.NTSB SEA07CA151Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Novato, CAThe instructor's failure to maintain directional control during landing. A contributing factor was the wind gusts.NTSB DEN07LA082Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Luna, NMthe pilot's failure to activate the pitot heat while flying in the clouds and visible moisture, resulting in pitot tube contamination and the subsequent loss of air data for the primary flight display. Contributing to the accident was the icing conditions,…NTSB ATL07CA049Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Ocraacoke, NCThe pilot's improper use of the aileron and rudder controls and inadequate compensation for the wind conditions during a crosswind landing resulting in a loss of directional control.NTSB SEA07CA064Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Glen Canyon Nat, UTThe 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 ATL07CA035Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Siler City, NCThe pilot's failure to perform an aborted landing which resulted in an inflight collision with the runway.