NTSB investigations, MN
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 WHERE c.\"eventStateOrRegion\" = 'MN' AND c.\"eventCountry\" = 'USA' 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 WHERE c."eventStateOrRegion" = 'MN' AND c."eventCountry" = 'USA' 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 CHI84LA199Accident · Serious injuriesLimited investigationFinal reportMeyers LIL Toot · White Bear Lake, MNPlt reported power loss while on initial climb. The left wing contacted the ground and the acft cartwheeled. Examinationof aircraft by FAA disclosed no malfunction of aircraft or of powerplant.NTSB CHI84IA196Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-40 · Minneapolis, MNDuring climb from FL330 to FL370 the 1st officer saw sparks and smoke coming from the left side panel under his glare shield. Cockpit lights were turned off and smoke stopped. Flt returned to Minneapolis and landed without incident. Inspection of the acft…NTSB CHI84LA185Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Minneapolis, MNThe plt was in the process of buying the Cessna 172. He took off on a local flt and after doing some airwork, he returned to the arpt. On final apch to rwy 27L, the acft was observed at a low alt. It continued descending and collided with microwave landing…NTSB CHI84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Boyd, MNThe acft was circling a field at about 400 to 500 ft AGL in at least a 40 degree bank when it stalled. The pilot added power and lowered the nose, as the acft was recovering from the stall it impacted the ground and nosed over.NTSB CHI84LA173Accident · No injuriesLimited investigationFinal reportBeech A36 · Minneapolis, MNThe acft touched down hard during the landing. The nose gear collapsed and the acft slid to a stop. The plt said he was not able to arrest the sink rate of the acft with power during the landing flare.NTSB CHI84LA172Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winona, MNAfter landing, the plt was turning left onto the taxiway when the wind lifted the right wing and tail of the acft. The acft nosed over.NTSB CHI84FA169Accident · 4 fatalField investigationFinal reportCessna 172RG · Woodbury, MNThe acft collided with a radio antenna support cable at aprx 171 ft AGL during low altitude maneuvering in snow showers. One witness stated that the heaviest snow showers were in the vicinity of the accident site. A policeman saw the acft over a field near…NTSB CHI84LA116Accident · Minor injuriesLimited investigationFinal reportNavion A · Newport, MNThe acft engine failed when the plt applied carburator heat to try to 'cure' a rough running engine. Post accident investigation revealed a hole in the left muffler and shroud allowing burnt exhaust gases to enter the carburetor when carburetor heat was…NTSB CHI84LA097Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Faribault, MNThe acft landed in a snow covered field following a partial power loss. The plt stated that he performed a preflight which included checking the fuel for contamination. Post accident investigation revealed water in the gascolator and icein the fuel lines near…NTSB CHI84LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit Lakes, MNThe acft collided with a snow embankment 15 to 20 ft short of the rwy on final approach. The acft got low and slow on final according to the instructor and he became concerned about a hard landing. As he advanced the throttle the acft hitthe embankment. The…NTSB CHI84LA089Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Hawley, MNThe acft ran into a snowbank during the landing roll and flipped over. The plt stated that the right brake pedal cylinder froze but this could not be confirmed during the investigation.NTSB CHI84LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-33A · Crystal, MNThe acft collided with trees and a residence near the destination airport after experiencing a total non-mechanical loss of power resulting from fuel starvation. The pilot reported he had estimated the fuel on board by a visual inspection of the tanks. This…NTSB CHI84LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sauk Rapids, MNThe plt stated that while landing on a snow covered field one of the landing skis broke when it struck a dirt mound below the snow. The acft cartwheeled and flipped over.NTSB CHI84LA075Accident · No injuriesLimited investigationFinal reportPiper J-4E · White Bear Lake, MNThe ski-equipped acft suffered landing gear failure during a landing on a snow covered turf rwy. The landing gear separated when an attach point failed. The plt gave fatigue failure as a reason for the failure.NTSB CHI84LA069Accident · No injuriesLimited investigationFinal reportCessna U206F · Eveleth, MNThe plt reported that after taking off, the cabin began to fill with smoke. He returned to the arpt for a precautionary landing; however, during touchdown, the left wing collided with a snowbank beside the rwy. An exam of the acft revealed that with the eng…NTSB CHI84LA059Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Brainerd, MNAfter making a vor/dme apch, the plt circled to land on rwy 23 in wx conditions of light snow & fog. The terrain & rwy were covered with snow. The plt tried to contact Brainerd UNICOM to have the rwy lights turned up, but he received no response. He could…NTSB CHI84LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Northfield, MNThe plt stated that while enroute at an alt of 3000 ft MSL the eng failed. He also stated that all attempts to restart the eng failed so he proceeded to make an emergency landing. Investigation revealed a manufacturing defect in the left magneto; the body…NTSB CHI84LA045Accident · Minor injuriesLimited investigationFinal reportMooney M-20K · Buffalo, MNThe acft collided with trees during an approach on a dark night. The weather was VMC and the plt canceled his IFR flt plan 15 miles east of the arpt. The plt approached the arpt in a normal VFR pattern but on final approach he got an illusion from the lights…NTSB CHI84LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Mankato, MNThe plt received 2 wx briefings before the flt & was advised that VFR flt was not recommended. Prior to departing, the 50 gal fuel sys was serviced with 35 gal of fuel. The plt reported that during the flt, he descended the acft thru a hole in the clouds…NTSB CHI84LA043Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gatzke, MNThe acft collided with the ground when the pilot attempted a low level turn.NTSB CHI83LA439Accident · No injuriesLimited investigationFinal reportCessna 206 · Eveleth, MNWhile returning from a fishing trip in ontario, Canada, the plt landed at crane lake, MN, where he cleared customs & had 10 gal of fuel added to the right fuel tank. He then flew to Eveleth, MN, aprx 90 mi away. From Eveleth, he proceed toward ely lake, MN.…NTSB CHI83FA437Accident · 1 fatalField investigationFinal reportJilek-Smith Miniplane DSA-M3 · Rush City, MNThe plt was performing a high speed taxi test on rwy 33 when the acft became airborne. After lift-off, it climbed to an alt of aprx 50 ft & went into a left turn. It continued in a nose high attitude until it turned about 180 deg then crashed. One witness…NTSB CHI83LA409Accident · No injuriesLimited investigationFinal reportCessna 172M · Grand Marais, MNThe plt took off from the departure point after an unexpected 1/2 hr delay. By the time he arrived at his destination, it was dark. No rwy lighting sys was installed, so someone at the arpt drove a car to rwy 27 to light up the approach end with the head…NTSB CHI83FA407Accident · 2 fatalField investigationFinal reportCessna 152 · Anoka, MNThe plt rented the acft & reported that he & his friend would be going on a local flt. A witness stated that he saw the acft fly over at an estimated 1000 to 1500 ft AGL. Reportedly, the acft was in level flt when the plt 'cut' the power, the acft 'nosed up a…NTSB CHI83LA405Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Halstad, MNThe acft landed long and collided with an embankment at a private farm strip. The pilot stated he landed on rwy 35 and the wind was from 170 degrees at 5-10 KTS.NTSB CHI83FA393Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Graceville, MNWhile spraying a field adjacent to a house the acft struck a guy wire which had been strung between a 82 ft tower on the house & a 28 ft pole supported by wires.NTSB CHI83LA389Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Canton, MNThe acft collided with a tree about 20-30 ft AGL in IMC weather after calling rochester approach at 1244 CDT to say that he was lost and in a thunderstorm. The plt was not instrument rated. Radio contact was lost at 1247 CDT. The flt originated in alton, IL…NTSB CHI83LER04Accident · No injuriesFinal reportCessna 170A · Crystal, MNAs the plt applied brakes the acft veered off to the right. He applied left rudder & left brake to no avail, & the acft ground-looped off the right side of the rwy. The left brake outer lining was missing. There were two rivets missing & one rivet had broken.…NTSB CHI83LER03Accident · Serious injuriesFinal reportBoeing A75N1 · Sabin, MNAcft collided with power lines.NTSB CHI83LER02Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring takeoff the eng lost power & the acft crashed landed collapsing the gear. The crankshaft, P/N631716, had broken in the cheek area between #2 & #3 crank throws. 1 month prior to this accident the acft had collided with a fence. Afterinstalling a new…NTSB CHI83LA376Accident · No injuriesLimited investigationFinal reportBeech S35 · Austin, MNThe plt started to takeoff on rwy 35 with a wind from 300 deg at 19, gusting 25 KTS. During the takeoff roll, the right door popped open & the acft veered to the left. Reportedly, the plt intended to continue the takeoff (to circle, land & fix the door).…NTSB CHI83FER01Accident · No injuriesFinal reportGoodyear FG1D · Crystal, MNThe plt reported that during the takeoff roll, there was a slight loss of manifold pressure. This was followed by a loud 'misfire', a futher loss of manifold pressure & a drop in the eng RPM. With an estimated 2000 ft of rwy remaining, he elect to abort &…NTSB CHI83LA339Accident · No injuriesLimited investigationFinal reportCessna 182 · Rochester, MNWhile en route, the engine lost power & the plt was unable to restart it. During a forced landing on a road at dusk, the vertical stabilizer struck a wire. Aprx 16 inches was cut off the top of the stabilizer & the rudder was torn loose from the hinges.…NTSB CHI83LA338Accident · No injuriesLimited investigationFinal reportKane Bush BY Mustang 2 · Winona, MNThe plt initiated a takeoff on a 2000 ft grass strip. He stated that the takeoff was normal until it became apparent that the acft would not climb out of ground effect. Since the go/no go decision point had been passed, he attempted to climb straight ahead.…NTSB CHI83LA332Accident · No injuriesLimited investigationFinal reportCessna 188B · Crookston, MNThe acft collided with a barley crop during a forced landing on a narrow dirt road. The acft had lost power after takeoff for a calibration spray run. The pilot stated he took off with about 10 gallons of fuel (1/8 tank) and did not visually check the fuel…NTSB CHI83LA321Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Brooklyn Park, MNThe plt reported that he was spraying the end rows of a field when the helicopter approached some wires. He stated that he saw the wires at the last second & tried to get under them. Reportedly, the helicopter crossed below a set of power lines, but struck a…NTSB CHI83FA319Accident · 1 fatalField investigationFinal reportBellanca 17-30 · Hibbing, MNPrior to departure, the plt obtained a wx briefing & was advised to check back before departing to see if anything had developed. Reportedly, he took off at 0815 CDT, and at 0831 CDT, he radioed the Hibbing fss for wx info. The fss specialist advised that the…NTSB CHI83LA316Accident · No injuriesLimited investigationFinal reportCessna 188-B · Springfield, MNThe acft crashed into a cornfield during a takeoff to spray crops. The pilot stated that there were no mechanical problems with the acft. Investigaiton showed that the pilot attempted a takeoff on rwy 31 with a 5 kt tailwind. The acftdid not become airborne.NTSB CHI83LA310Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Hamel, MNDuring flt, the plt used fuel from 2 of 4 propane tanks, then switched to the 2nd 2 tanks & started a descent. At aprx 300 ft AGL, he tried to start the burner, but could not get a light because the pilot light was out. He attempted to manually relight the…NTSB CHI83LA306Accident · No injuriesLimited investigationFinal reportCessna 150J · Hibbing, MNThe acft collided with a ditch during takeoff roll. The takeoff was on rwy 31 with the wind from 270 degrees at 8 KTS. The plt said that at 30-40 mph he lost directional control and swerved off the rwy into a drainage ditch. The rwy was 150 ft wide and made…NTSB CHI83LA311Accident · No injuriesLimited investigationFinal reportViking Dragonfly · Flying Cloud, MNThe pilot was initiating a high speed taxi run when the acft became airborne for 500-1000 ft. when a landing was attempted the aircraft bounced.NTSB CHI83LA298Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · St. George, MNThe plt elected to land on an uncultivated farm field that had been exposed to heavy rains 2 days previously. During the landing roll-out, the acft encounter soft terrain & nosed over.NTSB CHI83LA297Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Brooten, MNThe helicopter had just lifted off of the flatbed of a truck when it started to spin. The plt lowered the collective, reduced the power & landed beside the truck. During touchdown, the main rotor blades struck the truck. An investigation revealed that the…NTSB CHI83LA294Accident · No injuriesLimited investigationFinal reportCessna 172 · Sauk Centre, MNThe acft nosed over during a precautionary landing because of weather. During the landing roll the nose gear struck a rut and the acft nosed over. The weather was IMC. The pilot did recieve a weather briefing and the weather information was accurate. The…NTSB CHI83LA288Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morris, MNThe plt reported that while he was waiting for the flagman, circling the field to be sprayed, & talking to the flagman, the acft began to sink & struck trees. The load was dumped, but the plane continued to sink to the ground. During the landing, the acft…NTSB CHI83LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Morgan, MNThe acft collided with trees while turning during aerial application. The pilot reported that the acft controls felt soft. Thinking he was stalling he reduced bank, lowered the nose and at 85 mph indicated with full power continued levelflt until a wing hit a…NTSB CHI83LA284Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Crane Lake, MNThe plt reported that while he was taking off on an easterly heading, the float plane was on the step & became airborne sooner than he expected. While he was correcting the stituation by lowering the nose, the left float dug into the water. Subsequently,…NTSB CHI83LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Minneapolis, MNThe acft ran off the end of the rwy and collapsed the nose gear during an aborted takeoff. The acft exceeded the maximum gross weight for takeoff by 190 lbs. Decision to abort was made about 2/3 of the way down the rwy. Braking was good and deceleration…NTSB CHI83IA300Incident · No injuriesIncident investigationFinal reportBeech H-35 · Graceville, MNOn landing roll on slick grass with a crosswind the acft slid to the right and the right wing tip struck a tree.NTSB CHI83LA276Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Saint Cloud, MNShortly after takeoff, the plt's door came open. He tried to close it, but was unable, so he turned back toward the arpt to land. While making a turn before landing, the eng lost power. Shortly after that, the acft started falling to the right & crashed. An…