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 MIA86LA215Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Dania, FLWhile flying along the beach the pilot noticed that the engine steadily lost power. The pilot then ditched the aircraft. Examination of the aircraft wreckage after recovery revealed that the fuel line from the fuel servo unit to the fuel divider block was…Jul 20, 1986 · N1554H · Substantial damageNTSB MIA86FA216Accident · 3 fatalField investigationFinal reportBeech V35 · Tampa, FLThe private pilot transmitted to the contrl tower shortly after lift off that he had a door ajar, and he was turning back to the runway. Witnesses saw the aircraft execute a teardrop type of turn back to the runway with a nose high attitude, gear down and in…Jul 20, 1986 · N3872N · DestroyedNTSB LAX86LA298Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZA Cessna 140 lost control on takeoff ground run from rwy 21 and collapsed the right main landing gear. On the takeoff roll the acft veered to the right and as the acft approached the end of the rwy 21, it veered sharply back to the left collapsing the right…Jul 20, 1986 · N76553 · Substantial damageNTSB LAX86LA296Accident · Serious injuriesLimited investigationFinal reportGlasflugel ST Libelle · Vacaville, CAAccording to witnesses the sailplane was too low on the landing appraoch and in an attempt to stretch the glide the pilot stalled the sailplane and entered a spin prior to contact with the ground.Jul 20, 1986 · N74162 · Substantial damageNTSB LAX86FVG05Accident · Serious injuriesFinal reportBrown Pitts Special · Bridgeville, CAWitnesses reported the plt made 4 or 5 low passes over the rwy prior to the accident. During each pass the acft was rolled inverted, the eng would quit and the plt would roll the acft upright. On the last pass, according to witnesses, the eng quit again, the…Jul 20, 1986 · N9BB · Substantial damageNTSB FTW86LA137Accident · Serious injuriesLimited investigationFinal reportRose Rhinehart A4-C · Midland, TXThe pilot stated that he encountered severe windshear on approach to landing at the ryan aerodrom airport. He applied full power and pulled the nose up to the best angle of climb attitude, however he could not arrest the sink rate and hit the runway in a…Jul 20, 1986 · N846V · Substantial damageNTSB FTW86LA136Accident · No injuriesLimited investigationFinal reportCessna 305C · Stamford, TXThe pilot was receiving instruction on touch and go landings, in a tail wheel equipped aircraft, when he lost control on touchdown and ground looped the aircraft. The instructor was late with corrective action.Jul 20, 1986 · N4493H · Substantial damageNTSB FTW86LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Houston, TXReportedly the pilot was instructing the co-pilot in quick stop maneuvers, when the helicopter's tail boom and aft skids struck the ground on descent. The helicopter tail boom was bent 2 feet forward of the tail rotor gear box and both aft skids were broken.…Jul 20, 1986 · N1109T · Substantial damageNTSB FTW86LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Plano, TXThe pilot tried twice to rotate the aircraft before it lifted off at approximately 800 feet down the runway. At 100 feet above the ground, the aircraft started veering to the west side of the runway in a nose high attitude, stalled and nosed down impacting…Jul 20, 1986 · N83847 · Substantial damageNTSB DEN86LA203Accident · No injuriesLimited investigationFinal reportRotec Panther II Plus · Sundance, WYThe plt said that on the first flight of N990RE, the vehicle revealed some undesirable flt control characteristics. He said that after landing he installed both doors and then attempted another take off. It was shortly after take off that the plt lost control…Jul 20, 1986 · N990RE · Substantial damageNTSB CHI86FEM11Accident · Serious injuriesFinal reportCessna 150E · Muskegon, MIThe plt rprtd that drg takeoff, the acft lifted off at about the midpoint of the rwy & climbed to just above treetop level. He turned the acft slightly into the wind, then noted that it seem to lose the ability to climb further. The stall warning horn sounded…Jul 20, 1986 · N4072U · Substantial damageNTSB CHI86FA174Accident · 2 fatalField investigationFinal reportCessna 172K · Random Lake, WIThe acft lost pwr on final apprch and crashed into a swamp. Post accident investigation revealed that the eng camshaft was worn reducing the pwr output of the powerplant.Jul 20, 1986 · N79069 · DestroyedNTSB ANC86FA111Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKThe acft was not properly aligned with the rwy during landing touchdown. The acft touched down in a crab attitude. It then ground looped and came to rest on the left wing tip and nose.Jul 20, 1986 · N7156Z · Substantial damageNTSB SEA86LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot, with about 2 hours solo time, was making touch and go's. during the last landing the aircraft was observed to make several bouncing contacts with the runway before the nose gear collapsed.Jul 19, 1986 · N68723 · Substantial damageNTSB MKC86FA151Accident · 3 fatalField investigationFinal reportWhittman WD (Bigx) · Sheldahl, IAWitnesses state that they saw two airplanes, one silver and one red, climbing northbound to cruise altitude in loose formation when the red aircraft's engine backfired and the antique fabric-covered aircraft started burning. Flames five to eight feet in…Jul 19, 1986 · N31637 · DestroyedNTSB MIA86IA213Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Miami, FLFlt was unable to extend nose gear and a nose gear up landing was made. Investigation revealed the nose gear drag brace to be locked in the up position. Disassembly of the drag brace revealed the link assemblies which connect the locking pawls to the locking…Jul 19, 1986 · N8872Z · Minor damageNTSB LAX86LA295Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Whitmore, AZThe airplane departed marble canyon airport, marble canyon, Arizona, to pick up passengers at the grand canyon bar ten airstrip (1Z1) for a 14 CFR 135 flight. The pilot reported that upon arrival at 1Z1 he flew over the single dirt strip runway at about 20 ft…Jul 19, 1986 · N6484H · Substantial damageNTSB FTW86FA133Accident · 4 fatalField investigationFinal reportCessna 421 · Addison, TXWitnesses reported a normal takeoff and climb was made to an alt of aprx 400 ft AGL at which time eng pwr ceased/ decreased. The rt wing then dropped, the nose and lt wing rose and the acft entered a near vertical descent to ground impact. Post accident exam…Jul 19, 1986 · N6VR · DestroyedNTSB DEN86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minot, NDAccording to the plt, the flt proceeded normally until he arrived at an airstrip sw of Minot for a landing. Several low approaches were made before he elected to land. He said that after the touchdown and during his landing roll, the acft swerved and went…Jul 19, 1986 · N2355A · Substantial damageNTSB CHI86FEP06Accident · No injuriesFinal reportPatton Pitts S-1C · Hartford, WIThe plt was on an aerobatic competition flt. He reported that after finishing a sequence of aerobatic maneuvers, he returned to the rwy to land. During the landing, the acft was high on final apch & touched down to FAR down the 2100 ft rwy. It then contd off…Jul 19, 1986 · N3507 · Substantial damageNTSB ATL86LA199Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Orange Beach, ALDuring a banner towing flight along a Beach, the aircraft lost power and the pilot attempted a landing on the Beach of a small island. During landing roll the aircraft rolled into the water and flipped inverted. The operator of the aircraft reported that the…Jul 19, 1986 · N11703 · Substantial damageNTSB SEA86LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Petersburg, AKThe plt reported he had taken off in 'ok visibility' and proceeded toward wrangell, Alaska. En route he encountered 'ground fog' and was in the process of turning around when he 'hit conner (SIC) of fog on the hillside. Then hit trees.'the passenger reported…Jul 18, 1986 · N7642F · DestroyedNTSB NYC86LA190Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTWhen the plt checked the airspeed indicator on takeoff, he saw no indication of speed & aborted the takeoff, but was unable to stop on the remaining rwy. The acft contd off the departure end, when down an embankment & became inverted. An exam revealed the…Jul 18, 1986 · N65612 · DestroyedNTSB MKC86LA153Accident · Minor injuriesLimited investigationFinal reportStevenson Glasair · Oakley, KSThe PIC stated that he had not visually checked the acft's 4 gallon header tank prior to attempting takeoff. During the takeoff the eng would not produce full power. The takeoff was aborted and the PIC inspected the eng for a mechanical pblm. After the…Jul 18, 1986 · N2440H · Substantial damageNTSB MIA86LA214Accident · No injuriesLimited investigationFinal reportCessna 172P · Whiting, FLThe private pilot of a rented Cessna 172P experienced an engine failure after flying 4.7 hours on a cross country flight. During the landing roll the nose gear failed in rough terrain. No fuel was found in the aircraft fuel tanks or lines during recovery and…Jul 18, 1986 · N54069 · Substantial damageNTSB LAX86MA309Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Morgan City, LAThe plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…Jul 18, 1986 · N57967 · DestroyedNTSB LAX86LA294Accident · No injuriesLimited investigationFinal reportCessna 310J · Stockton, CAA C-31OJ went out of ctl on the rwy and collided with a dirt bank. The CFI indicated that they were practicing single eng procedures in the tfc pattern. After td on a single eng apch the CFI gave the left eng back to the student and annc go-around. Init climb…Jul 18, 1986 · N3195L · Substantial damageNTSB FTW86LA131Accident · No injuriesLimited investigationFinal reportBeech B-100 · Houston, TXThe pilot was unable to get a green light for the left main gear prior to landing and finally had to make an emergency landing on the nose and right main gear. The aircraft was substantially damaged when it veered off the runway on the landing roll out.…Jul 18, 1986 · N6354H · Substantial damageNTSB CHI86LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Frankfort, MIThe plt rprtd that during an attempted go-around, a crosswind caught the right wing and blew the acft to the left. The left wing hit a hangar door & was torn off, then the acft crashed to the ground & came to rest upside down. The wind was rprtd to be gusting…Jul 18, 1986 · N1402X · DestroyedNTSB CHI86FER14Accident · No injuriesFinal reportBell-Campbell CHG-2 · Brooklyn Park, MNAccording to the pilot after making three quarter-mile passes over the field the engine quit and he was forced to make an emergency landing in a field. The pilot stated, prior to takeoff the helicopter had been refueled by a ground crew member. According to…Jul 18, 1986 · N5235N · Substantial damageNTSB ATL86LA198Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Lake City, SCDuring landing roll the pilot noticed that the aircraft began to veer off the runway. He initiated a go-around in order to assess the problem. It was determined that the nose wheel had malfunctioned. During the landing roll the aircraft veered off the runway…Jul 18, 1986 · N6116N · Substantial damageNTSB NYC86FA183Accident · No injuriesField investigationFinal reportBell B-222A · Staten Island, NYThe helicopter, on a FAR 135 flight was in cruise flt at 900 ft. the plt was checking for called VFR traffic and the co-pilot was occuppied with the RNAV when a loud bang was heard and a sudden yaw was felt. Both crew members stated they reacted as instructed…Jul 17, 1986 · N404WW · Substantial damageNTSB MIA86LA212Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe plt stated that on final approach he forgot to put the landing gear down. He then landed gear up, & the acft slid to a stop.Jul 17, 1986 · N257ER · Substantial damageNTSB MIA86IA211Incident · No injuriesIncident investigationFinal reportBeech D18S · Ft. Lauderdale, FLFlight experienced collapse of the right main landing gear during landing roll when the bolt which attaches the upper end of the drag leg failed in fatigue. Company maintenance personnel did not remove this bolt regularly for inspection. Beech aircraft…Jul 17, 1986 · N76Q · Minor damageNTSB LAX86FUJ04Accident · No injuriesFinal reportGrumman G-164-3 · Casa Grande, AZThe acft collided with telephone wires on the third apch to a field for an aerial application run. The acft then descended to collision with the terrain. The plt reported having noticed the power lines during the previous spray runs.Jul 17, 1986 · N5342 · Substantial damageNTSB DEN86LA201Accident · No injuriesLimited investigationFinal reportGoertz Bushby Musting II · Ruidoso, NMN976J landed on rwy 18, which is 5,500 ft long and 75 wide and has a concrete surface. The wind was from 210 deg at 10 with gusts to 20 KTS. The plt reports that the crosswind caused a swerve to the right and the acft ran off the right side of the rwy. The…Jul 17, 1986 · N976J · Substantial damageNTSB SEA86LA171Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ketchikan, AKThe plt was attempting to land when the engine ceased operating as the throttle was advanced. Subsequently, the acft struck an embankment short of the runway. The plt had selected the right fuel tank, although the normal procedures in the operating manual…Jul 16, 1986 · N6336E · DestroyedNTSB NYC86LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lock Haven, PAThe pilot made a departure from an uncontrolled airport. During the climb in IMC conditions, the aircraft struck trees and crashed. The aircraft received substantial damage and the pilot received serious injuries. The pilot had a clearance, however, the…Jul 16, 1986 · N32777 · DestroyedNTSB MIA86LA210Accident · No injuriesLimited investigationFinal reportBeech 35 · Plymouth, FLThe plt lost control of the acft when it rotated early due to the elevator trim tab being set at four notches nose up. The acft then stalled & landed hard collapsing the landing gear. The plt failed to use a checklist.Jul 16, 1986 · N417B · Substantial damageNTSB LAX86FA293Accident · 1 fatalField investigationFinal reportBurkhart Grob A103 Twin II · Sun City, AZThe newly certificate sailplaned pilot had taken a friend for a sightseeing flight. On the return the pilot made a normal approach and landing, then veered off the left side of the runway and struck a large saguaro cactus. The cactus toppled and fell across…Jul 16, 1986 · N5448E · Substantial damageNTSB CHI86FA172Accident · 3 fatalField investigationFinal reportCessna 441 · Norton Shores, MIN6857E was transporting executives from holland, MI, to muskegon. The pilot was executing an asr approach to runway 06. The mda is 537 ft AGL. Co-pilot called out 1200 feet then below 1000 feet, pilot continued approach. Aircraft struck trees two miles from…Jul 16, 1986 · N6857E · DestroyedNTSB CHI86FA171Accident · 1 fatalField investigationFinal reportAero Commander 100 · Crivitz, WIFollowing one approach to land under conditions of low visibility (less than 1/4 mile) the pilot attempted to land again. On base leg, according to witnesses, the aircraft fell to the ground. In the wreckage the stall warning light bulb filament was grossly…Jul 16, 1986 · N3667X · DestroyedNTSB BFO86LA040Accident · No injuriesLimited investigationFinal reportCessna 172L · Aberdeen, MDThe plt stated that the eng began to run rough during flt, then all at once, it started vibrating excessively. He attempted to land at the phillips aaf, but the arpt was closed & the rwy lights were not illuminated. By the time he saw the rwy, the acft was…Jul 16, 1986 · N3933Q · DestroyedNTSB ATL86IA197Incident · No injuriesIncident investigationFinal reportBoeing 727-25C · Erlanger, KYAn inflt fire started in a cargo 'igloo' during hi-alt cruise due to spillage of nitric acid in a contact with a wooden packing crate. The fire went out when the acft was de-pressurized but smoke and acid fumes were hazard to the cockpit crew. An emer lndg…Jul 16, 1986 · N126FE · No damageNTSB ATL86FEK04Accident · No injuriesFinal reportAyres S2R-T15 · Mandale, OHThe acft stalled in turbulent air during a 180 turn while crop spraying at about 150 ft AGL. The plt said he increased power & dropped the acft nose while turning an additional 20 degrees to avoid trees. The recovery of positive control was in process when…Jul 16, 1986 · N4015P · Substantial damageNTSB NYC86LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Westerly, RIThe plt rprtd he landed in winds which were gusting to 20 KTS. As the acft touched down, it ballooned & the plt applied some power to maintain control. As he contd the landing, the acft began to drift to the left. The plt attempted a go-around, but he was…Jul 15, 1986 · N4301Q · Substantial damageNTSB LAX86LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hyampom, CAThe aircraft's engine quit when the flight was 25 miles short of its intended destination and an emergency landing was attempted in a river. The pilot stated that according to his calculations, the aircraft should have had a no reserve endurance of 6 hours…Jul 15, 1986 · N6430J · Substantial damageNTSB FTW86LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B · Conroe, TXThe pilot reported that he lost tail rotor control during the transition part of the takeoff. As the helicopter rotated to the right, the pilot reduced power and pulled in collective before impact. Examination of the tail rotor showed no evidence of any tail…Jul 15, 1986 · N352AT · Substantial damageNTSB CHI86FEC05Accident · No injuriesFinal reportJerry Berry MONO-FLY · Blissfield, MIThe acft was damaged in a forced lndg after a power loss at 200 ft AGL. The plt/owner had an ignition problem with the eng quitting in flt. After ground checks & repairs the eng was ground run successfully but during test flt it quit again. An attempt was…Jul 15, 1986 · N84JL · Substantial damageNTSB ATL86FEK03Accident · No injuriesFinal reportHiller UH-12E · Pataskala, OHThe acft autorotated to a forced landing after the eng quit at 600 ft AGL. The landing was made in a corn field. The plt told a FAA inspector at the scene that he had 8 gals of fuel remaining. When the fuel tank was drained it contained aprx 6 oz total. The…Jul 15, 1986 · N136HA · Substantial damage