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 GAA17CA444Accident · No injuriesData collectionFinal reportMcintosh Donald W Kitfox Series 7 · Priest River, IDThe pilot's failure to maintain lateral/bank control during the landing in variable gusting wind conditions.NTSB GAA17CA454Accident · Serious injuriesData collectionFinal reportAir Tractor AT 802 · Trumann, ARThe pilot’s improper decision to continue flight in deteriorating weather conditions, which resulted in collision with the ground.NTSB GAA17CA440Accident · No injuriesData collectionFinal reportMitchell Derryle V Rans S 7 Courier · Cordova, AKThe pilot’s improper decision to take off from a lake in gusting wind conditions, which resulted in a loss of airplane control.NTSB GAA17CA449Accident · No injuriesData collectionFinal reportRadford Darrel F Christen Eagle II · Atchison, KSThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.NTSB GAA17CA397Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Ahoskie, NCThe pilot's failure to maintain proper lateral/bank control during the landing in gusting wind conditions, which resulted in a nose-over into water.NTSB GAA17CA578Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Eagle Grove, IAThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA421Accident · No injuriesData collectionFinal reportAviat A 1 · Dixie, IDThe pilot's failure to maintain an appropriate glidepath to landing with sun glare and downdraft conditions, which resulted in the airplane landing in a ravine short of the runway.NTSB GAA17CA379Accident · No injuriesData collectionFinal reportAmerican General Acft AG5 · Rio Vista, CAThe student pilot’s failure to maintain directional control during a go-around in gusting wind conditions.NTSB ERA17LA220Accident · Serious injuriesLimited investigationFinal reportNunley KR2 · Baker, FLA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA17CA364Accident · No injuriesData collectionFinal reportCessna 305 · Ukiah, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA360Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Portales, NMThe pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.NTSB GAA17CA357Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Edgewood, NMThe pilot's decision to take off with a gusting tailwind, which resulted in a loss of pitch control during the initial climb and a subsequent hard landing and loss of directional control.NTSB GAA17CA352Accident · No injuriesData collectionFinal reportPiper PA 18 · Red Bluff, CAThe pilot’s failure to maintain pitch control during the landing roll in gusting wind conditions, which resulted in a nose-over.NTSB GAA17CA338Accident · No injuriesData collectionFinal reportPiper PA 28 · Estherville, IAThe student pilot's failure to maintain crosswind correction during a go-around in gusting wind conditions.NTSB GAA17CA339Accident · No injuriesData collectionFinal reportCessna 180 · Belmar, NJThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB GAA17CA331Accident · Minor injuriesData collectionFinal reportPiper PA25 · Hood River, ORThe pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.NTSB GAA17CA351Accident · No injuriesData collectionFinal reportCessna 172 · Lawrence, KSThe student pilot's incorrect control application during landing after a simulated engine failure, which resulted in a hard, bounced landing, and the flight instructor's delayed action to perform a go-around in gusting wind conditions.NTSB CEN17LA219Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Douglas, WYThe pilot's inability to control the helicopter's descent after encountering a sudden wind shift to a tailwind while performing a near maximum gross weight landing at a high density altitude.NTSB GAA17CA329Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA315Accident · No injuriesData collectionFinal reportCessna T182 · San Carlos, CAThe pilot's incorrect landing flare, which resulted in a hard, bounced landing.NTSB GAA17CA319Accident · Minor injuriesData collectionFinal reportMagnaghi Aeronautica SKY Arrow LSA · Chapman, KSThe pilot's failure to maintain lateral/bank control during the takeoff climb in gusting crosswind conditions.NTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.NTSB GAA17CA306Accident · Minor injuriesData collectionFinal reportCessna 150 · Zepp, VAA partial loss of engine power due to the formation of carburetor icing, which resulted from the student pilot’s failure to apply carburetor heat and the flight instructor’s delayed response in applying carburetor heat while operating in conditions conducive…NTSB GAA17CA292Accident · Minor injuriesData collectionFinal reportAirtime Cygnet · Casa Grande, AZThe flight instructor's failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB GAA17CA288Accident · No injuriesData collectionFinal reportAeronca 7AC · Lebanon, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ERA17FA181Accident · 4 fatalField investigationFinal reportMitsubishi MU2B · Eleuthera, BahamasThe pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.NTSB CEN17LA182Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Weatherford, TXThe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall/spin.NTSB GAA17CA287Accident · No injuriesData collectionFinal reportJohnson Kenneth W Super CUB Sport · Austin, NVThe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in a loss of directional control.NTSB GAA17CA275Accident · Serious injuriesData collectionFinal reportPiper PA18 · Seward, AKThe flight instructor's incorrect brake application during a high-speed taxi with a tailwind, which resulted in a nose-over.NTSB WPR17LA100Accident · No injuriesLimited investigationFinal reportGrumman G164 · Madera, CAThe pilot’s loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion and separation of the right landing gear.NTSB GAA17CA271Accident · No injuriesData collectionFinal reportCessna A185 · Big Rapids, MIThe pilot’s failure to obtain updated weather information while practicing takeoffs and landings and his subsequent failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB GAA17CA269Accident · No injuriesData collectionFinal reportJohnson Kenneth Super CUB Sport · Spanish Fork, UTThe pilot's decision to land with a gusting tailwind and his subsequent failure to maintain directional control.NTSB GAA17CA284Accident · No injuriesData collectionFinal reportCessna 170 · Taos, NMThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA17FA174Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Clearwater, FLThe pilot's decision to attempt to land while a line of rain showers with microburst activity was crossing the airport, which resulted in a loss of control during a subsequent attempted go-around.NTSB GAA17CA257Accident · Minor injuriesData collectionFinal reportNelson Sydney Vans Acft RV8A · Englewood, COThe pilot's improper landing flare and inadvertent selection of the mixture control, which resulted in a hard, bounced landing during gusting crosswind wind conditions.NTSB GAA17CA252Accident · No injuriesData collectionFinal reportMaule MX7 · Floydada, TXThe pilot's decision to fly into and land at an area of known widespread high gusting wind, which resulted in a nose-over.NTSB GAA17CA251Accident · No injuriesData collectionFinal reportBender Joseph KIT Rotoway · Wheatland, WYThe pilot's decision to operate the helicopter in gusting wind and high-density altitude conditions and his positioning of the helicopter such that it resulted in a right quartering tailwind, which resulted in a loss of helicopter control due to a loss of…NTSB GAA17CA248Accident · No injuriesData collectionFinal reportCessna 172S · Jean, NVThe pilot’s runway selection, which resulted in landing with a tailwind and an unstabilized approach and subsequent runway overrun.NTSB ERA17LA165Accident · No injuriesLimited investigationFinal reportGanjoo Amit Sonex · Leesburg, VAThe pilot's failure to use carburetor heat appropriately, which resulted in a total loss of engine power due to the formation of carburetor ice.NTSB GAA17CA243Accident · No injuriesData collectionFinal reportCessna 182 · Killeen, TXThe pilot's incorrect landing flare in gusting wind conditions.NTSB GAA17CA240Accident · Minor injuriesData collectionFinal reportParlette Robert L Glastar · Wenatchee, WAThe pilot’s improper landing flare and subsequent failure to adequately compensate for gusting wind conditions during a go-around.NTSB GAA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Twisp, WAThe pilot’s failure to maintain crosswind correction during landing, which resulted in the airplane cartwheeling.NTSB GAA17CA202Accident · Minor injuriesData collectionFinal reportCessna 182 · Mackay, IDThe pilot's decision to maneuver the airplane over mountainous terrain in high-density altitude conditions, which resulted in the airplane’s inability to maintain altitude or establish a climb.NTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.NTSB GAA17CA181Accident · No injuriesData collectionFinal reportAerotek Pitts S-2A · West Palm Beach, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA174Accident · Minor injuriesData collectionFinal reportLancair Columbia 400 · Henderson, NVThe pilot’s improper decision to land the airplane with a gusting crosswind, which resulted in a loss of airplane control.NTSB GAA17CA175Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot's failure to maintain directional control while taxiing in gusting crosswind conditions.NTSB GAA17CA164Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prentiss, MSThe pilot's decision to take off with a gusting tailwind and his subsequent failure to maintain directional control.NTSB GAA17CA140Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, NCThe pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.