NTSB investigations: Cirrus Design SR22
10 cases on aircraft the registry lists as Cirrus Design SR22, where NTSB found Altitude. 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 | 1 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2023 | 1 |
Where
Latest 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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01062012')))
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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '01062012')))
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 CEN24FA073Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Canton, TXThe pilot’s failure to attain the runway while landing at night, which resulted in an impact with trees.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 CEN20CA335Accident · Serious injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Lafayette, INThe pilot's failure to monitor aircraft control, which resulted in a loss of control when a passenger inadvertently moved the control stick, and the pilot and other passenger's decision to unbuckle their restraints inflight.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 CEN18FA144Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Williamsburg, PAThe pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…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 ERA13LA012Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Birmingham, ALThe pilot's failure to maintain airplane control during a missed approach in instrument meteorological conditions. Contributing to the accident was the pilot's overreliance on the autopilot system and his inability to hand-fly the airplane once the autopilot…NTSB ERA09FA515Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Rock Hill, SCThe pilot's failure to maintain aircraft control and altitude while maneuvering after takeoff.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.