NTSB investigations, WY
19 cases where NTSB found Psychological.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2018 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 1 |
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\", '0202'))
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", '0202')) 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 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 WPR25LA201Accident · Minor injuriesClass 4 · LimitedFinal reportLancair IV · Alpine, WYThe pilot’s loss of visual reference during the landing approach which resulted in a collision with water.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 WPR24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportZenith Zodiac CH601 · Rawlins, WYThe student pilot’s failure to see and avoid powerlines during an unstabilized approach, which resulted the airplane landing short of the runway and coming to rest inverted.NTSB WPR23FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna T182T · Albany, WYThe pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…NTSB CEN18LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna T310 · Laramie, WYThe pilot’s failure to properly adjust the fuel/air mixtures, which resulted in a partial loss of engine power to both engines due to fuel starvation and a subsequent forced landing to a field.NTSB GAA18CA462Accident · No injuriesData collectionFinal reportPiper PA24 · Evanston, WYThe pilot's failure to extend the landing gear during landing. Contributing to the accident were the pilot's distraction and his failure to complete the appropriate checklist before landing.NTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.NTSB CEN17FA035Accident · 1 fatalField investigationFinal reportStamper RV-10 · Dubois, WYThe pilot's failure to maintain adequate airspeed after becoming distracted by the opening of the gull-wing cabin door during takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low…NTSB WPR16FA046Accident · 2 fatalField investigationFinal reportAerostar S A YAK 52 · Alpine, WYThe pilot's failure to maintain clearance from snow-covered terrain in flat light conditions.NTSB GAA15CA007Accident · No injuriesData collectionFinal reportAviat A1 - B · Afton, WYThe pilot's failure to maintain directional control during landing.NTSB WPR14CA152Accident · No injuriesData collectionFinal reportPiper PA 18A · Wheatland, WYThe front seat pilot's excessive approach speed and subsequent brake application during the landing which resulted in a nose-over. Contributing to the accident was the instructor's failure to maintain situational awareness.NTSB WPR13CA381Accident · Minor injuriesData collectionFinal reportCessna 172E · Meeteetse, WYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of situational awareness.NTSB WPR11CA399Accident · No injuriesData collectionFinal reportRichmond Jim R CCK-1865 · Dubois, WYThe pilot's failure to maintain clearance from a wire during cruise flight.NTSB WPR11CA353Accident · No injuriesData collectionFinal reportSloan Roger D Vans RV7A · Sheridan, WYThe pilot's failure to maintain aircraft control during takeoff due to cockpit distractions.NTSB WPR11LA233Accident · Serious injuriesLimited investigationFinal reportPalmer RV6A · Cody, WYThe pilot’s failure to maintain sufficient altitude to avoid rising terrain. Contributing to the accident was the pilot’s visual illusion and disorientation due to the flat light conditions.NTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…NTSB WPR09CA348Accident · Serious injuriesData collectionFinal reportCessna 172M · Thermopolis, WYThe instructor pilot's failure to ensure that his dual student maintained clearance from the terrain during a dark night visual flight rules descent.NTSB LAX08FA265Accident · 3 fatalField investigationFinal reportCessna R172K · Rock Springs, WYThe failure of both pilots to see and avoid each other's aircraft.