NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 MIA86LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Brooksville, FLThe plt stated that the acft lost power on initial climb while practicing touch & go landings. The acft crashed .2 miles from the end of the rwy due to the fuel selector being positioned to the right tank, which did not contain enough fuel to return to the…NTSB FTW86LA084Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Pearland, TXThe plt was practicing touch & go landings at a local arpt. While making his apch, he undershot the rwy and the acft collided with a ravine. The plt reported that the airspeed was too slow and alt was too low. He continued to state that he should have made a…NTSB FTW86FA085Accident · 2 fatalField investigationFinal reportBell 206B · Pine Spring, TXThe helicopter was on a flt to a site nr guadalupe pass, an area known for erratic & gusty wnds. As the plt was on an apch to a hi meadow (elev aprx 5460'), the helicopter entered a dscnt & crashed well short of the intended lndg area. A witness rprtd the…NTSB CHI86LA140Accident · No injuriesLimited investigationFinal reportCessna 150F · Gaylord, MIOn rollout, while the plt was attempting to correct a drift to the right, the acft suddenly veered to the left and the nose gear collapsed. During the resulting slide, the aircraft began burning and was destroyed. The plt reported that the magnesium hub of…NTSB CHI86FEE03Accident · No injuriesFinal reportBeaupre Elfering Quickie · Waukegan, ILThe acft crash landed in a cultivated part of the arpt after the eng quit during takeoffs & landings. The acft climbed to about 400 ft AGL and started a turn when the eng stopped. The acft was glided to an alfalfa field on the arpt. The acft was damaged…NTSB ANC86FA055Accident · 1 fatalField investigationFinal reportEnstrom F28C · Turnagain, AKThe helicopter was observed flying along the highway at a low altitude and it then struck some high power transmission lines, fell to the ground and burned upon impact. The transmission lines were 283 feet above the road surface and spanned a distance of 1127…NTSB MKC86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ashby, NEThe plt stated that he and a passenger were sightseeing when he increased the mixture to full rich, applied carb heat and reduced power for a glide across a valley. When he advanced the throttle to level off the engine did not respond. During the forced…NTSB MKC86LA106Accident · No injuriesLimited investigationFinal reportCessna 188 · Lawrence, KSThe pilot stated that the right main tire rolled over sharp rocks and was subsequently destroyed during the takeoff roll. The pilot further stated that he apparently over corrected and drifted left, digging into a soft spot on the runway, and nosed over.NTSB MKC86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Louisburg, KSDuring a fly-by over a pvt airstrip owned by the plt, the acft contacted power lines bordering the south end of the airstrip which the plt stated he forgot about. The plt reported he failed to pull up during the over fly and flew under the power lines. The…NTSB MKC86FA103Accident · Serious injuriesField investigationFinal reportTaylorcraft BL-65 · Independence, MOThe pilot stated that they took off to the north with an intended southwest bound departure. After a left turn, while on the crosswind leg, and climbing through 800 feet, a blast of cold air and wind shear hit the aircraft, and the bottom fell out, according…NTSB MIA86LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Daytona Beach, FLFlt experienced engine failure while descending for landing. While approaching a field for a forced landing the aircraft struck electrical power lines and then crashed into the field. The engine was operated to full power after the accident with no evidence…NTSB DEN86LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAcft carburetor had been removed for maintenance and sign posted in acft to this effect. Student plt called to schedule acft and was put in another acft. Scheduler said plt was told acft was out of service but plt claimed he did not hear this. Plt met flt…NTSB SEA86LA123Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Sunnyside, WAAfter completing several touch and goes, the pilot lost control of the aircraft on landing rollout due to a light gusting crosswind. The pilot was unable to avoid departing the runway to the left striking a four foot embankment collapsing the nose gear.NTSB SEA86LA122Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Smiths Ferry, IDThe plt was returning to home base from a business flight on which he delivered parts to company personnel. The acft was observed flying down the north fork of the river at low altitude with its wings dipping. Aprx one mile after entering the canyon, the acft…NTSB NYC86LA124Accident · No injuriesLimited investigationFinal reportCessna 305A · Salem, NHThe Cessna 305, being used a tow plane for glider operations, ran through a fence at the departure end of the rwy during takeoff. The plt stated he experienced a wind shift during takeoff. He did not have a pre-decided point at which to either release the…NTSB NYC86LA123Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hallstead, PAThe airport is located in a valley between two rows of mountains on the ny/pa border. The plt had completed two takeoff and landings to a full stop at night for night currency. After takeoff and leveling off at 2,000 feet MSL and downwind for a left base to…NTSB NYC86FGM02Accident · Minor injuriesFinal reportContinental Copters OH13H Tomcat Mark 5A · Indiana, PAThe acft collided with wires during a spray run and crashed out of control. The plt tried to fly under the wires that were sighted too late to clear. During his survey of the field the plt had failed to see the wires that were struck. The collision broke off…NTSB NYC86FA127Accident · 1 fatalField investigationFinal reportRobinson R-22A · East Fishkill, NYA loss of control in flight for undetermined reasons.NTSB MKC86LA102Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Almyra, ARThe plt stated that the landing was routine until he used the brakes. At this point the left wheel brake assembly came apart and the acft veered out of control off the right side of the rwy and into a ditch, where the left main landing gear collapsed. Post…NTSB MIA86LA153Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Clearwater, FLWhile attempting to land at an arpt at night without the use of rwy lights, the acft touched down to the right side of the rwy on the grass. The acft then collided with the VASI lights, the landing gear was severed, & the acft slid to a stop.NTSB LAX86LA215Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Angels Camp, CANumerous ground witnesses observed the aircraft fly low along the river which fed into the new melonies reservoir lake and then collide with unmarked high tension power lines which spanned a narrow portion of the lake. The pilot thought the aircraft was at…NTSB DEN86LA133Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Walsh, COThe plt reports that he was landing to the south on the turf rwy with calm winds when the accident occurred. He said the landing was normal until the acft slowed to 40 to 50 mph at which time a whirlwind was encountered which lifted the right wing. The left…NTSB DEN86FA131Accident · 1 fatalField investigationFinal reportPiper PA-28B-140 · Salt Lake City, UTPlt and pax departed slc at 0930 for sightseeing cross country trip to heber city and return. Plt said plan was to fly through lambs canyon and parley's canyon. Acft hit tree and crashed at 8040 ft MSL level in lambs canyon at approximately 0955. Terrain…NTSB CHI86LA139Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Plainwell, MIWhile departing to the north in light wind conditions, the pilot made a decision to abort the takeoff, then realized he would not be able to stop on the remaining runway. He attempted to continue the takeoff. He zoomed the aircraft to clear wires in his path,…NTSB CHI86LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Webster, WIDuring an attempted go-around after a bounced crosswind landing, pilot failed to maintain a proper ground track and the aircraft collided with trees.NTSB BFO86FID08Accident · 1 fatalFinal reportMilliken Gyrocopter B-80 · Suffolk, VAAccording to a plt witness the accident plt was attempting to compensate for an increase in wind velocity when the accident occurred. The witness stated the plt entered a steep dive to compensate for the increase lift followed by the gyrocopter ballooning due…NTSB ATL86FA126Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ludlow, PAAn acft fitting the description of the acdt acft was observed entering the lake arm about 7 1/2 mi n of the acdt site. The acft was observed to pull up to clear pwr lines across the lake arm about 2 1/2 mi n of the acdt site. The acft was observed to fly into…NTSB MKC86FPG03Accident · Serious injuriesFinal reportSchweizer Grumman G-164B · Harrisburg, ARThe plt reported that while spraying a fld with propanil and penoxalin the wind shifted from the southeast to the northeast allowing the chemicals to cover the windshield thus reducing the plt's forward vision. This in combination with sun glare, resulted in…NTSB MKC86FA101Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Grand Island, NEThe twin eng acft crashed and burned 4 miles north of the arpt while on an instrument apch. The plt had transmitted that he had an engine problem. The #5 cylinder was found detached from the left engine but the left propeller was not feathered. An engine…NTSB MIA86LA156Accident · No injuriesLimited investigationFinal reportCessna T210N · Destin, FLThe plt stated that the acft swerved to the left uncontrollably after he applied the brakes during the landing roll. The nose gear then collapsed and the acft slid off the rwy. Investigation revealed no preexisting mechanical malfunction.NTSB MIA86LA152Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Panama City, FLWhile approaching to land during a sightseeing flt a loss of eng pwr was experienced and an autorotation was made 70 ft short of the helipad. During touchdown, the main rotor struck and severed the tail boom. The plt stated after touchdown the eng continued…NTSB LAX86LA216Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Riverside, CAThe CFI reported that during the landing roll on runway 24, at fla-bob airport, Riverside, CA, the airplane began to 'drift to the right.' The CFI applied left rudder to correct the excursion but his left foot slipped off the rudder bar and became lodged…NTSB LAX86LA214Accident · Serious injuriesLimited investigationFinal reportMBB BO-105S · La Jolla, CAThe pilot lost control of the helicopter's rotor system during the initial climb phase of the flight. The aircraft spun out of control and crashed on an interstate highway. Company maint applied AD-85-26-02 to detect or prevent jamming of rotorcraft controls…NTSB LAX86LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Crescent City, CAThe pilot reported due to severe turbulence he decided to land long. Upon realizing that the airplane was too high he added full flaps. Shortly after touchdown the plt began to lose control of the airplane and elected to takeoff. During the initial climb the…NTSB FTW86LA088Accident · No injuriesLimited investigationFinal reportCessna 337D · Edinberg, TXThe pilot stated he lost both engines while in cruise flight. However, no evidence of engine malfunction was found during the investigation. The pilot is under investigation for illegal drug trafficking. A dea agent suspects the pilot had unloaded his cargo…NTSB FTW86LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Tyler, TXThe pilot failed to flare the aircraft before touchdown, causing the aircraft to bounce and assume a nose down attitude, before it impacted the ground, although the pilot states he lost directional control due to locked controls, investigation did not reveal…NTSB DEN86LA130Accident · No injuriesLimited investigationFinal reportCessna A188B · Berino, NMThe pilot reports that he was taking off on his third aerial app flt of the day. He said the wind was from the nw and very light and he was departing to the n. the density alt was calculated to be 5,200 ft. acceleration seemed to be normal until about two…NTSB NYC86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Otselic, NYThe Cessna 182P was cruising at 2500 ft when it experienced an engine failure. The pilot made a landing in a plowed field across the furrows. The nose wheel broke off on landing and the aircraft flipped over. The pilot received minor injuries while the…NTSB NYC86LA121Accident · Minor injuriesLimited investigationFinal reportCessna T337HPII · Newburg, PAThe Cessna 337P experienced fuel exhaustion and attempted a landing on a road. During the landing the aircraft struck telephone poles and received substantial damage. The pilot did not receive any injuries in the accident which occurred in visual…NTSB MIA86LA151Accident · No injuriesLimited investigationFinal reportCessna T188C · Shaw, MSThe plt stated that shortly after takeoff he noticed the fuel cap was loose. He then turned downwind to land, at which time the aircraft stalled, resulting in the right wing colliding with trees.NTSB MIA86LA150Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Shelby, MSAfter departure while making a turn the pilot reported the engine lost power and the aircraft settled into the trees. There was no evidence of a preexisting mechanical failure/malfunction.NTSB FTW86FA079Accident · 6 fatalField investigationFinal reportCessna 411A · Bossier City, LAThe pilot reportedly did an unusual amount of engine run-up before pulling onto the runway. He then performed another run-up before departing. This is evidence that he was aware of a problem with his aircraft. The engine(s) were popping and puffing black…NTSB DEN86FA128Accident · 1 fatalField investigationFinal reportSwearingen SA226AT · Billings, MTWhile on an IFR flt plan in IMC, the plt executed a missed approach after flying a localizer back course 27 approach. During a subsequent ILS rwy 09L approach, radio and radar contact with the acft was lost lost. The acft wreckage was located on the inbound…NTSB ATL86LMG07Incident · No injuriesFinal reportBell UH-1B · Wrightsville, NCThe plt reported that he was about to descend from a high hover to land in an open field adjacent to a hotel parking lot when the tips of both main rotor blades contacted a light pole. The plt maneuvered away from the pole and landed in the open field.…NTSB SEA86LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakima, WADuring rollout on the third touch & go landing the student had control of the acft. While preparing for a downwind takeoff the acft drifted across the rwy and into a grass area. The instructor was unable to regain directional control. The acft contacted a…NTSB MIA86LA258Accident · Minor injuriesLimited investigationFinal reportBrewster Fleet 7 · Arcadia, FLAccording to statements, the pilot experienced brake difficulty & the acft flipped over during landing rollout & came to rest inverted.NTSB MIA86LA149Accident · Minor injuriesLimited investigationFinal reportLearjet 24 · Hollywood, FLThe plt stated he made a normal apch and landing but on rollout discovered he had no brakes. The acft traveled off the left side of the rwy and collided with a fence surrounding a ballpark. Post crash examination of the hydraulic system revealed that the…NTSB LAX86FVG04Accident · No injuriesFinal reportGrumman G-164 · Butte City, CAThe acft made a forced landing off arpt after a power loss during takeoff. The operator stated that water was found in the fuel system.NTSB FTW86IA078Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Dallas/Ftw Apt, TXThe crew stated that during an attempted start the no. 1 eng failed to gain ignition during the prescribed 25 sec limit and that they aborted the start. Shortly thereafter, grnd pers reported that the eng had developed a tail pipe fire. Following emerg…NTSB DEN86MA129Accident · 6 fatalMajor investigationFinal reportGulfstream 690D · Price, UTAt 1042 MDT, the flt rprtd mod turbc at FL 240, but elected to remain at that alt. At 1055, they were clrd to dscnd at plt's descretion to maint 12,000'. Aprx 8 min later, shortly after bgng a dscnt, the flt was instructed to chg freq; BUT21 secs later, they…