NTSB investigations
1,130 cases where the sequence of events included Other weather encounter.
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 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 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 ERA23LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Paris, KYThe pilot’s loss of control after encountering changing wind conditions during the initial climb, which resulted in descent and collision with terrain.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC23LA009Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 77 · Lihue, HIThe airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Murdo, SDThe pilot’s failure to maintain directional control during takeoff with strong gusty surface winds.NTSB CEN23LA029Accident · No injuriesClass 4 · LimitedFinal reportMaule M7-235B · Topeka, KSThe pilot’s failure to maintain airplane control during landing with strong gusty surface winds.NTSB CEN23LA286Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Holland, MIThe pilot’s failure to maintain directional control during the landing roll with gusty wind which exceeded the maximum crosswind of the airplane.NTSB CEN23LA013Accident · Serious injuriesClass 4 · LimitedFinal reportPober Pixie · Sterling, COThe pilot’s failure to maintain control during the takeoff with strong gusty surface wind.NTSB WPR23LA008Accident · No injuriesClass 4 · LimitedFinal reportSeabourn Scott R CCK-2000 · Clarksburg, CAThe pilot's failure to maintain directional control during the landing roll with a gusting quartering tailwind.NTSB WPR22LA339Accident · Minor injuriesClass 3 · LimitedFinal reportBell 205A-1 · Cougar, WAThe helicopter’s encounter with downdrafts during a low-altitude hovering maneuver while dipping for water.NTSB CEN22FA406Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Cleveland, TNThe pilot’s loss of airplane control while operating in instrument meteorological conditions.NTSB WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.NTSB CEN22LA389Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Appleton, MNThe pilot’s failure to maintain directional control during the takeoff roll with a quartering tailwind.NTSB ERA22LA348Accident · 1 fatalClass 3 · LimitedFinal reportCASA C212 · Raeford, NCThe airplane’s encounter with windshear during landing, which resulted in a hard landing and separation of the right main landing gear, and the pilot’s subsequent decision to leave his seat in flight, which resulted in his fall from the airplane.NTSB CEN22LA440Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Merrill, WIThe student pilot's failure to maintain adequate roll control during takeoff with a quartering tailwind.NTSB CEN22LA332Accident · Minor injuriesClass 4 · LimitedFinal reportCessna L-19E · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a gusty crosswind.NTSB CEN22LA338Accident · No injuriesClass 4 · LimitedFinal reportWaco Classic YMF-5C · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB WPR22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Lexington, ORThe pilot’s failure to maintain directional control during the landing roll with a gusting wind.NTSB CEN22LA337Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a gusty crosswind.NTSB CEN22LA316Accident · Minor injuriesClass 4 · LimitedFinal reportPiper/Cub Crafters PA-18-150 · Llano, TXThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN22LA280Accident · No injuriesClass 4 · LimitedFinal reportAero Commander S2R · Maryville, MOThe pilot’s failure to maintain control during the landing with a quartering tailwind.NTSB CEN22LA254Accident · No injuriesClass 4 · LimitedFinal reportKitfox Model 2 · San Marcos, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR22LA205Accident · No injuriesClass 4 · LimitedFinal reportBell HH-1H · Reno, NVThe pilot’s loss of control following the inadvertent placement of his foot behind the anti-torque pedal.NTSB CEN22LA207Accident · No injuriesClass 4 · LimitedFinal reportBellanca Cruisemaster · Gainesville, TXThe pilot’s failure to extend the landing gear before landing due to his distraction with the wind gusts.NTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB WPR22LA179Accident · No injuriesClass 4 · LimitedFinal reportSparks Ralph A RV8 · Deming, NMThe pilot’s loss of airplane control during takeoff following an encounter with a gust of wind.NTSB ERA22LA211Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe pilot’s failure to maintain directional control while attempting to land in a crosswind.NTSB ERA22LA185Accident · No injuriesClass 4 · LimitedFinal reportPF Cub Flyers CCK-2000 · Collegedale, TNThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion and a subsequent nose-over.NTSB ERA22LA210Accident · No injuriesClass 4 · LimitedFinal reportHenderson Clifford S Super Bear CSH-1 · Indiana, PAThe pilot's loss of directional control while landing, which resulted in a ground loop.NTSB ANC22LA027Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Chitina, AKThe pilot’s exceedance of the wing’s critical angle of attack, which resulted in a stall and impact with terrain.NTSB CEN22LA150Accident · No injuriesClass 4 · LimitedFinal reportSparrow Hawk III · Lubbock, TXThe pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds.NTSB CEN22LA174Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Paragould, ARThe student pilot’s failure to maintain directional control during landing which resulted in a ground loop.NTSB CEN22LA143Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Taylorville, ILThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN22LA104Accident · No injuriesClass 4 · LimitedFinal reportBeech V35B · McKinney, TXThe pilot’s failure to maintain control during the landing with gusty wind.NTSB CEN22LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Carrizo Springs, TXThe pilot’s failure to maintain directional control of the airplane during landing with a gusting crosswind that resulted in a runway excursion.NTSB CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.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.