NTSB investigations, 2017
11 cases where the sequence of events included Pressure/environ sys malf/fail.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 7 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 11 |
| 2018 | 13 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 11 |
| 2022 | 11 |
| 2023 | 7 |
| 2024 | 11 |
| 2025 | 10 |
| 2026 | 7 |
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\") = 2017
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '331' 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") = 2017 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '331' 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 DCA17WA222Incident · No injuriesForeign investigationBoeing 737 · Bangkok, ThailandThe AAIB of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of Thailand's investigation under the provisions of ICAO…NTSB DCA17WA223Incident · No injuriesForeign investigationBoeing 737 · Cancun, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB DCA17WA189Incident · No injuriesForeign investigationAirbus A320 233 · Lima, PeruThe Comisión de Investigación de Accidentes de Aviación (CIAA) of Peru has notified the NTSB of an incident involving a AIRBUS A320 233 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…NTSB DCA17WA220Incident · No injuriesForeign investigationBoeing 767 424ER · Zurich, SwitzerlandThe Swiss Transportation Safety Investigation Board has notified the NTSB of an incident involving a BOEING 767 424ER airplane that occurred on August 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's…NTSB DCA17WA176Incident · Minor injuriesForeign investigationBoeing 767 332 · London, United KingdomThe Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of a serious incident involving a BOEING 767 332 airplane that occurred on August 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…NTSB DCA17WA171Incident · No injuriesForeign investigationBoeing 737 · Bacau, RomaniaThe Civil Aviation Safety Investigation and Analysis Center of Romania has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB DCA17WA163Incident · No injuriesForeign investigationBoeing Boeing 737-330 · Frankfurt-Main, GermanyThe BFU of Germany has notified the NTSB of an incident involving a Boeing 737-330 airplane that occurred on July 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA17WA159Incident · No injuriesForeign investigationBoeing 747 422 · Frankfurt, GermanyThe BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA17WA192Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe government of Mexico has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA17WA118Incident · No injuriesForeign investigationBoeing 737 · Munich, GermanyThe Germany Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB ENG17WA021Incident · No injuriesForeign investigationBoeing Boeing 787-9 · London, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 787-9, which occurred on April 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…