NTSB investigations: Cirrus Design SR22, NC
18 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
| 2003 | 1 |
|---|---|
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
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 c.\"eventStateOrRegion\" = 'NC' 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"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 c."eventStateOrRegion" = 'NC' 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" 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 ERA24FA397Accident · 5 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Kill Devil Hills, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around attempt, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA22LA125Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Pinehurst, NCThe in-flight encounter while on final approach with high-speed trailing vortices from a military helicopter, resulting in abnormal runway contact. Contributing to the accident was the Cirrus pilot’s incorrect selection of the common traffic advisory…NTSB ERA22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Burnsville, NCThe pilot’s failure to compensate for the high density altitude and the tailwind component while landing at a mountaintop airport, which resulted in an aerodynamic stall and a loss of aircraft control.NTSB ERA20LA064Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Kenansville, NCA fatigue failure of the camshaft due to a manufacturing defect, which resulted in a partial loss of engine power.NTSB ERA19LA257Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Burnsville, NCThe pilot’s reliance on latent satellite weather imagery for tactical weather avoidance, which resulted in flight into thunderstorms and a loss of control. Also causal was an engine overspeed during the uncontrolled descent, which resulted in catastrophic…NTSB ERA16LA040Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Jefferson, NCA total loss of engine power for reasons that could not be determined during a postaccident test run of the engine.NTSB ERA15IA024Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Lexington, NCMaintenance personnel's improper tightening of the crankcase through bolt nuts during reassembly of the engine at the last overhaul, which resulted in the failure of the crankshaft and the subsequent total loss of engine power.NTSB ERA10CA343Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Burnsville, NCThe pilot's failure to maintain a proper visual glideslope during final approach.NTSB ERA09IA331Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Elkin, NCA total loss of engine power due to the failure of the No. 2 piston as a result of a fatigue crack of undetermined origin.NTSB MIA08CA112Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Roseboro, NCThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB MIA08FA081Accident · 1 fatalField investigationFinal reportCirrus SR22 · Waxhaw, NCThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the tailwind.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 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 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.NTSB NYC07FA037Accident · 1 fatalField investigationFinal reportCirrus SR22 · Huntersville, NCThe pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.NTSB ATL07FA013Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Statesville, NCThe pilot's failure to maintain airspeed while maneuvering with a low ceiling in instrument flight conditions, resulting in an inadvertent stall, and collision with trees and the ground. Factors in the accident were the pilot's failure to follow the published…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 ATL04LA060Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · King, NCA loss of engine power for undetermined reasons and the pilot's failure to maintain a visual lookout and obstacle clearance while performing a simulated engine out resulting in an in-flight-collision with a power line and the ground.