NTSB investigations
601 cases where NTSB found Perception/orientation/illusion.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020220')) 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", '020220')) 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 WPR20LA177Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH601 · Maricopa, AZThe pilot’s loss of situational awareness and descent below pattern altitude during the landing approach, which resulted in collision with terrain at night.NTSB WPR20CA150Accident · Serious injuriesClass 4 · Data collectionFinal reportAir Creation Tanarg · Buckeye, AZThe failure of the pilot to adequately maintain a safe distance from the airplane's propeller, which resulted in a serious injury when the propeller struck his hand.NTSB ERA20CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportBell UH 1N · Baghdad, IraqThe flight crew's inadequate situational awareness and failure to maintain adequate clearance from a security barrier during a night takeoff.NTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.NTSB ERA20LA150Accident · 2 fatalClass 3 · LimitedFinal reportArion Lightning LS-1 · Mount Pleasant, SCThe pilot's failure to maintain clearance from trees at the end of the runway due to spatial disorientation during initial climb in dark night conditions. Also causal was the flight instructor’s inadequate monitoring, which did not identify and prevent the…NTSB WPR20CA120Accident · No injuriesData collectionFinal reportPiper PA28R · Palm Springs, CAThe pilot's failure to see and avoid a parked vehicle near the taxiway edge.NTSB CEN20LA127Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28R · Pleasant Plain, OHThe pilot’s encounter with convective turbulence and low-level wind shear in dark night instrument meteorological conditions that resulted in spatial disorientation and the loss of airplane control.NTSB WPR20FA108Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Sylmar, CAThe pilot’s spatial disorientation during an instrument approach in instrument meteorological conditions, which resulted in loss of control of the airplane.NTSB CEN20CA119Accident · Serious injuriesData collectionFinal reportCessna 208 · Rhinelander, WIThe pilot's improper decision to continue an instrument approach to landing following a loss of visual reference with the runway, which resulted in the airplane touching down left of the runway in snow and flipping over.NTSB CEN20FA093Accident · 3 fatalClass 3 · FieldFinal reportBeech 200 · Coleman, TXThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s distraction with a “popped” circuit breaker and communications with air traffic control.NTSB CEN20CA094Accident · No injuriesData collectionFinal reportCessna 172 · Boulder, COThe pilot's loss of directional control during the landing roll on the slush-covered runway.NTSB ERA20FA096Accident · 4 fatalClass 3 · FieldFinal reportCessna 501 · Fairmount, GAThe pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB ANC20CA018Accident · No injuriesData collectionFinal reportCessna 172 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain while maneuvering at low altitude.NTSB DCA20MA059Accident · 9 fatalClass 1 · MajorFinal reportSikorsky S76 · Calabasas, CAThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…NTSB ERA20FA060Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA5 · College Park, MDThe pilot's loss of airplane control due to spatial disorientation after entering a climbing turn in instrument meteorological conditions.NTSB CEN20MA044Accident · 5 fatalClass 2 · MajorFinal reportPiper PA 31T · Lafayette, LAThe pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.NTSB CEN20FA032Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Victoria, TXThe pilot’s loss of control due to spatial disorientation. Contributing to the accident were the inoperative attitude indicator and horizontal situation indicator on the pilot’s side of the cockpit, and the pilot’s failure to reference the flight instruments…NTSB CEN20FA034Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Flower Pot, AZThe noninstrument-rated pilot’s decision to initiate and continue the visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of airplane control. Contributing was…NTSB WPR20FA031Accident · 2 fatalClass 3 · FieldFinal reportGrumman AA5 · Jackpot, NVThe pilot’s loss of control due to spatial disorientation while departing in dark night conditions, which resulted in impact with terrain. Contributing to the accident was the pilot’s limited experience flying in night conditions.NTSB ANC20LA004Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Goodnews Bay, AKThe pilot’s failure to monitor the airplane instruments during a night visual flight rules departure in dark light conditions, which resulted in spatial disorientation and the airplane’s descent into water.NTSB ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB CEN20FA003Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy · Bixby, MOThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA20FA002Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Asheboro, NCThe pilot’s loss of airplane control due to spatial disorientation, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent night flight experience.NTSB CEN19FA332Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Prairie Grove, ARThe noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.NTSB WPR19FA263Accident · 2 fatalField investigationFinal reportCessna 182 · Nixon, NVA loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.NTSB WPR19FA256Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · La Grande, ORThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ERA19FA266Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation, which resulted in the airplane’s descent into water.NTSB WPR19FA235Accident · 1 fatalClass 3 · FieldFinal reportMeyers Midget 0100 · Big Spring, TXThe pilot’s failure to maintain situational awareness while conducting a roll, which resulted in his inability to recover from the maneuver before the airplane impacted the ground. Contributing to the accident was his inexperience in both aerobatic maneuvers…NTSB ERA19FA240Accident · 3 fatalClass 3 · FieldFinal reportBeech F33 · Hatboro, PAThe pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.NTSB CEN19FA247Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Ontonagon, MIThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions with thunderstorm activity, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…NTSB ANC19FA033Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 24-180 · Ketchikan, AKThe pilot’s decision to continue visual flight rules into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB ANC19FA029Accident · 3 fatalField investigationFinal reportMaule M6 · Moose Pass, AKThe pilot's geographic disorientation and his exceedance of the airplane's critical angle of attack while maneuvering to avoid mountainous terrain, resulting in an aerodynamic stall.NTSB GAA19CA378Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the left wing striking bushes. Contributing to the accident was the pilot’s distorted visual perception due to his flying with one seat cushion rather than the two…NTSB CEN19FA185Accident · 2 fatalClass 2 · FieldFinal reportAgusta A109 · Brainerd, MNThe pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN19FA177Accident · 2 fatalField investigationFinal reportBeech A36 · Elida, OHThe noninstrument-rated pilot's decision to continue visual flight rules flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot not obtaining a weather…NTSB GAA19CA405Accident · No injuriesData collectionFinal reportEurocopter EC135 · Cobleskill, NYThe pilot's failure to maintain situational awareness during takeoff from a confined area, which resulted in the helicopter rotors striking tree branches.NTSB ERA19FA191Accident · 1 fatalClass 3 · FieldFinal reportAgusta A109 · New York, NYThe non-instrument-rated pilot’s decision to initiate the flight into marginal visual flight rules and instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB ERA19FA181Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Auburn Township, OHThe pilot's loss of control due to spatial disorientation in dark night conditions. Contributing to the accident was his inadequate weather planning, lack of experience flying at night and the deteriorating weather conditions.NTSB CEN19FA155Accident · 1 fatalClass 3 · FieldFinal reportCessna R172 · Mertzon, TXThe pilot's loss of control due to spatial disorientation.NTSB WPR19FA148Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Alpine, UTThe noninstrument-rated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was hypoxia due to the high altitude at which…NTSB CEN19FA140Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Eagle Lake, TXThe non-instrument-rated pilot's decision to fly into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and a subsequent impact with terrain.NTSB ANC19TA017Accident · Serious injuriesClass 3Final reportCessna A185 · Nome, AKThe pilot's decision to continue a visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in spatial disorientation and controlled flight into terrain. Contributing to the accident was the…NTSB WPR19FA103Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Farmington, NMThe noninstrument-rated pilot's continued visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB ERA19FA130Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Cashiers, NCThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB CEN19FA095Accident · 2 fatalClass 2 · FieldFinal reportBell 407 · Galliano, LAThe pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.NTSB ERA19FA116Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Fellsmere, FLThe student pilot's loss of control due to spatial disorientation following an encounter with instrument meteorological conditions shortly after takeoff. Contributing to the accident was the failure of both the pilot and the flight school to ensure that the…NTSB ERA19FA113Accident · 3 fatalField investigationFinal reportCessna 182 · Louisburg, NCThe pilot's spatial disorientation and loss of airplane control following takeoff in night instrument meteorological conditions.NTSB CEN19FA088Accident · 2 fatalField investigationFinal reportPiper PA46 · Shreveport, LAThe pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…