NTSB investigations

829 cases where NTSB found Ceiling/visibility/precip.

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\", '030350'))
  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.

NTSB GAA17CA388Accident · No injuriesData collectionFinal reportCessna 207 · Hope, AKThe pilot’s inadvertent flight into instrument meteorological conditions and subsequent controlled flight into terrain.Jul 3, 2017 · N9620M · Substantial damageNTSB ERA17FA222Accident · 4 fatalField investigationFinal reportPiper PA23 · Chatsworth, GAThe noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…Jul 1, 2017 · N44HJ · DestroyedNTSB CEN17LA244Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 602 · Stirum, NDThe pilot's decision to attempt flight with low-level fog in the area, which resulted in an encounter with instrument meteorological conditions and impact with terrain.Jun 29, 2017 · N4196Y · DestroyedNTSB WPR17LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Carpinteria, CAThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jun 10, 2017 · N2171D · Substantial damageNTSB WPR17FA125Accident · 1 fatalField investigationFinal reportBeech 95 C55 · Mountain Ranch, CAThe pilot's continued visual flight rules flight into instrument meteorological conditions and mountain obscuration that resulted in controlled flight into trees and terrain.Jun 9, 2017 · N3717Q · DestroyedNTSB GAA17CA325Accident · No injuriesData collectionFinal reportCessna 182 · Ellington, CTThe pilot’s unstabilized approach and failure to go around in rainy, gusting crosswind conditions, which resulted in a runway overrun. Contributing to the accident was the pilot’s self-induced pressure to land due to the deteriorating weather conditions.Jun 1, 2017 · N6193B · Substantial damageNTSB ANC17LA025Accident · Minor injuriesClass 3 · LimitedFinal reportAirbus AS350 · Juneau, AKThe pilot's decision to depart into an area of degraded visual meteorological and flat light conditions, which resulted in a loss of visual references and subsequent controlled flight into terrain.May 23, 2017 · N207CH · Substantial damageNTSB ERA17FA181Accident · 4 fatalField investigationFinal reportMitsubishi MU2B · Eleuthera, BahamasThe pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.May 15, 2017 · N220N · DestroyedNTSB ERA17FA180Accident · 2 fatalField investigationFinal reportBeech A36TC · Hopkinsville, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…May 12, 2017 · N1804E · DestroyedNTSB GAA17CA274Accident · Minor injuriesData collectionFinal reportCessna 177 · Frankston, TXThe pilot’s loss of runway visibility during landing in rain, which resulted in the pilot’s loss of situational awareness and subsequent loss of airplane control.May 10, 2017 · N34207 · Substantial damageNTSB ANC17FA021Accident · 1 fatalField investigationFinal reportCessna 208B · Chignik Lake, AKThe pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot…May 1, 2017 · N803TH · Substantial damageNTSB WPR17FA091Accident · 1 fatalField investigationFinal reportNanchang CJ6A · Keene, CAThe pilot's failure to maintain airplane control following a descent into clouds.Apr 27, 2017 · N192NG · DestroyedNTSB WPR17FA105Accident · 2 fatalField investigationFinal reportSocata TB 20 Trinidad · Sierraville, CAThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.Apr 17, 2017 · N28070 · DestroyedNTSB GAA17CA215Accident · Minor injuriesData collectionFinal reportCessna 182 · Blue Earth, MNThe pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…Apr 3, 2017 · N8889X · Substantial damageNTSB ERA17FA139Accident · 2 fatalField investigationFinal reportMooney M20J · Aberdeen, MSThe pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.Mar 28, 2017 · N643RJ · Substantial damageNTSB ANC17FA018Accident · 1 fatalField investigationFinal reportCessna R172K · Nome, AKThe pilot's improper decision to conduct multiple visual approaches to the destination airport despite the night instrument meteorological conditions; the airplane's low fuel state at that time, which resulted in a total loss of engine power due to fuel…Mar 6, 2017 · N736AS · Substantial damageNTSB GAA17CA158Accident · No injuriesData collectionFinal reportSocata TBM700 · Bellingham, WAThe pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.Feb 27, 2017 · CGWVS · Substantial damageNTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.Feb 26, 2017 · N3712F · Substantial damageNTSB CEN17CA114Accident · No injuriesData collectionFinal reportCessna 340A · Waukesha, WIThe pilot’s decision to fly in in conditions conducive to structural icing and her subsequent failure to maintain airplane control during the instrument approach.Feb 25, 2017 · N255BC · Substantial damageNTSB ERA17LA113Accident · Serious injuriesLimited investigationFinal reportCirrus SR20 · Daytona Beach, FLThe pilot's inadvertent encounter with instrument meteorological conditions (fog) during initial climb, which resulted in a loss of control due to spatial disorientation.Feb 24, 2017 · N255JB · Substantial damageNTSB CEN17FA103Accident · 2 fatalField investigationFinal reportBell Helicopter Textron Canada 429 · Shreveport, LAThe pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain.Feb 15, 2017 · N598PB · Substantial damageNTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Feb 12, 2017 · N4504X · DestroyedNTSB CEN17FA100Accident · 1 fatalField investigationFinal reportBell 206B · Galveston, TXThe pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.Feb 7, 2017 · N978RH · DestroyedNTSB WPR17FA055Accident · 1 fatalField investigationFinal reportMooney M20J · Lake Hughes, CAThe pilot's controlled flight into mountainous terrain while attempting to operate under visual flight rules in instrument meteorological conditions (IMC).Jan 12, 2017 · N6201N · Substantial damageNTSB WPR17FA045Accident · 4 fatalField investigationFinal reportCessna T210K · Payson, AZThe non-instrument-rated pilot's improper decisions to begin and to continue a flight under visual flight rules into instrument meteorological conditions, which resulted in controlled flight into terrain.Jan 2, 2017 · N272EF · DestroyedNTSB WPR17FAMS2Accident · 3 fatalMissing aircraftFinal reportCessna 172M · Open water, HIUndetermined because the airplane was not located.Dec 31, 2016 · N174LL · DestroyedNTSB CEN17FA064Accident · 4 fatalField investigationFinal reportPiper PA 28R-200 · Vienna, ILThe non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.Dec 31, 2016 · N2806R · DestroyedNTSB WPR17FA044Accident · 4 fatalField investigationFinal reportCessna 182 · Dabob, WAThe non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…Dec 30, 2016 · N52388 · Substantial damageNTSB ERA17FA074Accident · 2 fatalField investigationFinal reportIndependent Technologies Epic LT · Port Orange, FLThe pilot's loss of airplane control due to spatial disorientation, which resulted in the exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's failure to fly a stabilized approach…Dec 27, 2016 · N669WR · Substantial damageNTSB ERA17FA073Accident · 3 fatalField investigationFinal reportCessna 182 · Gatlinburg, TNThe non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.Dec 26, 2016 · N1839X · DestroyedNTSB WPR17FA035Accident · 1 fatalField investigationFinal reportQuest Kodiak 100 · Moab, UTThe pilot's loss of control shortly after takeoff due to spatial disorientation.Dec 12, 2016 · N772RT · DestroyedNTSB ANC17LA011Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Unalaska, AKThe pilot’s failure to maintain adequate clearance from terrain during a precautionary landing in whiteout conditions, which resulted in an in-flight collision with terrain.Dec 2, 2016 · N7085K · Substantial damageNTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.Nov 23, 2016 · N80RT · Substantial damageNTSB WPR17FA021Accident · 2 fatalField investigationFinal reportHughes 369 · Pukoo, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions at night in rain, which resulted in his geographic disorientation and controlled flight into terrain.Nov 16, 2016 · N81GG · DestroyedNTSB ANC17FA004Accident · 1 fatalField investigationFinal reportFairchild Heli-Porter Pilatus PC-6 · Port Alsworth, AKThe airplane's collision with mountainous terrain while operating in an area of reduced visibility and icing conditions. Contributing to the accident was the pilot's inadequate preflight planning, which would have identified deteriorating weather conditions…Oct 29, 2016 · N5308F · Substantial damageNTSB OPS17IA003IncidentClass 2 · IncidentFinal reportDouglas DC 9 83 · Westfield, MAThe air traffic controller issuing the aircraft a clearance to land while there was a vehicle authorized to be on the same runway. Contributing to the incident was the air traffic controller's decision to not simulcast the local control and ground control…Oct 21, 2016 · N425NV · No damageNTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…Oct 15, 2016 · N8718X · DestroyedNTSB ERA17CA008Accident · Serious injuriesData collectionFinal reportAlgimantas Jonusas RV-10 · Ashwood, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning and continued flight into instrument meteorological conditions, which resulted in impact with trees and terrain.Oct 7, 2016 · N100UK · Substantial damageNTSB ANC17MA001Accident · 3 fatalClass 1 · MajorFinal reportCessna 208B · Togiak, AKThe flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…Oct 2, 2016 · N208SD · DestroyedNTSB WPR16LA189Accident · Serious injuriesLimited investigationFinal reportDehavilland Beaver DHC 2 MK.1 · Lopez Island, WAThe pilot's decision to land in an area of low visibility and ground fog, which resulted in collision with water.Sep 30, 2016 · N6781L · Substantial damageNTSB GAA16CA516Accident · No injuriesData collectionFinal reportPiper PA 18 · Kotzebue, AKThe pilot’s selection of unsuitable terrain for an off-airport precautionary landing, which resulted in a nose-over.Sep 26, 2016 · N2880P · Substantial damageNTSB ANC16LA071Accident · No injuriesLimited investigationFinal reportHelio H-295 · Delta Junction, AKThe pilot’s decision to take off from a wet, snowy airstrip and his delayed decision to abort the takeoff, which resulted in a runway excursion.Sep 26, 2016 · N68857 · Substantial damageNTSB ERA16LA323Accident · No injuriesLimited investigationFinal reportLearjet 25 · San Juan, PRThe pilot’s improper decision to land the airplane on a wet runway, in heavy rain, with tires worn beyond safe limits, which resulted in a hydroplaning condition and subsequent loss of directional control.Sep 22, 2016 · YV1738 · Substantial damageNTSB CEN16FA372Accident · Serious injuriesField investigationFinal reportAgusta A109 · Alexandria, MNThe pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.Sep 17, 2016 · N91NM · DestroyedNTSB CEN16LA338Accident · 2 fatalLimited investigationFinal reportCessna 172 · New Orleans, LAThe pilot's improper decision to continue a descent during a night visual approach a for landing which resulted in controlled flight into terrain. Contributing to the accident was the reduced visibility and pilot's disregard of the PAPI indications that the…Aug 28, 2016 · N984RA · Substantial damageNTSB ANC16LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Salcha, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.Aug 27, 2016 · N8998Y · Substantial damageNTSB CEN16FA331Accident · 2 fatalField investigationFinal reportStemme S10 VT · Telluride, COThe pilot's encounter with a downdraft that exceeded the climb performance of the powered glider and resulted in his inability to maintain clearance from the trees. Contributing to the accident was the pilot's decision to fly near building clouds and rain…Aug 24, 2016 · N5021 · Substantial damageNTSB DCA16MA204Accident · 16 fatalClass 1 · MajorFinal reportKubicek BB85 · Lockhart, TXThe pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…Jul 30, 2016 · N2469L · DestroyedNTSB CEN16FA295Accident · 1 fatalField investigationFinal reportMooney M20J · Holmen, WIThe pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.Jul 28, 2016 · N54PM · DestroyedNTSB GAA16CA383Accident · No injuriesData collectionFinal reportAeronca 7AC · Lenoir, NCThe pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to…Jul 18, 2016 · N84690 · Substantial damage