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 DCA22WA022IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoNTSB DCA21WA222IncidentClass 5 · ForeignBoeing 737 · Katowice, PolandNTSB DCA21WA180Incident · No injuriesClass 5 · ForeignBoeing 737 · Ballarat, AustraliaNTSB DCA21WA173IncidentClass 5 · ForeignBoeing 737 · Caracas, VenezuelaNTSB CEN21LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Saint James, LAThe in-flight fatigue failure of an air-conditioning system hose which resulted in a precautionary landing and impact with a road sign.NTSB DCA21WA100IncidentClass 5 · ForeignBoeing 737 · Tijuana, MexicoNTSB DCA21WA075IncidentClass 5 · ForeignBoeing 737 · Durban, South AfricaNTSB DCA21WA041IncidentClass 5 · ForeignBoeing 757 · Silao, MexicoNTSB DCA21WA028IncidentClass 5 · ForeignBoeing 737 · Lusaka, RwandaNTSB DCA21WA017IncidentClass 5 · ForeignBombardier CL600 2C10 · Chihuahua City, MexicoNTSB DCA20WA132Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC of Mexico's investigation under the provisions of ICAO Annex…NTSB DCA20WA011Incident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaThe CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19WA217Incident · No injuriesForeign investigationBoeing 737 · Cape Town, South AfricaThe CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of…NTSB DCA19WA156Incident · No injuriesForeign investigationBoeing 787 · JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 787 airplane that occurred on June 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under…NTSB DCA21WA112Incident · No injuriesClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB DCA19WA027Incident · No injuriesForeign investigationBoeing 737 · Bangkok, ThailandThe AAIC of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIC of Thailand's investigation under the provisions of ICAO…NTSB DCA18WA304Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of India's investigation under the provisions of ICAO Annex…NTSB WPR18LA269Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Wahiawa, HILoss of oil in flight as a result of a loose oil filter adapter which resulted in the pilot initiating an immediate landing to an open field. Contributing to the accident was the pilot's manipulation of the throttle that led to a reduction in rotor rpm, which…NTSB DCA18WA279Incident · No injuriesForeign investigationBoeing 737 · Guadalajara, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA271Incident · No injuriesForeign investigationBoeing 737 · Narrandera, AustraliaThe ATSB of Australia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO Annex 13 as…NTSB DCA24WA108IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoNTSB DCA18WA243Incident · No injuriesForeign investigationBoeing 737 · Frankfurt, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…NTSB DCA18WA246Incident · No injuriesForeign investigationBoeing 737 300 · Nassau, BahamasThe Air Accident Investigation Department (AAID) - Ministry of Tourism, Aviation & Bahamasair has notified the NTSB of an incident involving a Boeing 737 300 airplane that occurred on July 03, 2018. The NTSB has appointed a U.S. Accredited Representative to…NTSB DCA18WA180Incident · No injuriesForeign investigationBoeing 737 · Port Elizabeth, South AfricaThe Civil Aviation Authority (CAA) of South Africa has informed the NTSB of an incident involving a Boeing 737-300, which occurred on May 4, 2018. The NTSB has appointed a U.S Accredited Representative to assist the CAA investigation under the provisions of…NTSB CEN18WA253Incident · No injuriesForeign investigationBeech 400 · Geneva, SwitzerlandOn May 2, 2018, about 1035 Universal Coordinated Time, a Beech 400, United Kingdom registration G-FXAR, experienced a cabin depressurization event and landed without further incident at the Geneva International Airport (LSGG), Geneva, Switzerland. There were…NTSB DCA18WA130Incident · No injuriesForeign investigationBoeing 737 · Rio de Janeiro, BrazilThe government of Brazil has notified the NTSB of an serious incident involving a BOEING 737 airplane that occurred on April 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA18WA124Incident · No injuriesForeign investigationBoeing 757 · Mexico City, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a BOEING 757 airplane that occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…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…NTSB DCA16FA217Accident · No injuriesField investigationFinal reportBoeing 737-700 · Pensacola, FLA low-cycle fatigue crack in the dovetail of fan blade No. 23, which resulted in the fan blade separating in flight and impacting the fan case. This impact caused the fan blade to fracture into fragments that traveled farther than expected into the inlet,…NTSB ENG16WA038Incident · No injuriesForeign investigationBoeing 737 · Toulouse, France, FranceThe Accident Investigation Bureau of Mongolia (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on June 8, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…NTSB DCA16WA167Incident · Minor injuriesForeign investigationBoeing 737 · tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of serious incident involving a BOEING 737 airplane that occurred on May 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under…NTSB CEN16LA197Accident · Minor injuriesLimited investigationFinal reportCessna 501 · Texarkana, ARThe pilot's failure to use supplemental oxygen as required during high-altitude flight, which resulted in his loss of consciousness following a loss of cabin pressurization. Contributing to the accident was the separation of the air conditioning system's…NTSB DCA16WA138Incident · No injuriesForeign investigationBoeing 737 · Chiang Mai, ThailandMinistry of Transport of Thailand has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…NTSB ENG15WA029Incident · No injuriesForeign investigationEmbraer ERJ170 - 200STD · Niigata, JapanOn July 7, 2015, an Embraer ERJ170 experienced a bleed system failure during climb after take-off from New Chitose Airport (RJCC), Chitose, Japan. The aircraft diverted to Niigata Airport (RJSN). No one on board the aircraft was injured. The incident is being…NTSB DCA15WA147Incident · No injuriesForeign investigationBoeing 737 · Tanegashima, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of JTSB's investigation under the…NTSB ERA15LA328Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G IV · Caribbean Sea, A1The in-flight failure of the cabin pressurization relief/safety valve (CPRV) due to an obstruction of the CPRV static port, which allowed the airplane to overpressurize. The reason for the initial overpressurization condition could not be determined.NTSB ENG15WA005Incident · No injuriesForeign investigationBoeing 757 - 236 · Magadan, RussiaOn December 6, 2014, at approximately 10:30 UTC, a Yakutia Airlines Boeing 757-236PCF, registration VQ-BPY experienced a decompression and cargo door opening approximately 4 minutes after takeoff from Magadan, Russian Federation. The Department for Inspection…NTSB DCA15WA091Incident · No injuriesForeign investigationNorth American NA 265-80 · Panama Pacifico, PanamaThe Civil Aeronautical Authority of Panama (AAC) has notified the NTSB of an incident involving a North American NA 265-80 that occurred on October 24, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAC investigation under the…NTSB DCA15LA011Accident · No injuriesLimited investigationFinal reportBoeing 737 330 · Lanai, HIthe improper loading and securing of the cargo pallets, which shifted on departure, resulting in substantial damage to the aft pressure bulkhead.NTSB ERA14LA424Accident · 2 fatalLimited investigationFinal reportSocata TBM 700 · Caribbean Sea, A1The design of the cabin pressurization system, which made it prone to unnecessary shutdown, combined with a checklist design that prioritized troubleshooting over ensuring that the pilot was sufficiently protected from hypoxia. This resulted in a loss of…