NTSB investigations: Cirrus Design SR22
6 cases on aircraft the registry lists as Cirrus Design SR22, where the sequence of events included Sys/Comp malf/fail (non-power). 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
| 2013 | 1 |
|---|---|
| 2016 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2130001')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('2130001')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA26LA333Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Ashland, OHOn September 7, 2026, about 1255 eastern daylight time, a Cirrus Design Corp SR22, N521LM, was substantially damaged when it was involved in an accident near Ashland, Ohio. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN24LA014Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Saginaw, MIThe failure of the right brake assembly due to excessive brake lining wear, which resulted in a thermally damaged piston O-ring, hydraulic fluid leak, and subsequent fire.NTSB ERA22LA275Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Gulf Shores, ALThe improper maintenance of the brake system, which resulted in the brakes overheating and catching fire and subsequent substantial damage to the airplane.NTSB CEN18LA392Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Addison, TXMaintenance personnel’s improper installation of the muffler attachment hardware, which resulted in the muffler separating in flight, thermal damage that interrupted the magnetos’ function, and the subsequent total loss of engine power.NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB CEN13IA285Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Dallas, TXThe failure of the airplane’s parachute to deploy when activated during a loss of control in cruise flight due to the dynamic maneuvering of the airplane at the time of the activation, which exceeded the parachute system’s certification requirements.