NTSB investigations: Cirrus Design SR22

11 cases on aircraft the registry lists as Cirrus Design SR22, where the sequence of events included Unknown or undetermined. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

NTSB investigations: Cirrus Design SR22 per year, 2008–2026: 11 cases
2008	1
2009	1
2012	2
2020	1
2022	1
2023	2
2026	3

Where

Open the map

Latest cases

Query with SQL

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" = '000' 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

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\" = '000' 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" = '000' 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

Run 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 GAA26WA317Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Calgary, CanadaSep 5, 2026 · N65KB · Destroyed NTSB GAA26WA238Accident · No injuriesClass 5 · ForeignCirrus SR22 · Chichester, United KingdomJul 3, 2026 · N151CG · Substantial damage NTSB GAA26WA203Incident · No injuriesClass 5 · ForeignCirrus SR22 · Nyíregyháza, HungaryMay 28, 2026 · N6103Y · Substantial damage NTSB CEN23LA297Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Boelus, NELoss of engine power for reasons that could not be determined.Jul 12, 2023 · N151SR · Substantial damage NTSB ERA23FA130Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Duluth, MNA rapid descent and subsequent collision with terrain for reasons that could not be determined based on the available evidence.Feb 24, 2023 · N929DR · Destroyed NTSB CEN22FA111Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Hutchinson, MNThe reduction in fuel flow and subsequent partial loss of engine power after takeoff for reasons that could not be determined.Jan 31, 2022 · N227BD · Substantial damage NTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.Dec 10, 2020 · N577CP · Substantial damage NTSB CEN12LA495Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lakeview, ARThe pilot’s loss of control during the takeoff roll for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.Jul 29, 2012 · N462CP · Substantial damage NTSB CEN12FA251Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Newcomerstown, OHThe pilot’s loss of airplane control in instrument meteorological conditions due to his distraction by electrical system anomalies, which resulted in an uncontrolled descent. The reason for the electrical system anomalies could not be determined.Apr 21, 2012 · N110EB · Substantial damage NTSB ERA10FAMS1Accident · 1 fatalMissing aircraftFinal reportCirrus SR22 · Gulf of MexicoUndetermined (airplane and pilot missing).Dec 15, 2009 · N723LJ · Destroyed NTSB DFW08FA111Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Hemphill, TXA loss of control for undetermined reasons.Apr 22, 2008 · N729SR · Destroyed