NTSB investigations: Cirrus Design SR20, Outside the U.S.

6 cases on aircraft the registry lists as Cirrus Design SR20. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20032026

NTSB investigations: Cirrus Design SR20, Outside the U.S. per year, 2003–2026: 6 cases
2003	1
2007	2
2010	1
2011	1
2014	1

Latest cases

Query with SQL

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."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 ('2130000')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"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 ('2130000'))
  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."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 ('2130000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC15WA017Accident · Minor injuriesForeign investigationCirrus Design SR20 · Ibusuki City, JapanOn October 12, 2014, about 0530 coordinated universal time, a US registered Cirrus SR-20 airplane, N176CD, experienced a total loss of engine power near Ibusuki City, Kagoshima Prefecture, Japan. The pilot made a emergency landing, and received minor…Oct 12, 2014 · N176CD · Substantial damage NTSB CEN11WA151Accident · 1 fatalForeign investigationCirrus Design SR20 · Santiago Atitlán, GuatemalaJan 10, 2011 · N431SR · Destroyed NTSB CEN10WA471Accident · No injuriesForeign investigationCirrus Design SR20 · Oxfordshire, United KingdomAug 10, 2010 · N470RD · Substantial damage NTSB DEN08WA037Accident · 1 fatalForeign investigationCirrus Design SR-20 · Jagel, GermanyNov 28, 2007 · N141CD · Substantial damage NTSB DCA07WA024Accident · 1 fatalForeign investigationCirrus Design SR20 · Greenland, GreenlandFeb 2, 2007 · N901SR · Destroyed NTSB ATL04WA043Accident · Minor injuriesForeign investigationCirrus Design SR-20 · Teuge, NetherlandsAug 15, 2003 · N209CD · Substantial damage