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 FTW85LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bartlesville, OKAfter one uneventful full-stop landing the plt re-entered the pattern for a second landing. The plt truned to final at about 500 ft AGL and 65-70 KTS with the rwy lights in sight. Shortly thereafter, according to the plt, the landing light illuminated two…NTSB FTW85FA131Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Stigler, OKThe plt filed a VFR flt plan after the wx improved from IFR to VFR with a chance of thunderstorms en route. Ocnl mod turbulence below 5000 ft was forcast due to strong/gusty low lvl wnds. While the acft was en route, a gnd witness heard the engs rev up more…NTSB FTW85LA129Accident · No injuriesLimited investigationFinal reportRotorway Exec · Bethany, OKThe owner/builder had a single engine, multi-engine, land rating, but did not have a helicopter rating. While practicing hover flt in his experimental helicopter, he unexpectedly allowed the helicopter to reach a higher than normal alt. He attempted to…NTSB FTW85LA126Accident · No injuriesLimited investigationFinal reportCessna 150J · Broken Bow, OKThe acft nosed over short of the rwy while the plt was making an emergency landing after a reported power loss. During the landing, the acft nosed over & was damaged. No reason for the power loss was found.NTSB FTW85LA127Accident · Serious injuriesLimited investigationFinal reportThorpe T-18 · Ada, OKThe aircraft had been stored for 8 months with automotive fuel in the tank. During takeoff, the eng lost power. Subsequently, the plt lost control & the acft impacted the ground at a 45 deg angle. An investigation revealed that softened tank sealant material…NTSB FTW85FA117Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300 · Healdton, OKThe acft collided at 4,500 ft MSL within aprx 15 degrees of head-on. VMC with 30 mi visibility existed with plt reported winds aloft as being light from the west. En route recorded data indicated that N39516 was on a true course of 180 deg and N1162N was on a…NTSB FTW85LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hobart, OKAt 1515 CST, the plt contacted a fss & was advised that a front would be moving thru the destination (Hobart) area at about 2200. When he departed stillwater at 1840, the wind was from the south. At 2004, the plt contacted altus afb & was advised that the…NTSB FTW85FA112Accident · 2 fatalField investigationFinal reportCessna 402B · Altus, OKDuring an eng start, prior to the flt, the l eng backfired 2 or 3 times. A witness described the 1st backfired as 'the loudest I have ever heard.' When the acft took off, two persons living near the departure end of the rwy noted that the acft (believed to be…NTSB FTW85LA092Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Oklahoma City, OKThe plt-in-command (PIC) reported that after touchdown, the spoilers & brakes were applied, but no braking action was felt although peddle pressure was evident. He stated that by the time it was clear that the brakes were ineffective,insufficient rwy remained…NTSB FTW85LA073Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe acft experienced a power failure while in cruise flight at 1100 ft AGL. He stated that after switching tanks, the 'engine started twice bit failed to continue'. Investigation revealed that the left fuel tank was empty and the right tank had an…NTSB FTW85LA074Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe acft collided with power lines during a recovery from a practice autorotational landing. The instructor plt took control of the acft for recovery and did not see the wires.NTSB FTW85LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKAfter touchdown flaps were raised and power added to takeoff during the touch-&-go landing. The solo student pilot was unable to maintain birectional control of the acft and it went off the left side of the asphalt rwy. The acft nosed overafter colliding with…NTSB FTW85FA061Accident · No injuriesField investigationFinal reportCessna T303 · Seminole, OKExperiencing a power loss on the right engine on takeoff from a touch & go landing. The pilot was forced to land off the runway. The aircraft rolled into a gully sustaining substantial damage. The malfunction could not be reproduced during subsequent…NTSB FTW85FA343Accident · 1 fatalField investigationFinal reportMooney M20J · Bethel, OKDespite a wx brief discouraging VFR flt the non-instrument rated plt departed at about 1330 CST. His stated dest was ft. worth, TX which is due north. After takeoff in VMC the acft flew NE toward an unknown dest. A wx study indicated conditions along the…NTSB FTW85LA057Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newcastle, OKOn simulated emerg landing, instructor evaluated approach as unsalvagable & at 1700 ft AGL told student to execute go-around. Student had allowed airspeed to decay in an effort to stretch glide. Student raised flaps & did not add pwr. As acft settled,…NTSB FTW85FA041Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Fairview, OKThe acft was engaged in performing at an air show when recovery from a left aileron roll at aprx 300 ft AGL was completed to an upright attitude, however, the acft nose dropped and the acft turned 45 degrees to the right of the rwy heading. It then impacted…NTSB FTW85FA034Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · El Reno, OKThe acft was destroyed on impact with the ground after being observed by ground witnesses to go out of control during anaerobatic maneuver. There was a difference of opinions as to what happened. One witness described the ground collision having been from an…NTSB FTW85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hinton, OKDuring takeoff on an instructional flt with a CFI aboard, the acft struck a grain wagon. The CFI stated that on takeoff, the student lifted off prematurely and the acft struck the parked vehicle. The CFI took no corrective action.NTSB FTW85IA028Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Tulsa, OKDuring cruise, the crew experienced a loss of hydraulic pressure & smoke in the cockpit, then donned their oxygen masks. They used the emerg gear extension system & made a safe emerg landing. An exam revealed a cracked 2000 PSI aluminum hydraulic line had…NTSB FTW85LA016Accident · No injuriesLimited investigationFinal reportCessna 172P · Stillwater, OKPilot had returned to his home airport after aborting a business flight due to weather. After landing, the pilot was taxiing from the active runway when the aircraft flipped inverted due to strong gusting winds. The wind was reported by the pilot to be…NTSB FTW85FA010Accident · 2 fatalField investigationFinal reportRockwell 695A · Checotah, OKThe pilot allowed the aircraft to stall at an altitude which was too low to effect recovery before ground impact occurred. He was in the process of performing VMC test and maximum performance single engine climbs during the test flight. Witness description of…NTSB FTW85LA008Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Waurika, OKAccording to witnesses, the acft nose was too low at water contact on lndg touchdown and the nose and right pontoon dug into the water. The acft swerved abruptly to the right, flipped inverted and sank. No logs or other floating debris were located during a…NTSB FTW84FA408Accident · 2 fatalField investigationFinal reportCessna 172P · Webbers Falls, OKAcft struck electrical transmission line 80' above water while flying under the line during a wildlife survey. The acft's mission was to conduct a duck count along a river in a nat'l wildlife refuge which required low, slow maneuvering. The ex-ag pilot was…NTSB FTW84LA406Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sand Springs, OKAcft was on final apch to land on return leg of x-country when eng began running rough and subsequently quit. Acft contacted trees short of the rwy. Plt stated a ttl of 5 gallons of fuel were drained from both fuel tanks collectively after the accident.…NTSB FTW84LA386Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Altus, OKAccording to the plt, with full flaps extended the acft encountered a windshear during the flare causing an excessive rate of descent on touchdown. Rwy contact collapsed the left main landing gear allowing the left wing to scrape on the rwy. Shortly before…NTSB FTW84LA385Accident · No injuriesLimited investigationFinal reportCessna A188B · Maysville, OKWith aprx 300 ft of rwy remaining the plt rotated. The acft flew to about 15 ft before it settled back to the ground at the end of the sod strip. After rolling through 2 fences the acft collided with a dirt bank next to a ditch collapsing the main gear. The…NTSB FTW84LA373Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethany, OKAccording to the plt of N9646H, while he was taxiing under the direction of ground control the acft was struck from behind by N1PN. The plt of N1PN stated that he was cleared to taxi and did not see any other acft as he entered the taxiway. Seated in the rear…NTSB FTW84LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKPlt lost control after a hard, right-wind-down landing. Acft porpoised, collapsing the nose gear and came to rest nose down.NTSB FTW84LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tahlequah, OKLaw enforcement officers responding to the acft accident found the acft inverted beyond the south end of the runway. Plt stated he and his passengers had been drinking beer and decided to go flying. Plt's statements to officers are not clear on exact events…NTSB FTW84FA344Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Reed, OKArpt manager reported preflight discussion with plt concerning weather to south (intended direction of flight) but plt stated he didn't think there would be any trouble. Mgr observed acft takeoff and disappear into clouds to the south. Witnesses reported…NTSB FTW84FA342Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Tulsa, OKOn climbout from a night takeoff, a complete power loss occurred. The plt attempted to return to the airport, but insufficient altitude was available. During an ensuing forced landing, the acft collided with trees before ground impact. An investigation…NTSB FTW84LA340Accident · No injuriesLimited investigationFinal reportCessna 150F · Walters, OKPlt took the acft without authorization and attempted a landing in an open field near his passenger's home. The terrain was soft and unsuitable for acft operations, acft right wing contacted the ground during lndg roll, damaging the wing attach point. Plt…NTSB FTW84LA325Accident · Minor injuriesLimited investigationFinal reportBell 47J · Grove, OKThe plt stated that yaw control was lost during climb out for a local flt with two passengers onboard. The acft began torotate to the right and the antitorque pedals were ineffective. They were over buildings at the time so the plt held a minimum descent…NTSB FTW84LA307Accident · No injuriesLimited investigationFinal reportCessna 152 · Eufaula, OKWhile taxing from landing the plt was watching the clearance on the left side of the acft and the right wing contacted an unmarked utility pole.NTSB FTW84LA309Accident · No injuriesLimited investigationFinal reportBeech C-45-H · Mcalester, OKAbout 40 miles from Mcalester arpt, the lt eng lost pwr & was shutdown. While attempting a precautionary ldg at the arptthe rt eng lost all pwr. While making an emergency descent the plt attempted to stretch the glide. The acft collided with trees 300 ft…NTSB FTW84LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Washington, OKThe plt reported that after he had landed & decelerated almost to taxi speed, the nose gear dug into soft terrain as he was turning off the landing area. The acft then slowly nosed over.NTSB FTW84FA291Accident · 2 fatalField investigationFinal reportCessna 152 · Minco, OKThe student plt had rented the acft. Records showed that he had flown this acft on previous occasions. The plt acting as instructor did not possess a current instructor certificate. There were no witnesses to the crash, but the acft was observed maneuvering…NTSB FTW84LA284Accident · No injuriesLimited investigationFinal reportGriffin Trane Starduster TOO · Oklahoma City, OKAcft touched down hard after 4 unsuccessful landing attempts at stroud, OK. Plt added full pwr and returned to Oklahoma City suspecting gear damage. Visual check by another acft revealed no apparent gear damage. Upon touchdown at expressway airpark, the main…NTSB FTW84LA283Accident · No injuriesLimited investigationFinal reportHughes 369HS · Oklahoma City, OKWhile performing a practice autorotation plt failed to bring in power in time to arrest the high rate of descent. The helicopter touched down hard and the main rotor blades flexed downward striking the tail boom and severing it. The plt stated his failure to…NTSB FTW84LA278Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Spiro, OKThe plt stated that while landing in an alfalfa field, he made the approach at a higher than normal speed. Subsequently, the acft overran the alfalfa field & went into a plowed field where it nosed over.NTSB FTW84FA272Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Lone Wolf, OKWitnesses reported that the plt made a low pass by each of his 2 sons who were operating combines in a wheat field. After making the low passes, he pulled up in a steep climb. The acft then entered a steep descent & crashed. An exam of the wreckage revealed…NTSB FTW84FU007Accident · Serious injuriesFinal reportWeedhopper B · Spencer, OKThe airman took off on a windy day and began to have difficulty controling his vehicle. This vehicle had a 34 ft soaring wing with no ailerons. The pilot decided to land and wait for better flying conditions. During the landing, a wing dropped and before the…NTSB FTW84LA257Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Ripley, OKAcft contacted three unmarked transmission power lines which crossed the cimarron river. The plt was flying over the river trying to locate a field which was to be sprayed. The acft then crashed on nearby river bed.NTSB FTW84FA258Accident · 1 fatalField investigationFinal reportCessna 152 · Fairview, OKThe acft had inflt structural failure and separation of some components and crashed in an inverted flat spin parts of the wing and aileron were never found. Some parts were found about 1/2 mile from the primary impact point. An autopsy onthe plt revealed the…NTSB FTW84LA256Accident · 1 fatalLimited investigationFinal reportPiper PA-36-375 · Hominy, OKThe acft collided with a radio tower guy wire while the plt was en route to reload. During the collision, the right wing was sheared off & the acft crashed to the ground & burned. The radio tower was located about 1 mi from the arpt.NTSB FTW84LA255Accident · No injuriesLimited investigationFinal reportAmerican Aerolights Eagle 2 · Goldsby, OKThe plt of the 2 place ultralight, N951AA, & the plt of another ultralight were en route from tuttle to goldspy, OK. While flying low over a wheat filfed, the plt of the other ultralight inadvertently flew into the crop. The plt of N951AA witnessed the…NTSB FTW84LA250Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Arnett, OKAccording to the plt, the wx for his route of flt was forcast to remain VFR. En route, ceilings at 4000 to 5000 ft MSL were encountered in the vicinity of hobart, OK. As the flt continued the wx deteriorated. In order to maintain VFR conditions, the…NTSB FTW84FA242Accident · 1 fatalField investigationFinal reportBeech BE35G · Wewoka, OKThe plt was not current in IMC operations nor was the acft certified for instrument lft. After obtaining a wx briefing which forecast a chance of thunderstorms along his route, the plt departed on a x-country. En route the plt contacted Oklahoma city efas and…NTSB FTW84LA241Accident · No injuriesLimited investigationFinal reportCessna 172P · Stillwater, OKPlt stated the acft nose raised up before takeoff speed had been reached. Control of the acft was lost and it descended into a field aprx 500 ft off the end of the rwy in an area of unimproved terrain. Plt later reported the elevator trim was set in the full…NTSB FTW84FA237Accident · 1 fatalField investigationFinal reportBeech G35 · Tulsa, OKA witness stated it appeared as though the plt was attempting to perform a precautionary landing on a highway. As the acft reached the highway, the witness heard the engine accelerate to 'full power' and saw the acft pull up. The acft contacted the top static…