Skip to content

NTSB investigations, 2018

13 cases where the sequence of events included Pressure/environ sys malf/fail.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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" = '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

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\" = '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") = 2018
  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 DCA21WA112Incident · No injuriesClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNov 17, 2018 · LV-HFR · No damage NTSB 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…Oct 19, 2018 · HS-LTJ · No damage 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…Sep 20, 2018 · VT-JGS · No damage 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…Sep 18, 2018 · N632NV · Substantial damage 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…Aug 20, 2018 · N520AM · No damage 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…Aug 15, 2018 · VH-XMO · No damage NTSB DCA24WA108IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoAug 6, 2018 · CN-RNJ · No damage NTSB 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…Jul 13, 2018 · EI-ENM 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…Jul 3, 2018 · N331CK · No damage 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…May 4, 2018 · ZS-VDP · No damage 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…May 2, 2018 · G-FXAR 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…Apr 6, 2018 · PR-GGE · No damage 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…Mar 29, 2018 · HP1910DAE · No damage