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 CEN21LA086Accident · No injuriesClass 4 · LimitedFinal reportEclipse EA 500 · Leadville, COThe pilot’s failure to maintain proper control of the airplane, which led to an unstabilized approach and a long landing on a runway contaminated with ice and patchy packed snow resulting in a runway excursion.Dec 14, 2020 · N686TM · Substantial damageNTSB ANC20CA039Accident · No injuriesData collectionFinal reportWag-Aero Sportsman 2+2 · Wasilla, AKThe pilot's loss of directional control during takeoff from an icy ski strip in gusting wind conditions, which resulted in the left wing impacting a tree.Mar 27, 2020 · N5045X · Substantial damageNTSB ANC20CA036Accident · No injuriesData collectionFinal reportCessna 175 · Soldotna, AKThe pilot's unintentional selection of the wrong landing surface, which was covered with 2 ft of snow and resulted in a nose-over.Mar 22, 2020 · N7023E · Substantial damageNTSB ANC20CA032Accident · No injuriesData collectionFinal reportCessna 172 · Big Lake, AKThe pilot's improper decision to initiate the takeoff roll from a snow-covered taxiway, which resulted in a loss of directional control, runway excursion, and impact with a snow berm.Mar 10, 2020 · N52168 · Substantial damageNTSB CEN20CA111Accident · Minor injuriesData collectionFinal reportCessna P206 · Hill City, MNThe pilot's failure to maintain the proper altitude and airspeed during the approach and his delayed addition of power to go around and the flight instructor’s delayed remedial action, which resulted in a nose-over after landing on the closed snow-covered…Mar 3, 2020 · N206JF · Substantial damageNTSB ANC20CA029Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 7GCAA · Sterling, AKThe pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting an area of deep snow. A factor associated with the accident was flat light conditions.Mar 3, 2020 · N9632S · Substantial damageNTSB ANC20CA023Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Talkeetna, AKThe pilot's failure to maintain adequate clearance from snow covered terrain during an en route descent in flat light conditions, which resulted in controlled flight into terrain.Feb 21, 2020 · N716JL · Substantial damageNTSB CEN20CA094Accident · No injuriesData collectionFinal reportCessna 172 · Boulder, COThe pilot's loss of directional control during the landing roll on the slush-covered runway.Feb 20, 2020 · N370SP · Substantial damageNTSB CEN20CA089Accident · No injuriesData collectionFinal reportPiper PA28 · Sparta, MIThe student pilot's failure to maintain directional control while landing on the snow/slush-covered portion of the runway and the flight instructor's improper decision to allow the student to make his first solo flight from a snow/slush-covered runway.Feb 16, 2020 · N6520W · Substantial damageNTSB CEN20LA083Accident · No injuriesClass 3 · LimitedFinal reportPiaggio P180 · Broomfield, COThe pilot’s loss of directional control on the snow-covered runway, which resulted in a runway excursion.Feb 13, 2020 · N677P · Substantial damageNTSB ANC20LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Hooper Bay, AKThe pilot’s decision to depart from a contaminated runway, and his failure to make a timely decision to abort the takeoff when the airplane was not accelerating as expected. Contributing to the accident was the pilot’s decision to depart in limited visibility…Feb 5, 2020 · N454SF · Substantial damageNTSB WPR20CA071Accident · No injuriesData collectionFinal reportCessna 172 · Sun River, ORThe pilot's failure to maintain directional control during the landing roll on a runway with icy patches, which resulted in impact with a snowbank and a subsequent nose-over.Jan 20, 2020 · N73707 · Substantial damageNTSB ANC20CA037Accident · No injuriesData collectionFinal reportCessna 207 · Kwigillingok, AKThe pilot's improper decision to depart from an ice-covered runway with a strong crosswind, which resulted in a loss of directional control, runway excursion, and impact with a ditch.Dec 10, 2019 · N9728M · Substantial damageNTSB GAA20CA004Accident · No injuriesData collectionFinal reportReed Mike Smiths Super CUB · Triangle, IDThe pilot's excessive use of brakes during the landing roll, which resulted in a nose-over.Oct 5, 2019 · N677M · Substantial damageNTSB GAA19CA233Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Juneau, AKThe pilot's failure to maintain a proper approach to landing on a ridge and his failure to maintain clearance from snow-covered terrain, which resulted in a tail rotor strike.Apr 28, 2019 · N288CH · Substantial damageNTSB GAA19CA217Accident · Minor injuriesData collectionFinal reportVans Vans RV-12 · Wall, SDThe pilot's improper decision to depart from a slush-covered runway, which resulted in a loss of directional control, a runway excursion, and a subsequent nose-over.Apr 14, 2019 · N277E · Substantial damageNTSB GAA19CA159Accident · Minor injuriesData collectionFinal reportPiper PA18 · Pullman, WAThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Mar 9, 2019 · N4100Z · Substantial damageNTSB GAA19CA157Accident · No injuriesData collectionFinal reportPiper PA22 · Superior, WIThe pilot's failure to maintain directional control during landing on a snow- and ice-covered runway, which resulted in impact with a snowbank and a nose-over.Mar 7, 2019 · N522DN · Substantial damageNTSB GAA19CA147Accident · Minor injuriesData collectionFinal reportPorterfield CP 65 · Aberdeen, SDThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Feb 23, 2019 · N37716 · Substantial damageNTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.Feb 11, 2019 · N750TA · Substantial damageNTSB GAA19CA143Accident · No injuriesData collectionFinal reportCessna 421 · Woodruff, WIThe pilot's failure to maintain to directional control during takeoff from a snow-covered runway with a right, quartering tailwind, which resulted in a runway excursion and impact with a snowbank.Feb 10, 2019 · N581CJ · Substantial damageNTSB GAA19CA125Accident · No injuriesData collectionFinal reportPiper PA 12 · Cedar City, UTThe pilot's failure to maintain pitch control while conducting a touch-and-go landing on an unimproved, snow-covered airstrip, which resulted in a nose-over.Feb 1, 2019 · N2333M · Substantial damageNTSB GAA19CA132Accident · No injuriesData collectionFinal reportPiper PA 18A · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the landing gear collapsing.Jan 28, 2019 · N8170C · Substantial damageNTSB DCA19CA079Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A320 · Denver, COloss of control of the tug by the driver during pushback operations as a result of the contaminated ramp, angle of the towbar, and the airplane engines being at idle thrust.Jan 28, 2019 · N220FR · Substantial damageNTSB ANC19CA010Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA31 · Chignik Lagoon, AKThe pilot’s selection of an unsuitable runway for landing, which resulted in a loss of control and runway excursion.Jan 21, 2019 · N995AK · Substantial damageNTSB GAA19CA116Accident · No injuriesData collectionFinal reportBeech 24 · Edgewood, NMThe pilot's improper landing flare, which resulted in hard, bounced landing, loss of directional control, runway excursion, and impact with a fence and terrain during an attempted go-around.Jan 4, 2019 · N6588R · Substantial damageNTSB GAA19CA118Accident · No injuriesData collectionFinal reportCessna 172 · Appleton, MNThe student pilot’s loss of directional control while landing on an ice-covered runway, which resulted in a loss of directional control, and his failure to attain sufficient airspeed during a subsequent aborted landing, which resulted in a nose-over.Jan 2, 2019 · N12181 · Substantial damageNTSB ANC19CA009Accident · No injuriesData collectionFinal reportCessna A185 · Big Lake, AKThe pilot's improper decision to land on a roadway during dark night conditions with inoperable landing and taxi lights, which resulted in an impact with a snow berm.Dec 23, 2018 · N93018 · Substantial damageNTSB GAA19CA058Accident · Minor injuriesData collectionFinal reportCessna 172 · Piseco, NYThe pilot’s loss of directional control during landing, which resulted in impact with a snow pile and necessitated a go-around, during which the airplane impacted trees.Nov 12, 2018 · N738VK · Substantial damageNTSB GAA18CA240Accident · No injuriesData collectionFinal reportBrown Joseph Sportsman GS-2 · Kalispell, MTThe pilot’s selection of an unsuitable snow-covered airstrip for landing, which resulted in a nose-over.Apr 24, 2018 · N454HP · Substantial damageNTSB GAA18CA221Accident · No injuriesData collectionFinal reportCessna 120 · Iola, WIThe pilot’s decision to reject the takeoff from a snow-covered grass surface, which resulted in a nose-over.Apr 21, 2018 · N1807V · Substantial damageNTSB GAA18CA173Accident · No injuriesData collectionFinal reportCessna 182 · Rapid City, SDThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and runway excursion.Mar 20, 2018 · N3024Y · Substantial damageNTSB GAA18CA136Accident · No injuriesData collectionFinal reportCessna 180 · Big Lake, AKThe pilot’s selection of unsuitable terrain for landing, which led to both skis breaking through the ice while positioning the airplane after landing.Feb 17, 2018 · N2934A · Substantial damageNTSB GAA18CA119Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.Feb 5, 2018 · N271BJ · Substantial damageNTSB GAA18CA134Accident · No injuriesData collectionFinal reportCessna T303 · Great Barrington, MAThe pilot’s failure to see the taxiway when returning to the ramp from the snow-covered runway, which resulted in the airplane rolling down an embankment.Feb 4, 2018 · N303TL · Substantial damageNTSB GAA18CA106Accident · No injuriesData collectionFinal reportCessna A185 · Lowman, IDThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.Jan 12, 2018 · N2W · Substantial damageNTSB CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.Dec 27, 2017 · N525KT · Substantial damageNTSB ANC18CA017Accident · No injuriesData collectionFinal reportPiper PA 18-125 · Nikolai, AKThe pilot’s improper decision to contact an unsuitable landing surface, which resulted in a nose-over.Nov 29, 2017 · N1386A · Substantial damageNTSB GAA18CA052Accident · No injuriesData collectionFinal reportCessna 182 · Skwentna, AKThe pilot’s decision to land on an unimproved snow-covered airstrip, which resulted in the airplane coming to rest inverted.Oct 28, 2017 · N2661Q · Substantial damageNTSB GAA17CA294Accident · No injuriesData collectionFinal reportDehavilland DHC 2 · Petersville, AKThe pilot’s selection of unsuitable terrain for taxiing, which resulted in a nose-over.May 28, 2017 · N561TA · Substantial damageNTSB GAA17CA210Accident · No injuriesData collectionFinal reportPiper PA22 · Soldotna, AKThe pilot’s unstabilized approach and failure to attain the proper touchdown point, which resulted in a runway overrun and collision with a snowbank.Mar 27, 2017 · N2838Z · Substantial damageNTSB GAA17CA188Accident · No injuriesData collectionFinal reportPiper PA 12 · Anchorage, AKThe pilot’s failure to maintain directional control during the taxi on skis on hard-packed snow in gusting wind conditions.Mar 14, 2017 · N3654M · Substantial damageNTSB GAA17CA159Accident · No injuriesData collectionFinal reportPiper PA22 · Big Lake, AKThe contamination of snow and ice on the left main landing gear and brake, which prevented the wheel from rolling during touchdown and resulted in a nose-over.Feb 23, 2017 · N6024D · Substantial damageNTSB GAA17CA187Accident · No injuriesData collectionFinal reportPiper PA22 · Ruby, AKThe pilot’s failure to maintain directional control while landing in flat light conditions on a hard-packed snow-covered landing area.Feb 16, 2017 · N72999 · Substantial damageNTSB GAA17CA134Accident · No injuriesData collectionFinal reportCessna 180 · Tyonek, AKThe pilot’s improper decision to land on a snow-covered airstrip with a tundra tire-equipped airplane, which resulted in a nose-over.Jan 30, 2017 · N5222E · Substantial damageNTSB WPR17LA062Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Jiggs, NVAn engine anomaly for reasons that could not be determined, which resulted in a precautionary landing in deep snow and a subsequent noseover.Jan 28, 2017 · N382US · Substantial damageNTSB CEN17LA123Accident · No injuriesLimited investigationFinal reportBeech C 99 · Durango, COThe pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.Jan 24, 2017 · N216CS · Substantial damageNTSB CEN17LA078Accident · Serious injuriesLimited investigationFinal reportTextron 525C · Howell, MIThe pilot's attempted landing on the ice-covered runway, which resulted in a runway excursion and impact with terrain. Contributing to the accident was airport personnel's lack of training regarding issuance of NOTAMsJan 16, 2017 · N525PZ · Substantial damageNTSB GAA17CA110Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Milton-Freewater, ORThe pilot's decision to take off from unsuitable terrain with a tailwind, which resulted in a nose-over.Jan 10, 2017 · N9598Z · Substantial damageNTSB GAA17CA106Accident · Minor injuriesData collectionFinal reportMaule M7 · Palouse, WAThe pilot’s failure to maintain directional control on an ice- and snow-covered runway during taxi with a crosswind, which resulted in a runway excursion.Dec 31, 2016 · N260BD · Substantial damage