NTSB investigations, OK
72 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 5 |
| 2022 | 1 |
| 2023 | 6 |
| 2024 | 3 |
| 2025 | 4 |
| 2026 | 1 |
Where
Open the mapLatest 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\" = 'OK' 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\", '0303'))
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" = 'OK' 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", '0303')) 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 CEN26LA170Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA 31P 350 · Ardmore, OKThe pilot’s failure to maintain control of the airplane while landing on a wet runway with a tailwind.NTSB CEN26LA075Accident · No injuriesClass 4 · LimitedFinal reportSteen Skybolt · Guthrie, OKThe pilot's failure to maintain directional control during landing with a quartering left crosswind.NTSB CEN26LA057Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Weatherford, OKThe pilot’s improper landing flare which resulted in a hard landing. Contributing to the accident was the pilot being in a rush and failing to note the wind direction and speed.NTSB CEN25LA350Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Ardmore, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB DCA25LA190Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Tahlequah, OKThe airplane’s encounter with moderate turbulence during descent.NTSB CEN24LA158Accident · No injuriesClass 3 · LimitedFinal reportJacobson SE5A Replica · Luther, OKThe pilot’s failure to use carburetor heat, which resulted in fuel starvation during the initial climb, a loss of engine power, and impact with terrain.NTSB CEN24LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Cherokee, OKA partial loss of engine power for reasons that could not be determined. Contributing to the accident was the presence of ground fog, which hindered the landing approach and resulted in the pilot inadvertently landing long and impacting a fence during the…NTSB CEN24FA094Accident · 3 fatalClass 3 · FieldFinal reportBell 206 · Hydro, OKThe helicopter’s inflight collision with cackling geese, resulting in an inflight breakup.NTSB CEN24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Ponca City, OKThe pilot’s loss of directional control during landing in gusty crosswind conditions.NTSB CEN23LA226Accident · Serious injuriesClass 3 · LimitedFinal reportTemco GC-1B · Bristow, OKThe loss of engine power due to carburetor ice due to the pilot’s delayed application of carburetor heat.NTSB CEN23LA157Accident · Minor injuriesClass 4 · LimitedFinal reportAcro Sport II · Skiatook, OKThe pilot's failure to maintain directional control during landing in a gusting crosswind.NTSB CEN23LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oklahoma City, OKThe pilot’s loss of directional control during landing with wind gusts, which resulted in a runway excursion and nose over.NTSB CEN23FA095Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Hooker, OKThe pilot’s decision to depart and continue the visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN22FA145Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Pond Creek, OKThe pilot’s loss of control of the airplane, resulting in an in-flight breakup.NTSB CEN22FA016Accident · 1 fatalClass 3 · FieldFinal reportAutoGyro Cavalon · Stroud, OKThe pilot’s lack of experience in the gyroplane and his decision to takeoff with a tailwind. As a result, the gyroplane did not generate enough lift to takeoff before it struck a barbed wire fence. Contributing to the accident was the pilot’s failure to wear…NTSB CEN21LA338Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Harrah, OKThe pilot’s decision to fly the airplane without a carburetor heat control in atmospheric conditions conducive to the development of serious carburetor icing, which resulted in a partial loss of engine power.NTSB CEN21FA300Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-33 · Roff, OKThe pilot’s loss of airplane control due to spatial disorientation during low-level nighttime flight.NTSB CEN21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Tishomingo, OKThe pilot’s decision to abort the takeoff on encountering a wind gust and his landing beyond the end of the runway that resulted in the airplane impacting a ditch collapsing the nose landing gear.NTSB CEN21LA153Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC130 · Tulsa, OKThe pilot’s improper decision to approach the airport and enter a low altitude hover with a gusting quartering tailwind, which resulted in a loss of tail rotor effectiveness during a turn at a low altitude.NTSB CEN21LA047Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Ardmore, OKThe pilot’s improper decision to takeoff with 3 persons in a 2-place airplane and over maximum gross weight, and his failure to apply carburetor heat when the airplane’s engine experienced carburetor ice and a partial loss of power.NTSB CEN20CA350Accident · No injuriesClass 4 · Data collectionFinal reportCessna 140 · Olustee, OKThe pilot's decision to attempt a takeoff from the middle of the runway in shifting wind conditions, which resulted in an aborted takeoff and runway excursion.NTSB CEN20CA226Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 17 30 · Talihina, OKThe pilot's failure to maintain control of the airplane during a crosswind landing, which resulted in a hard landing and runway excursion.NTSB CEN20CA152Accident · No injuriesData collectionFinal reportCessna 172 · Enid, OKThe flight instructor's delayed remedial action during a power-off approach and go-around in gusting wind conditions, which resulted in a hard landing, loss of directional control, and a runway excursion onto a field.NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB GAA19CA368Accident · No injuriesData collectionFinal reportCessna 172 · Tulsa, OKThe pilot's failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a taxiway sign.NTSB GAA19CA142Accident · No injuriesData collectionFinal reportCirrus SR22 · Tulsa, OKThe pilot's failure to maintain a stabilized approach with a tailwind and his subsequent failure to maintain yaw control during an attempted go-around.NTSB GAA18CA527Accident · No injuriesData collectionFinal reportCessna 170 · Tulsa, OKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB CEN18LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grove, OKA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat immediately following the loss of engine power.NTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…NTSB CEN18LA070Accident · No injuriesLimited investigationFinal reportCessna 170 · Ponca City, OKThe pilot's loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion.NTSB GAA17CA349Accident · No injuriesData collectionFinal reportPiper PA44 · Tulsa, OKThe pilot receiving instruction’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA160Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot’s failure to maintain clearance from a hangar while taxiing at night.NTSB GAA17CA037Accident · No injuriesData collectionFinal reportPiper PA24 · Wagoner, OKThe pilot's failure to maintain directional control during landing in gusting wind conditions.NTSB GAA16CA395Accident · No injuriesData collectionFinal reportEngineering & Research 415 · Collinsville, OKThe pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.NTSB GAA16CA390Accident · No injuriesData collectionFinal reportPiper PA46 · Claremore, OKThe pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.NTSB GAA16CA194Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and collision with a runway distance remaining sign.NTSB GAA16CA176Accident · No injuriesData collectionFinal reportNorth American AT6 · Yukon, OKThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in runway excursion and impact with terrain.NTSB GAA16CA116Accident · No injuriesData collectionFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain pitch control during the landing, resulting in a porpoise.NTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.NTSB CEN15FA127Accident · 1 fatalField investigationFinal reportEagleston John H Vans RV9A · Kingston, OKThe pilot’s continuation of a banked turn following the loss of engine power, which resulted in his failure to maintain adequate airspeed and the airplane exceeding its critical angle of attack and entering an accelerated stall at low altitude. Contributing…NTSB CEN14CA525Accident · No injuriesData collectionFinal reportBell 206B · Nashoba, OKThe pilot's loss of directional control due a loss of tail rotor effectiveness.NTSB CEN14FA506Accident · 1 fatalField investigationFinal reportCessna 172R · Okmulgee, OKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.NTSB CEN14LA129Accident · No injuriesLimited investigationFinal reportCessna 525 · Elk City, OKThe pilot’s descent below the published minimum descent altitude for the instrument approach procedure, which resulted in impact with a utility pole.NTSB CEN14FA019Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Talihina, OKThe pilot’s lack of weather planning and his continued flight into an area of known rain with reduced visibility and his subsequent failure to maintain clearance with trees.NTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.NTSB CEN13LA332Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Oklahoma City, OKThe pilot's failure to maintain directional control of the airplane.NTSB CEN13FA217Accident · 2 fatalField investigationFinal reportMooney M20E · Guymon, OKThe noninstrument-rated pilot's encounter with instrument meteorological conditions, which resulted in spatial disorientation and his subsequent loss of airplane control. Contributing to the accident was the pilot's decision to take off in deteriorating…NTSB CEN13FA174Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Oklahoma City, OKThe loss of engine power due to engine ice ingestion during initial climb after takeoff in dark night light conditions. Contributing to the accident were the lack of an installed engine air inlet cover while the helicopter was parked outside, exposed to…NTSB CEN13FA121Accident · Serious injuriesField investigationFinal reportEurocopter EC130 B4 · Seminole, OKThe loss of engine power due to ice ingestion. Contributing to the accident was maintenance personnel’s delayed decision to install the helicopter's engine inlet cover until after the engine had been exposed to moisture and freezing temperatures and their…