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 ANC12CA020Accident · No injuriesData collectionFinal reportHelio H-295 · Old Minto, AKThe pilot's decision to land on unsuitable terrain, which resulted in the airplane nosing over.Jan 26, 2012 · N713C · Substantial damageNTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.Jan 23, 2012 · N800DF · Substantial damageNTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.Jan 6, 2012 · N127AK · Substantial damageNTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…Dec 15, 2011 · N252AL · Substantial damageNTSB WPR12CA060Accident · No injuriesData collectionFinal reportCessna 182C · Lowman, IDThe pilot's misjudgment of the runway surface firmness, which resulted in a nose-over during the landing roll.Dec 10, 2011 · N800YD · Substantial damageNTSB WPR12CA041Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Ashton, IDThe student pilot’s poor decision-making when he decided to land on a snowy grass airstrip, which resulted in an encounter with deep snow during the landing roll and a subsequent nose-over.Nov 20, 2011 · N131PM · Substantial damageNTSB ANC11CA023Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Talkeetna, AKThe pilot's selection of a soft, slushy runway for landing, resulting in a noseover.Apr 9, 2011 · N8842D · Substantial damageNTSB CEN11LA273Accident · No injuriesLimited investigationFinal reportCessna 414A · Aberdeen, SDThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.Mar 23, 2011 · N4057C · Substantial damageNTSB ANC11CA020Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Beluga Lake, AKThe pilot's decision to land on unsuitable terrain, resulting in the airplane nosing over.Mar 19, 2011 · N3573P · Substantial damageNTSB ANC11CA017Accident · No injuriesData collectionFinal reportChampion 7GCBC · Nenana, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a nose over.Mar 17, 2011 · N5160X · Substantial damageNTSB WPR11CA148Accident · No injuriesData collectionFinal reportCessna A150M · Grass Valley, CAThe aircraft's encounter with deep snow during the landing roll out. Contributing to the accident was the airport manager's failure to update the AWOS recording to reflect the closure of the runway due to snow.Feb 27, 2011 · N7951V · Substantial damageNTSB OPS11IA271Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dayton, OHThe pilots' lack of consideration for developing and known weather conditions en route to and at the destination airport, resulting in a runway excursion and subsequent incursion.Feb 1, 2011 · N13964 · Minor damageNTSB CEN11CA191Accident · No injuriesData collectionFinal reportErcoupe 415-CD · Newaygo, MIThe pilot's loss of directional control during takeoff from a frozen lake.Jan 30, 2011 · N127G · Substantial damageNTSB WPR11CA098Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Austin, NVThe pilot’s failure to maintain directional control during the takeoff roll.Jan 13, 2011 · N4030Z · Substantial damageNTSB ANC11LA009Accident · No injuriesLimited investigationFinal reportCessna 208B · Kipnuk, AKThe pilot’s decision to land long on the icy snow-covered runway, resulting in a runway excursion and collision with terrain.Jan 6, 2011 · N715HE · Substantial damageNTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.Jan 4, 2011 · N90TY · Substantial damageNTSB ANC11LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Platinum, AKThe pilot's misidentification of the airport's active runway, resulting in an off-runway landing and collision with a ditch/berm.Jan 4, 2011 · N9304K · Substantial damageNTSB ANC11LA007Accident · No injuriesLimited investigationFinal reportBeech E18S-9700 · New Stuyahok, AKThe pilot's misjudgment of the runway surface condition, resulting in an aborted landing and collision with rising terrain during the ensuing takeoff attempt.Jan 3, 2011 · N9001 · Substantial damageNTSB CEN11CA139Accident · No injuriesData collectionFinal reportCessna 305A · Spooner, WIThe pilot's selection of unsuitable terrain for landing on a snow-covered lake.Dec 25, 2010 · N6897 · Substantial damageNTSB WPR11LA058Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Salt Lake City, UTThe tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…Nov 24, 2010 · N614SK · Substantial damageNTSB WPR11IA055Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Jackson, WYThe flight crew's inability to stop the airplane during landing roll on a snow- and ice-contaminated runway. Contributing to the runway overrun were the deteriorating runway conditions.Nov 22, 2010 · N718QS · No damageNTSB WPR10CA201Accident · Minor injuriesData collectionFinal reportCessna 150D · Galena, IDThe pilot's encounter with soft, snow-covered terrain while executing a precautionary landing.Apr 10, 2010 · N4296U · Substantial damageNTSB WPR10CA190Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAThe pilot's failure to identify the snow-covered runway, which resulted in an off-runway landing and subsequent collision with a berm.Apr 3, 2010 · N4137C · Substantial damageNTSB ANC10TA028Accident · No injuriesFinal reportPiper PA-18-150 · Stony River, AKThe pilot's failure to maintain directional control of the airplane during taxi from landing, which resulted in the airplane sliding into trees.Apr 3, 2010 · N82732 · Substantial damageNTSB ANC10LA021Accident · No injuriesLimited investigationFinal reportCessna U206G · Nanwalek, AKThe pilot's decision to land on a short, icy runway with poor braking action, resulting in a runway overrun/excursion and collision with a snowbank.Mar 5, 2010 · N734JM · Substantial damageNTSB ERA10CA231Accident · Minor injuriesData collectionFinal reportCessna 340A · Grove City, PAThe pilot's failure to maintain directional control after electing to land on a snow-covered runway.Feb 27, 2010 · N1952E · Substantial damageNTSB WPR10LA155Accident · No injuriesLimited investigationFinal reportKeller FK1 Stol · Dixie, IDThe failure of the experimental FK1 pilot to maintain clearance from a parked airplane while landing.Feb 26, 2010 · N4XK · 2 aircraft · Substantial damageNTSB ERA10CA144Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Alton Bay, NHThe pilot’s failure to maintain directional control while landing on an ice runway.Feb 14, 2010 · N236PR · Substantial damageNTSB ERA10TA142Accident · No injuriesFinal reportEurocopter AS 365 N2 Dauphin · Cheverly, MDIncomplete clearing of snow from the helipad and vicinity. Contributing to the accident was the lack of a NOTAM regarding the presence of snow banks and the pilot's failure to ensure that the helicopter was clear of a snow bank prior to departure.Feb 12, 2010 · N61MD · Substantial damageNTSB CEN10CA118Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Connersville, INThe pilot's failure to maintain directional control while landing on an ice- and slush-covered runway.Feb 11, 2010 · N8946W · Substantial damageNTSB CEN10LA117Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Amarillo, TXThe pilot's loss of directional control while landing on an ice/snow covered runway.Feb 4, 2010 · N644EM · Substantial damageNTSB ERA10LA128Accident · No injuriesLimited investigationFinal reportCessna 402C · Watertown, NYThe pilot's decision to continue the approach with a known anomaly with the left airspeed indicator. Contributing to the accident was an undetermined malfunction of the left airspeed indicator and the condition of the runway, resulting in decreased braking…Feb 1, 2010 · N121PB · Substantial damageNTSB ERA10CA126Accident · No injuriesData collectionFinal reportMaule M-4-220C · Westmoreland, TNThe pilot's failure to maintain clearance from a snow drift.Jan 30, 2010 · N40668 · Substantial damageNTSB CEN10CA094Accident · Minor injuriesData collectionFinal reportEngineering & Research Ercoupe 415-CD · New London, WIThe pilot's decision to land with a tailwind on the snow- and ice-covered runway.Jan 10, 2010 · N94670 · Substantial damageNTSB WPR10CA099Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's decision to land on a closed, snow-covered runway.Jan 6, 2010 · N48ZZ · Substantial damageNTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…Dec 23, 2009 · N520NE · Substantial damageNTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.Dec 18, 2009 · N99930 · Substantial damageNTSB ANC10CA008Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's decision to land and attempt to takeoff from an unsuitable off-airport site.Nov 14, 2009 · N3797Z · Substantial damageNTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.Apr 4, 2009 · N40684 · Substantial damageNTSB CEN09CA235Accident · No injuriesData collectionFinal reportCessna 210 · Angel Fire, NMThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot's decision to take off on an icy runway with high crosswinds.Mar 23, 2009 · N59287 · Substantial damageNTSB CEN09CA210Accident · No injuriesData collectionFinal reportAeronca 7AC · Bagley, MNThe pilot's delayed aborted takeoff, which resulted in the ski-equipped airplane running aground and striking trees. Contributing to the accident was the slush layer that had formed since the previous landing.Mar 15, 2009 · N1831E · Substantial damageNTSB ANC09LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Buckland, AKThe pilot's failure to abort the landing while landing on a snow/ice-covered runway.Mar 14, 2009 · N4112K · Substantial damageNTSB ANC09CA020Accident · No injuriesData collectionFinal reportBeech 65-A90-1 · Soldotna, AKThe pilot's misidentification of the runway surface during landing. Contributing to the accident were the snow-covered terrain, and low-light conditions.Feb 16, 2009 · N418SP · Substantial damageNTSB CEN09LA165Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Steamboat Springs, COThe pilot's failure to apply brakes in a timely manner while landing on a snow-packed, ice-covered runway, and his delay in executing a go-around.Feb 14, 2009 · N486CD · Substantial damageNTSB CEN09CA148Accident · No injuriesData collectionFinal reportCessna 172 · Union Mills, INThe certificated flight instructor's failure to follow correct engine clearing procedures. A factor was the unsuitable landing area.Feb 1, 2009 · N53576 · Substantial damageNTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.Jan 19, 2009 · N35571 · Substantial damageNTSB CEN09CA130Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Elrosa, MNThe pilot's inability to maintain control after touchdown on a snow-covered runway.Jan 10, 2009 · N2553S · Substantial damageNTSB ANC09CA016Accident · No injuriesData collectionFinal reportCessna 172S · Girdwood, AKThe flight instructor's lack of action to correct a high and fast landing approach which resulted in a long landing, and subsequent collision with a snow berm at the end of the runway. Contributing to the accident was the student pilot's improper approach.Dec 28, 2008 · N453SP · Substantial damageNTSB CEN09LA100Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Lewistown, MOThe pilot's loss of directional control during landing on an ice-contaminated runway.Dec 23, 2008 · N20NL · Substantial damageNTSB WPR09CA066Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Idaho Falls, IDThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the icy runway conditions and a snow bank.Dec 22, 2008 · N379P · Substantial damage