NTSB investigations
116 cases where the sequence of events included Pressure/environ sys malf/fail.
Cases, newest first
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 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 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 ENG13WA042Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandThe investigation is under the jurisdiction of the government of New Zealand. Further information pertaining to this accident may be obtained from:Transport Accident Investigation Commission PO Box 10323, The Terrace Wellington 6143, New Zealand. Website :…NTSB DCA13WA042Incident · Minor injuriesForeign investigationBoeing 737 · Genoa, ItalyOn 23 January 2013, at about 0947 UTC time, a Boeing 737-800, registration EI-DCX, operated by RyanAir, declared an emergency and diverted into Genoa, Italy, after experiencing a pressurization problem on both systems. Two passengers sustained minor injuries…NTSB DCA13WA031Incident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaOn 24 November, 2012, at approxiumately 1636 UTC time, a Boeing B737-7V3, registration HP1371CM, operated by Copa Airlines Columbia between Bogota and Cartegna, Coulmbia, experienced a depressurization while climbing through FL240 and the oxygen masks…NTSB DCA13WA019Incident · No injuriesForeign investigationBoeing 757 · Frankfurt, GermanyOn November 11, 2013, a Boeing B757-300, registration D-ABOE, operated by Condor Flugdienst, experienced a smell in cockpit and cabin during take off roll and climb. The airplane returned to Frankfurt and landed uneventfully. There was no damage to the…NTSB DCA13WA015Incident · No injuriesForeign investigationBoeing 737 · Brasilia, BrazilThe Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA), has notified the NTSB of an incident involving a Boeing 737 that occurred on October 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…NTSB DCA12WA145Incident · No injuriesForeign investigationBoeing 737-800 · Gran Canaria, SpainThe Civil Aviation Accident and Incident Investigation Commission (CIAIAC) of Spain, has notified the NTSB of an accident involving a Boeing 737-800 that occurred on September 7, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA12WA125Incident · No injuriesForeign investigationBoeing 757-200 · Tenerife Sur, SpainThe Civil Aviation Accident and Incident Investigation Commission (CIAIAC) of Spain, has notified the NTSB of an accident involving a Boeing 757-200 that occurred on August 8, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC…NTSB DCA12WA120Incident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaOn July 30, 2012, at approximately 0920 UTC, a Boeing 737-800, registration ZS-SJB, s/n 29249, operated by South African Airways, experienced a sudden decompression approximately one hour after takeoff. The cabin oxygen masks deployed from the overhead panels…NTSB DCA12WA039Incident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on February, 11, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA11WA088Incident · No injuriesForeign investigationBoeing 737 · Pemir, LatviaOn July 26, 2011, a Boeing 737-300, Latvian registration YL-BBR, operated by Air Baltic, experienced a depressurization while enroute from Antalya, Turkey, to Riga, Latvia. There were no injuries to the 6 crew and 138 passengers. The incident is being…NTSB DCA11WA062Incident · No injuriesForeign investigationBoeing B737 · Dublin, IrelandOn May 20, 2011 at 2110 UTC, a Boeing 737-800, Irish registration EI-DLI, operated by Ryanair, experienced a depressurization when enroute from Liverpool England, to Dublin Ireland. There were no injuries to the 6 crew and 60 passengers, and the airplane was…NTSB DCA11WA018Incident · No injuriesForeign investigationBoeing 737 · Rio De Janiero, BrazilThe aircraft stopped to climb to cruising level at level 330, because the pilots realized that the pressurization system was not working properly. The "CABIN RATE OF CLIMB" was indicating +500ft/min, the "ALT CABIN INDEX" 8.0, and the differential pressure…NTSB DCA11WA017Incident · No injuriesForeign investigationBoeing B737 · Brasilia, BrazilThe Brazilian Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 737 that occurred on December 8, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU…NTSB DCA10WA100Incident · No injuriesForeign investigationBoeing 737 · Milan, ItalyOn July 23, 2010, a Airone Boeing 737-400, registration EI-CWW, conducted an emergency descent after experiencing a decompression. The flight continued on to its destination at 10,000 feet. There were no injuries to the 6 crew members onboard and the airplane…NTSB ERA09FA429Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Ravenswood, WVThe pilot's improper modification of the certified, on-board oxygen system, which resulted in incapacitation due to hypoxia, and the airplane's subsequent uncontrolled descent into terrain.NTSB CEN09FA087Accident · 1 fatalField investigationFinal reportBeech C90 · Rocksprings, TXThe pilot's failure to properly configure the pressurization controls, resulting in his impairment and subsequent incapacitation due to hypoxia.