NTSB investigations, OK
22 cases where NTSB found Attention/monitoring.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 4 |
| 2011 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2025 | 2 |
| 2026 | 2 |
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\" = '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\", '020215'))
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", '020215')) 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 WPR26LA277Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206B III · Stonewall, OKThe pilot’s failure to maintain clearance from power lines while conducting a low-altitude aerial application.NTSB WPR26LA230Accident · No injuriesClass 4 · LimitedFinal reportStephen Aberle Chipper CH-2A · Alva, OKThe pilot's decision to taxi the tailwheel-equipped airplane over uneven terrain while operating with limited forward visibility, which resulted in the left main landing gear entering a hole.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 CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.NTSB DCA22LA126Incident · No injuriesClass 3 · LimitedFinal reportBoeing 757-236 · Tulsa, OKThe flight crew’s misidentification of the intended landing runway. Contributing to the incident were (1) the flight crew’s failure to perceive and correctly interpret visual and auditory indicators – including electronic guidance – that they were approaching…NTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.NTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…NTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.NTSB CEN19LA068Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 · Ponca City, OKThe pilot's failure to maintain altitude during the hover operation while his view was obstructed due to the fogged-over windshield.NTSB CEN17CA120Accident · Serious injuriesData collectionFinal reportAero Commander S2R · Fairmont, OKThe pilot’s failure to maintain clearance from a power line while conducting agricultural spray operations.NTSB GAA17CA160Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot’s failure to maintain clearance from a hangar while taxiing at night.NTSB GAA16CA253Accident · No injuriesData collectionFinal reportCessna 172 · Shawnee, OKThe pilot's failure to remain a safe distance from obstacles while taxiing to parking, resulting in the airplane's wing striking a light pole.NTSB CEN11CA509Accident · No injuriesData collectionFinal reportBell 206B · Temple, OKThe pilot’s failure to maintain clearance from static power lines.NTSB CEN11FA434Accident · 1 fatalField investigationFinal reportSchaffer Gary W Lancair · Yukon, OKThe pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…NTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.NTSB CEN09CA479Accident · Serious injuriesData collectionFinal reportPiper PA28-151 · Purcell, OKThe student pilot's failure to see and avoid the power lines.NTSB CEN09TA399Accident · No injuriesFinal reportCessna 182 · Cookson, OKThe pilot's failure to maintain clearance with the building while taxiing on a road.NTSB CEN09CA359Accident · No injuriesData collectionFinal reportHiller UH-12E · Stringtown, OKThe pilot's failure to maintain clearance from power lines. Contributing to the accident was the pilot's preoccupation with personal affairs.NTSB CEN09CA287Accident · Serious injuriesData collectionFinal reportPitts Aerobatics S-2B · Muskogee, OKInadequate supervision by the certified flight instructor, resulting in a delayed stall recovery attempt.NTSB DEN08LA111Accident · No injuriesLimited investigationFinal reportCessna 172R · Tishomingo, OKThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall during the landing flare. Contributing factors in this accident was the terrain-induced turbulence, and the instructor's inadequate supervision of the pilot.NTSB DFW08CA070Accident · No injuriesData collectionFinal reportCessna 172S · Jenks, OKThe owner of the parking surface's failure to ensure that the parking surface was clear of hazards to taxiing airplanes and the pilot's failure to ensure a safe taxi route in unfamiliar surroundings.