NTSB investigations, 2018

125 cases where the sequence of events included Other weather encounter.

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 year(c.\"eventDate\") = 2018
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' 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.

NTSB GAA18CA474Accident · No injuriesData collectionFinal reportDiamond DA20 · Van Nuys, CAThe student pilot's failure to maintain directional control during landing in a left quartering headwind, which resulted in a ground loop.Jul 18, 2018 · N309EF · Substantial damageNTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…Jul 17, 2018 · N24515 · Substantial damageNTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.Jul 16, 2018 · N5551L · Substantial damageNTSB GAA18CA426Accident · No injuriesData collectionFinal reportPiper PA 20 · Dayton, OHThe pilot's inadequate compensation for variable crosswind conditions during landing, which resulted in a runway excursion.Jul 14, 2018 · N7492K · Substantial damageNTSB ERA18TA193Accident · Serious injuriesFinal reportQuicksilver MXL II · Arecibo, PRThe noncertificated pilot's improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 14, 2018 · N594TC · Substantial damageNTSB GAA18CA404Accident · No injuriesData collectionFinal reportCessna 180 · Cut Bank, MTThe pilot's failure to maintain directional control during the landing roll.Jul 9, 2018 · N180GB · Substantial damageNTSB GAA18CA392Accident · No injuriesData collectionFinal reportSchempp Hirth Discus CS · Pomfret, VTThe glider pilot’s selection of an unsuitable landing area, which resulted in a collision with a ditch during the landing roll.Jul 3, 2018 · N1122Q · Substantial damageNTSB GAA18CA449Accident · No injuriesData collectionFinal reportCessna 182 · Swainsboro, GAThe pilot's unstabilized approach during the initial landing with a right quartering tailwind, which resulted in a hard landing and subsequent go-around and the collapse of the nose landing gear during the subsequent landing.Jun 30, 2018 · N6167L · Substantial damageNTSB GAA18CA416Accident · No injuriesData collectionFinal reportAeroprakt A-22 Valor · Malone, NYThe pilot’s improper crosswind correction during the landing flare in gusting wind conditions, which resulted in a hard landing.Jun 30, 2018 · N712FP · Substantial damageNTSB GAA18CA389Accident · No injuriesData collectionFinal reportSchweizer SGS 1 34 · Boulder, COThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard landing.Jun 27, 2018 · N134BC · Substantial damageNTSB GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.Jun 23, 2018 · N123PW · Substantial damageNTSB ERA18LA175Accident · Minor injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Newburyport, MAThe pilot's failure to adequately compensate for existing crosswind conditions during the final approach and landing flare, which led to the airplane drifting left of the runway, and his delayed decision to go around, which resulted in the airplane touching…Jun 20, 2018 · N239AM · Substantial damageNTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.Jun 15, 2018 · N3764Z · Substantial damageNTSB ANC18LA046Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Ambler, AKThe pilot's selection of an unsuitable takeoff area with unfavorable wind conditions, which resulted in the airplane’s inability to maintain a climb.Jun 15, 2018 · N2957K · Substantial damageNTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.Jun 14, 2018 · N67404 · Substantial damageNTSB GAA18CA336Accident · No injuriesData collectionFinal reportAviat A 1 · Renton, WAThe pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface.Jun 10, 2018 · N352AM · Substantial damageNTSB CEN18FA217Accident · 2 fatalField investigationFinal reportLet L 23 Super Blanik · Moose, WYThe pilot's encounter with atmospheric conditions that resulted in a loss of lift and a subsequent loss of control near terrain that precluded recovery. Contributing to the accident was the pilot's failure to follow the operator's published tour flight…Jun 9, 2018 · N317BA · DestroyedNTSB ERA18LA162Accident · No injuriesLimited investigationFinal reportBryan C L/Labrash R D Searey · Englewood, FLThe partial loss of engine power due to carburetor icing.Jun 7, 2018 · N907CB · Substantial damageNTSB GAA18CA324Accident · No injuriesData collectionFinal reportPiper PA 22 · Talkeetna, AKThe flight instructor’s improper landing flare and failure to maintain a proper descent rate during approach, which resulted in a hard landing.Jun 4, 2018 · N7257D · Substantial damageNTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…Jun 2, 2018 · N62073 · Substantial damageNTSB GAA18CA321Accident · Minor injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Ketchikan, AKThe pilot’s failure to maintain pitch and directional control during a water landing.Jun 1, 2018 · N203KL · Substantial damageNTSB GAA18CA314Accident · No injuriesData collectionFinal reportSchleicher ASW · Nephi, UTThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a hard off-airport landing.May 30, 2018 · N428US · Substantial damageNTSB GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.May 28, 2018 · N84163 · Substantial damageNTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.May 28, 2018 · N2004U · Substantial damageNTSB GAA18CA301Accident · No injuriesData collectionFinal reportEldridge George Skystar Kitfox SER 7 · Weippe, IDThe pilot’s failure to maintain a proper approach altitude, which resulted in a collision with a fence.May 27, 2018 · N103GE · Substantial damageNTSB WPR18LA145Accident · Minor injuriesLimited investigationFinal reportSportavia Putzer RF5B Sperber · Lookout Pass, MTThe pilot’s improper decision to continue flight toward rising terrain after the engine overheated, which necessitated a precautionary landing when the motorglider could not maintain altitude in downdrafts.May 22, 2018 · N66GL · Substantial damageNTSB WPR18CA146Accident · No injuriesData collectionFinal reportAyres S2R G10 · Marysville, CAThe pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.May 22, 2018 · N32064 · Substantial damageNTSB GAA18CA293Accident · No injuriesData collectionFinal reportCessna 150 · Bemidgi, MNThe student pilot’s failure to maintain lateral control of the airplane during the landing roll, which resulted in a side load and subsequent failure of the left main landing gear extension casting.May 22, 2018 · N5999T · Substantial damageNTSB GAA18CA287Accident · No injuriesData collectionFinal reportMaule M 7 · Burnet, TXThe pilot’s failure to maintain directional control during landing in gusting wind conditions and with an incorrect flap configuration.May 19, 2018 · N427LS · Substantial damageNTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.May 18, 2018 · N7265K · Substantial damageNTSB GAA18CA280Accident · Minor injuriesData collectionFinal reportCessna 172 · Nooksack, WAThe pilot’s improper approach in tailwind conditions, which resulted in long landing and subsequent runway overrun.May 14, 2018 · N4144L · DestroyedNTSB GAA18CA292Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe student pilot’s improper landing flare in tailwind conditions, which resulted in a hard landing.May 11, 2018 · N610FT · Substantial damageNTSB GAA18CA270Accident · No injuriesData collectionFinal reportJetson'S Aircam · Bumpass, VAThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around.May 9, 2018 · N334JS · Substantial damageNTSB GAA18CA262Accident · No injuriesData collectionFinal reportCessna 182 · Albuquerque, NMThe pilot’s decision to continue flight in mountainous terrain with downdraft conditions, which necessitated a precautionary landing on unsuitable terrain.May 7, 2018 · N632EP · Substantial damageNTSB GAA18CA260Accident · No injuriesData collectionFinal reportCessna 182 · Clarksville, TNThe pilot’s decision to land with a tailwind in variable crosswind and downdraft and updraft conditions on a wet runway, which resulted in a runway overrun.May 6, 2018 · N5419E · Substantial damageNTSB GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.May 5, 2018 · N4534H · Substantial damageNTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.May 5, 2018 · N7762X · Substantial damageNTSB GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.May 5, 2018 · N76SC · Substantial damageNTSB GAA18CA254Accident · No injuriesData collectionFinal reportBeech 58 · Sisters, ORThe pilot’s failure to maintain sufficient altitude during approach in gusting crosswind conditions, which resulted in an attempted rejected landing and a runway undershoot.May 5, 2018 · N222BD · Substantial damageNTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.May 4, 2018 · N99141 · Substantial damageNTSB GAA18CA347Accident · No injuriesData collectionFinal reportPiper PA28 · Pine Spring, TXThe pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.May 2, 2018 · N9494J · Substantial damageNTSB GAA18CA294Accident · No injuriesData collectionFinal reportCessna 172 · Palo Alto, CAThe pilot’s improper landing flare, which resulted in a hard landing.Apr 30, 2018 · N254EK · Substantial damageNTSB GAA18CA242Accident · No injuriesData collectionFinal reportSeno Louis C SR KIS · Eagle Lake, TXThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Apr 29, 2018 · N66SK · Substantial damageNTSB GAA18CA236Accident · No injuriesData collectionFinal reportL-Bird CCX-2000 · Hood River, ORThe pilot’s decision to take off in gusting wind conditions, which resulted in a loss of directional control.Apr 27, 2018 · N844FC · Substantial damageNTSB GAA18CA224Accident · No injuriesData collectionFinal reportMooney M20R · San Antonio, TXThe pilot’s landing long in tailwind conditions with insufficient runway remaining to stop the airplane.Apr 16, 2018 · N6868 · Substantial damageNTSB CEN18FA143Accident · 2 fatalField investigationFinal reportBeech G33 · Warsaw, OHThe pilot's decision to continue flight in known icing conditions, which resulted in structural icing, degraded airplane performance, and a subsequent loss of control. Contributing to the accident was the pilot's failure to obtain an official weather briefing…Apr 16, 2018 · N9345Q · Substantial damageNTSB GAA18CA217Accident · No injuriesData collectionFinal reportSmith Dennis P Magni M24 · La Grange, TXThe pilot’s failure to maintain lateral control while taxiing onto the runway in gusting wind conditions.Apr 14, 2018 · N3PW · Substantial damageNTSB GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.Apr 5, 2018 · N1438U · Substantial damageNTSB CEN18FA266Accident · 1 fatalField investigationFinal reportCessna 210 · Alma, COThe noncertificated pilot's poor decision to depart on a flight over mountainous terrain in an improperly maintained airplane, and the subsequent encounter with mountain wave turbulence, which resulted in the loss of airplane control and impact with terrain.…Apr 2, 2018 · N68640 · Substantial damageNTSB ERA18LA119Accident · 2 fatalLimited investigationFinal reportAmes Angier M LNC2 · Atlantic Ocean (Atlantic Ocean)The pilot's spatial disorientation after entering instrument meteorological conditions and encountering moderate-to-heavy precipitation, which resulted in a loss of airplane control.Mar 31, 2018 · N4ZQ · Substantial damage