NTSB investigations, OK
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW83LA360Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Afton, OKThe acft landed 3 ft short of the rwy on an inclined concrete slope. The weather was VMC. At the approach to the rwy a concrete embankment slopes downward about 10 ft to a road. The acft hit on this embankment bounced and slid 75 ft down the rwy. Discussions…NTSB FTW83LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cashion, OKThe plt was told that the sod strip was 1800 ft long. His calculated takeoff distance to clear a 50 ft obstacle was 1720 ft. however, the actual length of the sod strip ws 1300 ft. during the takeoff roll, the plt realized he would not be able to clear the 30…NTSB FTW83LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft collided with a ditch during a forced landing. This was an instructional flt and the CFI gave the student a simulated forced landing. During the attempted go-around the engine reportedly developed only 1800 RPM and a landing wasmade in a field by the…NTSB FTW83LA349Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Stillwater, OKWhile on a solo x-country flt, the eng lost power & the student plt landed on a highway. During the emergency landing, the right wing hit a road sign & the acft went off the right side of the highway & hit other structures. The fuel selector was found…NTSB FTW83LA316Accident · No injuriesLimited investigationFinal reportCessna 150K · Arcadia, OKThe acft was damaged in a forced landing after the engine quit from fuel exhaustion. The plt had made an unscheduled stop for oil during the x-country flt. According to the plt the engine began to run rough while cruising and then quit completely even though…NTSB FTW83FA311Accident · Minor injuriesField investigationFinal reportBell 47G-2 · Bethany, OKThe helicopter collided with trees and rolled over during a forced landing after engine failure. The plt had been takingpassengers up for sight-seeing for several hours. After the last flt he and his wife had departed the city park to fly back to the acft…NTSB FTW83FA310Accident · 2 fatalField investigationFinal reportBeech A36 · Enid, OKPrior to takeoff the plt was advised the winds were from 180 deg at 20 KTS gusting to 27 KTS. During takeoff from rwy 17THE plt advised the tower that he was 'bringing it around to land on 30.' When asked if he was experiencing any difficulties the plt…NTSB FTW83LA309Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elk City, OKThe acft landed short of the rwy during a night landing following a x-country. The plt stated that he was on the approach to land and attempted to add power. The engine sputtered without an increase in power. The acft touched down 5 ft short of the rwy…NTSB FTW83FA299Accident · 2 fatalField investigationFinal reportAero Commander 680-F · Norman, OKThe acft crashed after starting a go-around or aborted landing at normal ok. The acft was on a x-country from dallas to wichita. There was no radio communication with the acft after it was cleared to land. The approach looked ok but on short final the acft…NTSB FTW83LA304Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Langley, OKThe non-rated plt stated that the eng lost power after he took off & he was unable to restart the eng. During a forced landing, he was unable to clear over wires. He said the nosewheel hit the ground & the acft tumbled as he was attempting to glide under the…NTSB FTW83LA265Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tulsa, OKThe acft veered off the rwy & nosed over. The plt stated he had purchased the acft to start taking plt lessons to securehis license which had been revoked 10/3/79.NTSB FTW83FA261Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Omega, OKThe plt had just completed spraying a field & was in a right turn when the right wing tip hit gently rising terrain. The owner thought that the plt might have diverted his attention while looking at a farmer's map to locate the next field. (Several similar…NTSB FTW83LA256Accident · No injuriesLimited investigationFinal reportAeronca 7AC · El Reno, OKThe acft nosed over during a forced landing after the engine quit. The plt stated that when about 4 miles from the arpt at 200 ft the engine began losing power with the dropping from 2000 to 1500 RPM. He also stated that application of carburetor heat did not…NTSB FTW83LA249Accident · No injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKThe Certified Flight Instructor's delayed remedial action which resulted in the dual student stalling the airplane.NTSB FTW83FA245Accident · 1 fatalField investigationFinal reportBreezy DRAKE-EDGAR · Broken Arrow, OKThe acft collided with the ground in a flat spin that lasted for about 14 turns with no change in attitude. The plt had just completed an air show and was preparing to join a formation flt to return to the arpt. Just before joining the formation the plt was…NTSB FTW83LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodward, OKAs the a/s increased drng tkof roll the acft started to skid to the rt. The student plt stated that with full l aileron and no rt rudder the acft continued to skid to the rt. He then atmptd to apply l rudder and abort the tkof by reducing pwr. The acft veered…NTSB FTW83LA233Accident · No injuriesLimited investigationFinal reportCessna 170A · Prague, OKWhile turning to base leg for landing the eng quit. With insufficient altitude to reach the arpt, the plt selected another field, but landed short in rough terrain. A large quantity of water was found in the acft's fuel tanks which wastraced to a contaminated…NTSB FTW83LA229Accident · No injuriesLimited investigationFinal reportBeech B60 · Afton, OKAfter touchdown the plt applied brakes to slow the acft in order to turn off the mid-field exit, but the acft was going too fast for the turn. The plt stated he felt the brakes begin to be ineffective at this point. He then decided to let the acft roll to the…NTSB FTW83LA211Accident · No injuriesLimited investigationFinal reportHughes 269B · Forgan, OKThe helicopter hooked a skid and rolled over while trying to land on a trailer. The plt stated that after surveying someproperty he landed next to the trailer used for transporting the acft. He then lifted off and while hovering over the trailer a skid hooked…NTSB FTW83LA202Accident · No injuriesLimited investigationFinal reportCessna 150M · Altus, OKThe acft collided with a barbed wire fence and a ditch during an aborted takeoff. The acft was pulled off the ground prematurely and when it failed to accelerate the CFI aborted the takeoff. During the rollout the acft went through a fence and into a ditch.…NTSB FTW83LA197Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Gage, OKThe acft made a forced landing off arpt after the engine quit. The weather was VMC and no flt plan was filed. This was across-country flt from los angeles, CA to bolivar, MO with a fuel stop at Gage, OK. The flt crashed 900 ft short of the rwy at Gage, OK.…NTSB FTW83LA206Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Prague, OKAfter purchasing the acft, the new owner (a student plt) had asked his uncle (reportedly an experienced plt) to fly his acft home. During the flt, the eng lost power shortly after the plt leveled off at 4000 ft MSL (aprx 3000 ft AGL). There was no suitable…NTSB FTW83FPJ02Accident · Serious injuriesFinal reportCessna R172E · Little, OKThe acft had been landed twice to check for leaking fluid on the windshield. When the fuel pressure went to zero and theengine quit the leak was confirmed to be acft fuel. During a forced landing the acft struck a fence and the nose gear collapsed. The…NTSB FTW83LA182Accident · No injuriesLimited investigationFinal reportRotec Rally 3B · Edmond, OKThe plt of the registered, 2 place, ultralight acft reported that the winds were variable & he was intending to land into the wind. However, he further stated that he believed the wind had switched to a tail wind before the landing. After landing, he realized…NTSB FTW83LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hugo, OKThe pilot reported that during the first approach strong gusts were encountered over the threshold and a go-around was was initiated. During the second approach he flew a little higher on final with a steeper descent. He again encountered gusty winds just…NTSB FTW83FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Bethany, OKThe student pilot departed Oklahoma city, OK en route to chickasha, OK. The acft was observed to depart runway 17R and proceed wsw of the airport. The acft wreckage was located about 1 1/2 miles west of wiley post airport. The acft was intact and exam…NTSB FTW83FA170Accident · 2 fatalField investigationFinal reportBeech A36 · Enid, OKDuring the early morning hours, the acft crashed at the edge of a wheat field on relatively level terrain. The main wreckage then crossed a road & came to rest in another field. There were no known witnesses. A passing farmer discovered the wreckage at about…NTSB FTW83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Mountain Park, OKThe pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.…NTSB FTW83LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Guthrie, OKThe pilot said he was waiting for an acft to clear the rwy. As he started to turn downfield for takeoff he pushed the throttle in, advancing the power instead of retarding it. The aircraft crossed the runway at an angle, became airborne and hit a tree. The…NTSB FTW83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Oklahoma City, OKWitnesses reported that the landing gear was lowered at the outer marker on an ILS approach. The pilot stated that he extended full flaps at about 400 feet AGL just as they broke out of the clouds. Almost immediately after landing the pilot retracted the…NTSB FTW83FA150Accident · 2 fatalField investigationFinal reportBeech A23-24 · Shawnee, OKThe plt departed his private, 1200 ft airstrip & flew to the Shawnee muni arpt with 1 passenger. During arrival on the return flt, he elected to land toward the south. According to a witness, there was a thunderstorm at that time aprx 1/2 to 1 mi…NTSB FTW83FA149Accident · 3 fatalField investigationFinal reportPiper PA-34-200 · Kingston, OKThe acft rolled right after a premature liftoff due to a dip in the rwy. The acft continued to roll right until it impacted a 6 degree slope in a 100 degree nose down attitude. Investigation revealed that the right engine had suffered a power loss due to a…NTSB FTW83LA152Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Norman, OKDuring arrival, the plt landed with a 30 deg left crosswind. After touching down in a 3-point attitude, the acft swerved to the right & turned aprx 25 deg before the plt regained control. He corrected the heading to parallel the runway aprx 10 ft right of a…NTSB FTW83LA135Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Muskogee, OKThe passenger was in the back seat with a 35 mm camera, a pocket camera, a pair of binoculars in a case and a windbreaker. While flying at dusk, they flew by a herd of deer, but the passenger did not get a photograph. Reportedly, the plt made a 180 deg turn &…NTSB FTW83LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Hennessey, OKWhile on a short final to land at a private ag strip, the acft struck power lines, then flipped over & impacted on the apch end of the rwy. Although the plt was unfaamilar with the arpt, she had been briefed on the existance of the wires before her departure.…NTSB FTW83LA106Accident · No injuriesLimited investigationFinal reportRobinson R22 · Stillwater, OKA simulated autorotational landing was initiated at about 450 ft AGL. During the approach, a 90 deg arc was flown toward an open field. A flare was begun with a power recovery at about 40 ft AGL when a wire was observed in the flight path. By this time, the…NTSB FTW83FA079Accident · 2 fatalField investigationFinal reportMooney M20E · Cushing, OKThe acft collided with a powerline during a low flt down a river. The acft impacted 3 high tension cables spanning the river. Witnesses said the acft was flying low and fast. The collision produced a sound 'like a gunshot' and the acft fell to the ground and…NTSB FTW83LA082Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Mangum, OKThe pilot stated that shortly after takeoff the left engine surged twice and quit. He elected to make a precautionary landing in an open field which was soft from melting snow. During roll out the nose wheel dug in and the drag link broke which collapsed the…NTSB FTW83LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Nash, OKPilot encountered fog and decided to land in a wheat field looked frozen but was soft and aircraft nosed over. There were 3 local airports within 20 miles.NTSB FTW83LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Grandfield, OKShortly after takeoff, a child, who had been allowed to occupy the baggage compartment during the takeoff, fell from the acft when the door opened in flight. The child's grandfather, who occupied the rear seat, allowed the youngster to climb into the baggage…NTSB FTW83FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hennessey, OKThe plt was giving taxi rides to his grandchildren at a private farm strip. Accompanied by two teenage granddaughters, the plt was observed in the right front seat holding the entry door open while taxiing the acft up & down the strip. A witness heard the…NTSB FTW83FPM04Accident · 2 fatalFinal reportPiper PA23-250 · 8 Miles Se Bris, OKThe acft departed at 2220 with a planned enroute stop at holdenville, OK. 55 minutes later the acft crashed approximately 8.5 miles from its original departure point. Witnesses describe the wx as very bad due to heavy rain & fog.NTSB FTW83FPM03Accident · Minor injuriesFinal reportCessna 152 · Tulsa, OKOn the day before the accident the plt flew the acft to excelsor springs, MO for refueling, returning to liberty. On 11/7/82 at 1545 the flt departedliberty on an IFR flt plan. Approximately 7 mi north of Tulsa intl arpt the plt elected to land at Tulsa for…NTSB FTW83FPJ01Accident · Serious injuriesFinal reportPiper PA-28RT-201T · 3 Miles Ne Of E, OKThe aircraft struck power lines near the south end of the airport, at dusk, while on a final approach to runway 36. After striking the wires, the plane impacted the ground.NTSB FTW83LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ardmore, OKPilot tookoff with prop governor inoperative. While cruising 21 miles south of Ardmore, he began to loose oil pressure and turned toward Ardmore. Engine quit 4 miles from airport. Pilot declared an emergency and descended through the clouds. He went through…NTSB FTW83FPM02Accident · 1 fatalFinal reportAmerican AA-5B · 3 1/2 Nm Ene Di, OKWitnesses stated that the aircraft bounced at touchdown, a go-around was attempted and the aircraft struck a powerline at the end of the runway. The aircraft impacted the ground approximately 1/4 mile southeast of the runway. The accident occurred at dusk.NTSB FTW83LA019Accident · No injuriesLimited investigationFinal reportNorth American F-51D · Piedmont, OKThe eng failed at 5,500 ft MSL. During an emergency landing at a 5,000 ft dirt strip (under construction for paving), gear extension was delayed to increase glide. The right gear did not have time to lock down & retracted during landing. Initial exam of the…NTSB FTW83FPM01Accident · Serious injuriesFinal reportCessna 180 · Foyil, OKThe pilot reported that he had 20 gal of fuel on board when he took off. He climbed to 10,000 ft for a parachute jump, then returned to the airport with an estimated 10 gal of fuel. During a downwind landing, he elected to go around. He said the engine lost…NTSB FTW82DA398Accident · No injuriesFinal reportPiper PA-28-140 · Kansas, OKAircraft collided with a hole in a pasture after a precautionary landing due to low fuel state brought on by head winds.NTSB FTW82FPM17Accident · 1 fatalFinal reportCessna 421B · Afton, OKAt about 1930 CDT, the aircraft departed yukon, OK on a direct flight to alton, IL. It landed at alton at about 2200 CDT, and about 10 minutes later, it departed on a return flight to yukon. Before departing alton, the pilot stated that he would refuel at…