NTSB investigations
10 cases where the defining event was Evacuation.
Cases per year
| 2013 | 1 |
|---|---|
| 2015 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 4 |
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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '460') 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 c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '460') 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 DCA25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Canada BD500 · Denver, COUnidentified burned debris in an aft galley oven, which generated smoke and odor in the cabin and led to an air turnback and subsequent evacuation, during which a serious injury occurred.NTSB DCA25WA250Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Palma, SpainNTSB DCA25LA185Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Houston, TXSerious Injury to a flight attendant sustained during an evacuation.NTSB DCA25LA084Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Atlanta, GASubstantial injury to a passenger sustained during evacuation.NTSB DCA23WA335Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Chek Lap Kok, Hong Kong SAR ChinaNTSB DCA21LA208Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-990ER · SeaTac, WAThe passenger’s use of the evacuation slide resulted in the serious injury.NTSB DCA20WA084Incident · No injuriesForeign investigationBoeing 757 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 757 airplane that occurred on January 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB DCA16WA097Accident · Serious injuriesForeign investigationBoeing 737 · Chitose, JapanThe government of Japan has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…NTSB DCA15CA129Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · St Petersburg, FLevacuation of the aircraft due to reported, but unverified, aircraft condition and poor communication between Aircraft Rescue and Firefighting personnel and the flight crew.NTSB DCA13WA143Incident · No injuriesForeign investigationBoeing 757 · Gatwick, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757-2Y0, which occurred on August 23, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…