NTSB investigations: Cirrus Design SR22
7 cases on aircraft the registry lists as Cirrus Design SR22, where the first occurrence was “Loss of control - on ground/water”. 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
| 2001 | 1 |
|---|---|
| 2004 | 1 |
| 2006 | 2 |
| 2007 | 3 |
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 MIA08LA024Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Hendersonville, NCThe pilot's improper recovery from a bounced landing resulting in a loss of directional control.NTSB SEA07CA151Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Novato, CAThe instructor's failure to maintain directional control during landing. A contributing factor was the wind gusts.NTSB ATL07CA049Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Ocraacoke, NCThe pilot's improper use of the aileron and rudder controls and inadequate compensation for the wind conditions during a crosswind landing resulting in a loss of directional control.NTSB CHI06CA133Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Verdigre, NEThe pilot's decision to land on a wet grass runway that had insufficient length available for landing roll. An additional cause was the pilot's failure to properly retract the flaps during the aborted landing, resulting in diminished climb performance and the…NTSB LAX06CA128Accident · No injuriesData collectionFinal reportCirrus SR22 · Scottsdale, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB NYC04LA209Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Oxford, CTThe pilot's improper recovery from a bounced landing.NTSB CHI01FA169Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Springfield, MOthe lack of experience in the type of airplane and directional control not maintained by the pilot. The improper flare and parked airplane were contributing factors.