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 CHI86FER09Accident · 1 fatalFinal reportPiper PA-22-150 · Lino Lakes, MNThis aircraft was overloaded on takeoff with extra fuel, camping equipment, a passenger, an outboard motor, tools and the like. In addition the center of gravity was probably out of safe limits. An additional factor affecting takeoff and turn performance was…NTSB CHI86FEM05Accident · No injuriesFinal reportEagle DW-1 · Baroda, MIThe plt shut down the acft engine after noticing oil on the canopy and a loss of oil pressure. A forced landing was performed in a corn field and the acft nosed over. Post accident inspection disclosed the oil pressure hose had ruptured.NTSB ATL86LA140Accident · No injuriesLimited investigationFinal reportCessna 150E · Gulfshore, ALThe pilot related that the aircraft ran out of fuel and he attempted a forced landing in a field 3 miles from his airport of intended landing. The fuel cells were not visually inspected to determine the fuel quantity, however, the pilot stated that the fuel…NTSB ATL86IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-295 · Nashville, TNThe flight experienced a fire warning light descending through 10500 feet for landing at Nashville. The aircraft landed without incident. The passengers evacuated the aircraft using evacuation slides. Examination of the aircraft disclosed that the detection…NTSB ANC86LA060Accident · 1 fatalLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot stated that at the time of the accident the wind was 30 knots gusting to 35 knots. After touchdown on the water, the pilot lost control of the aircraft causing the aircraft to nose over on its back and sink.NTSB MKC86LA116Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Crete, NEThe plt of this tail-wheel acft attempted a landing on a rwy with a strong x-wind. After a go-around, he started an apch to a turf rwy that was better aligned with the wind but made a go-around when he thought the grass was too high. He then attempted another…NTSB LAX86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Springerville, AZThe acft collided with two parked acft after the student pilot lost control during a go-around. The student stated that during his first landing of the day the acft started to 'slide sideways' and he elected to go-around. He increased the throttle and the…NTSB FTW86LRD13Accident · No injuriesFinal reportGrumman G164B · Morse, LAThe acft settled into power lines and stalled into the ground during a spray operation. The plt had turned downwind to line up for his spray run. The acft started descending and even though power was applied as load was jettisoned the acfts tail wheel snagged…NTSB FTW86FRG19Accident · 1 fatalFinal reportSoward Rutan Longeze · Georgetown, TXThe acft crashed after hitting trees on short final following an inflight fire and an eng failure. The acft was on it's first flt following an eng overhaul and had been airborne about 2 minutes when ground and air observers noticed smoke trailing from the eng…NTSB DEN86FA142Accident · 3 fatalField investigationFinal reportCessna T210N · Elgin, NDPlt received wx briefing prior to departure. VFR flt not recommended by fss. Plt radioed that he was in thunderstorm activity, IFR conditions and was attempting to turn around. Witnesses stated that they observed acft descending at a high rate of speed of a…NTSB ATL86LA139Accident · No injuriesLimited investigationFinal reportMooney M20K · Peachtree City, GAThe plt reported that the acft began to 'wheelbarrow' on the nose gear during the ldg roll. The acft veered off the rwy into a ditch. The plt said that he might not have had the pitch trim set correctly at touchdown. The acft flt manual before landing…NTSB MKC86FPG04Accident · Serious injuriesFinal reportHomebuilt Jodel F-9 · N. Little Rock, ARThe acft stalled and impacted the terrain in a nose low attitude during an attempted forced landing following an eng failure. Post accident inspection revealed the magneto drive coupling had failed. There was evidence present which indicated wear on the…NTSB MIA86LA165Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Fellsmere, FLThe plt stated that he had about 350 lbs of fuel onboard when he took off on his 4th night crop dusting mission. He indicated that each mission is 6 to 8 mins in duration and that the average fuel consumption is about 570 lbs per hr. He stated that the 20 min…NTSB LAX86LA227Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Lompoc, CAThe bellance champion went out of control an collided with two other parked acft after a hand propped start. The plt indicated that the acft was tied down with two chains attached to each of the wings at one end and to a cable that stretched across the ramp…NTSB LAX86LA226Accident · Minor injuriesLimited investigationFinal reportBell 206B · Los Angeles, CADuring a x-wind takeoff the downwind skid contacted the landing pad and the helicopter rolled over to the right. One person on the ground was injured by flying debris.NTSB FTW86LRD12Accident · No injuriesFinal reportGrumman G-164A · Branch, LAShortly after takeoff, a partial power loss occurred & the plt made a forced landing in a soft plowed field, where the acft nosed over onto its back. The plt rprtd the loss of power was due to failure of the eng blower.NTSB FTW86LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Rio Hondo, TXThe right eng failed during cruise flt and the plt was unsuccessful in his attempt to restart the eng. The acft was unable to maintain alt and impacted the ground resulting in substantial damage to the acft. Although there was no evidence of any…NTSB FTW86FRG20Accident · No injuriesFinal reportAir Tractor AT301 · Taylor, TXCommercial pilot of an Air Tractor AT301 enroute to base of operations at Taylor, TX executed a forced landing after experiencing severe vibration in the aircraft. Landing was made to a soft field. The aircraft nosed over during landing roll and was…NTSB CHI86LA144Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia City, INThe pilot had become disoriented and was concerned about his low fuel state when he decided to make a precautionary landing. The weather was deteriorating and it was getting dark although the pilot stated he could distinguish the trees from the ground. He…NTSB BFO86LA030Accident · Serious injuriesLimited investigationFinal reportShort Brothers SD3-30 · Hopewell, VAThe captain reported that moderate to severe turbulence was encountered while passing through some clouds. He called the flight attendant on the intercom and told her to sit down; while she was attempting to answer the intercom, an object from the galley area…NTSB ATL86FA137Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Valdosta, GAThe left engine lost power shortly after takeoff and the pilot did not feather the propeller. A traffic pattern was flown with the aircraft in a continuous descent. Insufficient altitude remained to maneuver the aircraft to the runway, so the pilot elected to…NTSB SEA86FA121Accident · 2 fatalField investigationFinal reportCessna 152 · Mead, WABoth acft were operating in VFR conditions modified by slight haze, high overcast and low sun angle near airport. N6161M was performing lazy eight maneuvers in a normal practice area two miles east of airport; N8267Q was in clockwise orbital descent for…NTSB MKC86LA115Accident · No injuriesLimited investigationFinal reportCessna A185F · Bernie, MOThe pilot stated that they were on the takeoff roll when his seat failed and he fell backward away from the flight controls and the throttle. The airplane veered left, off the runway, crossed a small ditch, a road and then impacted in a very large drainage…NTSB MKC86LA114Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Winona, KSThe pilot stated that he borrowed the airplane from his father to practice takeoffs and landings at his father's private, crop dusting airstrip. There were no chemicals onboard, according to the pilot. He further stated that on a go-around maneuver, and as he…NTSB MKC86FA113Accident · No injuriesField investigationFinal reportSwearingen SA226 · Hutchinson, KSThe capt rprtd that during arrival, the apch seemed normal until he flared to land on rwy 17. At that time, he heard a loud 'pop' as the landing gear contacted the rwy surface. Subsequently, the left main gear collapsed & the acft veered off the rwy. An exam…NTSB MIA86LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Stuart, FLThe student plt was on his first supervised solo flt and was attempting his third landing. During the flare, the acft ballooned, nosed over and struck the rwy on the nose gear. The acft then burst into flames and was consumed by fire. Theplt was able to exit…NTSB FTW86LRG21Accident · No injuriesFinal reportGrumman G-164B · Port O'Connor, TXAcft flipped over on touchdown during an emergency landing in a cultivated field following a partial power loss during a swath run at 30 ft AGL. Investigation revealed that the no. 1 cyl exhaust valve push rod had failed. Exact cause of the push rod failure…NTSB DEN86FTM02Accident · Serious injuriesFinal reportDenney Aerocraft Kitfox · Ogden, UTShortly after takeoff, the acft had a partial power loss. The left wing then dipped sharply & the acft entered a steep nose low descent & crashed on the nw corner of the arpt. An investigation revealed a noise suppressor was installed on one of 2 spark plug…NTSB DEN86FTK02Accident · No injuriesFinal reportAero Commander Callair A-9B · Dell Rapids, SDThe plt stated that during the takeoff roll, he lost rudder effectiveness after accelerating to about 60 KTS. He applied brakes to stop, but the acft veered off the left side of the rwy & struck a fence. No preimpact part failure or malfunction was reported.…NTSB DEN86FA141Accident · Serious injuriesField investigationFinal reportCessna 150-H · Glen Canyon, UTWhile in a descent 20 miles before reaching the destination, the acft engine quit due to fuel exhaustion. The plt initiated an emergency forced landing to a dry stream bed in rough desert terrain. After touchdown, the acft impacted an embankment and flipped…NTSB CHI86LA143Accident · No injuriesLimited investigationFinal reportBeech BE-F90 · Eaton, INThe acft had made a stop at muncie to pick up a fourth passenger. After boarding, the passenger closed the cabin door. After departure and climbing thru 6,000 ft the airstair separated from the aircraft and struck the vertical stabilizer.NTSB ATL86LA136Accident · No injuriesLimited investigationFinal reportBeech A36 · Swansboro, NCThe plt reported that the acft touched down about 700 ft down the 2700 ft sod rwy. The rwy was wet from rain and braking action was nil. The plt elected to stay on the rwy and continue braking efforts. The acft slid off the rwy end into a drainage ditch. The…NTSB ANC86LA059Accident · No injuriesLimited investigationFinal reportTaylorcraft TC-19 · Fairbanks, AKThe pilot stalled the acft during approach to a gravel bar and made a hard landing. The plt said that he needed to improve his proficiency at slow flying.NTSB SEA86LA128Accident · No injuriesLimited investigationFinal reportAyres S-2R · Odessa, WAA rough running engine accompanied by smoke rising from the left side of the engine occurred shortly after takeoff. The landing gear then collapsed during the subsequent forced landing and the acft was destroyed by fire. The number one cylinder was found to…NTSB NYC86LA137Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-32A · Kurtztown, PAAfter flying in thermals for about 45 minutes, the plts returned to the arpt to land. The instructor (CFI) stated they came over the initial approach point at about 1000 ft for a landing on runway 30. The glider passed over the end of the runway at about 150…NTSB MKC86LA112Accident · Minor injuriesLimited investigationFinal reportCollin Campbell Zippy Sport · Bolivar, MOWhile performing a high speed taxi run on a turf rwy the plt stated the acft hit a bump in the rwy where a drainage pipe runs beneath the surface and inadvertently became airborne. The plt did not reduce throttle to abort the takeoff and the acft stalled…NTSB MKC86LA111Accident · No injuriesLimited investigationFinal reportJackman Pitts S-1S · Montezuma, KSThe pilot stated that as the aircraft touched down on the runway the left wing struck crops in a wheatfield which arrested the forward motion of the wing. According to th e pilot, the aircraft veered out of control into the wheatfield, cartwheeled twice, and…NTSB DEN86LA140Accident · No injuriesLimited investigationFinal reportCessna 172B · Alamosa, COThe student plt had soloed that morning. After a short rest period he flew with his instructor. He then flew a second solo flt. The student plt made two landings. On the third approach the plt made a go-around. On the next approach the acft stalled close to…NTSB CHI86FER08Accident · No injuriesFinal reportCessna A188B · Montevideo, MNDuring takeoff roll from a roadway the wind shifted from a headwind to a tailwind. The pilot of this crop duster turned to avoid a stop sign on the roadway and allowed his landing gear to touch down on a crossing roadway. The aircraft then flipped over onto…NTSB ATL86LA138Accident · No injuriesLimited investigationFinal reportBell 47G-3B · Red Bay, ALThe pilot had completed a dispensing operation and was returning to the ag staging area to refuel. As the helicopter hovered towards the parked refueling vehicle, the main rotor blades struck a metal structure attached to the truck. The pilot stated that the…NTSB NYC86LA130Accident · No injuriesLimited investigationFinal reportCessna 206 · Greenville, METhe pilot experienced problems on takeoff from moosehead lake, but eventually was able to get airborne and fly to the Greenville airport. The aircraft remained on the ground for a few hours, then was preflighted for deparapure. Runway 21 was the favorable…NTSB NYC86LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · North Hampton, NHThe acft settled into trees during a landing apch. The plt reported that he added full power with the carburetor heat off and was still unable to stop the descent. When flt checked by the FAA, the plts slow flt and stall recovery procedures were found to be…NTSB NYC86FGM03Accident · Serious injuriesFinal reportEipper Quicksilver MX2 · Mars, PAPilot, once airborne, passing a tree line, encountered a sudden gust of wind. The quicksilver ultra-lite, with one pax, was forced from its flight path into power lines causing the aircraft to crash. Both pilot and pax sustained serious injuries. Aircraft was…NTSB NYC86FA131Accident · 2 fatalField investigationFinal reportCessna 414A · Atlantic City, NJDuring tkf gnd run, at a speed of 95 KTS, the plt pulled the control wheel back to lift off. The control wheel, according to the plt, would not go back more than about 2 inches; which is less than half the normal full aft travel. The acft reached a speed of…NTSB MKC86LA110Accident · No injuriesLimited investigationFinal reportMyers EAA BI-PLANE · Winfield, KSThe pilot stated he was landing his taildragger to the north with winds from the north at 12 to 15 knots. He said he was making a three point landing and just before touchdown, the airplane changed directions and after touchdown, it went off the side of the…NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…NTSB LAX86FJA06Accident · 2 fatalFinal reportBell 206B · Maui, HIThe acft collided with powerlines while carrying pass'g on a sightseeing flt through a canyon. The wires across the canyon were EST to be 1700 long with height AGL unknown. The wires were unmarked and were 1/2 in dia aluminum. One of the passengers was…NTSB LAX86FA222Accident · 6 fatalField investigationFinal reportCessna 320D · Van Nuys, CAThe acft was returning from a x-country flt when the accident occurred. Witnesses observed the acft on a low downwind leg and made two sudden steep turns, one to the east followed by a sudden steep turn to the north prior to a nose down impact into the…NTSB FTW86LA082Accident · Minor injuriesLimited investigationFinal reportCessna 150F · San Antonio, TXPilot failed to obtain sufficient airspeed to clear the trees at the end of the runway. The runway was soft and there was a left crosswind.NTSB DEN86LA139Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Denver, COThe plt report that he entered normal traffic for landing at front range airport. There were 3 or 4 acft preceding him so he extended his traffic pattern. After turning onto final approach about 1 mile from end of rwy, the plt said the eng quit abruptly. The…