NTSB investigations, OK
13 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2021 | 1 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '338' 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."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '338' 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 CEN26LA175Accident · No injuriesClass 3 · LimitedPreliminary reportHiller UH-12E · Chickasha, OKOn April 30, 2026, about 1730 central daylight time, a Hiller UH-12E, N22SP, was substantially damaged when it was involved in an accident near Chickasha, Oklahoma. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB CEN21FA314Accident · 1 fatalClass 3 · FieldFinal reportPZL Mielec M18 · Seiling, OKThe pilot’s in-flight loss of control due to the structural failure of a wing fitting and separation of the outboard wing section. Also causal were the inadequate wing fitting inspections, which failed to detect the initial corrosion and crack before it…NTSB CEN18FA023Accident · 2 fatalField investigationFinal reportBeech V35B · Alva, OKThe flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation…NTSB CEN17LA235Accident · No injuriesLimited investigationFinal reportCessna 182A · Buffalo, OKThe separation of the nose wheel axle bolt and the nose wheel during the landing roll for reasons that could not be determined because the bolt was not recovered.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 CEN16LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ponca City, OKMaintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.NTSB CEN15LA379Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ketchum, OKThe separation of the tail rotor gearbox from the tailboom aft bulkhead due to overstress loads imposed by a blade imbalance from an in-flight impact with an undetermined object.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 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 CEN13FA344Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Talihina, OKThe helicopter pilot's failure to see and avoid the 40-ft-tall lamp post during takeoff. Contributing to the accident was the pilot's inadequate preflight evaluation of the obstructions in the takeoff path.NTSB CEN12LA368Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Hooker, OKThe pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…NTSB CEN10LA241Accident · Minor injuriesLimited investigationFinal reportHager Clinton Ray Vans RV-8 · Prague, OKThe in-flight separation of a propeller blade for undetermined reasons.NTSB CEN09LA197Accident · No injuriesLimited investigationFinal reportNeland Richard L Daytona SU · Guymon, OKFailure of the left main landing gear shock/strut during takeoff for undetermined reasons.