NTSB investigations, 2011, Outside the U.S.
4 cases where the defining event was Sys/Comp malf/fail (non-power).
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 3 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 14 |
| 2022 | 12 |
| 2023 | 20 |
| 2024 | 9 |
| 2025 | 17 |
| 2026 | 4 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '330')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '330') 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 DCA12WA030Incident · No injuriesForeign investigationBoeing 777 · Maldives, MaldivesThe UAE General Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Boeing 777 that occurred on December 2, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of…NTSB CEN12RA052Accident · 3 fatalClass 5 · ForeignBell 206L · Kapuskasing, CanadaOn November 2, 2011, about 0958 eastern daylight time (EDT), a Bell 206L helicopter, Canadian registration C-GDQH, was substantially damaged during an in-flight collision with terrain in Kapuskasing, Ontario, Canada. The pilot and 2 passengers sustained fatal…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 DCA11WA023Incident · No injuriesForeign investigationBoeing 737 · Montpelier, FranceOn January 10, 2011, at 1330 local time a Boeing 737-700, registration F-GIXD experienced an AOA sensor blockage resulting in false stick-shaker during takeoff from Montpelier, France. The airplane was on a ferry flight to Toulouse, France, and returned to…