NTSB investigations

219 cases where NTSB found Snow/slush/ice covered surface.

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\", '03023015'))
  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 GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.Dec 23, 2016 · N7961F · Substantial damageNTSB GAA17CA101Accident · No injuriesData collectionFinal reportMaule MX 7 · Willow, AKThe pilot’s failure to ensure that the runway was clear of any obstacles before departure, which resulted in the airplane impacting a snowdrift.Dec 15, 2016 · N56681 · 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 GAA16CA191Accident · No injuriesData collectionFinal reportBeech C23 · Frenchville, METhe pilot's failure to maintain directional control during the takeoff roll on a runway contaminated with ice and snow, which resulted in a runway excursion and an impact with a snowbank.Mar 30, 2016 · N2397E · Substantial damageNTSB ANC16CA014Accident · No injuriesData collectionFinal reportCessna 180 · Sleetmute, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.Feb 14, 2016 · N2253C · Substantial damageNTSB GAA16CA120Accident · Minor injuriesData collectionFinal reportCessna 210 · Park Valley, UTThe pilot's decision to drag the left main landing gear on a snow covered dry lake bed, which resulted in a loss of directional control and a nose over during an aborted landing.Feb 2, 2016 · N8340Z · Substantial damageNTSB DCA16CA070Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Newark, NJthe ground crew's misjudgment of the distance between the B767 wingtip and the MD-88 tail. Contributing to the accident was the slushy condition of the ramp which limited the maneuvering space available.Jan 24, 2016 · N908DE · Substantial damageNTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.Jan 2, 2016 · N947SP · Substantial damageNTSB ANC16CA009Accident · No injuriesData collectionFinal reportCessna 172 · Manley Hot Springs, AKThe pilot's decision to depart from an unsuitable, off-airport site, which resulted in a collision with a tree.Nov 27, 2015 · N7176A · Substantial damageNTSB DCA15FA085Accident · No injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD 88 · New York, NYthe captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…Mar 5, 2015 · N909DL · Substantial damageNTSB CEN15LA144Accident · No injuriesLimited investigationFinal reportBeech 58 · Denver, COThe pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.Feb 16, 2015 · N297AT · Substantial damageNTSB CEN15CA097Accident · No injuriesData collectionFinal reportCessna 172M · Marquette, MIThe pilot did not maintain directional control during takeoff on the snow and ice covered runway in gusting crosswind conditions.Jan 5, 2015 · N6591H · Substantial damageNTSB ERA15CA079Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Henniker, NHThe pilot's failure to maintain aircraft control while landing, which resulted in a collision with a snow bank. Contributing to the accident was ice that covered the landing surface.Dec 22, 2014 · N64HF · Substantial damageNTSB CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.Nov 16, 2014 · N6985G · Substantial damageNTSB ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.Apr 10, 2014 · N2143N · Substantial damageNTSB ANC14CA021Accident · No injuriesData collectionFinal reportCessna 180 · North Pole, AKThe pilot's failure to maintain directional control of the airplane while taxiing on a snow covered runway, which resulted in a collision with a terrain.Mar 27, 2014 · N3125D · Substantial damageNTSB CEN14CA158Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Chisago City, MNThe unsuitable landing area encountered by the pilot due to wet soft snow conditions that resulted in a nose over.Mar 10, 2014 · N63HE · Substantial damageNTSB ANC14CA017Accident · Minor injuriesData collectionFinal reportSilvaire Luscombe 8E · Alegnagik, AKThe pilot's failure to determine that the ice that he was taxiing on was safe for operation.Mar 2, 2014 · N2542K · Substantial damageNTSB CEN14LA146Accident · No injuriesLimited investigationFinal reportFogg Quicksilver MX II · Holland, MIThe pilot's inability to maintain airplane control after inadvertently landing in an area of deep snow on a frozen lake.Feb 15, 2014 · N94567 · Substantial damageNTSB CEN14CA132Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Hartford, WIThe pilot's inadequate preflight planning and failure to inspect the runway before departure.Feb 8, 2014 · N43955 · Substantial damageNTSB WPR14LA113Accident · No injuriesLimited investigationFinal reportBell 206 · Bountiful, UTThe pilots' inaccurate assessment of the snow depth on the landing zone, which resulted in a landing on snow deeper than that for which the helicopter was equipped and led to dynamic rollover.Feb 5, 2014 · N3211N · Substantial damageNTSB CEN14CA114Accident · No injuriesData collectionFinal reportCessna 340 · Coldwater, MIAirport personnel did not remove the snow banks from the intersecting runway and/or close the intersection runway, which resulted in the airplane impacting the snow banks. Contributing to the accident was the reduced visibility inhibiting the pilot's ability…Jan 15, 2014 · N10MF · Substantial damageNTSB CEN14LA080Accident · No injuriesLimited investigationFinal reportPiper PA46 500TP · Albuquerque, NMThe pilot’s loss of directional control during landing due to his inadequate compensation for the tailwind.Dec 7, 2013 · N220JE · Substantial damageNTSB CEN14CA078Accident · No injuriesData collectionFinal reportCessna 152 · Columbia Station, OHThe pilot's inadequate flight planning and decision to land on the soft grass/turf runway which resulted in a nose over.Dec 7, 2013 · N93756 · Substantial damageNTSB ANC14CA009Accident · No injuriesData collectionFinal reportCessna A185F · Nenana, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrain.Nov 23, 2013 · N8310Q · Substantial damageNTSB ANC14CA004Accident · No injuriesData collectionFinal reportPiper J3C 65 · Talkeetna, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.Oct 10, 2013 · N70604 · Substantial damageNTSB ANC13CA104Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Delta Junction, AKThe pilot's inadequate takeoff planning and judgment that did not consider the reduced acceleration due to snow-covered terrain, which resulted in an aborted takeoff and collision with terrain.Sep 19, 2013 · N7190D · Substantial damageNTSB ANC13CA046Accident · No injuriesData collectionFinal reportCessna U206G · Nenana, AKIce accretion in the right main landing gear wheel brake during departure, which prevented the right main landing gear from rotating on landing and resulted in a runway excursion and subsequent impact with a snow bank.Apr 24, 2013 · N756DJ · Substantial damageNTSB ANC13CA037Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane while taxiing on a snow-covered taxiway.Mar 26, 2013 · N995SP · Substantial damageNTSB ANC13CA034Accident · No injuriesData collectionFinal reportPiper PA-16 · Big Lake, AKThe pilot's decision to land on unsuitable terrain.Mar 17, 2013 · N5942H · Substantial damageNTSB ANC13LA032Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe overstress fracture and failure of the right wheel/ski arm while taxiing in snow and water-overflow terrain conditions, which resulted in a noseover.Mar 8, 2013 · N185FK · Substantial damageNTSB ANC13CA023Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Dutch Harbor, AKThe pilot's decision to land in wind conditions that exceeded the airplane's demonstrated crosswind capability, which resulted in a loss of airplane control during the landing roll.Feb 16, 2013 · N15PR · Substantial damageNTSB CEN13CA161Accident · No injuriesData collectionFinal reportCessna 172M · Jenison, MIThe pilot's failure to maintain directional control while landing on an ice- and snow-covered runway in crosswind conditions.Feb 12, 2013 · N12989 · Substantial damageNTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.Jan 11, 2013 · N110BA · Substantial damageNTSB WPR13CA079Accident · No injuriesData collectionFinal reportCessna 182P · Chiloquin, ORThe flight instructor’s failure to maintain airplane control during a landing on a snow-covered runway.Jan 1, 2013 · N58677 · Substantial damageNTSB ANC12CA036Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series 3 · Chefornak, AKThe pilot's misidentification of a nearby snow-covered road as the snow-covered runway in flat light conditions.May 3, 2012 · N1906 · Substantial damageNTSB ANC12TA035Accident · No injuriesFinal reportPiper PA-18-150 · Paxon, AKA separation of the right main landing gear suspension strut assembly due to overstress, which resulted in the collapse of the main landing gear while landing.Apr 28, 2012 · N7059 · Substantial damageNTSB ANC12CA033Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 Ecureuil · Valdez, AKThe pilot's selection of an unsuitable landing surface, which resulted in the tail rotor contacting terrain.Apr 18, 2012 · N191EH · Substantial damageNTSB WPR12CA148Accident · No injuriesData collectionFinal reportStinson 108-1 · Coolin, IDThe pilot’s decision to land on a snow-covered runway.Mar 25, 2012 · N97032 · Substantial damageNTSB WPR12CA145Accident · No injuriesData collectionFinal reportRockwell International 690C · Conrad, MTThe pilot did not maintain directional control of the airplane due to ice and slushy snow on the runway during the landing roll.Mar 23, 2012 · N840JC · Substantial damageNTSB ANC12CA025Accident · No injuriesData collectionFinal reportHughes 369 · Trading Bay, AKThe pilot's selection of an unsuitable landing site in flat-light conditions, which resulted in an inadvertent dynamic rollover.Mar 11, 2012 · C-GVEB · Substantial damageNTSB ANC12CA027Accident · No injuriesData collectionFinal reportCessna U206G · Naknek, AKThe pilot's decision to take off from an unsuitable off-airport site.Mar 9, 2012 · N756CL · Substantial damageNTSB CEN12CA160Accident · No injuriesData collectionFinal reportCessna 180 · South Fork, COThe pilot's loss of directional control while landing on a patchy snow-covered runway.Feb 18, 2012 · N56180 · Substantial damageNTSB WPR12CA112Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not maintain directional control while landing on a snow-contaminated runway.Feb 14, 2012 · N8433V · Substantial damageNTSB WPR12CA101Accident · No injuriesData collectionFinal reportLearjet 31A · Wheatland, WYThe flight crew’s loss of directional control during landing on an ice- and water-contaminated runway, which resulted in a runway excursion.Feb 11, 2012 · N382AL · Substantial damageNTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.Feb 10, 2012 · N46279 · Substantial damageNTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.Feb 5, 2012 · N3671Z · Substantial damageNTSB CEN12FA151Accident · No injuriesField investigationFinal reportGates Lear Jet 35 · Pueblo, COThe captain's failure to maintain airplane control during an attempted crosswind takeoff on a contaminated runway.Feb 3, 2012 · N31WS · Substantial damageNTSB ERA12CA162Accident · No injuriesData collectionFinal reportCessna 172L · Grand Isle, VTThe pilot's inability to stop the airplane on a grass runway with undetected ice.Jan 28, 2012 · N811P · Substantial damage