NTSB investigations
6 cases where the probable cause includes Oxygen system.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2023 | 1 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.\"inProbableCause\" AND starts_with(f.\"findingCode\", '010235')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f."inProbableCause" AND starts_with(f."findingCode", '010235')) 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 ERA23FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna 560 · Montebello, VAPilot incapacitation due to loss of cabin pressure for undetermined reasons. Contributing to the accident was the pilot’s and owner/operator’s decision to operate the airplane without supplemental oxygen.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 ERA15LA349Accident · 1 fatalLimited investigationFinal reportMooney M20TN · Atlantic City (Atlantic Ocean)A loose oxygen line, which was not detected by maintenance personnel during a recent annual inspection, that allowed oxygen to escape and drain the oxygen canister more quickly than the pilot expected. This reduced the pilot's availability of supplemental…NTSB ENG09IA016Incident · No injuriesIncident investigationFinal reportBoeing 767 432ER · St. Johns, CanadaIncorrect installation of a wire bundle, which contained wires for oxygen system, passenger address system and lavatory power, led to chafing of the wires on structure. The chafing eventually exposed the wire conductors and resulted in electrical arcing,…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 DCA08MA076Accident · No injuriesClass 1 · MajorFinal reportBoeing 767 · San Francisco, CAThe design of the supplemental oxygen system hoses and the lack of positive separation between electrical wiring and electrically conductive oxygen system components. The lack of positive separation allowed a short circuit to breach a combustible oxygen hose,…