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 ANC86LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot lost control of the aircraft on landing at a winter ice landing strip.NTSB ANC86FA037Accident · 2 fatalField investigationFinal reportde Havilland DHC-4A · Lime Village, AKWitnesses observed the acft on final approach with its gear down then the nose pitched up. The acft rolled left and crashed into trees. The acft's cockpit, cabin, engine nacelles, cargo and portions of the wings were destroyed by post-impact fire. Post…NTSB MKC86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Mulvane, KSThe PIC of the acft landed his Cessna 182 to the north on a farm pasture he owns which doubles as a landing strip. The PIC stated he approached too high and too fast, landing about midway of the field. A fence which borders the field was fast approaching with…NTSB MIA86LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Pierce, FLThe plt stated that while switching tanks, his fuel selector froze up & both eng's failed. Upon landing, the acft struck a tree severing a wing. The NTSB form 6120.1 that was sent to the plt was returned, it stated that the addressee moved & left no address.…NTSB MIA86FA101Accident · 2 fatalField investigationFinal reportDurkota Thorp T-18 · Lakeland, FLWitnesses observed black smoke trailing from the homebuilt acft during takeoff & initial climb. The acft was observed to climb to an estimated alt of 150 to 200 ft where eng sound ceased & the prop stopped. The acft was then observed to attempt a left turn…NTSB LAX86LA147Accident · No injuriesLimited investigationFinal reportMooney M20F · Burbank, CAThe acft was landed nose low after flying the pattern with a flt control problem. The plt said he noticed the lack of elevator control during initial climb and came back in for a precautionary landing. The elevator was found to be inoperative due to a broken…NTSB LAX86LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Hayward, CAA Cessna 172P collided with a rwy light after veering off rwy 28. The winds at the time off the accident were reported from 350 deg at 6 KTS. The right main landing gear collapsed when it struck a rwy light damaging the right wing and tail section.NTSB SEA86IA080Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Reno, NVAt FL250 the engine ceased operating due to a failed fuel pump. A restart was successful at 10,000 feet m.s.l. with an uneventful landing. This fuel pump (a model g) had a total time of three hours. It was a replacement for a model c fuel pump which had…NTSB MKC86LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, ARThe plt reports that a deer ran in front of the acft during the flare for a night landing. The prop hit and killed the deer and the nose gear and bottom of the eng compartment were damaged. After the collision the plt said he smelled fuel fumes and when the…NTSB MIA86FA100Accident · 3 fatalField investigationFinal reportBeech D-35 · Crystal Springs, FLWitnesses stated they observed the acft performing aerobatics while at an estimated alt of 1000 to 1300 ft. after the completion of a loop, the acft was observed to nearly come to a stop while vertical, then fall off to the left & enter a spin which continued…NTSB LAX86LA144Accident · No injuriesLimited investigationFinal reportCentrair Schleicher ASW-20 · Phoenix, AZThe plt elected to abort the takeoff because the acft was veering off the rwy. After release from the tow plane the acft wing tip struck a bush causing the afct to ground loop. The plt reported that the winds at the time of the accident were from 200 deg at 5…NTSB FTW86LA043Accident · No injuriesLimited investigationFinal reportBell 47G · Beaumont, TXThe pilot was taking off from an area which was protected from the wind by a large building. After obtaining translational lift and climbing above the building, a right quartering tail wind, with gusts to 20 knots, was encountered. The pilot stated he lost…NTSB CHI86LA105Accident · No injuriesLimited investigationFinal reportCessna 150J · Lansing, MIThe student pilot flew a four leg round-robin with touch and go landing after each leg. After his return to his point of origin and following his second touch and go there, the engine quit at 100 ft AGL, halfway down the runway. He bounced into the grass at…NTSB ATL86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Crossville, TNOn takeoff the plt saw an oil leak around the prop hub. The acft was returned to the airport and the prop governor oil tube fitting was found to be cracked. The part was replaced and the flt was continued. The part was checked during a later refueling stop…NTSB SEA86LA079Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Overton, NVThe noncertificated plt rprtd that he had repaired the helicopter, then proceeded to make a local test flt. He rprtd that he took off in darkness after having a few beers. The plt chose to turn off the landing light shortly after takeoff. While at low…NTSB LAX86LA143Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350D · Tahoe Valley, CAThe helicopter collided with trees and crashed in rough mountainous terrain during takeoff. The acft was shuttling skiers from a landing area located at approximately 8,300 ft mls to a ridgeline at 11,000 ft MSL. The plt reported the EGT (T-4) was at 790 deg…NTSB FTW86LA045Accident · 1 fatalLimited investigationFinal reportCessna TU206F · Goliad, TXThe pilot apparently failed to properly recover from a bounced landing and broke a landing gear wheel. The aircraft hit and fatally injured a person on the ground. Local authorities believe the persons body was then transported about four miles and thrown…NTSB ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…NTSB SEA86LA078Accident · Minor injuriesLimited investigationFinal reportMaule M-4-180C · Orchards, WAThe pilot inadvertently placed the fuel selector to a non-tank position. During initial climb at about 400 m.s.l. a total loss of power occurred. During forced landing the aircraft struck telephone lines, a patio roof, and a parked unoccupied pickup truck.NTSB NYC86FHA02Accident · Serious injuriesFinal reportGulfstream American AA-1 · Pottstown, PAThe acft collided with an embankment short of the intended rwy. A CFI waiting on the taxiway for clearance to takeoff stated that the acft appeared to be ok about 200 ft from the threshold of the rwy. Then it appeared to slip to the left and turn 90 degrees…NTSB MIA86IA098Incident · No injuriesIncident investigationFinal reportBoeing 727 · Miami, FLDuring arrival at ft lauderdale, the aircrew attempted to extend the gear, but at first, they were unable to get a safe 'down' indication for the rgt main gear. After about one hour, they were able to insure that both main gear had extended& were locked. They…NTSB LAX86LA142Accident · No injuriesLimited investigationFinal reportHiller 12E · Poterville, CAA Hiller 12E helicopter landed hard after an eng failure. The acft was enroute to another field site at aprx 100 ft AGL and 40 KTS IAS. The eng quit abruptly and the rotor RPM decayed 100 RPM. The acft was about 2,000 pounds gwt at the time of the accident…NTSB CHI86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Gregory, MIThe newly purchased acft was being flown off of the seller's turf strip. After taking off, the acft struck 50 ft trees off of the end of the runway. The seller, who watched the takeoff, stated that the pilot overrotated the acft after lift-off.NTSB CHI86LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooklyn Park, MNUpon initial touchdown the acft bounced. In the process of 're-flaring' the acft it drifted to the egde of the rwy. The solo student plt applied full power to go-around, however, during this maneuver the left wheel hit a snowbank along the edge of the rwy.…NTSB ANC86FA035Accident · Serious injuriesField investigationFinal reportCessna A185E · Anchorage, AKAcft hit trees and power lines and crashed on city residential street following engine failure during takeoff climb. Engine driven fuel pump failed due to long term exposure to water in fuel. Over two quarts water was collected from aircraft tanks after…NTSB NYC86LA085Accident · Minor injuriesLimited investigationFinal reportRockwell 680FL · Houlton, METhe pilot-in-command landed on runway 5 which had approximately 1 inch of fresh snow. He reported that he encountered whiteout conditions during the landing & lost reference to the runway centerline. The aircraft touched down on the left side of the runway,…NTSB MKC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Lake City, ARThe flight instructor and his student touched down on the newly constructed private dirt strip in the airplane and rolled for 610 feet before the main gear bogged down. The nosewheel then cocked sideways and the airplane rolled forward to the inverted…NTSB MIA86FA097Accident · 2 fatalField investigationFinal reportMcfarland Quickie 2 · Mulberry, FLWitnesses reported that the acft was flying at a lower than normal altitude and at full throttle when something broke off the acft. The acft then rolled to the right, went almost straight up and spiraled down striking the ground inverted. Post crash…NTSB LAX86LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Apple Valley, CAA Cessna 172N nosed over on the taxiway after completing a full stop ldg on the rwy. Winds were reported from 180 deg at 18 KTS gusting to 23 KTS with peak gusts from the se at 31 KTS. UNICOM reported winds from the s at 20 KTS gusting to 30 KTS. The plt had…NTSB LAX86FA140Accident · 3 fatalField investigationFinal reportBeech A36TC · Woodfords, CAThe wx deteriorated while the acft was cruising in IMC at 17,000 ft. moderate turbulence & icing conditions in the layered clouds were reported by other nearby flying acft. The plt informed ARTCC that he 'lost the autopilot,' & the acft's course began…NTSB FTW86LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Marietta, OKDuring takeoff roll, at about 45 knots ground speed, the left main landing gear contacted a water eroded spot on the runway. The aircraft bounced and/or was pulled off the ground without sufficient speed to maintain flight. The aircraft settled and struck a…NTSB ATL86LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Stone Mountain, GAShortly after taking off at ngt, the plt encountered low visibility (vis) in fog. He attempted to return to the arpt for lndg, but the acft crashed in a wooded area aprx 3/4 mi from the arpt. A check of the plt's blood showed an alcohol lvl of 0.17 grams…NTSB ATL86LA094Accident · Serious injuriesLimited investigationFinal reportShaffer KR-2 · Mobile, ALThe pilot lost control of the aircraft during cruise flight while attempting to close the cockpit canopy which inadvertently unlatched. The aircraft entered a spin and the pilot was unable to recover prior to ground impact. The aircraft was an experimental…NTSB ATL86IA098Incident · No injuriesIncident investigationFinal reportCessna 404 · Mc Rae, GADuring cruise flight pilot heard loud bang from right engine and right propeller feathered. Aircraft was diverted and landed with no further damage and no injuries to the pilot. Subsequent teardown of engine revealed fractured connecting rod. Examination of…NTSB SEA86LA101Accident · No injuriesLimited investigationFinal reportBeech 76 · Troutdale, ORThe acft was substantially damaged during a hard landing performed by the multi-enging student during a dual instructional flt.NTSB NYC86FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Williamstown, NJThe plt executed VOR rwy 09 apch to the arpt at night and during low visibility conditions that ranged from 100 to 400 feet due to fog. The acft first collided with a house, followed by two parked cars and then main impact with a second house. The accident…NTSB MIA86LA096Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lake Wales, FLThe plt stated that he landed long and was unable to stop. The acft ran off the end of the runway into a lake.NTSB MIA86FA095Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Florida City, FLThe acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the…NTSB DEN86LA100Accident · No injuriesLimited investigationFinal reportCessna A185F · Bozeman, MTAccording to the plt, shortly after touchdown, the right wing came up and the acft seemed to be pushed to the left. The plt said before he regained control, the left wing and horizontal stabilizer contacted the ground. The plt later learned that a Boeing 767…NTSB DEN86FA099Accident · Serious injuriesField investigationFinal reportCessna 401 · Silver City, NMThe 2 com rated plts were returning from a part 135 flt at night. The fuel tanks were inadvertently not switched from mains to aux. Fuel starvation occurred when acft was at low altitude. Insufficient altitude remained to restart the engines. Acft impacted…NTSB DCA86AA021Accident · 3 fatalFinal reportEmbraer EMB-110P1 · Alpena, MIDrg arrival at 2125 EST, simmons airline flt 1746 was adzd by wurtsmith afb apch ctl that the 2052 EST wx at phelps collins arpt was: sky partially obscd, ceiling 100' overcast, vis 1/2 mi with lgt drizzle & fog, & to expect an ILS apch. However, at 2119, a…NTSB CHI86FA102Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Frankfort, MIThe plt was taking off from his local arpt and local residents described conditions of 100 ft vis in heavy ground fog. After lift-off he began a left turn toward a 300 ft high ridge topped by 100 ft trees. The acft struck the tree tops, the plt lost control…NTSB ATL86IA093Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-31 · Charleston, SCThe acft landed on rwy 15 at 2357 EST. The rwy was wet from heavy rain & thunderstorms. Braking was ineffective and the acft failed to stop. The capt steered rt into the mud to the rt side of the overrun. Post accident review of the flt data recorder showed…NTSB LAX86LA139Accident · No injuriesLimited investigationFinal reportCessna A150K · Hanakuli, HIThe acft was ditched in pacific ocean after the eng quit. Recovered inboard portion of left wing showed gas tank cap missing. The ditching occurred 1 mile from shore and the occupants were picked up unharmed after 20 minutes in the water. The plt said the eng…NTSB CHI86FER01Accident · Serious injuriesFinal reportCessna 172H · Williams, MNThe plt made a low pass over a frozen, snow covered lake, then intended to make a climbing left turn. He rprtd the wx & light conds as 'slight haze, poor horizon visibility, very white out.' As the plt contd with what he thought was a climbing turn, the acft…NTSB ATL86FA092Accident · 1 fatalField investigationFinal reportPiper PA-23 · Toledo, OHN3124P crashed while attempting an ILS approach to rwy 07 at express airport in Toledo, OH. The pilot had attempted an approach at metcalf airport but missed the approach because of the weather. The aircraft crashed about 1 mile short of the airport in a…NTSB SEA86LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Morgan, ORDuring takeoff from a soft rough barley field during a crosswind the pilot rotated prematurely. The aircraft settled back onto the field striking the nose gear first and then flipped inverted.NTSB NYC86LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · White Plains, NYDuring the flight the plt noted a full discharge on the ammeter and a open alternator circuit breaker after ATC reported loss of transpx signal. The circuit breaker would not reset. The low voltage light did not come on. He diverted the flight to White Plains…NTSB BFO86FA020Accident · No injuriesField investigationFinal reportCessna 172H · Upper Marlboro, MDSince the fuel gages in the acft were known not to be accurate, the plt measured the amount of fuel in each tank with a dipstick before departing. He determined that he had 18 gallons for the 2 hours of flying he planned to do and based on a fuel consumption…NTSB ATL86LA090Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Memphis, TNAmerican airlines flight 502 experienced a fire warning light illumination on no. 1 engine as the aircraft was climbing through 6000 feet. The pilot declared an emergency and returned to Memphis. Following the landing the pilot ordered a passenger emergency…