NTSB investigations, 2018
11 cases where the sequence of events included Cabin safety event.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 10 |
| 2010 | 13 |
| 2011 | 14 |
| 2012 | 11 |
| 2013 | 8 |
| 2014 | 23 |
| 2015 | 11 |
| 2016 | 5 |
| 2017 | 7 |
| 2018 | 11 |
| 2019 | 8 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 5 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 2018
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '110' 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") = 2018 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '110' 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 DCA19CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan object which fell from an overhead bin struck a flight attendant resulting in a serious injury.NTSB DCA19WA196Incident · Serious injuriesForeign investigationBoeing 777 · New Delhi, IndiaThe government of India has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on October 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the…NTSB DCA19CA006Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · San Jose, CAA passenger falling while returning to her seat which resulted in a serious injury.NTSB DCA19CA005Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Nashville, TNflight attendant tripping over a passenger's knee that resulted in hot liquid splashing on the flight attendant.NTSB DCA18CA294Accident · Serious injuriesData collectionFinal reportAirbus A321 · Dallas, TXa passenger leaving a bag in the aisle that the flight attendant tripped over.NTSB DCA18CA299Accident · Serious injuriesData collectionFinal reportBoeing 757 · Newark, NJthe catering cart striking the flight attendant's foot.NTSB CEN18LA309Accident · 1 fatalLimited investigationFinal reportCameron A 250 · Hartsel, COThe passengers’ fall from the basket after landing when the basket tipped over.NTSB DCA18CA209Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Phoenix, AZa passenger bumping into a flight attendant who was holding a hot liquid.NTSB DCA18CA219Accident · Serious injuriesData collectionFinal reportBoeing 787-9 · Harbin, Chinathe accidental tipping over of a beverage service cart, when there was no turbulence, which caused pots of hot water to burn two flight attendants.NTSB GAA18CA226Accident · No injuriesData collectionFinal reportTextron G58 · Easton, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB DCA18WA133Incident · Minor injuriesForeign investigationAirbus A330 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving an amateur-built AIRBUS A330 airplane that occurred on February 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…