NTSB investigations, 2019, Outside the U.S.
7 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\") = 2019
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") = 2019 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 DCA20WA012Incident · No injuriesForeign investigationBoeing 737 · Malta, MaltaThe AAIU of Ireland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU of Ireland's investigation under the provisions of ICAO…NTSB DCA19WA203Accident · Serious injuriesForeign investigationBoeing 787 · Beijing, ChinaThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 797, which occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…NTSB DCA19WA172Accident · Serious injuriesForeign investigationBoeing 737 · Seoul, South KoreaThe ARAIB of Korea has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on May 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB's investigation under the provisions of ICAO Annex 13 as State…NTSB DCA19WA222Accident · Serious injuriesForeign investigationBoeing 737 · Narita, JapanThe government of Japan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of ICAO…NTSB DCA19WA082Incident · No injuriesForeign investigationBoeing 737 · Albania, AlbaniaThe government of Albania has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Albania's investigation under the provisions…NTSB DCA19CA075Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Bluefields, NicaraguaAn inadvertent encounter with clear air turbulence.NTSB CEN19WA077Accident · 2 fatalForeign investigationRans S12 · Bavispe, Mexico