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 ERA15FA220Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Rowdy, KYThe noninstrument-rated pilot’s decision to continue visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.May 21, 2015 · N26886 · DestroyedNTSB WPR15FA152Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Mt Tom, ORThe noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.Apr 22, 2015 · N1729J · DestroyedNTSB WPR15FA147Accident · 1 fatalField investigationFinal reportRobert C. Hanson Pitts S2E · Lebec, CAThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.Apr 14, 2015 · N75BH · DestroyedNTSB 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…Apr 7, 2015 · N789UP · Substantial damageNTSB CEN15FA189Accident · 1 fatalField investigationFinal reportCessna 152 · Batesville, ARThe noninstrument-rated pilot's controlled flight into terrain due to an inadvertent encounter with clouds in dark night conditions. Contributing to the accident was the pilot's decision to fly at night in marginal visual meteorological conditions without the…Apr 2, 2015 · N65463 · DestroyedNTSB WPR15FA135Accident · 1 fatalField investigationFinal reportPiper PA32R - 301 · Townsend, MTThe pilot's decision to depart on and to continue a visual flight rules flight over mountainous terrain into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of recent…Mar 26, 2015 · C-GAUS · Substantial damageNTSB ERA15LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Masscotte, FLThe pilot's failure to use carburetor heat during the flight while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's decision to take off…Mar 20, 2015 · N8254S · Substantial damageNTSB CEN15FA174Accident · 1 fatalField investigationFinal reportCessna 182Q · El Paso, TXThe pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.Mar 17, 2015 · N735KF · DestroyedNTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.Mar 13, 2015 · N919EM · DestroyedNTSB ERA15FA144Accident · 3 fatalField investigationFinal reportMooney M20F · Norfolk, VAThe pilot's failure to properly execute the instrument approach procedure. Contributing to the accident were the pilot's improper preflight planning and his decision to conduct the flight in instrument meteorological conditions at night into forecast moderate…Mar 4, 2015 · N66BB · Substantial damageNTSB CEN15FA135Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Lubbock, TXThe pilot's loss of airplane control due to spatial disorientation and light ice accumulation while operating in night, instrument meteorological conditions with gusting wind.Feb 5, 2015 · N301D · DestroyedNTSB ERA15CA127Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Carthage, NYThe non-helicopter-rated pilot's improper decision to operate the helicopter at low-level and his inability to adequately see the horizon over snow and ice, which resulted in controlled flight into terrain.Feb 1, 2015 · N20059 · Substantial damageNTSB ERA15FA099Accident · 1 fatalField investigationFinal reportCessna 152 · New Smyrna Beach, FLThe pilot's failure to maintain control of the airplane while operating under visual flight rules (VFR) in night, instrument meteorological conditions, likely due to spatial disorientation. Contributing to the outcome was the radar controller's failure to…Jan 14, 2015 · N757ZM · Substantial damageNTSB WPR15FA082Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Tooele, UTThe non-instrument rated pilot’s decision to depart into low visibility conditions, which resulted in spatial disorientation and a loss of control. Contributing to the accident was the pilot’s impaired performance due to his use of the sedating antihistamine,…Jan 9, 2015 · N383GM · Substantial damageNTSB CEN15LA098Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Parker City, INThe pilot’s loss of airplane control while troubleshooting an engine issue in instrument meteorological conditions, which resulted in impact with trees and terrain.Jan 4, 2015 · N349EA · Substantial damageNTSB WPR15FA072Accident · 2 fatalField investigationFinal reportBell 206 · Benson, AZThe pilot’s continued visual flight into instrument meteorological conditions which resulted in an inflight collision with terrain. Contributing to the accident was the pilot’s inadequate preflight planning, during which he failed to identify forecasted…Jan 1, 2015 · N57AW · DestroyedNTSB CEN15FA092Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Vaughn, NMThe noninstrument-rated pilot’s continued flight into night instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain.Dec 30, 2014 · N2558M · Substantial damageNTSB WPR15FA070Accident · 2 fatalField investigationFinal reportCessna 172 · Sutter Creek, CAThe noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…Dec 24, 2014 · N8518B · Substantial damageNTSB CEN15FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Port Huron, MIThe pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.Dec 24, 2014 · N38884 · DestroyedNTSB CEN15FA081Accident · 1 fatalField investigationFinal reportBeech V35A · Seagoville, TXThe pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.Dec 19, 2014 · N555SF · DestroyedNTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…Dec 8, 2014 · N100EQ · DestroyedNTSB ERA15FA066Accident · 1 fatalField investigationFinal reportPiper PA28 · Sommerville, TNThe noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…Dec 2, 2014 · N8607W · DestroyedNTSB CEN15LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Berrien Springs, MIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Nov 28, 2014 · N5897P · Substantial damageNTSB CEN15FA051Accident · 2 fatalField investigationFinal reportMooney M20C · Pagosa Springs, COThe noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.Nov 15, 2014 · N6466U · DestroyedNTSB CEN15FA044Accident · 1 fatalField investigationFinal reportMooney M20K · Clines Corners, NMThe noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…Nov 13, 2014 · N231JF · DestroyedNTSB CEN15FA040Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Grover Hill, OHThe airplane's encounter with supercooled large droplet (SLD) icing, which resulted in a loss of lift and a subsequent uncontrolled descent into terrain. Also causal was the pilot's preflight and in-flight decision to fly in known icing conditions in an…Nov 6, 2014 · N811CD · DestroyedNTSB CEN15FA027Accident · 1 fatalField investigationFinal reportCessna T210M · Bay City, WIThe non-instrument rated pilot’s continued visual flight into instrument flight rules conditions, which resulted in an in-flight loss of control.Oct 24, 2014 · N761SU · DestroyedNTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.Oct 13, 2014 · N31EW · DestroyedNTSB CEN14FA506Accident · 1 fatalField investigationFinal reportCessna 172R · Okmulgee, OKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.Sep 19, 2014 · N2435R · Substantial damageNTSB ERA14LA433Accident · Serious injuriesLimited investigationFinal reportPiper J3C 65 · Carrol County, VAThe pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…Sep 10, 2014 · N26105 · Substantial damageNTSB CEN14CA512Accident · No injuriesData collectionFinal reportChampion 7GCAA · Alpine, TXThe loss of airplane control during a precautionary landing resulting in a hard landing.Sep 7, 2014 · N2535F · Substantial damageNTSB CEN14LA419Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · South Haven, MIThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.Aug 11, 2014 · N214EV · Substantial damageNTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.Aug 9, 2014 · N7968Z · DestroyedNTSB CEN14LA424Accident · 2 fatalLimited investigationFinal reportBarger Steve M RV-7A · Russell, IAThe noninstrument-rated pilot’s inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.Aug 9, 2014 · N92BF · DestroyedNTSB ERA14CA373Accident · Minor injuriesData collectionFinal reportPiper PA-46-350P · Statesville, NCThe pilot's failure to maintain a proper glide path and airspeed on final approach, which resulted in a long landing and runway excursion.Aug 2, 2014 · N472ST · Substantial damageNTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.Jul 26, 2014 · N248SP · DestroyedNTSB CEN14FA369Accident · 3 fatalField investigationFinal reportAgusta A109E · Newkirk, NMThe pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.Jul 17, 2014 · N507CF · DestroyedNTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jul 8, 2014 · N5816B · Substantial damageNTSB WPR14FA231Accident · 1 fatalField investigationFinal reportGrumman G 21A · Sula, MTThe pilot's decision to continue flight into deteriorating weather conditions in an airplane not maintained for instrument flight, which resulted in a loss of control due to spatial disorientation.Jun 17, 2014 · N888GG · DestroyedNTSB ERA14FA292Accident · 1 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · East Patchogue, NYThe noninstrument-rated pilot's encounter with instrument meteorological conditions and his decision to continue visual flight rules flight in instrument conditions, which resulted in a loss of control due to spatial disorientation.Jun 17, 2014 · N610MH · DestroyedNTSB WPR14FA244Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5B · Florence, ORThe noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.Jun 15, 2014 · N28718 · DestroyedNTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…Jun 13, 2014 · N5335R · DestroyedNTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…Jun 7, 2014 · N86NW · Substantial damageNTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.May 31, 2014 · N6275G · Substantial damageNTSB WPR14FA188Accident · 2 fatalField investigationFinal reportMooney M20C · Cody, WYThe non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.May 6, 2014 · N6704U · Substantial damageNTSB CEN14FA224Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Highmore, SDThe pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…Apr 28, 2014 · N8700E · DestroyedNTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.Apr 26, 2014 · N911EX · DestroyedNTSB ERA14CA189Accident · No injuriesData collectionFinal reportMoore Thomas O Zenith Stol CH701 · Frostproof, FLThe pilot's failure to maintain directional control during a precautionary landing. Contributing to the accident was the pilot's delayed decision to divert due to deteriorating weather.Apr 8, 2014 · N12369 · Substantial damageNTSB WPR14TA149Accident · No injuriesFinal reportBell OH-58A · Tehachapi, CAThe pilot's decision to attempt a mission at night with known en route weather conditions below operating minimums, likely due to self-induced pressure, and then continue flight beyond the alternate landing airport as weather conditions deteriorated, which…Mar 27, 2014 · N497E · Substantial damageNTSB ERA14FA163Accident · 1 fatalField investigationFinal reportDehavilland DHC-1 · Vonore, TNThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Mar 23, 2014 · N540FM · Substantial damage