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.

NTSB FTW86FA027Accident · 2 fatalField investigationFinal reportCessna 172B · Caddo Mills, TXMid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was…Dec 28, 1985 · N6876X · 2 aircraft · DestroyedNTSB DEN86LA055Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NMAccording to the plt, he was attempting to depart from a pvt grass strip, which is located on a plateau at an elev of aprx 6,400 MSL. The grass strip, which is aprx 3,000 ft in length, has an upslope of about 10% for the first half and a downslope at about…Dec 28, 1985 · N4849V · Substantial damageNTSB CHI86LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glidden, WIThe aircraft collided with powerlines while attempting a power off landing after engine stoppage. The fuel tanks were inspected and there was no fuel in the right tanks and only a small quantity in the lft tank. The engine was tested and found to function…Dec 28, 1985 · N8687S · Substantial damageNTSB SEA86LA031Accident · No injuriesLimited investigationFinal reportCessna 402B · Spokane, WAThe plt reported encountering icing conditions during his apch to Spokane. Upon arrival, the acft remained at Spokane for 30-40 minutes during which freezing drizzle and below freezing temps existed prior to and during the departure. The plt did not utilize…Dec 27, 1985 · N4624N · Substantial damageNTSB MKC86LA041Accident · No injuriesLimited investigationFinal reportBeech M35 · Council Bluffs, IAThe acft made a gear-up forced lndg off the arpt after a loss of power during a business flt. The acft had only been airborne for about 15 minutes. Post accident investigation discovered that the acft fuel was contaminated with water.Dec 27, 1985 · N9730R · Substantial damageNTSB ANC86LA021Accident · No injuriesLimited investigationFinal reportCessna 180 · Homer, AKThe plt stated, during a touch and go landing he lost directional control of the acft and a ground loop resulted.Dec 27, 1985 · N3186D · Substantial damageNTSB NYC86LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mttituck, NYPilot states on landing flair the aircraft was tracking on a 190 degree heading for rwy 29 winds were from 260 pt 20 KTS on flair acft drifted approx 16 ft to the left and left wide extended beyond rwy making contact with shrubbry on the edge of the rwy. Acft…Dec 26, 1985 · N9409W · Substantial damageNTSB LAX86LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34T-22OT · Tucson, AZDuring a trans border VFR x-country flt, the plt noticed 'oil spirting from the left engine' with smoke, & he shut it down. An emergency was declared by the Tucson ATCT, who cleared the acft to land straight in on rwy 29L. Tower personnel observed the acft…Dec 26, 1985 · XBDRL · Substantial damageNTSB FTW86LPJ04Accident · No injuriesFinal reportCessna 150F · Tulsa, OKThe acft nosed over during a forced landing following a loss of pwr. The plt stated 'quite abit' of water was drained from the fuel system during preflight. Aprx 10 to 15 minutes after takeoff the eng began to sputter and eventually quit. The nose wheel…Dec 26, 1985 · N8535G · Substantial damageNTSB FTW86FRG10Accident · Minor injuriesFinal reportMooney M20C · San Antonio, TXThe acft was destroyed during a forced landing. While en route over the San Antonio area the plt noticed a few drops of what he believed to be precipitation on the windshield. Shortly thereafter, it was determined the drops on the windshield were oil. The…Dec 26, 1985 · N7025V · DestroyedNTSB ATL86LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kings Mountain, NCThe acft had been moored on an open ramp in extremely cold tempertures. During preflight the plt found that the fuel strainer drain would not close and one wing tank drain would not open. A mechanic attempted to repair the leaking strainer but could not stop…Dec 26, 1985 · N7300A · Substantial damageNTSB DEN86FA054Accident · 1 fatalField investigationFinal reportBell 206-L3 · Monument Valley, UTThe helicopter contacted power lines and the terrain during an attempted takeoff from a hospital after a cancelled med-evac flt. The hospital is located in a box canyon surrounded by high terrain and power lines. The plt was aware of the power line that…Dec 25, 1985 · N10UB · DestroyedNTSB LAX86MA074Accident · 7 fatalMajor investigationFinal reportBeech 95-A55 · Concord, CADrg arr, the acft was vectored for an lda rwy 19R apch. After being clrd for the apch, the plt was advised that radar svc was terminated & told to contact the twr. At 2033 PST, he rprtd inbnd at the final apch fix & was clrd for the apch. Aprx 2 min later, he…Dec 24, 1985 · N1494G · DestroyedNTSB FTW86FRG09Accident · Serious injuriesFinal reportRobinson R22 HT · Sonora, TXThe helicopter contacted the terrain in an uncontrolled descent after colliding with power lines during a climbing turn to the west. The plt reported he could not see the power lines because of glare from the setting sun.Dec 23, 1985 · N9074U · Substantial damageNTSB DEN86LA052Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA-1A Yankee · Cloudcroft, NMThe plt stated that he was following a highway from alamogordo, NM to roswell, NM. The plt continued to state that the highway lead him into an area of high terrain that his acft could not climb over. The plt was unable to turn around and executed an emerg…Dec 23, 1985 · N9201L · Substantial damageNTSB ANC86FA020Accident · 2 fatalField investigationFinal reportCessna 182 · Lake Clark Pass, AKThe acft collided with rising terrain while maneuvering in a mountain Pass. Low ceilings, 40 to 50 kt winds and rain showers were reported in the area at the time of the accident.Dec 23, 1985 · N5009D · DestroyedNTSB MIA86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe instructor pilot simulated an engine failure after takeoff. The student pilot failed to lower the airplane nose to maintain flying speed. The instructor took over the controls and lowered the nose, but was unable to avert the hard landing and ensuing…Dec 22, 1985 · N2569L · Substantial damageNTSB LAX86LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAThe student plt & his CFI successfully performed 8 landings. On final apch to the 9'TH ldg the acft was low & the CFI delayed in directing his student to increase eng pwr. The student responded but the acft did not gain alt soon enough to avoid colliding with…Dec 22, 1985 · N714GG · Substantial damageNTSB DEN86LTM01Accident · Serious injuriesFinal reportCessna 172 · Brigham City, UTThe acft contacted mountainous terrain during a descent through fog. The plt stated that on the return flt from malad, ID, he began following a mountain range which he believed would take him back to ogden. However, the range guided him southwest of the…Dec 22, 1985 · N64005 · DestroyedNTSB DEN86LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Anthony, NMThe plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…Dec 22, 1985 · N7451T · Substantial damageNTSB CHI86MA052Accident · 6 fatalMajor investigationFinal reportCessna 177B · Brooklyn, MIThe pilot took off with five passengers approximately 170 pounds over maximum allowable gross weight into known moderate icing conditions. His aircraft was not equipped to fly in these conditions. Radio and radar contact were lost at approximately 3500 feet…Dec 22, 1985 · N34046 · DestroyedNTSB BFO86LA010Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDAfter landing at the bay bridge airport, the CFI got out of the aircraft and told the student-pilot to take it around the pattern. The aircraft was taxied to runway 28 and while waiting for other traffic to depart the CFI called over UNICOM that the landing…Dec 22, 1985 · N6147Q · DestroyedNTSB ATL86LA047Accident · No injuriesLimited investigationFinal reportCessna 177RG · Atlanta, GAThe aircraft landed hard resulting in substantial damage to the aircraft. This was following a final approach which was flown high and fast. The aircraft was observed to stall approximatel 10 ft above the runway and land on the nose gear.Dec 22, 1985 · N1603H · Substantial damageNTSB ANC86LA019Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Anchorage, AKThe pilot stated that during the touch and to landing, the aircraft stalled approximately 20 feet in the air. The pilot was trying the slow the aircraft down for a short field landing when it stalled.Dec 22, 1985 · N9533S · Substantial damageNTSB NYC86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rochester, NYThe acft contacted the terrain following a loss of control during an attempted go-around.Dec 21, 1985 · N98240 · Substantial damageNTSB NYC86LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bristol, CTThe acft was on a return flight back to teterboro when an eng failure occurred for unknown reasons. The plt requested vectors to the nearest arpt which was robertson but he was not able to reach it. A forced landing resulted in an open fld during which the…Dec 21, 1985 · N61260 · Substantial damageNTSB MKC86LA038Accident · No injuriesLimited investigationFinal reportCessna 140 · Coy, ARThe pilot reports that the engine of N3587V was run at idle for an extended time before the takeoff was attempted. After several minutes, the engine died. It was restarted and the takeoff was commenced immediately. According to the pilot, the engine was…Dec 21, 1985 · N3587V · Substantial damageNTSB MKC86FA037Accident · 3 fatalField investigationFinal reportBell 206L · Ainsworth, NEThis med-evac helicopter was being positioned to pick up a patient. The plt obtained a wx briefing which included a forecast for a chance of marginal VMC along the planned route, although at the time of the briefing the dest weather was VMC. The flt departed…Dec 21, 1985 · N110LG · DestroyedNTSB FTW86LRG08Accident · No injuriesFinal reportRobinson R-22HP · Pflugerville, TXThe helicopter rolled over when the right skid contacted the ground during a hover. The plt stated he had landed to and opened the door to check the skid position. After takeoff while in a hover at 2 ft AGL, the door popped open. The right skid contacted the…Dec 21, 1985 · N8358C · Substantial damageNTSB FTW86FA026Accident · 1 fatalField investigationFinal reportCessna 150E · Shawnee, OKThe unlicensed plt was conducting an unauthorized flt when the accident occurred. The plt took off from a sod fld adjacent to a closed rwy at Shawnee, OK. Witnesses stated that the acft assumed an excessively nose high attitude immediately after takeoff and…Dec 21, 1985 · N4066U · DestroyedNTSB ATL86LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mendenhall, MSThe plt stated that the acft collided with a tree while he was making a low pass over his father's home. The plt said his attention was diverted while making a left turn and the acft descended into the tree.Dec 21, 1985 · N6712G · Substantial damageNTSB MKC86FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Kansas City, MOThe plt was seen to enter the acft for a short time and then get out, go to the front of the acft and pull down on the prop. The eng fired and the prop struck the pilot's head. A plt who approached the acft moments after the acdt looked into the cockpit and…Dec 20, 1985 · N761YS · No damageNTSB FTW86FPA10Accident · No injuriesFinal reportBell BH206L-1 · Hurst, TXThe instructor plt was demonstrating an autorotation from the 'top of the height-velocity' curve. The CFI zeroed the airspeed and entered the autorotation at an alt of aprx 400 ft AGL. The acft touched down hard, spreading the skids, severing the tail boom…Dec 20, 1985 · N1069Q · Substantial damageNTSB DEN86LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COAccording to the student plt he made a normal apch to landing. The runway had not been cleared of snow to its full width. The acft's left wheel touched the snow pulling the acft off the rwy and the acft flipped over.Dec 20, 1985 · N7609F · Substantial damageNTSB CHI86LA051Accident · No injuriesLimited investigationFinal reportFairchild SA226TC · Cleveland, OHThe crew obtained visual contact with the rw evironment 100 ft above dh. During the landing roll the a/c traveled along the left edge of the runway until it collided with a snow bank. The runway was covered with patches of ice and packed snow.Dec 20, 1985 · N334BA · Substantial damageNTSB CHI86FEM03Accident · 1 fatalFinal reportRobinson R22A · Grand Rapids, MIThe plt reported he flew into the wolverine power plant for the purpose of picking up a passenger to whom he was to demonstrate the helicopter's ability to survey power lines. He continued to report, shortly after landing during normal engine shut down…Dec 20, 1985 · N8488H · Substantial damageNTSB ATL86LA045Accident · No injuriesLimited investigationFinal reportCessna C-172M · Andalusia, ALThe acft battery power was depleted. The plt hand propped the engine with his wife at the controls. The engine started with the throttle advanced and acft taxied into trees and over an embankment. The wife was not a rated pilot.Dec 20, 1985 · N509R · Substantial damageNTSB ANC86LA018Accident · No injuriesLimited investigationFinal reportCessna 185 · Aleknagik, AKThe pilot stated that on landing at a frozen lake he lost control of the aircraft causing the plane to ground loop. The aircraft then struck a snow bank on the beach.Dec 20, 1985 · N4520F · Substantial damageNTSB MIA86LA046Accident · No injuriesLimited investigationFinal reportBeech C-18S · Deland, FLThe pilot in the right seat was making his first landing in that make and model of aircraft. During the landing roll he tried to raise the wing flaps lever. Instead, he raised the landing gear lever causing the landing gear to retract.Dec 19, 1985 · N64463 · Substantial damageNTSB LAX86LA072Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Tucson, AZAfter about a 45 min wait as the number one acft for departure, the controller informed the plt that he could expect an additional 3 min wait because of wake turbulence from a (large) EC-130 acft which was approaching for a touch & go landing. The plt elected…Dec 19, 1985 · N10882 · Substantial damageNTSB LAX86LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Arbuckle, CAThe 35-HR student plt was authorized to fly on a solo instructional flight to the colusa county arpt. But, for 'personal reasons' the student disobeyed his CFI & landed at an uncharted, gravel, private airstrip. During landing roll out the student failed to…Dec 19, 1985 · N4946H · Substantial damageNTSB LAX86LA070Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Moss, CAAfter starting a left climbing turn at the end of a spray run the plt said he felt a 'shudder in the airframe' as the engine 'went to full RPM.' The plt stated that he thought 'the clutch had slipped' and added collective to compensate. The helicopter began…Dec 19, 1985 · N8404E · Substantial damageNTSB LAX86FVM01Accident · No injuriesFinal reportPitts Special G-1 · Salinas, CAOn December 19, 1985, an experimental Pitts-special, N14JD, owned and operated by the owner crashed under unknown circumstances near Salinas, California. The pilot survived but the aircraft was not recovered. The pilot stated that he had an unknown flight…Dec 19, 1985 · N14JD · DestroyedNTSB LAX86FA069Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Newport Beach, CAThe plt contacted coast TRACON (terminal radar control) & requested VFR traffic advisories to torrence. At aprx 0747 psthe declared an emergency, said the eng had quit & requested vectors to the john wayne/orange county arpt. The controllerprovided a hdg to…Dec 19, 1985 · N9044P · DestroyedNTSB DEN86LA049Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Bountiful, UTAccording to the plt, he and three friends were en route to a local ski resort, when the helicopter encountered deteriorating wx. The plt stated he elected to cross the ridge and fly down a ravine to maintain visual reference. The plt said he was aware of…Dec 19, 1985 · N184FH · DestroyedNTSB MIA86LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Lake City, FLThe plt stated that after a forced landing in a field due to a stuck fuel selector valve, the fuel selector was repaired and a takeoff was attempted from county road 240. At an alt of aprx 3 ft the eng sputtered & the plt lost control of the acft, veered left…Dec 18, 1985 · N5547J · Substantial damageNTSB LAX86LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Canoga Park, CAWhile the plt was cruisin in his own acft, an eng oil leak developed, oil pressure decreased & eng power was lost, the plt attempted to make an emergency ldg on a city street, on approach the acft collided with power lines & a fence, & the acft came to rest…Dec 18, 1985 · N6740P · Substantial damageNTSB DEN86LA050Accident · Serious injuriesLimited investigationFinal reportBeech V-35B · Wibaux, MTThe plt stated that light snow was falling at the arpt at the time of departure. The pax stated after the accident that the plt encountered clouds at their cruise alt of about 6000 ft. he continued to state that the acft made a shallow descent at first…Dec 18, 1985 · N24198 · DestroyedNTSB DEN86LA048Accident · No injuriesLimited investigationFinal reportCessna TU-206G · Denver, COWhile gnd taxiing to a general aviation terminal after ldg, the pilot taxied behind and turned downwind into jet thrust from a B737 acft as it was being taxied from a passenger terminal enroute to rwy for takeoff. The acft was blown onto its nose and right…Dec 18, 1985 · N7418N · Substantial damageNTSB ATL86LA044Accident · No injuriesLimited investigationFinal reportHughes 269B · Stone Mountain, GADuring ground refueling of the aircraft the fuel tank was over- filled and the fuel spilled over onto the ramp. The fuel was ignited and the aircraft was destroyed by fire.Dec 18, 1985 · N9303F · Destroyed