NTSB investigations
9 cases where NTSB found Cognitive overload.
Cases per year
| 2008 | 1 |
|---|---|
| 2015 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02023015')) 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 starts_with(f."findingCode", '02023015')) 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 WPR26LA071Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lake Elsinore, CAThe pilot’s intentional deployment of the airframe parachute system due to task-saturation in instrument meteorological conditions.NTSB DCA24LA318Incident · No injuriesClass 3 · LimitedFinal reportEmbraer ERJ 170-100 LR · Chicago, ILThe flight crew’s misidentification of the intended landing runway, which resulted in an approach to and landing on the wrong runway due to their planned continuation bias. Contributing to the incident was the flight crew’s decision to continue the approach…NTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB WPR24FA238Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Helena, MTThe pilot’s loss of situational awareness during the water scoop due to task overload while operating in a multi-airplane tactical firefighting environment, which resulted in the pilot’s failure to maintain directional control and the airplane’s collision…NTSB CEN24FA064Accident · 2 fatalClass 3 · FieldFinal reportPilatus PC-12/45 · Christoval, TXThe instrument-rated pilot and a passenger departed on an instrument flight rules (IFR) flight. After about 4.5 hours, while approaching the first planned fuel stop, the airplane was in instrument meteorological conditions (IMC). According to air traffic…NTSB DCA19MA143Accident · Minor injuriesClass 2 · MajorFinal reportBoeing 737 · Jacksonville, FLAn extreme loss of braking friction due to heavy rain and the water depth on the ungrooved runway, which resulted in viscous hydroplaning. Contributing to the accident was the operator’s inadequate guidance for evaluating runway braking conditions and…NTSB ERA17FA190Accident · 1 fatalField investigationFinal reportEurocopter Deutschland EC 135 · New Castle, DEThe pilot's loss of helicopter control during a missed approach in instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB CEN15FA190Accident · 7 fatalField investigationFinal reportCessna 414A · Bloomington, ILThe pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.