NTSB investigations
1,131 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 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.NTSB ANC20CA040Accident · No injuriesData collectionFinal reportPiper PA32 · Fairbanks, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in a loss of directional control, a runway excursion, and impact with a snowbank.NTSB 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.NTSB CEN20LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Harrisville, MIThe pilot’s loss of directional control during landing rollout in gusty crosswind conditions, resulting in a runway excursion and collision with trees.NTSB WPR20CA113Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Puyallup, WAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in the wing striking the ground.NTSB ERA20CA131Accident · No injuriesData collectionFinal reportAmerican Legand AL18 · Social Circle, GAThe pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.NTSB WPR20CA100Accident · No injuriesData collectionFinal reportPiper PA28R · Twin Falls, IDThe pilot's loss of directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and impact with a runway approach light.NTSB CEN20CA112Accident · No injuriesData collectionFinal reportCessna 172 · Madison, INThe flight instructor's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and nose-over.NTSB ERA20CA116Accident · Serious injuriesData collectionFinal reportLet L 23 Super Blanik · Huntsville, ALThe pilot's failure to maintain glider control and his exceedance of the glider's critical angle of attack while maneuvering in gusting wind conditions, which resulted in an aerodynamic stall.NTSB ERA20CA120Accident · No injuriesData collectionFinal reportLearjet 35 · Altoona, PAThe pilot flying's improper lateral bank control during a go-around in gusting wind conditions, which resulted in the left-wing tip tank striking the runway.NTSB ANC20CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Big Lake, AKThe pilot's failure to use carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with snow.NTSB WPR20CA095Accident · No injuriesData collectionFinal reportCessna 172 · Dubois, IDThe student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…NTSB ERA20CA114Accident · No injuriesData collectionFinal reportCessna 172 · Everglades City, FLThe pilot's failure to maintain airplane control during the landing flare in gusting crosswind conditions, which resulted in the left wing striking the runway.NTSB ERA20CA113Accident · No injuriesData collectionFinal reportLearjet 55 · Farmingdale, NJThe flight crew's failure to stop the airplane on the available runway, which was wet and resulted in the airplane impacting a ditch.NTSB WPR20CA093Accident · Minor injuriesData collectionFinal reportAviat A1 · Columbia, CAThe pilot's failure to maintain bank control during landing in gusting wind conditions.NTSB ERA20CA107Accident · No injuriesData collectionFinal reportOrlican L60 · Frederick, MDThe pilot's failure to maintain airplane control during the approach, which resulted in the airplane ballooning and then veering left upon landing and the right wing impacting the runway.NTSB 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.NTSB ERA20CA104Accident · No injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe student pilot's improper pedal and cyclic input while maneuvering, which resulted in a loss of helicopter control.NTSB ANC20CA027Accident · No injuriesData collectionFinal reportCessna TP206 · Kahului, HIThe pilot's improper landing flare in gusting crosswind conditions, which resulted in the airplane porpoising and a subsequent a loss of directional control, runway excursion, and nose-over.NTSB ERA20CA098Accident · No injuriesData collectionFinal reportMaule M7 · Manchester, NHThe pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a ground-loop.NTSB ERA20CA087Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Fernandina Beach, FLThe pilot receiving instruction’s loss of directional control on landing with a crosswind, which resulted in a runway excursion and the left main landing gear collapsing.NTSB WPR20CA073Accident · Minor injuriesData collectionFinal reportStearman B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose-over when the right wheel encountered mud.