NTSB investigations: Cirrus Design SR20
131 cases on aircraft the registry lists as Cirrus Design SR20. 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, newest first
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2130000'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2130000'))
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 CEN09FA146Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Menomonie, WIThe pilot's failure to maintain control of the airplane while flying at night in instrument meteorological conditions.NTSB ERA09LA062Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Green Cove Springs, FLThe fusing of an electrical cable from the No. 2 (standby) alternator with the throttle cable resulting in the flight crew’s inability to move the throttle control. Contributing to the accident was the failure of maintenance personnel to detect inadequate…NTSB ERA09CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Chester, CTThe pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.NTSB CHI08CA263Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Greenville, MIThe deer that ran onto the runway contacting the airplane. A factor associated with the accident was the dark night conditions.NTSB MIA08LA123Accident · No injuriesLimited investigationFinal reportCirrus Design SR-20 · Williston, FLThe student pilot’s failure to follow the manufacturer's recommended taxiing procedures.NTSB NYC08IA206Incident · No injuriesIncident investigationFinal reportCirrus SR20 · Sanford, FLA failure of the nose landing gear strut weldment.NTSB DEN08WA037Accident · 1 fatalForeign investigationCirrus Design SR-20 · Jagel, GermanyNTSB NYC08FA041Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · New Windsor, NYThe pilot's failure to maintain the proper glidepath during an instrument-landing-system approach in fog. Contributing to the accident were pilot fatigue and air traffic control's failure to issue a minimum safe altitude warning.NTSB ATL07LA115Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Siassconset, MAThe non-instrument rated pilot's loss of control at night in instrument flight conditions due to spatial disorientation. A factor was the pilot's in-flight decision not to inform the controller that he was not instrument rated.NTSB NYC07IA092Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Leesburg, VAThe airplane manufacturer's inadequate rudder-aileron interconnect rigging information. Contributing to the incident was the design of the rudder-aileron interconnect system.NTSB DCA07WA024Accident · 1 fatalForeign investigationCirrus Design SR20 · Greenland, GreenlandNTSB DCA07MA003Accident · 2 fatalClass 1 · MajorFinal reportCirrus Design SR-20 · Manhattan, NYC, NYThe pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.NTSB DEN06FA131Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Maybell, COThe pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…NTSB DEN06FA114Accident · Serious injuriesField investigationFinal reportCirrus Design SR20 · Kremmling, COThe pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…NTSB DFW06LA101Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Kerrville, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA06LA067Accident · No injuriesLimited investigationFinal reportCirrus SR20 · Orlando, FLCatastrophic engine failure due to a low oil level brought about by excessive blow-by and cylinder detonation. Contributing factors in this accident were the inadequate instructions contained in Service Bulletin M89-9 and the ditch.NTSB LAX06FA087Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Lancaster, CAThe student pilot's failure to maintain an adequate airspeed while maneuvering, and, the flight instructor's inadequate supervision of the flight. A factor in the accident was the strong tailwind encountered as the airplane turned from an upwind to a downwind…NTSB CHI05LA223Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Brainerd, MNThe delayed go-around and inadequate flare by the pilot during landing.NTSB NYC05LA131Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Farmingdale, NJA fire that originated at the right main landing gear brake caliper and piston, during taxi, which resulted in substantial damage to the airplane.NTSB MIA05IA087Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Jacksonville, FLInadequate welding procedure by the manufacturer resulting in a poor weld of the nose landing gear and collapse of the nose landing gear during a porpoised landing.NTSB ATL04FA096Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Greenwood, SCThe pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.NTSB ATL04WA043Accident · Minor injuriesForeign investigationCirrus Design SR-20 · Teuge, NetherlandsNTSB SEA03LA137Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · Fish Haven, IDThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, an inadvertent raising of the flaps for unknown reasons, and low altitude were factors.NTSB LAX03FA072Accident · 1 fatalField investigationFinal reportCirrus Design SR 20 · San Jose, CAThe pilot's failure to maintain the course for the published approach procedure due to his diverted attention. The distraction responsible for the pilot's diverted attention was the erroneous frequency assignment provided by ATC and the resultant task…NTSB FTW03FA029Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Las Vegas, NMThe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain clearance with the terrain. A contributing factor was the pilot's failure to obtain an updated preflight weather briefing.NTSB NYC03LA007Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Point Pleasant, WVAn inadvertent collision with wildlife. A factor in the accident was wildlife having access to the runway environment.NTSB FTW02FA162Accident · 1 fatalField investigationFinal reportCirrus Design SR-20 · Angel Fire, NMThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,NTSB NYC02LA071Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Lexington, KYThe pilot's failure to maintain aircraft control. Factors in this accident were the undetermined failure of the turn coordinator, as reported by the pilot, and the instrument meteorological conditions.NTSB CHI01LA318Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · St. Bonifacius, MNImproper servicing of the airplane by other maintenance personnel, inadequate inspection of the airplane by the other maintenance personnel prior to the airplane's flight, and the unsuitable terrain encountered during the forced landing. Factors relating to…NTSB LAX01FA145Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Sierra Vista, AZthe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in an in-flight collision with mountainous terrain. Factors in the accident included the adverse weather conditions and the dusk lighting conditions.NTSB CHI99FA112Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Duluth, MNthe lack of sufficient aileron-to-wing gap clearance design. Contributing factors were the inadequate oversight of the Federal Aviation Administration of the design and manufacturing and flight test process of Cirrus Design Corporation, the location of the…