NTSB investigations: Cirrus Design SR20
5 cases on aircraft the registry lists as Cirrus Design SR20, where the first occurrence was “In flight encounter with weather”. 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 |
|---|---|
| 2002 | 1 |
| 2006 | 2 |
| 2007 | 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 ('2130000')
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\" = 240))
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 ('2130000')
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" = 240))
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 ATL07LA115Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Siassconset, MAThe non-instrument rated pilot's loss of control at night in instrument flight conditions due to spatial disorientation. A factor was the pilot's in-flight decision not to inform the controller that he was not instrument rated.NTSB DEN06FA131Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Maybell, COThe pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…NTSB DEN06FA114Accident · Serious injuriesField investigationFinal reportCirrus Design SR20 · Kremmling, COThe pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…NTSB FTW03FA029Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Las Vegas, NMThe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain clearance with the terrain. A contributing factor was the pilot's failure to obtain an updated preflight weather briefing.NTSB LAX01FA145Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Sierra Vista, AZthe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in an in-flight collision with mountainous terrain. Factors in the accident included the adverse weather conditions and the dusk lighting conditions.