NTSB investigations: Cirrus Design SR22, MD
7 cases on aircraft the registry lists as Cirrus Design SR22. 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
| 2004 | 1 |
|---|---|
| 2006 | 1 |
| 2009 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2018 | 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.\"eventStateOrRegion\" = 'MD' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2130001'))
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."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2130001'))
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 ERA25LA190Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Stevensville, MDThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion.NTSB GAA18CA578Accident · No injuriesData collectionFinal reportCirrus SR22 · Frederick, MDThe pilot's improper landing flare, which resulted in the airplane porpoising.NTSB ERA15FA025Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Frederick, MDThe failure of the helicopter pilots and the airplane pilot to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident were the airplane pilot's descent below the…NTSB ERA13CA305Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Stevensville, MDThe pilot's failure to maintain directional control during the takeoff. Factors in the accident were the pilot's over-rotation at takeoff, and his failure to abort the takeoff prior to the runway excursion.NTSB ERA09LA200Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Gaithersburg, MDThe pilot’s spatial disorientation after the passenger door opened during flight in instrument meteorological conditions. Contributing to the accident was the pilot’s failure to properly secure the door latch.NTSB CHI06FA186Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Edgewater, MDThe pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.NTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.