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 SEA86LA149Accident · No injuriesLimited investigationFinal reportMellema Bede 4 · Kent, WAThe engine ceased operating 10 feet a.g.l. during takeoff while on a biennial flight review. A landing straight ahead was made onto the runway, but in order to avoid an overrun an intentional ground loop was made. On engine examination a large bug was found…Jun 21, 1986 · N76VR · Substantial damageNTSB NYC86LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wayne, NJThe aircraft developed engine problems while on approach to the airport at caldwell, new jersey and collided with trees during the forced landing. Upon examination of the aircraft, debris was found in the vent line from the fuel vent tube to the left fuel…Jun 21, 1986 · N89720 · DestroyedNTSB NYC86FNA01Accident · No injuriesFinal reportSteen Skybolt UNK · Beverly, MAThe Steen Skybolt modified with a turbo-prop conversion experienced a power loss on takeoff after achieving an altitude of 200-300 ft AGL and made a hard landing on the runway remaining. The landing gear collapsed and aircraft received substantial damage. The…Jun 21, 1986 · N932JF · Substantial damageNTSB MIA86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Plant City, FLWhile on a dual student plt flt, about 10 minutes after takeoff, the eng began severely vibrating. The instructor plt took control of the acft, reduced power and established a glide to a local arpt. The engine then suddenly failed completely. The instructor…Jun 21, 1986 · N63133 · DestroyedNTSB MIA86LA186Accident · No injuriesLimited investigationFinal reportCessna U206F · Ft. Myers, FLThe private pilot had just completed a short no-radio night flight and during the landing roll the nose gear wheel assembly separated from the aircraft. Examination revealed that the wrong nuts had been installed on the wheel assembly at the last annual…Jun 21, 1986 · N1372V · Substantial damageNTSB LAX86FA260Accident · 2 fatalField investigationFinal reportCessna 152 · Marysville, CAAt 0203 PDT, there was an electrical power outage when a Cessna 152, N4873H, collided with a power line that crossed the feather river near Marysville, CA. The acdnt occurred as a student plt was flying over the river at low alt with a passenger aboard at…Jun 21, 1986 · N4873H · DestroyedNTSB FTW86LA117Accident · No injuriesLimited investigationFinal reportCessna 172K · Weatherford, TXThe pilot reported losing control of the acft during touchdown due to the crosswind. The landing was being made on runway 16 and there was a 7 kt wind from 200 degrees.Jun 21, 1986 · N84839 · Substantial damageNTSB DEN86LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bosler, WYAccording to the plt, the acft had just become airborne when it encountered a gust of wind while simultaneously crossing a gully, lost lift & descended until ground contact. The plt also indicated there was a 'density altitude problem.' The density altitude…Jun 21, 1986 · N79221 · Substantial damageNTSB DEN86FA170Accident · 1 fatalField investigationFinal reportCessna A150K · Silver City, NMThe student plt took a private plt for a sight seeing ride. The acft was over gross weight and the density alt was calculated to be 9,292 feet. On an approach to landing the student plt elected to go around. The surviving plt said that in a steep bank the…Jun 21, 1986 · N6DW · DestroyedNTSB CHI86LA160Accident · No injuriesLimited investigationFinal reportBeech V35B · Mackinac Island, MIAfter making two go-arounds the aircraft's landing gear collapsed as the aircraft porpoised on the runway during the third landing attempt.Jun 21, 1986 · N18393 · Substantial damageNTSB ATL86LA180Accident · No injuriesLimited investigationFinal reportCessna 172P · Salisbury, NCThe plt reported that the engine lost power and quit shortly after T/0 at about 500-700 ft AGL. He checked the mixture, carb heat and mags but was unable to restart the engine. A 180 turn was made back to the arpt. The plt stated that he let the airspeed…Jun 21, 1986 · N52601 · Substantial damageNTSB ATL86LA179Accident · Serious injuriesLimited investigationFinal reportAndrew D. Moore HP-18 · Chester, SCThe pilot related that while turning from base to final he heard a loud bang from the left side of the aircraft. The aircraft entered a steep left turn and crashed left of final approach course. Post crash examination of the aircraft revealed that the flap…Jun 21, 1986 · N9700P · Substantial damageNTSB ATL86FMG08Accident · 1 fatalFinal reportH. Preiss HP-19C · Boone, NCThe glider made a steep nose high turn, stalled and crashed after a premature tow release at aprx 150 ft AGL. Witnesses said that the glider appeared to be badly controlled from the beginning of the takeoff roll. After the stall during the turn the acft…Jun 21, 1986 · N4259Y · DestroyedNTSB ATL86FA178Accident · 2 fatalField investigationFinal reportCessna 120 · Marlton, NJAbout 10 min after takeoff, the acft collided with trees & crashed while the plts were performing aerobatic maneuvers. According to witnesses, aerobatics were being performed at an about 500 ft AGL. They rprtd that the plts had made an overhead maneuver…Jun 21, 1986 · N89789 · DestroyedNTSB ANC86IA088Incident · No injuriesIncident investigationFinal reportCessna 404 · St Marys, AKDuring the descent into st. mary's, Alaska, the door ajar warning light illuminated. The pilot-in-command checked the rear door and then the front crew door. When the handle of the crew door was retouched it flew open and departed the airplane taking about…Jun 21, 1986 · N4450M · Minor damageNTSB ANC86FA085Accident · No injuriesField investigationFinal reportPiper L-4H · Anchorage, AKThe pilot/mechanic stated the engine oil pressure gauge began flickering, so he elected to land and during the descent the engine failed. He landed downwind in 20 knot winds and during the landing roll, across tundra/mud the airplane's wheels struck a large…Jun 21, 1986 · N58988 · Substantial damageNTSB NYC86LA171Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Barkhanstead, CTThe flight took off with about seven gallons of fuel with a slight tailwind. But after about 30 minutes of flight the flight encountered a headwind. The aircraft suffered fuel exhaustion and the pilot executed a precautionary landing in a field. During ground…Jun 20, 1986 · N1166B · Substantial damageNTSB MIA86LA222Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Cleveland, MSThe pilot stated that when he took off, the acft was overweight and he was unable to remain airborne. He attempted a running landing, the skids dug in and collapsed causing the spray boom to swing forward and break the bubble canopy.Jun 20, 1986 · N53SP · Substantial damageNTSB LAX86LA259Accident · Serious injuriesLimited investigationFinal reportBeech A-36TC · San Rafael, CAThe acft stalled and collided with the ground initial during a takeoff initial climb. He indicated that he misjudged the stall buffet as turbulent airflow from a crosswind. The right wing dropped and the acft stalled. The plt also indicated the stall warning…Jun 20, 1986 · N3823A · Substantial damageNTSB LAX86LA258Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Prescott, AZThe acft landed hard on runway 21. The certified flight instructor indicated that during the landing flare of a full flap landing the student pilot allowed the aircraft to yaw 45 degs off the runway heading. The CFI immediately initiated a go-around by…Jun 20, 1986 · N68916 · Substantial damageNTSB FTW86FPJ09Accident · Serious injuriesFinal reportQuick Silver Mxii · Ardmore, OKThe acft landed short of the rwy after losing eng pwr during the apch. Post acc inspection showed that the bearing on the pwr shaft failed. This allowed the belt tension to become slack which reduced the prop RPM. No other discrepancies were noted.Jun 20, 1986 · N4410W · Substantial damageNTSB DEN86LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · South Heart, NDAccording to the plt, during a swath run (agricultural spraying), the eng quit & a forced landing was accomplished. During the interview, the plt stated the eng quit due to fuel exhaustion.Jun 20, 1986 · N8768L · Substantial damageNTSB CHI86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Shiocton, WICFI delayed corrective action during a practice forced landing by a student. Aircraft touched down with insufficient runway remaining to stop safely. During the subsequent go-around attempt the aircraft rolled into a plowed field and nosed over.Jun 20, 1986 · N5220M · Substantial damageNTSB CHI86FEM09Accident · 2 fatalFinal reportCessna 172I · Nunica, MIThe acft was seen flying over the water at an alt of aprx 150-200 ft AGL prior to hitting wires. The acft was flying into the sun at the time of the wire strike.Jun 20, 1986 · N46074 · DestroyedNTSB ATL86LA177Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Chester, OHDrg flt, the eng lost power & the plt was unable to maintain alt. He made a forced landing on a road, but drg the lndg roll, the acft collided with a road sign. A post crash exam of the eng revealed the #6 cylinder had separated aprx 4' above the cylinder…Jun 20, 1986 · N6639P · Substantial damageNTSB ANC86LA090Accident · No injuriesLimited investigationFinal reportCessna 150 · Talkeetna, AKThe student pilot, who was carrying a passenger, mixed automotive fuel with aviation gasoline. The auto gas contained water causing the engine to run intermittently. The airplane turned over during a forced landing in a swamp. Post accident inspection rvealed…Jun 20, 1986 · N1773Q · Substantial damageNTSB MKC86FCJ02Accident · 1 fatalFinal reportCessna A188B · Bridgeport, NEDuring an agricultural spray run, the aircraft collided with a utility pole, leaving part of the spary boom wrapped around the pole, and pieces of flap, wing, and fuel bladder nearby. The aircraft then impacted the ground about 1000 ft from the pole & was…Jun 19, 1986 · N84729 · DestroyedNTSB FTW86LA118Accident · Minor injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot decided to land due to rainy conditions shortly after departure. He had forgotten to retract the landing gear after takeoff and made a water landing with the gear down, causing the aircraft to invert and sink.Jun 19, 1986 · N9937N · Substantial damageNTSB FTW86LA113Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Palacios, TXDuring the ground run portion of the takeoff, the acft contacted a mud hole which resulted in it veering off the grass and into bushes alongside the strip. The plt did not select suitable terrain for the takeoff.Jun 19, 1986 · N48398 · Substantial damageNTSB DEN86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Onida, SDThe plt reported a partial loss of pwr occurred momentarily before liftoff. The takeoff was continued and once airborne the pwr loss reoccurred. The load was dumped, however, the acft impacted trees aprx 1 mile from the arpt as sufficient alt could not be…Jun 19, 1986 · N3856E · DestroyedNTSB CHI86LA158Accident · No injuriesLimited investigationFinal reportCessna 182P · Gary, INThe student pilot was on a supervised solo flight. According to him, he closed the throttle over the threshold due to excessive speed and the plane floated for some distance as he brought the control column back. The nose of the aircraft then dropped and the…Jun 19, 1986 · N20735 · Substantial damageNTSB ATL86FA176Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Columbus, GAJust as the aircraft flared for landing, a gust of wind struck the airport. The pilot and passengers reported that the aircraft ballooned up several feet, and the right wing dipped. The pilot got the wings level and attempted to perform a go-around. The…Jun 19, 1986 · N103EF · Substantial damageNTSB ANC86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Egegik, AKThe airplane experienced a power failure and nosed over in one foot of water while making an emergency landing on a beach.Jun 19, 1986 · N5907Z · Substantial damageNTSB ANC86LA084Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe plt reported that a loud bang was heard at an alt of about 25 ft AGL shortly after takeoff. The acft settled to the rwy and pwr was regained. The acft then veered off the left side of the rwy and nosed over. Post accident inspection revealed maintenance…Jun 19, 1986 · N2393C · Substantial damageNTSB MKC86LA129Accident · No injuriesLimited investigationFinal reportCessna 152II · Jonesboro, ARThe pilot stated that he was level at 3,000 feet, and had the airport in sight when he experienced a fluctuation in engine RPM. The pilot further stated that he continued the flight but that the engine quit when the aircraft was over the airport. The p.I.c.…Jun 18, 1986 · N67490 · DestroyedNTSB MIA86FA185Accident · 1 fatalField investigationFinal reportAyres S2R-1820 · Dundee, MSThe ag acft was flying low over a water covered muddy rice field when the eng stopped running. The plt then jettisoned the load of fertilizer & entered a steep right turn. Subsequently, the aircraft struck the ground on the right wing & nose, then…Jun 18, 1986 · N4023P · DestroyedNTSB LAX86MA268Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Galveston, TXThe plt rprtd that while apchg an oil drilling platform for a lndg, he observed the main rotor blades go out of track about 8 to 10 inches. He also rprtd the helicopter developed a 1:1 vertical vibration. Drg the lndg, the helicopter entered into ground…Jun 18, 1986 · N5796T · Substantial damageNTSB FTW86LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Weatherford, TXThe plt experienced a power loss at approximately 200 feet during the takeoff climb portion of the flight. On descent the aircraft collided with a tree before coming to rest in a field. During pre-flight the pilot noted the fuel tanks were half full and there…Jun 18, 1986 · N6469E · Substantial damageNTSB FTW86LA112Accident · No injuriesLimited investigationFinal reportBeech T-34A · Pearland, TXThe plt experienced an eng failure during cruise flt due to a blockage of the air induction system by a sheet of paper. The acft had been painted just prior to the accident. The acft received substantial damage when the right wing collided with the ground due…Jun 18, 1986 · N5154V · Substantial damageNTSB DEN86LA164Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Toston, MTThe plt reports that he took off from an ag strip about a mile from the fld being treated and was making a turn-around after his second swath run when the acft began to settle. He dumped his chem but the acft continued to settle and impacted the ground. The…Jun 18, 1986 · N82539 · Substantial damageNTSB DEN86FTG01Accident · Serious injuriesFinal reportPiper PA25-235 · Stanley, NDThe acft went off the departure end of the rwy and collided with a ditch after which it erupted in flames. The temperature was 87 degrees with light wind. The density alt was computed to be 5000 ft. the plt had stated to the operator that he thought it was…Jun 18, 1986 · N6535Z · DestroyedNTSB DEN86FA165Accident · 1 fatalField investigationFinal reportBeech A36 · Mosquero, NMThe acft was observed flying at low altitude when it pitched up at a steep angle, climbed about 400 ft, rolled off on left wing, descended into the ground, exploded and burned. Post accident exam revealed the landing gear was retracted but the flaps were…Jun 18, 1986 · N333RS · DestroyedNTSB DCA86AA028Accident · 25 fatalFinal reportde Havilland DHC-6-300 · Grand Canyon, AZAt about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the…Jun 18, 1986 · N76GC · 2 aircraft · DestroyedNTSB CHI86FEP05Accident · No injuriesFinal reportBeech C-23 · Milwaukee, WIDuring taxi for takeoff the plt inadvertently taxied onto an access road and struck and unlit sign. The taxiway had been resurfaced and no taxi guide lines had been repainted.Jun 18, 1986 · N66345 · Substantial damageNTSB ATL86LA175Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fuquay-Varina, NCThe flt was a practical flt test for a commercial plt certificate. At aprx 3,000 ft the plt examiner initiated a simulated forced landing. The applicant spiraled to a modified downwind and base leg. The applicant said everything was fine until on final apch…Jun 18, 1986 · N6046Z · Substantial damageNTSB ANC86LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Theodore River, AKThe pilot stated that upon attempting a soft field takeoff the aircraft drifted to the left. The left main landing gear struck a sand berm which caused the aircraft to exit the road into an open ditch.Jun 18, 1986 · N73419 · Substantial damageNTSB NYC86LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westport, NYThe Piper PA-28-235 made an off airport landing at night in conditions of reduced visibility, with rain, gusty winds and thunderstorms in the area. The aircraft received substantial damage and the pilot received serious injuries. Post crash examination of the…Jun 17, 1986 · N9094W · Substantial damageNTSB MIA86FA184Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Boynton Beach, FLAccording to witnesses, the acft entered a turn shortly after taking off from a touch-&-go landing, then stalled & began to spin to the right. The acft impacted the ground at the edge of a canal, aprx 1000 ft from the dept end of the rwy. One witness stated…Jun 17, 1986 · N1318V · DestroyedNTSB LAX86LA256Accident · No injuriesLimited investigationFinal reportCessna 140 · Pacoima, CAThe plt lost control of the acft during landing. A witness stated that when the acft was about one-fourth of the way down the rwy, it began porpoising and then flipped over on its back.Jun 17, 1986 · N89403 · Substantial damageNTSB LAX86DVA09Accident · No injuriesFinal reportHiller UH-12E · Delano, CAThe helicopter rotor blade delaminated shortly after departing the operator's north base at Delano, CA. The investigation determined the blade contained extensive voids on the bond line. The blade was rejected by the manufacturer as being unairworthy. The…Jun 17, 1986 · N172ET · Substantial damage