NTSB investigations
12 cases where the first occurrence was “Decompression”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2005 | 2 |
| 2007 | 1 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 140) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 140) 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 CHI07LA063Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Cape Girardeau, MOThe company pilot's poor judgment before and during the flight, including turning the oxygen system ready switch to the OFF position after he conducted the preflight inspection and using an unapproved checklist, which did not provide guidance for a fractured…NTSB SEA06LA033Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe ground personnel baggage handler failed to maintain clearance from the aircraft with cargo handling equipment during ground operations and inadvertently damaged the airplane's pressure bulkhead which subsequently decompressed during climb to cruise.NTSB DCA05MA071Accident · Serious injuriesMajor investigationFinal reportBombardier CL-600-2B19 · Chicago O'Hare, ILThe opening of the service door when the airplane was pressurized. Contributing to the accident was the captain's failure to ensure that one of the airplane doors was open while a ground-cooling cart was connected, which resulted in pressurizing the airplane…NTSB LAX98FA260Accident · 3 fatalField investigationFinal reportPiper PA-31-T1 · Baker, NVthe pilot's failure to comply with a 12,500-foot altitude restriction placed on the aircraft by an FAA approved maintenance facility due to unresolved oxygen system issues. Contributing to the accident was the pilot's failure to divulge his true physical…NTSB CHI96IA157Incident · Minor injuriesIncident investigationFinal reportBoeing 727-290 · Indianapolis, INthe failure of the captain and flight engineer to utilize a checklist to troubleshoot a pressurization system problem, and the flight engineer's improper control of the pressurization system which resulted in an inadvertent opening of the outflow valve and…NTSB LAX94IA181Incident · Minor injuriesIncident investigationFinal reportFairchild SA-227AC · Ontario, CAthe failure of maintenance personnel to detect a crack in the windscreen which exceeded the operational limits for pressurized flight. A factor in the accident was the inadequacy of the inspection method published by the manufacturer.NTSB MIA93IA030Incident · Minor injuriesIncident investigationFinal reportBoeing 727-225A · Miami, FLThe failure of the window pane for undetermined reasons.NTSB NYC92IA030Incident · No injuriesIncident investigationFinal reportDouglas DC-8-63 · Toledo, OHThe failure of the flight engineer to conduct a proper preflight inspection and ensure the main cargo door was fully closed and locked. Factors related to the accident were the damaged wires in the bundle, and the improper main cargo door installation.NTSB ATL89IA099Incident · No injuriesIncident investigationFinal reportBoeing 737-201 · Dayton, OHAn excessively worn outflow valve in the cabin evironmental/pressurization system that resulted in a rapid cabin depressurization.NTSB FTW88IA097Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Detroit, MIThe PIC made an unscheduled landing following decompression at 30,000 feet. The aircraft had been written up by flightcrews numerous times between may 7 and may 9 for pressurization problems. Pressure bulkhead at station 940 in the right wheel well cracked 15…NTSB FTW85FA259Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Rocksprings, TXAs the acft was climbing thru 14,800' for 19,000', the plt reported a rapid decompression. Two minutes later, he reported that he has lost the tail. Acft impacted in an inverted flat spin and the tail and a section of empennage were found about 3/4 mile away…NTSB MIA83FA027Accident · 1 fatalField investigationFinal reportBoeing 707-300 · Miami, FLDuring climbout from Miami, a cabin pressurization problem was encountered. All crew members donned their oxygen masks & the cabin altitude stabilized at 20,000 ft as the acft was leveled at 33,000 ft. about 40 minutes from destination the flight engineer…