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 FTW82FPM16Accident · 1 fatalFinal reportMustang II · Tahlequah, OKThe amateur built Mustang ii crashed while attempting a roll during the annual tulsa fly-in at Tahlequah airport. The acft was observed making a hi-speed fly-by over runway 35 at approximately 50 ft AGL, and start a gradual climb & roll to the right to…NTSB FTW82DA386Accident · No injuriesFinal reportGrumman AA-5A · Tulsa, OKThe student pilot stated that he made several touch-and-go landings without incident, when the engine started "cutting out" on final approach. He reported that carburetor heat was not applied until after the power loss began. He was unable to restore power…NTSB FTW82DA374Accident · Minor injuriesFinal reportCessna 172 · Vain, OKThe pilot and his passenger took off on a local flight and flew over a runway that they were constructing in their pasture. The pilot stated that he was in slow flight over the runway. Both occupants received concussions in the accident and could not recall…NTSB FTW82DA371Accident · Minor injuriesFinal reportCessna 150 · Tulsa, OKAircraft collided with trees on final after engine quit due to lack of fuel. Aircraft had 1 gallon of fuel on board when it crashed.NTSB FTW82DA369Accident · No injuriesFinal reportBeech A36 · Shawnee, OKLanding gear collapsed during landing roll.NTSB FTW82DA345Accident · No injuriesFinal reportPiper PA-28-140 · Oklahoma City, OKThe student pilot reported that during a landing, the aircraft ballooned and he overcorrected. The nose gear assembly was damaged during touchdown and the rudder pedals became inoperative. The student lost directional control andcollided with a parked…NTSB FTW82DA338Accident · No injuriesFinal reportCessna P210N · Ardmore, OKAfter making an NDB approach, the pilot sighted the runway and turned onto a downwind for a visual approach. The aircraft touched down at about the midfield point in calm wind conditions. The runway had just been resurfaced and was wet and slick from…NTSB FTW82DA327Accident · No injuriesFinal reportHughes 269A · Forgan, OKThe purpose of the flight was to look for a missing person. The pilot reported that during an approach to land, he lost tail rotor control and the helicopter began to spin to the right. He set the helicopter down while it was turning, but the right skid hit a…NTSB FTW82FPM15Accident · 2 fatalFinal reportBeech H35 · Tulsa, OKAircraft lost power during takeoff. Pilot tried to turn back to airport in a left bank described as 60 to 90 degrees. Aircraft stalled and crashed about 1300 feet east of takeoff point. During the investigation the fuel pump was placed on a flow bench & on…NTSB LAX82FVG30Accident · Serious injuriesFinal reportPiper PA-36-285 · Malin, OKPower loss during takeoff resulted in forced landing. Aircraft collided with canal bank. Cylinder had broken rings. Both plugs were badly oil fouled. One plug would not fire & the other fired intermittently.NTSB FTW82FPJ19Accident · Serious injuriesFinal reportCessna 172M · Overbrook, OKThe pilot stated that he began his takeoff from the very beginning of the runway, and that on rotation, the engine seemed to lose power. He stated that he observed the tachometer and saw that the engine was dropping below 1500 RPM. Subsequently, the aircraft…NTSB FTW82DA317Accident · No injuriesFinal reportBeech C23 · Afton, OKDuring arrival, the pilot landed on runway 36 with a reported tail wind of 10 KTS to 12 KTS. He stated that during the landing, his airspeed was a little too fast and the aircraft bounced. On the second bounce, the aircraft landed on its nose gear and the…NTSB FTW82DA307Accident · No injuriesFinal reportCessna 182M · Calumet, OKWhen the pilot landed on a 2000 ft private strip, the left wing of the aircraft struck a tree that was located beside the landing area. After impact the aircraft traveled approximately 100 ft before coming to rest. Both wings, propeller, cabin section and…NTSB FTW82FPJ18Accident · Serious injuriesFinal reportPiper 28-181 · Oklahoma City, OKThe pilot had difficulty locating the airport at his destination. He touched down at a point more than halfway down the 3000 foot runway and realizing he would be unable to stop the aircraft, attempted a go-around. The main landing gear struck a roadside…NTSB FTW82DA294Accident · Minor injuriesFinal reportVarga 2150A · Oklahoma City, OKThe student reported that before he began his flight, he visually checked both tanks and estimated that he had two hours of fuel remaining. He flew 1.1 hrs and was on his way home when the engine lost power. While landing in a plowed field, the plane flipped…NTSB FTW82FPJ17Accident · 1 fatalFinal reportPiper 28-140 · Harrah, OKDuring takeoff, the pilot elected to cross under a power line near the end of the runway when he realized he could not fly over. As the plane crossed under the power line, the right main gear struck a steel perimeter fence post. Across the street form the…NTSB FTW82FPJ16Accident · Serious injuriesFinal reportPiper 18 · Gage, OKThe aircraft was being used to spray grasshoppers and was flying in an easterly direction. The right wing struck a high line wire that is oriented north and south. After striking the wire the aircraft struck the ground approximately 190 feet east of the high…NTSB FTW82FPJ15Accident · Serious injuriesFinal reportHughes 269 · Boise City, OKThe plt had completed conducting tests with dyed water to determine spray pattern & coverage after recently installing special purpose aerial application equipment. While approaching for a landing at a forward speed of 15-20 mph & descending rapidly he…NTSB FTW82FPM13Accident · Serious injuriesFinal reportBoeing A75 · Tulsa, OKA witness located at the departure end of the runway stated that the aircraft climbed to an altitude of approximately 400 feet when the engine stopped running. In a nose high atitude the left wing was observed to drop and a stall occurred. The pilot had no…NTSB FTW82DA291Accident · No injuriesFinal reportCessna A188B · Boise City, OKThe pilot stated that during the landing roll after a normal touchdown, the right tire blew out. Subsequently, the aircraft veered into a ditch and was substantially damaged. This was a 2200 x 8 goodyear tire.NTSB FTW82DA259Accident · No injuriesFinal reportCessna 310Q · El Dorado, OKWhen the pilot arrived in the vicinity of his destination, he lowered the gear and flaps and dlew over an oil rig. He did this to alert someone on the ground to pick him up at the destination. As he applied power to proceed to the airport, the left engine did…NTSB FTW82DA282Accident · No injuriesFinal reportBoeing A75L300 · Tulsa, OKThe pilot reported that during a wheel landing, the aircraft began to veer to the right and all efforts to straighten it with rudder failed. As the plane went off the runway. The left wing dropped, striking the runway, and the lower left wing spar broke. The…NTSB FTW82DA228Accident · Minor injuriesFinal reportCessna 152 · Tulsa, OKThe aircraft lost power during climb at 1300 feet. The engine would not restart. The pilot made a forced landing in the Arkansas river. No preimpact malfunction or failure of the aircraft's engine could be found.NTSB FTW82DA227Accident · No injuriesFinal reportBoeing 75A · Picher, OKThe pilot had just completed spraying a field and was climbing to return to his home airstrip when the engine failed. He landed in a nearby pasture but was unable to stop on the wet terrain before hitting a low fence. The main gear caught on the fence and the…NTSB FTW82FA223Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Hartshorne, OKWhile on a cross-country flight, the pilot was advised by radio of a severe thunderstorm and tornado watch along his route. At 1613 CDT, he was advised of a line of radar returns about 10 miles ahead. He replied that it "looks like a soft spot through there,…NTSB FTW82DA224Accident · No injuriesFinal reportCessna 172 · Duncan, OKThe student pilot was practicing touch-and-go landings in winds from the southeast at 10 gusting 15 KTS. Just prior to landing, the aircraft encountered a gust of wind, then touched down hard. The engine fire wall was buckled and two tires blew out.NTSB FTW82DA222Accident · Minor injuriesFinal reportBeech C-35 · Ryan, OKOn arrival at the destination airport the pilot determined the grass strip was too wet for a landing. The pilot selecteda farm road and stated that a gust of wind struck the aircraft at about 10 to 12 feet above the road. The aircraft landed hard and swerved…NTSB FTW82DA220Accident · No injuriesFinal reportCessna 152 · Cushing, OKWhile landing, the student pilot lost control and the aircraft swerved off the runway, collided with a ditch and nosed down. The student stated that she flared for landing and added too much power and right rudder which resulted in the loss of control.NTSB FTW82DA199Accident · No injuriesFinal reportAir Tractor AT 301 · Eakly, OKThe pilot stated that as he pulled up from a swath run the engine started missing. He then elected to attempt a return to his departure airstrip. While turning toward the field the engine started making a loud noise and lost power. During the forced landing…NTSB FTW82DA192Accident · Minor injuriesFinal reportRobinson R22 · Ada, OKThis was a commercial certification check flight for the pilot-in-command. After completing normal hovering maneuvers, the examiner instructed the pilot to execute a hovering autorotation over a level area of grass. The pilot rolled the throttle off on a…NTSB FTW82DA191Accident · Minor injuriesFinal reportErco 415-C · Sand Springs, OKThe pilot stated that on his second approach for a touch and go landing, the aircraft was a little high on final. He reduced power to complete a short field landing on the sod strip. The aircraft landed moderately hard in a flat attitude and the nose gear…NTSB FTW82DA186Accident · No injuriesFinal reportCessna 150 · Knowles, OKDuring a cross country flight the student pilot elected to land in a pasture near his home. On takeoff the aircraft collided with a fence resulting in substantial damage to the aircraft. The pilot returned to the pasture and landed without further incident.…NTSB FTW82DA182Accident · No injuriesFinal reportCessna T210N · Tulsa, OKWhile cruising at 17,500 feet the aircraft encountered clear air turbulence and went inverted. During recovery the aircraft entered a spin. Recovery was made at 16,750 feet. The pilot continued on to Tulsa and landed safely. The aircraft received substantial…NTSB FTW82DA177Accident · No injuriesFinal reportGrumman G-164A · Elreno, OKDuring takeoff the pilot encountered standing water on the runway. The aircraft swerved left and nosed over.NTSB FTW82DA174Accident · No injuriesFinal reportBoeing E75 · Erick, OKThe pilot was pulling up from the swath run and collided with wires. The aircraft nosed over during the forced landing.NTSB FTW82FA132Accident · 3 fatalField investigationFinal reportBell 222 · Hinton, OKHelicopter broke up in flight and fell in pieces in an open field. Weather was VMC and it was daylight. All 3 occupants were fatally injured. The breakup occurred while aircraft was in cruise flight.NTSB FTW82DA153Accident · No injuriesFinal reportJurca 3/4 Spitfire · Bartlesville, OKDuring initial climb on the first flight of the homebuilt aircraft, the engine failed. The aircraft was landed off the airport and demolished. Investigation revealed the fuel pump drive designed by the builder had failed.NTSB FTW82DA105Accident · No injuriesFinal reportPiper PA-28-180 · Norman, OKThe aircraft's engine quit 15 minutes short of the destination on a cross country flight. The aircraft had 36 gallons of fuel on departure at 1600 CST and the accident occurred at 1915. A forced landing was made on a street in Norman, Oklahoma.NTSB FTW82DA107Accident · No injuriesFinal reportBeech 95-B55 · Afton, OKDuring landing the aircraft bounced on the nose gear three times before the nose gear collapsed. The aircraft slid 60 yards on its nose and stopped midway down the runway.NTSB FTW82DA106Accident · Minor injuriesFinal reportPiper PA-28-235 · Tulsa, OKThe aircraft experienced a partial power loss during takeoff at an altitude of about 150 AGL. The pilot turned left with the intention of landing on a perpendicular taxiway. During the turn the aircraft developed a high sink-rate and struck the taxiway in a…NTSB FTW82DA098Accident · No injuriesFinal reportCessna 421C · Weatherford, OKBefore landing, the pilot observed that the wind sock was indicating a wind from 270 degrees. He stated that he tried to call UNICOM several times for wind information, but received no answer. After touchdown on runway 17, a strong gust of wind was…NTSB FTW82FPJ14Accident · 1 fatalFinal reportCessna 172N · Hulen, OKThe pilot departed lawton, Oklahoma at 0902 local time on a flight to inspect mineral property. At about 0931, the pilot contacted ft. sill approach control and requested vectors to lawton. He was instructed to fly a heading of 320 degrees. After flying that…NTSB FTW82IA095Incident · No injuriesIncident investigationFinal reportCessna 402C · Chickasha, OKA checkout was being performed with the PIC in the right seat and the trainee in the left seat. As power was increased for takeoff during a touch and go landing, the PIC heard the propellers strike the runway. The trainee lifted the aircraft off the ground,…NTSB FTW82FPM11Accident · 2 fatalFinal reportCessna 172 · Heavener, OKThe aircraft crashed at night on rising terrain about 300 ft below the crest of a hill. The nearest weather reporting station was at mcalester, OK. The weather at mcalester was 1200 ft overcast, visibility 7 miles, ceiling ragged. The mcalester field…NTSB FTW82DPM10Accident · Serious injuriesFinal reportCessna 140A · Wagoner, OKDuring a low pass over a river, the aircraft struck some power lines approximately 125 ft above the water level.NTSB FTW82DA070Accident · No injuriesFinal reportCessna 172 · Hennessey, OKThe pilot reported that he encountered a gust of wind as he was flaring with full flaps about two feet above the strip. He stated that the right wing was blown down (the tail moved to the left) and the right wing collided with a fence beside the airstrip. The…NTSB FTW82DA068Accident · No injuriesFinal reportCessna 172 · Kingfisher, OKThe student pilot stated he read the wind direction as coming from the south and landed accordingly. The aircraft landed downwind, the nose wheel dug in and collapsed, and the aircraft nosed over.NTSB FTW82FPM09Accident · Serious injuriesFinal reportCessna A188B · Muskogee, OKThe pilot made two passes to survey the field to be sprayed. He stated that on his third pass, he pulled up, made a shallow left turn, leveled off, and started looking to the right for obstructions. Reportedly, the aircraft started into a 10 degree dive at…NTSB FTW82FPJ12Accident · 2 fatalFinal reportBeech G35 · Stillwater, OKThe aircraft departed on a dark night with no record of a flight plan filed or a weather briefing received. Witnesses observed the aircraft climb out of sight into a fog layer when 2/3 down the runway then reappear and continue to fly at tree top level…NTSB FTW82FPJ11Accident · No injuriesFinal reportPiper PA-28R-201T · Watonga, OKThe pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…