NTSB investigations, 2014
17 cases where the defining event was Turbulence encounter.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 15 |
| 2010 | 9 |
| 2011 | 22 |
| 2012 | 22 |
| 2013 | 9 |
| 2014 | 17 |
| 2015 | 18 |
| 2016 | 19 |
| 2017 | 16 |
| 2018 | 18 |
| 2019 | 24 |
| 2020 | 13 |
| 2021 | 11 |
| 2022 | 18 |
| 2023 | 22 |
| 2024 | 31 |
| 2025 | 25 |
| 2026 | 22 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '360')
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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '360') 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 DCA15CA050Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · San Jose, CAan inadvertent encounter with convective turbulence during descent.NTSB DCA15CA035Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Valdosta, GAan inadvertent encounter with clear air turbulence while the flight attendants were returning to their seats.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 ANC14CA047Accident · No injuriesData collectionFinal reportPiper PA 18 · Cantwell, AKThe pilot's encounter with a wind gust during takeoff from a short gravel bar, which resulted in the airplane settling after rotation and striking obstacles.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 ANC14CA027Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Wasilla, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter at low altitude and collision with trees. Contributing to the accident was the pilot's lack of knowledge of local wind conditions.NTSB OPS14IA007Incident · Minor injuriesIncident investigationFinal reportBoeing 757 · Powhatan, VAThe air traffic controller’s failure to provide required advisories about significant radar-observed convective precipitation along both airplanes’ flight routes and the air route traffic control center’s lack of a program to ensure that air traffic…NTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…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 DCA14LA060Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Kaycee, WYan encounter with severe mountain wave turbulence during cruise flight.NTSB CEN14CA123Accident · Minor injuriesData collectionFinal reportCessna 172N · Boulder, COThe pilot's failure to maintain airplane control during final approach with known turbulence present.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…NTSB DCA14CA036Accident · Serious injuriesData collectionFinal reportBoeing 757 232 · Atlanta, GAunexpected encounter with convective turbulence while the flight attendants were preparing for arrival.