NTSB investigations, 2021
43 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\") = 2021
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") = 2021 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 CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB WPR22FA055Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Medford, ORThe pilot’s failure to maintain aircraft control during the initial climb into clouds due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA22LA063Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Denver, NCThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB CEN22LA034Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Fort Davis, TXThe pilot’s encounter of a downdraft from which there was insufficient altitude to recover.NTSB WPR22LA029Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Challis, IDThe pilot’s loss of directional control after the airplane encountered a gust of wind during the landing roll.NTSB WPR22FA004Accident · 2 fatalClass 3 · FieldFinal reportCessna 340A · Santee, CALoss of control due to spatial disorientation.NTSB CEN22LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Chesterfield, MOThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard, bounced landing and the nose landing gear collapsing. .NTSB WPR21LA359Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Phoenix, AZThe student pilot's failure to maintain helicopter control while making a clearing turn which resulted in a hard landing.NTSB CEN21LA471Accident · Serious injuriesClass 4 · LimitedFinal reportJust Highlander · West Cobb, ARThe airplane’s encounter with gusting wind conditions and low-level wind shear on final approach, which resulted in a loss of control, an aerodynamic stall, and a subsequent hard landing.NTSB WPR21LA360Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182E · Warren, IDThe pilot’s failure to maintain altitude while maneuvering in a valley of mountainous terrain.NTSB CEN21LA458Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182E · Troup, TXThe pilot’s failure to maintain directional control during landing with a variable gusting wind and his decision not to perform a go-around that resulted an overrun and impact with a fence and trees.NTSB CEN21LA454Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Ozark, ARThe pilot’s inability to maintain altitude after the airplane encountered a downdraft while he intentionally flew at a low-altitude during a practice for a short-takeoff-and-landing flight competition.NTSB CEN21LA394Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Dunseith, NDThe pilot’s failure to maintain directional control during an attempted go-around with a strong gusting crosswind.NTSB CEN21LA393Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Storm Lake, IAThe pilot’s failure to maintain adequate airspeed during a landing approach with a tailwind that resulted in a landing overrun and impact with terrain.NTSB CEN21LA392Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Olive Branch, MSThe pilot’s failure to maintain directional control of the airplane during landing with a direct crosswind that resulted in an impact with terrain.NTSB CEN21LA397Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Braunfels, TXThe pilot’s failure to maintain control of the airplane during landing.NTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…NTSB WPR21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Reno, NVThe pilot’s failure to maintain clearance from mountainous terrain prior to encountering a downdraft, which resulted in a forced landing and collision with terrain.NTSB CEN21LA370Accident · No injuriesClass 4 · LimitedFinal reportMarlowe Thooft Just Acft Highlander · Brainerd, MNThe pilot’s failure to maintain directional control during a crosswind landing that resulted in an impact with terrain.NTSB ERA21LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 402A · Fort Lauderdale, FLThe pilot’s loss of directional control during takeoff with a fogged wind screen and sun glare, which resulted in a runway excursion and a collision with a taxiway sign.NTSB WPR21LA246Accident · No injuriesClass 4 · LimitedFinal reportAirborne Australia XT582 · Carson City, NVThe student pilot's failure to maintain directional control during landing in gusting wind, which resulted in a runway excursion and impact with terrain.NTSB CEN21LA288Accident · No injuriesClass 3 · LimitedFinal reportVining SD1 Minisport · Butler, OHThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall and impact with terrain. The reason for the partial loss of engine power could not be determined based on available information.NTSB CEN21LA280Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Hayward, WIThe pilot's failure to maintain directional control during landing with gusting wind.NTSB ERA21LA244Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Sanford, METhe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB WPR21LA225Accident · Serious injuriesClass 4 · LimitedFinal reportLindstrand Balloons 90A · Dayton, NVThe pilot’s failure to maintain control of the balloon due to an unexpected high surface wind and downdraft, which resulted in a hard landing.NTSB CEN21LA240Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Trumann, ARThe pilot’s failure to review the weather conditions before the flight, which resulted in a loss of directional control during takeoff due to a sudden change in wind direction and speed associated with an approaching thunderstorm.NTSB CEN21LA228Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Pinecreek, MNThe pilot’s failure to maintain control of the airplane in gusting crosswind conditions.NTSB WPR21LA196Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Wallowa, ORThe pilots failure to maintain airplane control during the landing roll after experiencing a tailwind gust which required excessive braking and resulted in the airplane nosing over.NTSB ERA21LA220Accident · No injuriesClass 4 · LimitedFinal reportDouglas K Thompson Justaircraft Superst · Brunswick, METhe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of directional control during the approach and landing.NTSB ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.NTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.NTSB CEN21LA202Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75 · Denver, COThe pilot’s failure to maintain directional control during the landing roll with variable and gusty wind conditions.NTSB WPR21LA176Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV4 · Oljato-Monument Valley, UTThe pilot’s failure to maintain airplane control while compensating for a downdraft during landing, which resulted in the airplane touching down short of the runway on soft terrain and nosing over.NTSB CEN21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Tishomingo, OKThe pilot’s decision to abort the takeoff on encountering a wind gust and his landing beyond the end of the runway that resulted in the airplane impacting a ditch collapsing the nose landing gear.NTSB CEN21LA179Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny Powered Parachutes 2000 · Saint Paul, NEThe uncertificated pilot’s failure to maintain control of the powered parachute during low altitude flight in gusting wind conditions.NTSB CEN21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Delavan, WIThe pilot’s failure to maintain control of the airplane during the landing roll with gusting crosswinds, which resulted in his excessive brake input and a subsequent nose over.NTSB CEN21LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Austin, TXThe pilot’s failure to maintain directional control while turning onto the taxiway in variable wind conditions.NTSB ANC21LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Chevak, AKThe pilot’s loss of directional control during the back-taxi for departure in strong crosswind conditions which resulted in a runway excursion. Contributing to the accident was the snow-and-ice-covered runway.NTSB CEN21LA154Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Duson, LAThe uncertified pilot’s failure to maintain control of the helicopter when encountering a wind gust while hovering to land.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR21LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-1B · St Johns, AZThe pilot’s decision to operate with a demonstrated crosswind velocity above the airplane’s performance capabilities which resulted in a loss of airplane control and collision with terrain.NTSB CEN21LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Urbana, OHThe student pilot’s loss of directional control during landing which resulted in an impact with a snowbank. The slippery runway condition contributed to the accident.