NTSB investigations, 2011, Outside the U.S.
4 cases where NTSB found Aircraft.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 8 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 5 |
| 2015 | 3 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 3 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 3 |
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 year(c.\"eventDate\") = 2011
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
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 year(c."eventDate") = 2011 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 DCA12CA023Accident · No injuriesData collectionFinal reportUniversity Of Kansas Meridian · McMurdo, AYan aerodynamic stall induced by an inadvertent autopilot Home command. The Home command was entered following a loss of the direct radio link due to improperly set failsafe settings, and an unintentional latching of Home mode from an earlier functionality…NTSB ERA11WA472Accident · 4 fatalForeign investigationAgusta AW139 · BrazilOn August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…NTSB CEN11WA412Accident · Serious injuriesForeign investigationMcDonnell Douglas Helicopter 369E · Glastonbury, United KingdomOn June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…NTSB ERA11WA209Accident · Serious injuriesForeign investigationCessna 182 · Palora, EcuadorOn Feburary 14, 2011, about 1935, universal coordinated time, a Cessna 182E, Ecuadorian registration HC-CDL, registered to and operated by Fundación Amazónica., incurred substantial damage during a force landing in rough terrain due to a total loss of engine…