NTSB investigations: Cirrus Design SR22
12 cases on aircraft the registry lists as Cirrus Design SR22, where the sequence of events included Controlled flight into terr/obj (CFIT). 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
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 3 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2025 | 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\" = '120' 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" = '120' 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 ERA26FA019Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus SR22 · Ruston, LAOn October 21, 2025, about 0944 central daylight time, a Cirrus SR22, N42BE, was destroyed when it was involved in an accident near Ruston, Louisiana. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…NTSB WPR20FA034Accident · 3 fatalClass 3 · FieldFinal reportCirrus SR-22 · North Las Vegas, NVThe pilot’s failure to maintain clearance from terrain during cruise flight in dark night conditions.NTSB WPR18FA001Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Klamath Falls, ORThe noninstrument rated pilot's decision to depart on a cross-country flight with en route weather conditions forecasted to be less than visual meteorological conditions and then to continue flight into instrument meteorological conditions, which resulted in…NTSB WPR17LA084Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Brinnon, WAThe flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.NTSB ERA16CA056Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Danbury, CTThe pilot's failure to maintain adequate clearance from obstructions while on approach to landing.NTSB CEN16LA016Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Lancaster, TXThe pilot’s failure to maintain a proper glidepath during a night visual approach, which resulted in impact with a power line. Contributing to the accident was an inoperative precision approach path indicator.NTSB WPR15FA082Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Tooele, UTThe non-instrument rated pilot’s decision to depart into low visibility conditions, which resulted in spatial disorientation and a loss of control. Contributing to the accident was the pilot’s impaired performance due to his use of the sedating antihistamine,…NTSB CEN13FA456Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Chesterfield, MOThe pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.NTSB ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.NTSB SEA08FA108Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Big Bear City, CAThe pilot's failure to maintain altitude/clearance from mountainous terrain. Contributing to the accident were the mountainous terrain, the dark night condition, the turbulent wind condition, and the low clouds.NTSB NYC08FA138Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Front Royal, VAThe pilot's failure to maintain clearance from rising mountainous terrain, and his failure to turn toward his assigned course during initial climb. Contributing to the accident were the low ceiling, reduced visibility, dark night conditions, and rising…