NTSB investigations
392 cases where the sequence of events included VFR encounter with IMC.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '401' 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 c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '401' 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 WPR22FA298Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Blyn, WAThe pilot’s continued operation of the airplane with known mechanical malfunctions with the flight displays, and his continued flight into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.NTSB WPR22FA266Accident · 2 fatalClass 3 · FieldFinal reportHolland Mike RV9A · Tryon, NEThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup of the airplane…NTSB WPR22FA255Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7BCM · Lake McMurray, WAThe pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain.NTSB ERA22FA314Accident · 2 fatalClass 3 · FieldFinal reportCessna 210C · Shelby, MIThe non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…NTSB WPR22LA253Accident · 2 fatalClass 3 · LimitedFinal reportCessna P210N · Buffalo, WYThe pilot’s decision to continue the visual flight rules flight into localized instrument meteorological conditions, which resulted in an encounter with convective turbulence and a subsequent loss of control and in-flight breakup.NTSB WPR22FA172Accident · 2 fatalClass 3 · FieldFinal reportVans RV10 · Sausalito, CAThe pilot’s improper decision to continue a visual flight rules flight into an area of limited visibility conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA22LA180Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Fort White, FLThe non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB ERA22LA142Accident · 2 fatalClass 3 · LimitedFinal reportVans RV-12IS · Big Pine Key, FLThe pilot’s inadequate preflight and in-flight weather planning and his improper decision to continue visual flight rules flight into an area of limited visibility in moderate precipitation, which resulted in a loss of airplane control due to spatial…NTSB ERA22FA096Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cosby, TNThe pilot’s intentional, continued flight into instrument meteorological conditions in a helicopter that was not certified for instrument conditions, which resulted in a loss of helicopter control and a collision with trees and terrain.NTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…NTSB GAA22WA054Accident · 1 fatalClass 5 · ForeignCirrus Design SR22 · Auxerre, FranceNTSB ERA22FA085Accident · 2 fatalClass 3 · FieldFinal reportBeech V35 · Crab Orchard, KYThe noninstrument-rated pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control and collision with terrain. Contributing to the accident was…NTSB ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB WPR22FA054Accident · 4 fatalClass 3 · FieldFinal reportBeech V35 · Visalia, CAThe pilot’s loss of control due to spatial disorientation shortly after takeoff. Contributing to the accident was the pilot’s decision to depart into night instrument meteorological conditions.NTSB CEN22FA058Accident · 1 fatalClass 3 · FieldFinal reportCessna 182L · Bonnerdale, ARThe noninstrument rated pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent impact with terrain.NTSB GAA22WA082Accident · 1 fatalClass 5 · ForeignCubcrafters CC11-160 · Monterrey, MexicoNTSB ERA22LA060Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Wilkes-Barre, PAThe pilot’s decision to commence the flight in marginal visual flight rules conditions at night, and his failure to maintain a safe altitude once instrument conditions were encountered.NTSB WPR22LA032Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Holtville, CAThe pilot’s failure to maintain helicopter control after becoming spatially disoriented when the helicopter entered low-level haze/fog.NTSB CEN22FA023Accident · 2 fatalClass 3 · FieldFinal reportBeech P35 · Harrison, NEThe pilot’s decision to continue the flight into instrument and icing conditions, which resulted in loss of control and impact with terrain. Contributing to the accident was the pilot’s failure to obtain a timely weather briefing.NTSB WPR22FA021Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Dunsmuir, CAThe non-certificated pilot’s improper decision to continue the flight under visual flight rules into instrument meteorological conditions which resulted in controlled flight into terrain.NTSB CEN22FA013Accident · 2 fatalClass 3 · FieldFinal reportNew Glasair Glastar · Waukesha, WIThe noninstrument-rated pilot’s decision to depart and continue flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA21FA362Accident · 3 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Monticello, GAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions during a dark night and over unlit terrain, which resulted in spatial disorientation and a subsequent loss of helicopter control.NTSB ANC21FA069Accident · 6 fatalClass 2 · FieldFinal reportDehavilland DHC-2 MK.I · Ketchikan, AKThe pilot’s decision to continue visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in controlled flight into terrain. Contributing to the accident was the FAA’s reliance on voluntary compliance with the Ketchikan…NTSB ERA21LA295Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Point Harbor, NCThe noncertificated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation over a large body of water and a high velocity impact with the water. Contributing to the accident…NTSB CEN21FA297Accident · 1 fatalClass 3 · FieldFinal reportEarthstar Gull 2000 · Curtiss, WIThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions with dense fog and low clouds, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot’s self-imposed…NTSB ERA21LA191Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 · Forkston, PAThe pilot’s inadequate preflight weather planning, which resulted in an inadvertent encounter with instrument meteorological conditions at night, spatial disorientation, and collision with terrain.NTSB ERA21FA189Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201T · Brownsville, TNThe student pilot’s continued visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a rapid uncontrolled descent into terrain. Contributing to the accident were the self-induced and external…NTSB CEN21FA125Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Galt, MOThe pilot’s decision to takeoff into instrument meteorological conditions consisting of low ceilings and icing and his failure to remain clear of terrain while attempting to remain below the clouds, which resulted in impact with terrain.NTSB ERA21LA028Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Point Lookout, NYThe pilot’s decision to depart on a visual flight rules flight, and to continue that flight into forecasted and deteriorating instrument meteorological conditions (IMC) in a helicopter that was not equipped for flight in IMC, which resulted in the pilot’s…NTSB WPR20LA319Accident · 1 fatalClass 3 · LimitedFinal reportCessna T182 · Santa Barbara, CAThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions.NTSB ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.NTSB WPR20LA304Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Seeley Lake, MTThe noninstrument-rated pilot’s encounter with instrument meteorological conditions during a night visual approach due to wildfire smoke, which resulted in controlled flight into terrain.NTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.NTSB CEN20LA379Accident · 4 fatalClass 3 · LimitedFinal reportCirrus SR22 · Chester, ARThe noninstrument-rated pilot’s continued flight into dark night instrument meteorological conditions which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB ERA20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA20 · Luray, VAThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and collision with terrain.NTSB ERA20LA262Accident · 2 fatalClass 3 · LimitedFinal reportBeech F33 · Malbis, ALThe noninstrument-rated pilot’s decision to depart in deteriorating weather conditions, which led to restricted visibility and the pilot’s loss of airplane control due to spatial disorientation. Contributing to the pilot’s poor decision-making was…NTSB ERA20CA222Accident · No injuriesClass 4 · Data collectionFinal reportBeech 77 · Elizabethton, TNThe student pilot's decision to continue from visual flight into instrument meteorological conditions, which resulted in a collision with trees and mountainous terrain.NTSB CEN20LA186Accident · 2 fatalClass 3 · LimitedFinal reportCessna T206 · Center, TXThe non-instrument rated pilot’s intentional flight into instrument meteorological conditions (clouds) which resulted in spatial disorientation and an inflight loss of control.NTSB WPR20CA089Accident · Minor injuriesData collectionFinal reportCessna 208 · Eureka, CAThe pilot's delayed response to initiate a go-around during a night visual approach over water after the airplane entered instrument meteorological conditions, which resulted in a loss of forward visibility and subsequent impact with the water.NTSB ERA20FA088Accident · 1 fatalClass 3 · FieldFinal reportAeropro CZ A220 · Grafton, WVThe pilot’s decision to continue a visual flight rules flight into instrument meteorological conditions and conditions favorable for airframe icing, which resulted in a loss of control of the airplane.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 ANC20MA010Accident · 7 fatalClass 1 · MajorFinal reportAirbus AS350B2 · Kekaha, HIThe pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…NTSB CEN20WA011Accident · 2 fatalForeign investigationCessna 172 · San Salvador, El SalvadorNTSB WPR20WA003Accident · 2 fatalForeign investigationCessna 172 · Sultanpur, IndiaOn October 6, 2019, about 0750 coordinated universal time, a Cessna 172, VT-RGF, impacted terrain near Sultanpur, India after requesting to turn back due to bad weather. The student pilot and passenger were fatally injured, and the airplane was destroyed. The…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 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 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 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.