NTSB investigations, 2020
73 cases where the sequence of events included Other weather encounter.
Cases per year
| 2008 | 42 |
|---|---|
| 2009 | 41 |
| 2010 | 36 |
| 2011 | 44 |
| 2012 | 39 |
| 2013 | 27 |
| 2014 | 45 |
| 2015 | 65 |
| 2016 | 135 |
| 2017 | 109 |
| 2018 | 125 |
| 2019 | 71 |
| 2020 | 73 |
| 2021 | 43 |
| 2022 | 33 |
| 2023 | 65 |
| 2024 | 59 |
| 2025 | 50 |
| 2026 | 29 |
Where
Open the mapLatest cases
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\") = 2020
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.
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") = 2020 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA21LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Culpeper, VAThe pilot’s decision to land the airplane in crosswind conditions that exceeded the airplane’s maximum demonstrated crosswind velocity.NTSB CEN21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Albion, NEThe pilot’s failure to maintain directional control during the landing with a tailwind.NTSB CEN21LA089Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Bossier City, LAThe student pilot’s decision to conduct a flight during night instrument meteorological conditions and his loss of airplane control due to spatial disorientation. Contributing to the accident was the student pilot’s use of an amphetamine and his attention…NTSB WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.NTSB CEN21LA058Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Waukegan, ILThe pilot’s failure to maintain directional control during takeoff with a crosswind that resulted in a ground loop and impact with terrain.NTSB CEN21LA047Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Ardmore, OKThe pilot’s improper decision to takeoff with 3 persons in a 2-place airplane and over maximum gross weight, and his failure to apply carburetor heat when the airplane’s engine experienced carburetor ice and a partial loss of power.NTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.NTSB ERA21LA036Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Fernandina Beach, FLThe flight crew's improper decision to land with a tailwind on a wet runway, which resulted in a runway overrun. Contributing to the accident was the copilot’s early retraction of the speed brakes and the pilot’s decision to turn off the anti-skid system.NTSB WPR21LA027Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Silver City, NMThe pilot’s failure to maintain sufficient altitude above terrain while operating in reduced visibility due to snow showers.NTSB CEN21LA021Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Washington, WIThe pilot’s failure to maintain lateral control during a hover and improper recovery action after the helicopter contacted the ground, which resulted in a dynamic rollover sequence and an impact with terrain.NTSB ERA21LA027Accident · Minor injuriesClass 4 · LimitedFinal reportMuse Stol CH 750 · Sewanee, TNThe airplane’s encounter with a downdraft during the initial climb, which resulted in an impact with trees.NTSB ERA21LA013Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA18 · Plymouth, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering gusting headwind.NTSB ERA20LA338Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Pottstown, PAThe pilot’s failure to maintain directional control while landing in gusty, shifting wind conditions.NTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.NTSB WPR20LA295Accident · 2 fatalClass 3 · LimitedFinal reportBeech 35 · Three Rivers, CAThe pilot’s controlled flight into terrain while operating in conditions of reduced visibility due to smoke.NTSB ANC20CA088Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Kotzebue, AKThe pilot's failure to maintain an airspeed conducive to flight during takeoff.NTSB ANC20CA087Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Lake Louise, AKThe pilot’s decision to takeoff in shifting winds from a remote unimproved gravel bar, which resulted in a failure to attain an airspeed suitable for flight and a loss of control.NTSB CEN20CA356Accident · No injuriesClass 4 · Data collectionFinal reportMaule M5 · Olathe, KSThe pilot's loss of directional control during landing.NTSB CEN20CA350Accident · No injuriesClass 4 · Data collectionFinal reportCessna 140 · Olustee, OKThe pilot's decision to attempt a takeoff from the middle of the runway in shifting wind conditions, which resulted in an aborted takeoff and runway excursion.NTSB CEN20LA343Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Brandon, MNThe partial loss of engine power during takeoff due to carburetor icing.NTSB WPR20CA273Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer SGS233 · Warner Springs, CAThe pilot's inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB WPR20CA265Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Stanley, IDThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a ground loop.NTSB CEN20CA332Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Englewood, COThe flight instructor did not maintain a proper approach path and landing flare during a landing with a tailwind, which resulted in a hard landing and damaged landing gear. During the subsequent landing with damaged landing gear, the flight instructor lost…NTSB CEN20CA333Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters Carbon CUB EX · Marion, ILThe pilot's failure to attain/maintain directional control during landing that resulted in a ground-loop and collision with terrain.NTSB CEN20CA326Accident · No injuriesClass 4 · Data collectionFinal reportHughes 369A · St Louis, MOThe flight instructor's failure to maintain helicopter control which resulted in a hard landing while preforming a practice autorotation.NTSB WPR20CA267Accident · Serious injuriesClass 4 · Data collectionFinal reportCameron A 315 · Jackson, WYThe balloon pilot’s inability to maintain the proper descent rate during the balloon’s approach to landing during un-forecasted weather, which resulted in a hard landing.NTSB WPR20CA263Accident · Serious injuriesClass 4 · Data collectionFinal reportLindstrand 310A · Jackson, WYThe pilot’s inability to arrest the descent rate when the balloon encountered unforecasted high ground wind that resulted in a hard landing.NTSB WPR20CA262Accident · Serious injuriesClass 4 · Data collectionFinal reportHead AX8 88 · Jackson, WYThe balloon pilot’s inability to maintain altitude during un-forecasted weather, which resulted in a hard landing.NTSB WPR20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Susanville, CAThe pilot's failure to maintain directional control during takeoff with a tailwind, which resulted in a subsequent collapse of the right main landing gear.NTSB ERA20CA256Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Wellington, FLThe pilot’s inadequate compensation for a wind gust during landing.NTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.NTSB CEN20LA270Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 188 · Pembina, NDThe pilot’s failure to maintain control during an aerial spray turnaround in high crosswind conditions.NTSB ERA20CA233Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 8 · Perkasie, PAThe pilot’s loss of directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and collision with a ditch.NTSB WPR20CA197Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Pioche, NVThe pilot’s decision to fly at low level over mountainous terrain and his inability to recover when the helicopter encountered a downdraft that resulted in a collision with terrain.NTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…NTSB ERA20CA209Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA38 · Cumberland, MDThe pilot's failure to maintain directional control during landing and the subsequent go-around in gusting crosswind conditions.NTSB CEN20CA204Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Denver, COThe pilot’s failure to maintain directional control while landing during variable wind conditions.NTSB WPR20CA162Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Elko, NVThe pilot's failure to maintain helicopter control in gusting wind that resulted in a loss in altitude and subsequent collision with a fence.NTSB CEN20CA193Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Ionia, MIThe pilot's failure to maintain directional control during landing. Contributing was the pilot getting his shoe caught in the rudder pedal.NTSB WPR20CA149Accident · No injuriesClass 4 · Data collectionFinal reportCessna 185 · Winifred, MTAn inadequate flare that resulted in a bounced landing and the pilot's subsequent delayed decision to go-around that did not allow for sufficient clearance from trees when the airplane was affected by a gusting wind.NTSB CEN20CA161Accident · No injuriesData collectionFinal reportPiper PA 20 · Colorado Springs, COThe flight instructor's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control.NTSB WPR20CA134Accident · Minor injuriesData collectionFinal reportPiper PA18 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a roll-over.NTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.NTSB ERA20CA155Accident · Serious injuriesData collectionFinal reportGrumman AA5 · Bloomingdale, GAThe pilot's failure to maintain airplane control during landing with a gusting quartering tailwind.NTSB CEN20CA151Accident · No injuriesData collectionFinal reportEagle Eagle DW 1 · Hudson, COThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and nose-over.NTSB ANC20CA044Accident · No injuriesData collectionFinal reportPiper PA31 · Buckland, AKThe pilot's failure to extend the landing gear before landing due to distraction by the condition of the runway and his failure to use the Before Landing checklist.NTSB WPR20CA124Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's loss of directional control and subsequent improper brake application during the landing roll in gusting wind conditions, which resulted in a nose-over.NTSB CEN20CA138Accident · No injuriesData collectionFinal reportChampion Aeronca 7FC · Hessel, MIThe pilot's loss of directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a snowbank.NTSB ERA20CA146Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe pilot’s failure to apply full engine power during the initiation of a go-around in gusting wind conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at low altitude, and the flight instructor's…NTSB ERA20CA143Accident · No injuriesData collectionFinal reportDiamond DA42 · Palm Coast, FLThe pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.