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 CHI85LA200Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Golden Valley, MNShortly after takeoff, on the last leg on it's flight, the engine of the air cargo acft started to sputter. The plt turned the fuel selector handlr from the left tank to another position & turned on the boost pump. The engine stopped running & the plt elected…NTSB CHI85LA189Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tyler, MNPlt stated he was about to abort the takeoff during the long ground run when the acft lifted off. At 30 to 40 ft AGL acft began to sink. Acft contacted a fence post and touched down in a plowed field. Nose gear collapsed and acft nosed over. Plt previously…NTSB CHI85FA186Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Lakeville, MNThe acft was observed to enter a spin from aprx 3000 ft AGL. The acft continued the spin to ground contact which witnesses stated occurred as the acft seemed to level off. Witnesses also reported seeing the acft perform aerobatics, which included loops, prior…NTSB CHI85LA184Accident · No injuriesLimited investigationFinal reportCessna 180J · Minneapolis, MNThe plt was ferrying the acft to the anoka county arpt for radio maintenance. During the landing roll, the acft swerved off the right side of the rwy & was damaged. No preimpact part failure or malfunction was reported.NTSB CHI85LA177Accident · No injuriesLimited investigationFinal reportCessna T210L · Minneapolis, MNAfter lowering the landing gear, the pilot heard a loud 'thump'. A gear down & locked indication was not obtained, however, the main gear appeared to be down to the pilot. Upon landing the acft swerved off the side of the runway. Only the right main gear was…NTSB CHI85LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · St. Paul, MNShortly after takeoff, while climbing thru aprx 700 ft AGL, the eng developed a severe vibration & a loud 'clanking' sound. These were followed by a partial loss of power. During a subsequent forced landing, the acft's right wing hit a tree & the nose gear…NTSB CHI85LA167Accident · No injuriesLimited investigationFinal reportCessna 150M · Hutchinson, MNThe student plt was on his 2nd solo flt after being endorsed for flt in the Cessna 150 acft. During a landing, he lost directional control in winds that he reported were from 080 degs at 7 KTS. The acft went off the right side of the rwy & went in a ditch…NTSB CHI85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rush City, MNThe plt reported that he was taking off on rwy 33 with the wind from 280 deg a 18 gusting 25 KTS. After becoming airborne, the acft weathervaned into the wind. It then traveled to the left of the rwy where it settled back to the ground. Subsequently, the acft…NTSB CHI85LA144Accident · No injuriesLimited investigationFinal reportChampion 7EC · Lake Elmo, MNOn takeoff, at about 150 ft AGL, all power was lost and the pilot executed a forced landing on the airport. Post-accident inspection revealed contamination in the fuel manifold valve.NTSB CHI85LA140Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Marshall, MNThe acft contacted 10 ft high trees during takeoff from a gravel taxiway. The plt then performed a forced landing in a cultivated fld during which the landing gear separated from the acft.NTSB CHI85LA114Accident · No injuriesLimited investigationFinal reportBeech 58 · Hibbing, MNThe acft ran off the rt. Side of the rwy into a snowbank after a hard lndg. The plt stated that he was 50 ft adh & off centerline to the left at the middle marker during the instrument approach. The passg at this time said he could se the rwy off to the rt.…NTSB CHI85LA099Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Alexandria, MNThe acft on a ferry flt after an annual insp was on to climb 100 ft AGL when power began to deteriorate while manuvering to ld on an adjacent runway the acft struck a VASI installation and ground impacted no 5 lower spark plug improper installationNTSB CHI85IA097Incident · No injuriesIncident investigationFinal reportBoeing 727-51 · St. Paul, MNShortly after takeof, the aircraft experienced an uncontained 7th to 8th stage removable sleeve compressor spacer failure in the number 3 engine. Pieces of the spacer passed through the number 2 engines duct causing compressor stalls in that engine. The…NTSB CHI85LA063Accident · No injuriesLimited investigationFinal reportCessna 310R · Eden Prairie, MNPlt stated that the acft had picked up ice during the descent. He continued to state that he broke out of the clouds at 1600 ft and the windshield was covered with ice. He was able to clear a small area at the bottom of the windshield with the alcohol deice.…NTSB CHI85LA057Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Blaine, MNInvestigation revealed that the plt landed the acft on rwy 35 with winds from 130 degrees at 15 KTS gusting to 23 KTS. The acft departed the end of the 4900 ft rwy where the left fuel tank was ruptured and a fire erupted.NTSB CHI85LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Pillager, MNThe plt took off uphill on a grass rwy that was dew covered. The field was aprx 1600 ft long bordered by 50-75 ft trees. The plt stated that during takeoff roll the acft lights were flickering. He said that the acft was airborne aprx 300 ft before reaching…NTSB CHI85LA037Accident · No injuriesLimited investigationFinal reportKragnes Acrosport II · Moorhead, MNAfter 20 min flight, engine lost power due to fuel exhaustion. Plt executed forced lndg in rough field, acft nosed over on contact with uneven terrain during lndg roll. Plt stated he must have measured fuel quantity incorrectly during last refueling. Acft not…NTSB CHI85LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNOn initial climb from takeoff, the plt noted the engine cowling was loose and vibratring. Plt initiated a shallow turn back for landing but preoccupation with the cowling caused him to allow the acft to enter a steep bank. During the plt's attempts to reduce…NTSB CHI85LA016Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Blue Earth, MNDuring arrival, the plt was cleared for a vor/dme apch to rwy 31. As he continued, he intercepted a 12 mi arc. He stated that when he applied power to level off at 2800 ft MSL & no power was available. He moved the mixtures to full rich, positioned the fuel…NTSB CHI85LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · St. Cloud, MNThe plt stated that his ground speed was too fast during a landing due to no wind. During the go-around the acft collided with tree tops & crashed. The plt reported that he delayed his decision to perform a go-around.NTSB CHI85FA013Accident · 1 fatalField investigationFinal reportHarbaugh John T COUGAR-1 · St. Cloud, MNThe homebuilt acft crashed while attempting an emergency lndg in a farmers field. The final turn to land was steepened to avoid a house. The acft flipped over and contacted the ground in an inverted, left wing & nose dwn attitude which resulted in a 180…NTSB CHI85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greenbush, MNFollowing an uneventful approach and landing, the plt was taxiing back up the runway when the right engine quit. The right seat passenger immediately noted flames coming from the engine and notified the plt, who swung the acft into positon for wind to keep…NTSB CHI84LA399Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lake Elmo, MNPilot stated that he landed near the approach end of runway 13 and 'right side of aircraft collapsed.' The investigation revealed that the aircraft landed 50 feet to the right side of runway 13. The pilot recorded only a total of 4 hours of night time, 2…NTSB CHI84LA397Accident · No injuriesLimited investigationFinal reportBeech D 35 · Alexandria, MNThe acft was started with the throttle open after refueling. The plt said the acft collided with a gas hose before he could get the throttle reduced.NTSB CHI84LU011Accident · Serious injuriesFinal reportReicher FP-101 · Mankato, MNThe pilot of the ultra-light stated that he made a take-off and climbed to about 30 ft then attempted a right turn. He said the aircraft stalled and crashed into the soybean field field. The pilot reported 12 previous flights but no pilots certificate.NTSB CHI84LA378Accident · No injuriesLimited investigationFinal reportCessna 320B · Clear Lake, MNFollowing maint on an air vent the mechanic failed to secure the map compartment. The ass'y interfered with the rearward movement of the control yoke on rotation for takeoff limiting the climb rate and resulting in a collision with the trees. The flt…NTSB CHI84LA366Accident · No injuriesLimited investigationFinal reportCessna A188B · Delavan, MNThe plt stated the acft would not climb rapidly enough on takeoff to clear powerlines. Plt elected to fly under the wires instead of climbing over them and risking stalling the acft. The prop, windshield, and vert stabilizer contacted the lowest wire. Plt…NTSB CHI84LA361Accident · No injuriesLimited investigationFinal reportBeech V35B · Eden Prairie, MNPlt reported that after operating the fuel boost pump on pre-flt, he exited the acft to turn the prop by hand. During a telephone interview, he stated he could not recall removing the ignition key. After pulling the prop through 1/4 turn, the eng started and…NTSB CHI84LA357Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Rice, MNPilot stated that during the takeoff roll the acft suddenly began to pull to the left. The pilot reduced power and applied right brake and rudder to correct but the left wing struck corn stalks. Examination of the acft after the accident revealed the left…NTSB CHI84FA348Accident · 1 fatalField investigationFinal reportBell 206L-1 · Medford, MNPlt stated engine failed during cruise at an alt of 500 to 700 ft AGL. Autorotation was attempted. With collective full down rotor RPM continued to decrease while the plt maintained 60 to 70 KTS in a descent. Acft touched down with 40 to 50 KTS forward speed.…NTSB CHI84LA340Accident · No injuriesLimited investigationFinal reportHiller 12E · Big Lake, MNThe acft lost power during takeoff and rolled over during a forced landing. The pilot said the engine 'sucked up accumulated water into the gas line.' He later said water was found in the refueling truck. His recommendation: 'keep water out of gas.'NTSB CHI84FA313Accident · 1 fatalField investigationFinal reportIntermountain Mfg. Callair A-7 · Newfolden, MNThe acft crashed after completing two passes over the field being sprayed. Before takeoff the acft was loaded with 80 gals of liquid insecticide. The plts brother, who was acting as a flagman, said that the acft 'started to spiral to the ground' after…NTSB CHI84LA311Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-341G · Plymouth, MNThe co-plt, who had no experience in this model acft, began a transition from hover to climb and the acft went into a rapid rotation. Both plts were unable to stop the rotation and when the PIC tried to land, the acft struck raised ridgeswith the left skid…NTSB CHI84LA310Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNDuring a touch & go landing the acft veered to the right, exiting the runway. The nose wheel struck a manhole cover which protruded 12 to 18 inches above the ground. The acft nosed over upon contacting the cover. The student pilot stated that he had allowed…NTSB CHI84IA314Incident · No injuriesIncident investigationFinal reportBoeing 727-2M7 · Minneapolis, MNThe crew reported that they noticed a decrease in climb rate while over rapid city, SD, en route from msp to sfo at flt level 310. The plt noted fuel burn was aprx 1400 lbs ahead of schedule. In-flt inspection revealed that the inboard trailing edge flaps had…NTSB CHI84FA308Accident · 4 fatalField investigationFinal reportGrumman AA-5 · Little Falls, MNThe acft collided with the ground during a takeoff attempt. The low time plt was using a grass rwy for the 1st time without an instructor. The acft was rotated prematurely and assumed a nose high attitude. According to one witness the acft was 'behind the…NTSB CHI84LA274Accident · No injuriesLimited investigationFinal reportHughes 269B · Eden Prairie, MNThe CFI stated that while practicing a pedal turn the student pilot suddenly applied back cylic causing the tail rotor to contact the ground. The main rotor then contacted the ground and the helicopter rolled over.NTSB CHI84LA272Accident · Minor injuriesLimited investigationFinal reportHoward E. Lee Rutan Long EZ · Minneapolis, MNThe plt claimed a loss of power during takeoff. He turned and attempted a landing on the arpt. The rwy was overrun and the acft stopped in a wheat field. Post accident examination of the engine revealed no discrepancies.NTSB CHI84LA266Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Lake Benton, MNWhile on an aerial application flt, the plt was crossing under a power line when a wire caught the rudder & separated itfrom the acft. During a landing, the left wing contacted the ground 1st.NTSB CHI84LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mahnomen, MNShortly after taking off, the eng lost power. The plt stated that the eng stopped completely 'like fuel starvation.' He dumped his load of chemicals & made an emergency landing. During the landing, the acft hit a ditch & nosed over. An investigation revealed…NTSB CHI84LA254Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe plt reported that he had completed spraying 60 acres of land & was beginning a pass in another field. Half way through the spray pass the eng quit. He pulled up to clear a tree & the acft stalled into a field of sunflowers. No mechanical failure or…NTSB CHI84FA250Accident · 2 fatalField investigationFinal reportGrumman G-164B · Warren, MNN9367K was on departure and climbout to aerial application operations. N6533K was about to enter the traffic pattern to land and reload. Marks on respective airframes indicate N9367K was above and approaching N6533K from the latter's forward left quarter;…NTSB CHI84LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNPreviously, the acft had been landed in a 1000 ft fld when the eng quit during a simulated emergency while on a dual instructional flt. The instructor plt decided to leave the student there & fly the acft back to the arpt. He walked down the field & made an…NTSB CHI84LA245Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · Nimrod, MNWhile landing in an area of tall grass a skid collided with a sand ridge causing a roll over.NTSB CHI84LA241Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Goodridge, MNThe acft was forced to land in a farm pasture after the engine lost power. Post accident examination of the acft revealed that the carburetor heat control was off. The right magneto was found to be very weak. A spark could only be produced at high RPM. The…NTSB CHI84LA237Accident · No injuriesLimited investigationFinal reportHughes 269C · Boyd, MNWhile beginning a gradual pull-up at the end of a spray run, the plt was distracted by a person in a ditch & did not see the wire at the end of the field. The wire contacted the tail rotor & the helicopter began to spin. The plt reduced power & was able to…NTSB CHI84LA232Accident · Minor injuriesLimited investigationFinal reportBell 47G · Fairfax, MNThe helicopter plt turned at the end of a spray run & the acft collided with a power line. He said that because of a quartering tailwind, the helicopter was in a nose high attitude & the tail rotor hit a wire. The plt was able to make an autorotation after…NTSB CHI84LA231Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe acft ran off a road into a ditch which destroyed the main landing gear during the forced landing. The plt said oil covered the windshield after takeoff and he could not see well enough to find the airstrip so he landed on the road while looking out the…NTSB CHI84FA225Accident · 1 fatalField investigationFinal reportSchleicher AS-K13 · Stanton, MNThe tow plane and the sailplane it had towed to pattern alt collided on final approach of the pattern. The tow plane was supposed to follow the sailplane to land after it had dropped the tow rope. There was a low sun glare facing the towplt on the heading of…NTSB CHI84LA216Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes Firefly 8-24 · Burnsville, MNThe Balloon landed without incident. According to the plt, the envelope was being deflated when a gust of wind tipped the basket. The plt said he saw a young boy with his leg under the basket. The plt lifted the edge of the basket by stepping out of it to…