NTSB investigations, 2013, Outside the U.S.
5 cases where the sequence of events included Turbulence encounter.
Cases per year
| 2009 | 4 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 8 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 6 |
| 2023 | 5 |
| 2024 | 16 |
| 2025 | 8 |
| 2026 | 15 |
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\") = 2013
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '360' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2013 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '360' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA14WA084Incident · Minor injuriesForeign investigationBoeing 757-200 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland, has notified the NTSB of an incident involving a Boeing 757-200 that occurred on October 20, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB DCA13WA176Accident · Serious injuriesForeign investigationAirbus A330 - 203 · Fortaleza, BrazilThe Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA) has notified the NTSB of an accident involving an Airbus A330-203, registration PT-MVL, which occurred on September 1, 2013. The NTSB has appointed a U.S. Accredited…NTSB DCA13WA134Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Batopilas, MexicoNTSB DCA14WA108Accident · Serious injuriesForeign investigationBoeing 737-800 · Perugia, ItalyThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an accident involving a Boeing 737-800 that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…NTSB WPR13LA131Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean, A1The flight’s encounter with moderate clear air turbulence while en route, which resulted in a serious injury to a flight attendant. Contributing to the accident was the lack of communication equipment in the rest compartment, which, if installed, could have…