NTSB investigations, 2014, Outside the U.S.
8 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\") = 2014
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") = 2014 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 DCA15WA041Accident · Serious injuriesForeign investigationBoeing 777 223 · Ishikawa, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-200 that occurred on December 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…NTSB DCA15WA002Accident · Serious injuriesForeign investigationBoeing 777 223 · Buenos Aires, ArgentinaNTSB DCA15WA039Accident · No injuriesForeign investigationBoeing 737-700 · Belo Horizonte, BrazilThe Aeronautical Accident Investigation and Prevention Center (CENIPA) of Brazil has notified the NTSB of an accident involving a Boeing 737-700 that occurred on September 25, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…NTSB DCA14WA160Incident · No injuriesForeign investigationEmbraer EMB 145LR · London, CanadaThe TSB of Canada has notified the NTSB of an accident involving a Embraer EMB145LR airplane that occurred on September 05, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the TSB-Canada's investigation under the provisions of ICAO…NTSB DCA14WA176Accident · Serious injuriesForeign investigationBoeing Boeing 737-8AS · Tarragona, SpainThe CIAIAC of Spain has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on June 23, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…NTSB DCA14WA104Incident · No injuriesForeign investigationBoeing 767-300 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 767-300 that occurred on March 19, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under…NTSB DCA14WA088Accident · Serious injuriesForeign investigationBoeing 737-800 · En route, United KingdomThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an accident involving a Boeing 737-800 that occurred on March 9, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…NTSB DCA14WA042Incident · No injuriesForeign investigationBoeing 767 332 · Buenos Aires, ArgentinaThe Direccion Nacional de Aviacion Civil e Infraestructura Aeronautica (DINACIA) has notified the NTSB of an incident involving Boeing 767-300, which occurred on January 21, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DINACIA…