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 LAX86LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · El Monte, CAThe student pilot was taxiing to the run-up area when his left wing struck the corner of a hangar. The pilot stated he was paying attention to the right wing which was close to another aircraft at the time.Sep 16, 1986 · N95010 · Substantial damageNTSB DEN86LTM03Accident · No injuriesFinal reportQuickie Q-2 · Grand Junction, COThe plt reported that the acft entered a porpoise during landing. While attempting to add power the eng quit. The landing gear then broke off and the acft entered a ground loop and ran off the rwy. The plt notes that the acft has a tendency to bounce during…Sep 16, 1986 · N39204 · Substantial damageNTSB DEN86FA252Accident · 1 fatalField investigationFinal reportCessna 172M · Bennett, COThe plt, a bail bondsman, flew to goodland, KS, reportedly in search of an accused felon. On the afternoon of the accident, the plt obtained a wx briefing from the fss and filed a VFR flt plan back to the brighton-van aire airport in Colorado. Wx was cavu.…Sep 16, 1986 · N1691V · DestroyedNTSB ANC86LA157Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Redoubt Bay, AKThe non-instrument rated pvt plt became caught on top of a cloud layer during flt and was given ATC assitance. After getting below the clouds the plt encountered fog covered land and water. The plt landed the floatplane in shallow water in an inlet. The…Sep 16, 1986 · N77LM · Substantial damageNTSB SEA86LA246Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Reno, NVThe plt had been waiting in line for takeoff on runway 16 for over an hour, due to traffic departing air races. When cleared to depart, winds were 300 deg at 15 KTS, gusting to 22 KTS. Plt elected to attempt takeoff, became momentarily airborne with stall…Sep 15, 1986 · N28987 · Substantial damageNTSB LAX86LA351Accident · No injuriesLimited investigationFinal reportCessna 195 · Porterville, CAAfter a normal landing the pilot said he began to apply moderate brake pressure to make the mid-field taxiway turn off and felt what he described as 'a light jerk in the left gear' followed by a 'snapping sound which occurred two or three times.' The pilot…Sep 15, 1986 · N3879V · Substantial damageNTSB FTW86FRD25Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M18 · Mer Rouge, LAThe pilot pulled up steeply at the end of a spray run and started a turn-around. During this time he allowed the airspeed to bleed off to the point at which the aircraft stalled and entered a spin without sufficient altitude to recover before ground impact…Sep 15, 1986 · N2710L · DestroyedNTSB DEN86FA249Accident · 1 fatalField investigationFinal reportCessna 182G · Brighton, COAt approximately 0415 hours when it was still night time, the non instrument rated private plt took off on an extended cross country flt to Kentucky. About 15 minutes later he was observed flying in a left turn, at an attitude of 50 to 75 feet in heavy fog…Sep 15, 1986 · N2030R · DestroyedNTSB BFO86LA048Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Westminster, MDFive inches of one propeller blade tip separated during cruise flight at an altitude of 3,500 ft MSL. The imbalance resulted in a severe vibration and a partial power loss. Unable to maintain altitude, the plt set up for a forced landing at clearview airport.…Sep 15, 1986 · N34251 · Substantial damageNTSB ANC86LA142Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Eureka, AKAircraft left the gravel strip and nosed over due to the rear seat passenger pushing on the right rear rudder pedal just as the aircraft became airborne.Sep 15, 1986 · N9656P · Substantial damageNTSB NYC86LA245Accident · No injuriesLimited investigationFinal reportRyan-Navion A · Lakeport, NYThe rocker box cover on the #6 cylinder had the top and bottom screws loose and the center screw missing, causing oil to leak from the bottom of the rocker box cover.Sep 14, 1986 · N5146K · Substantial damageNTSB NYC86LA242Accident · No injuriesLimited investigationFinal reportCessna 172 · Seven Springs, PAPilot came in long and high for landing, attempted to land then decided to abort due to insufficient runway remaining. The aircraft continued off the end of the runway.Sep 14, 1986 · N733CP · Substantial damageNTSB NYC86LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Pedricktown, NJFlight encountered a gust of wind on takeoff, ran off the left side and collided with a sewer ditch. The aircraft flipped over and received substantial damage.Sep 14, 1986 · N738HZ · Substantial damageNTSB NYC86LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Geneseo, NYThe aircraft lost power on approach to Geneseo airport. Investigation did not reveal any preimpact malfunction/failure. Conditions conducive to carburetor icing existed at the time of the accident.Sep 14, 1986 · N7215P · Substantial damageNTSB LAX86LA350Accident · No injuriesLimited investigationFinal reportCessna 172 · Novato, CAThe pilot attempted a crosswind landing at the end of a pleasure cross country flight. A loss of directional control occurred on short final and the aircraft drifted right of the runway. A go-around was attempted without success and the aircraft rolled off…Sep 14, 1986 · N7181G · Substantial damageNTSB LAX86LA349Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · El Monte, CAThe aircraft rolled to the right as the student pilot and his instructor neared the runway. The instructor took the controls and the acft continued the right turn. The acft impacted storage buildings approximately 300 feet to the right of the rwy. A business…Sep 14, 1986 · N5066Z · Substantial damageNTSB LAX86LA347Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Rio Linda, CAAt the end of a local pleasure flight, the pilot noticed a loss of oil pressure approximately 10 miles north of Rio Linda airport. Three minutes later the engine began running rough and the pilot initiated an emergency landing in a rice field. Upon touchdown,…Sep 14, 1986 · N3879X · Substantial damageNTSB FTW86LA168Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Mc Alester, OKSixty-six year old commercial pilot taking off from Mc Alester, OK airport. Pilot stated fuel pressure fluctuated followed by loss of power during initial climb. Pilot activated auxiliary fuel pumps and switched fuel tanks. Could not restore fuel pressure.…Sep 14, 1986 · N7568M · Substantial damageNTSB CHI86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greenwood, INThe brake pads on the aircraft were allowed to wear beyond their limits. When the brakes were applied, the right brake cylinder moved out past its limit and released the o-ring. This resulted in a loss of brake fluid from the right brake. All of this happened…Sep 14, 1986 · N3072L · Substantial damageNTSB CHI86LA222Accident · No injuriesLimited investigationFinal reportCessna 310G · Ypsilanti, MIThe left main gear collapsed and the acft veered off the left side of the runway during the landing roll at an groundspeed of aprx 30 KTS. Inspection of the landing gear disclosed a bent push pull tube.Sep 14, 1986 · N8996Z · Substantial damageNTSB CHI86LA221Accident · No injuriesLimited investigationFinal reportCessna 152II · Carbondale, ILThe pilot stated that as he was returning to the airport, the engine sputtered once and the RPM dropped very low. He applied carb heat, but there was no change, so he made an emergency landing in a corn field where the aircraft nosed over. During an…Sep 14, 1986 · N6490L · Substantial damageNTSB CHI86FEE07Accident · Minor injuriesFinal reportMurphy LONG-EZE · Princeton, ILThe pilot stated that he held the aircraft in a crabbed attitude throughout the touchdown phase of landing to compensate for a crosswind condition. On touchdown the nose and main landing gear collapsed and the aircraft slid on its belly for approximately 330…Sep 14, 1986 · N21VE · Substantial damageNTSB BFO86LA046Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Roanoke, VAThe hot air Balloon was involved in an air show flight event. While enroute to the airport the plt stated that he encountered winds that forced him to land short of the arpt. During the lndg apch he became distracted by spectators on the ground who were in…Sep 14, 1986 · N7423H · Minor damageNTSB BFO86FA047Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Woodbine, MDWitnesses observed the aircraft nose over into a dive after the glider it had been towing released. They then saw it roll and during the roll the left wing departed the aircraft. The CFI in the glider had observed the pilot of N53899 perform what appeared to…Sep 14, 1986 · N53899 · DestroyedNTSB ANC86LA156Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKPilot lost control of aircraft after touchdown on runway due to strong crosswind gust, causing right wing tip to hit ground.Sep 14, 1986 · N82064 · Substantial damageNTSB ANC86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Naknek, AKDuring the taxi to takeoff phase a strong gust of wind lifted the left wing causing the airplane to flip over on its back.Sep 14, 1986 · N1712P · Substantial damageNTSB SEA86LA244Accident · No injuriesLimited investigationFinal reportCessna 172 M · Red'S Horse Ran, ORThe pilot was attempting to depart an airstrip with a strong tail wind. 10 to 20 feet AGL the aircraft descended back onto the ground to the right of the airstrip, bounced, rolled through a wire fence and onto soft muddy terrain. The nose wheel dug into the…Sep 13, 1986 · N12135 · DestroyedNTSB NYC86FGM07Accident · 1 fatalFinal reportTapaszy Benson B-8-M · Cooperstown, PAThe benson B-8-M gyrocopter was observed to take off and transition to level flight. The nose of the aircraft was then observed to dip and then the aircraft banked left and crashed. The aircraft was destroyed and the pilot received fatal injuries. No…Sep 13, 1986 · N6154 · DestroyedNTSB MIA86LA249Accident · No injuriesLimited investigationFinal reportCessna A188B · Newberry, FLThe plt stated that while spraying a field he experienced an eng problem and while attempting a precautionary landing in a cow pasture his left main gear hit a hole and collapsed. Post crash examination of the eng revealed that the linkage on the throttle…Sep 13, 1986 · N4892R · Substantial damageNTSB MIA86LA248Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Miami, FLThe plt stated that his landing apch was high. The acft touched down too fast and the plt veered the acft off the left side of the rwy to avoid contacting a fence at the end of the rwy. The acft traveled into soft dirt and the landing gear collapsed.Sep 13, 1986 · N1421T · Substantial damageNTSB LAX86LA348Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Thermal, CAThe pilot departed on a local flight to put 'some break in time' on a newly installed engine cylinder. The pilot stated that he' departed with a low fuel level but was only going to be up for a little while.' After 40 minutes of flight time, the pilot…Sep 13, 1986 · N917Q · Substantial damageNTSB FTW86LA167Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Norias, TXThe commercial plt was engaged in a livestock round-up and attempted to hover over a wire fence. The acft skid caught on the fence causing a loss of acft control and subsequent impact with the terrain.Sep 13, 1986 · N40268 · Substantial damageNTSB FTW86LA166Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oklahoma City, OKThe pilot apparently had neglected to check his engine oil supply before takeoff since there was no oil in the crankcase at the time of the accident. If five quarts of oil (the amount the pilot reportedly stated was in the engine at takeoff) had leaked out…Sep 13, 1986 · N1250X · Substantial damageNTSB FTW86FPA27Accident · Minor injuriesFinal reportPiper PA-25-235 · Marlin, TXThe plt reported the eng quit during a right turn after takeoff at an alt of aprx 200 ft AGL. The acft crashed in a heavily wooded area aprx 1/4 mile west of the arpt. Cause of the eng failure was not determined.Sep 13, 1986 · N7759Z · DestroyedNTSB DEN86FTG02Accident · Serious injuriesFinal reportRarsch RV-4 · Erie, NDThe plt said he was making a short field apch to a private, sod, strip. He said he was in a shallow lt bank on final apch when he noticed the acft was in a slip and descending too fast to avoid a collision with trees 500 ft from the apch end of the strip. The…Sep 13, 1986 · N319ER · Substantial damageNTSB CHI86LA223Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Danville, INThe aircraft veered off the left side of the gravel runway during the takeoff ground roll. The pilot stated that the airstrip was surrounded by cornstalks, and that on the left side of the airstrip, there was deep loose gravel. Reportedly, the loose gravel…Sep 13, 1986 · N7277P · Substantial damageNTSB ATL86LA257Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Covington, KYThe plt landed at the airstrip on his fathers farm as the third stop of the day. He reported that during the attempted takeoff he hit a tree and stalled the acft. His student pilot certificate had been signed off for his first x-country flt the day prior to…Sep 13, 1986 · N10539 · Substantial damageNTSB ATL86LA256Accident · No injuriesLimited investigationFinal reportCessna 310J · Bessemer, ALWhile taxiing for takeoff the plt attempting to taxi between two rows of parked acft. He used the left brake to maneuver the acft between the rows and could not stop the turn by using the right brake. The acft continued in the turn and struck a parked Cessna…Sep 13, 1986 · N3105L · Substantial damageNTSB ATL86LA253Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-19B · Griffin, GAThe glider departed on an aerial tow and was released at 1700' AGL. Intention of the flt was an out and back x-country. During the flt the plt could not find lift and radioed a friend, also in a glider, that he intended to land at a sod strip. The plt stated…Sep 13, 1986 · N15FW · DestroyedNTSB ANC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe plt rprtd that he had flown to the strip a long time ago & did not know that it had deteriorated. During the landing, the acft ran into holes. Subsequently, the main gear & one lift strut were damaged.Sep 13, 1986 · N2665P · Substantial damageNTSB ANC86FA167Accident · 2 fatalField investigationFinal reportPiper PA-18 · Port Alsworth, AKUndetermined.Sep 13, 1986 · N9109D · DestroyedNTSB ANC86FA152Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · Wasilla, AKFloat plane crashed into trees at end of lake just after takeoff. Witnesses reported hearing the engine backfire and sputter before it quit. Post accident examination of the engine failed to disclose mecanical failures/malfunctions.Sep 13, 1986 · N3996P · Substantial damageNTSB SEA86LA243Accident · 1 fatalLimited investigationFinal reportGrumman G164A-450 · Orovado, NVPower lines were inadvertently struck in flight while maneuvering during aerial application. After striking the power lines the aircraft descended to the ground where a fire erupted and the aircraft was then destroyed by fire.Sep 12, 1986 · N8025K · DestroyedNTSB SEA86FA245Accident · 2 fatalField investigationFinal reportCessna 150M · Carbonado, WAThe instructor and passenger departed on either an introductory flight, initial instructional flight, (or combination thereof). During the flight the aircraft was flown down a canyon which the instructor had flown down previously. As the aircraft approached…Sep 12, 1986 · N9250U · DestroyedNTSB MKC86LA188Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Rolla, MOThe plt had taxied his acft to the upwind end of his pvt strip after landing and commenced his takeoff roll downwind. Shortly after becoming airborne, the acft stalled and descended out of control to the rwy. After the impact the acft was destroyed by a post…Sep 12, 1986 · N9161X · Substantial damageNTSB LAX86LA352Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Likely, CAThe airplane departed san jose airport (sjc), san jose, CA on a business flight in an area near Likely, CA. The pilot intentionally landed on an open dirt area to obtain a soil sample. During the landing roll-out the airplane's left main gear separated after…Sep 12, 1986 · N8085W · Substantial damageNTSB LAX86LA346Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · San Diego, CAThe acft experienced a pwr loss during initial climb. During the ensuing forced lndg the acft collided with a utility pole. To #4 cyl fuel injector line had becom disconnected. The 915 hr eng had received an annual inspection 36 hrs prior to the acc.Sep 12, 1986 · N39695 · Substantial damageNTSB LAX86FVG08Accident · 2 fatalFinal reportChristen Industries Eagle II · Rio Vista, CAWitnesses reported the acft sounded normal during run-up and takeoff until it reached an alt btw 150-500 ft AGL at which time the eng quit. The acft then entered a turn back toward the arpt and descended to ground impact. Post accidentinspection revealed aprx…Sep 12, 1986 · N19DW · DestroyedNTSB FTW86LA165Accident · Minor injuriesLimited investigationFinal reportTemco Glode Swift · Temple, TXThe plt departed rwy 36 at charping field to perform touch and go landings. The plt stated that the acft eng quit on final apch. The plt elected to land short of the airfield with the landing gear retracted because of a power line along the final apch path.…Sep 12, 1986 · N2311B · DestroyedNTSB DEN86LA250Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Casper, WYWhile in normal cruise flt, after crossing a ridgeline, the plt encountered downdraft wind currents. The acft entered a descent from which the plt could not recover. He attempted to make an emergency forced landing in rough desert terrain. The acft impacted…Sep 12, 1986 · N8595D · Substantial damage