NTSB investigations, WY
146 cases where NTSB found Task performance.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 15 |
| 2012 | 10 |
| 2013 | 10 |
| 2014 | 5 |
| 2015 | 9 |
| 2016 | 7 |
| 2017 | 11 |
| 2018 | 9 |
| 2019 | 8 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 9 |
| 2023 | 4 |
| 2024 | 11 |
| 2025 | 2 |
| 2026 | 10 |
Where
Latest 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 c.\"eventStateOrRegion\" = 'WY' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0206'))
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."eventStateOrRegion" = 'WY' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0206')) 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 WPR26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRans S7 · Kemmerer, WYThe pilot’s decision to perform a take-off in high-density-altitude, gusting-crosswind conditions, which resulted in an aerodynamic stall, hard landing and subsequent nose-over.NTSB WPR26LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Marbleton, WYThe pilot's failure to maintain directional control during the landing roll.NTSB WPR26LA250Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Buffalo, WYThe pilot’s improper flare and subsequent failure to maintain directional control of the airplane during the aborted landing.NTSB WPR26LA248Accident · No injuriesClass 4 · LimitedFinal reportDean J Irvin KFA Safari XL · Saratoga, WYThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB WPR26LA201Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican AA1 · Cowley, WYThe pilot's improper landing flare and subsequent loss of directional control during landing.NTSB WPR26LA156Accident · No injuriesClass 4 · LimitedFinal reportMarshall Daniel R L-21 · Cody, WYThe pilot's failure to maintain control of the airplane during the landing rollout, which resulted in a nose-over.NTSB WPR26LA095Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Alpine, WYThe pilot’s inadvertent descent while operating in flat light conditions which resulted in controlled flight into terrain.NTSB WPR26LA088Accident · No injuriesClass 4 · LimitedFinal reportJordan Valley CCX-2000 · Alcova, WYThe pilot's excessive brake application during the landing roll resulting in a nose over.NTSB WPR26LA083Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Parkman, WYThe pilots’ failure to maintain separation while conducting air work in a common operational area. Contributing to the accident was the pilots’ divided attention associated with the mission activity and unreliable radio communications.NTSB WPR26LA084Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Cody, WYThe pilot's failure to maintain directional control during landing roll.NTSB ANC25LA116Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Alpine, WYThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off airport landing.NTSB WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…NTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…NTSB ANC24LA070Accident · No injuriesClass 4 · LimitedFinal reportRoberts Jeff Super RV8 · Carter, WYThe pilots encounter with a shifting winds during takeoff, which resulted in a loss of control and runway excursion.NTSB WPR24FA257Accident · 7 fatalClass 3 · FieldFinal reportPilatus PC-12/47E · Recluse, WYThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the pilot’s distraction from the autopilot disconnecting due to an…NTSB WPR24LA245Accident · Serious injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26Z · Casper, WYThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in the pilot’s ejection from the basket and serious injury.NTSB WPR24LA242Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Teton Village, WYThe pilot’s failure to maintain control of the airplane during the landing roll.improper compensation for the prevailing wind conditions, resulting in impact of the left wing on the runway surface.NTSB WPR24LA205Accident · Minor injuriesClass 3 · LimitedFinal reportReplica PA-12 Replica · Douglas, WYA loss of power due to fuel exhaustion as a result of the pilot’s failure to calibrate the fuel flow indicator.NTSB WPR24LA187Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Garrett, WYThe pilot’s failure to maintain clearance from terrain while conducting low-level altitude operations, following an encounter with wake turbulence.NTSB WPR24LA176Accident · No injuriesClass 4 · LimitedFinal reportOklahoma Fat Tire Flyers CCX-2000 · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in aground loop.NTSB ANC24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Afton, WYThe commercial pilot’s failure to maintain directional control of the airplane during takeoff. Contributing was the student pilot’s application of brakes during the takeoff roll and the failure of both pilots to maintain a positive transfer of controls.NTSB WPR24LA148Accident · No injuriesClass 3 · LimitedFinal reportKjelsrud Gary Kitfox · Powell, WYThe pilot’s adjustment of the carburetor to an incorrect setting, which resulted in partial loss of engine power during takeoff.NTSB WPR24LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Casper, WYThe pilot’s failure to maintain directional control while taxiing with a crosswind.NTSB WPR23LA283Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C35 · Rock Springs, WYMaintenance personnel’s failure to properly secure the propeller pitch control rod castellated nut hardware, which resulted in an in-flight failure of the pitch control bearing and subsequent loss of engine RPM and thrust.NTSB WPR23LA277Accident · Minor injuriesClass 4 · LimitedFinal reportEvolution Revolt · Casper, WYThe pilot’s loss of directional control during landing after encountering wake turbulence.NTSB WPR23FA137Accident · 1 fatalClass 3 · FieldFinal reportCessna 182S · Alcova, WYThe airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.NTSB WPR23LA108Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Lander, WYThe pilot’s failure to maintain directional control during landing.NTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.NTSB WPR22LA334Accident · Serious injuriesClass 3 · LimitedFinal reportBuxbaum Mark Edward Long EZ · Medicine Bow, WYA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.NTSB WPR22LA244Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Afton, WYThe pilot's inadequate flare and bounced landing which resulted in loss of directional control of the airplane during the landing roll.NTSB WPR22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Wheatland, WYThe pilot’s improper landing flare which, resulted in a bounced landing and subsequent nose over.NTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…NTSB WPR22LA187Accident · Minor injuriesClass 4 · LimitedFinal reportTwenty Second Street Backcountry Boss · Douglas, WYThe pilot’s inadequate flare and subsequent loss of airplane control during landing.NTSB WPR22LA121Accident · No injuriesClass 4 · LimitedFinal reportTuttle Bruce C Jungster I · Rock Springs, WYThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with terrain.NTSB WPR22LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Buffalo, WYThe pilot’s failure to compensate for a wind gust during the landing roll, which resulted in a loss of directional control and collision with terrainNTSB WPR22LA102Accident · No injuriesClass 4 · LimitedFinal reportDarrell D. Dugger Mustang II · Cheyenne, WYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in an aborted takeoff and collision with terrain.NTSB WPR21LA345Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · Rock Springs, WYThe pilot’s improper pitch control during takeoff which resulted in an aerodynamic stall and subsequent hard landingNTSB WPR21LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Lander, WYThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence.NTSB WPR21LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Buffalo, WYThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a ground loop and collision with terrain.NTSB WPR21LA108Accident · No injuriesClass 3 · LimitedFinal reportAbbett Gerry Lancair Evolution · Saratoga, WYA windshield failure during cruise flight due to stress concentrations in the bond area as a result of improper assembly of the windshield.NTSB WPR20CA266Accident · Serious injuriesClass 4 · Data collectionFinal reportAviat A-1C-200 · Grover, WYThe pilot’s inability to regain airplane control after a pilot-induced spin conducted during a flight test, which resulted in a collision with terrain.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 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 WPR20CA154Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Spotted Horse, WYThe pilot's loss of directional control during an aborted takeoff with a tailwind, which resulted in a noseover.NTSB WPR20LA110Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Pinedale, WYA loss of airplane control during approach for reasons that could not be determined based on available evidence.NTSB GAA19CA575Accident · Minor injuriesData collectionFinal reportPiper J3C · Lander, WYThe pilot's failure to maintain lateral control during takeoff with a quartering tailwind, which resulted in the right wing striking the ground, a runway excursion, impact with a fence, and a subsequent noseover.NTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.NTSB GAA19CA526Accident · No injuriesData collectionFinal reportPietenpol Pietenpol Aircamper · Glendo, WYThe pilot's overapplication of brakes during the landing roll, which resulted in a noseover.