NTSB investigations, OK
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 DFW08CA136Accident · No injuriesData collectionFinal reportPiper PA-36 · Thomas, OKThe disconnected throttle linkage resulting in the loss of engine power during takeoff-initial climb. A factor contributing to the accident was the muddy forced landing site.NTSB DFW08CA127Accident · Minor injuriesData collectionFinal reportThompson Howard Pazmany PL-2 · Wagner, OKLoss of power for undetermined reasons.NTSB DFW08LA121Accident · 1 fatalLimited investigationFinal reportTromsness Enterprises Turbine LE · Miami, OKThe pilot's failure to maintain control of the airplane for undetermined reasons. Contributing to the accident included his extensive use of medications and/or his multiple medical conditions and the failure of the FAA to follow up on his reported medication…NTSB DFW08LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quinton, OKAn undetermined mechanical malfuction associated with the tail rotor drive system which led to a loss of control.NTSB DFW08CA083Accident · No injuriesData collectionFinal reportCessna 150 · Idabell, OKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident are high and gusting winds.NTSB DFW08CA079Accident · No injuriesData collectionFinal reportWilley Rotorway Exec 90 · Westport, OKAn unsuccessful precautionary landing due to an electrical system malfunction.NTSB DFW08MA076Accident · 5 fatalClass 1 · MajorFinal reportCessna 500 · Oklahoma City, OKAirplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.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.NTSB DFW08FA060Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Lindsay, OKThe flight instructor's failure to maintain control of the airplane, which resulted in an inadvertent stall while maneuvering.NTSB DFW08FA056Accident · 1 fatalField investigationFinal reportAero Commander 500B · Tulsa, OKThe pilot's loss of control due to spatial disorientation and the pilot exceeding the design/stress limits of the aircraft. Factors contributing to the accident were the pilot's reported gyro problem, the dark night conditions , and prevailing instrument…NTSB DFW08LA055Accident · 1 fatalLimited investigationFinal reportPilatus PC-12/45 · Oklahoma City, OKThe line technician's failure to remain clear of the propeller. A factor was the night lighting conditions.NTSB DFW08CA047Accident · No injuriesData collectionFinal reportCessna 210 · Medford, OKThe pilot's decision to attempt a night landing without runway lighting. A contributing factor was inoperative runway lights.NTSB DFW08CA044Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot failed to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB DFW08FA040Accident · 2 fatalField investigationFinal reportCessna 172N · Marlow, OKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin and impact with terrain. Contributing to the accident were the low altitude for recovery and the gusty tailwind.NTSB DFW08FA038Accident · 2 fatalField investigationFinal reportCessna T210M · Tulsa, OKThe pilot's failure to maintain clearance from the power transmission line(s). Contributing to the accident were the loss of aircraft electrical power, diverted attention, and the night conditions.NTSB DFW08CA032Accident · No injuriesData collectionFinal reportCessna 150 · Muskogee, OKThe pilot's failure to maintain directional control while landing.NTSB DFW08CA028Accident · No injuriesData collectionFinal reportCessna 152 · Ardmore, OKThe pilot's improper landing flare which resulted in a hard landing.NTSB DFW08CA021Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's improper recovery from a bounced landing.NTSB DFW08FA015Accident · 5 fatalField investigationFinal reportBeech A36 · Glenpool, OKThe pilot's failure to maintain control of the airplane after departure, which resulted in a collision with power lines. A factor was the high winds.NTSB DFW07CA192Accident · No injuriesData collectionFinal reportBoeing 1942 · Edmond, OKThe pilot's failure to maintain directional control during takeoff resuting in a nose over. A contributing factor was the soft terrain.NTSB DFW07CA194Accident · Minor injuriesData collectionFinal reportNicely Kitfox Model 5 · Guthrie, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable landing terrain for the forced landing.NTSB DFW07CA196Accident · No injuriesData collectionFinal reportInterplane Skyboy · Atoka, OKThe pilot's improper landing flare, resulting in a hard landing.NTSB DFW07LA170Accident · 1 fatalLimited investigationFinal reportHazen Fly Baby · Page, OKThe airplane's collision with wooded and mountainous terrain for undetermined reasons.NTSB DFW07LA167Accident · No injuriesLimited investigationFinal reportRotorway 162F · Stratford, OKThe loss of engine power due to a seized supercharger. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA162Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315 · Stuart, OKThe loss of engine power due to a clogged fuel tube. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA164Accident · Serious injuriesLimited investigationFinal reportBoeing B737-800 · McAlester, OKAn in-flight encounter with clear air turbulence, which resulted in a serious injury to a flight attendant.NTSB DFW07CA143Accident · Minor injuriesData collectionFinal reportBell BH206B-3 · Sand Springs, OKThe pilot's failure to maintain clearance with ground obstacles, which resulted in a blade strike. A contributing factor was the low altitude selected by the pilot.NTSB DFW07CA131Accident · No injuriesData collectionFinal reportGrumman G-164A · Okarche, OKThe pilot's failure to maintain clearance from an unmarked light fixture.NTSB DFW07CA129Accident · No injuriesData collectionFinal reportGrumman G-164A · Sayre, OKThe partial loss of engine power on takeoff-initial climb for an undetermined reason. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.NTSB DFW07LA108Accident · Serious injuriesLimited investigationFinal reportCessna A188A · Clinton, OKSeparation of the exhaust stack and resulting vapor lock. A contributing factor was the none suitable terrain for the forced landing.NTSB SEA07CA105Accident · No injuriesData collectionFinal reportCessna 150E · Shawnee, OKThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the tree.NTSB DFW07CA092Accident · Minor injuriesData collectionFinal reportCessna 182E · Marietta, OKThe airplane noseover due to the pilot's failure to obtain current NOTAM information on the closed airport. A contributing factor was the unsuitable terrain.NTSB DFW07FA084Accident · 1 fatalField investigationFinal reportBeech 58P · Marietta, OKThe pilot's improper landing flare. A contributing factor was the premature touchdown in an area of rising terrain.NTSB DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.NTSB DFW07LA080Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Ponca City, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07FA071Accident · 1 fatalField investigationFinal reportStevens KB-2 · Oklahoma City, OKThe pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.NTSB DFW07CA058Accident · No injuriesData collectionFinal reportCessna 152 · McAlester, OKThe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose landing gear.NTSB DFW07LA052Accident · No injuriesLimited investigationFinal reportFairchild Merlin SA-226-T · Tulsa, OKThe loss of control as result of the malfunction of the nose wheel steering mechanism during landing for undetermined reasons.NTSB DFW07LA056Accident · No injuriesLimited investigationFinal reportCessna 172S · Tulsa, OKThe pilot's failure to maintain clearance from a hangar and parked airplane during the unauthorized use of an airplane.NTSB DFW07FA039Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Jay, OKThe loss of engine power for undetermined reasons and the pilot's improper decision to extend the landing gear for the water landing. Contributing factors were the prevailing night conditions and the lack of suitable terrain for the forced landing.NTSB DFW07LA032Accident · 2 fatalLimited investigationFinal reportNoble Vans RV-7A · Norman, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.NTSB DFW07LA024Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pocasset, OKThe "abnormally high" oil temperature indication and smoke in the cabin for undetermined reasons. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB DFW07FA019Accident · 2 fatalField investigationFinal reportCessna 172S · Hominy, OKThe pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.NTSB DFW07FA004Accident · 4 fatalField investigationFinal reportAero Commander 690A · Antlers, OKThe pilot's failure to reduce airspeed while operating in an area of moderate turbulence, resulting in an in-flight break up. Contributing factors were the pilot's decision to exceed the maximum takeoff weight, and the prevailing turbulence.NTSB DFW06CA213Accident · No injuriesData collectionFinal reportRobinson R22 · Skiatook, OKThe pilot's failure to maintain control of the helicopter following an encounter with dynamic rollover.NTSB DFW06LA191Accident · No injuriesLimited investigationFinal reportCessna R182 · McAlester, OKThe in-flight fuel leak and fire as result of electrical arcing of a fuel line connecting the engine driven fuel pump and the electric fuel pump.NTSB DFW06FA173Accident · 1 fatalField investigationFinal reportCessna 180K · Owasso, OKThe pilot's selection of unsuitable terrain, a residential street, for both takeoff and landing, which resulted in a collision with a static wire and terrain during takeoff-initial climb.NTSB DFW06CA164Accident · Serious injuriesData collectionFinal reportCessna 172F · Marietta, OKThe pilot's improper weather evaluation. Contributing factors were the strong tailwind and the high density altitude.NTSB DFW06CA165Accident · No injuriesData collectionFinal reportCessna 210 · Lawton, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.