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 CHI83LA264Accident · No injuriesLimited investigationFinal reportBell 47-G3B · Litchfield, MNThe helicopter rolled over while attempting a takeoff after servicing from a truck platform for a spraying operation. The hose used to put the chemical spray into the hopper was not removed. When takeoff was attempted the acft was tethered to the ground rig…NTSB CHI83LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Anoka, MNThe acft touched down off the runway and nosed over. The low time student pilot stated that on his 6th and final landinghe landed 'slightly off runway.' When the nose wheel was lowered it touched down in soft sand and the acft nosed over. The student pilot…NTSB CHI83LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Crookston, MNThe acft collided with the ground after takeoff. The pilot said the acft lost power and felt sloppy at about 350 ft AGL.he added power but maximum obtainable was 2000 RPM as opposed to 2300. The pilot said he tried to drop the load but the load remained with…NTSB CHI83LA252Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Blackduck, MNThe acft made a hard landing in an alfalfa field after loss of engine power. During an enroute portion of this flt the pilot stated that oil consumption was excessive. He planned an intermediate stop for that reason. Before reaching the intermediate stop the…NTSB CHI83LA257Accident · Minor injuriesLimited investigationFinal reportMooney M20J · St. Paul, MNThe CFI stated that the student (private pilot) was informed of a crosswind condition after the acft was established on the base leg. The CFI stated that after touchdown the acft yawed sharply to the left and proceeded toward the grass area adjacent to the…NTSB CHI83LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Roseau, MNDuring an aerial application flt, the acft collided with power lines during a pull-up from a swath run. The plt reported no preimpact malfunctions.NTSB CHI83LA242Accident · No injuriesLimited investigationFinal reportCessna 206A · St. Cloud, MNThe acft bounced during a hard landing and nosed over. The weather was VMC but there was a crosswind on rwy 31 which wasthe active rwy. The wind was 290 degrees at 11 KTS with gusts to 19 KTS. After 2 bounces during which the acft moved about 20-25 ft to the…NTSB CHI83LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Lake, MNThe acft collided with a railroad sign during approach to a private airstrip. The weather was VMC but there was a cross-wind of about 15 KTS and a low sun creating sunglare. The acft drifted to the south side of the rwy due to wind and collided with the sign.…NTSB CHI83LA240Accident · No injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNThe acft veered off the rwy during landing. The landing was on rwy 07. The wind was from 360 degrees at 15 KTS. A thunderstorm was in the area and some turbulence remained. The pilot stated he felt one good bump at 50 AGL and from that point to touchdown very…NTSB CHI83LA223Accident · Serious injuriesLimited investigationFinal reportSchreder HP12A · Stanton, MNThe pilot performed his preflight checks including a flight control check. After lift off the pilot could not control the pitch of the glider. As the pitch increased to about 30 degrees he elected to release the tow cable from the tow aircraft. The glider…NTSB CHI83LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Mora, MNThe acft ran off the departure end of the rwy into a cornfield during an aborted takeoff. The pilot stated that after liftoff the stall warning came on and the acft would not accelerate or climb. He pulled the power off and aborted the takeoff. The acft…NTSB CHI83LA201Accident · No injuriesLimited investigationFinal reportCessna 172 · Austin, MNThe acft ran off the right side of the rwy during landing flare. The right wing tip struck the ground and the acft cartwheeled. The wind was reported as from 010 degrees at 25 KTS gusting to 33 KTS.NTSB CHI83LA197Accident · Serious injuriesLimited investigationFinal reportHolmes XTC2 · River Falls, MNThe acft pulled up steeply after takeoff and stalled. The acft crashed back on the rwy. The pilot said he reduced power after takeoff and the acft stalled. He also said if he had not reduced power the accident would not have happened.NTSB CHI83LA204Accident · No injuriesLimited investigationFinal reportCessna 180J · Ely, MNThe plt was practicing water takeoffs & landings. He stated that during takeoff a gust of wind caught the acft lifting the right wing. The left wing struck the water & the acft flipped inverted.NTSB CHI83LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Minneapolis, MNAfter takeoff, the plt elected to practice touch-and-go landings. After about 5 landings, the eng lost power while the plt was turning on a base leg for rwy 17 at about 400 ft AGL. He tried to restart the eng. However, the left wing hit the tops of trees &…NTSB CHI83FA180Accident · 2 fatalField investigationFinal reportCessna 185F · Pillager, MNThe acft collided with the ground after dragging the right wing in the water 3 times. The acft disappeared from view of witnesses around a point of land in the lake. The acft was heard producing power up to a 'few second' before a 'thud' was heard followed by…NTSB CHI83LA175Accident · No injuriesLimited investigationFinal reportHughes 300C · Hollandale, MNThe pilot said 'that upon takeoff from truck, pulled too much power so he lost too much RPM, hit somewhat solid ground, slid 10 feet and stuck in the mud, the helicopter stopped immediately and flew apart.'NTSB CHI83LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Alexandria, MNThe pilot decided to make a precautionary landing after he heard a noise or bang which he thought was the muffler. The pilot made a decision to land on a runway which had an unfavorable wind. Control was lost when a gust of wind raised the left wing. The…NTSB CHI83IA162Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Minneapolis, MNWhile in curise flight a tire on theleft main landing gear blew out. On landing roll a fire erupted in the area of the left main landing gear, which was extinguished by airport crash rescue personal.NTSB CHI83FA156Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Miltona, MNPrior to separting, the plt was advised of low ceilings & poor visibility over the entire proposed route & was advised that VFR flt was not recommended. In a discussion with persons at fergus falls, MN, he stated that he was going to follow the highway. About…NTSB CHI83LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Warren, MNThe pilot was practicing a short field takeoff. The acft came off the ground nose high at low airspeed. At about 40 feetagl the pilot retracted the landing gear and while doing this he inadvertantly raised the flaps. The acft mushed back tothe surface. The…NTSB CHI83LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sandstone, MNThe pilot reported that soon after touchdown, the aircraft began to veer to the left and attempts to correct the situation failed. Subsequently, the aircraft impacted a snowbank and was damaged.NTSB CHI83LA140Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Princton, MNThe pilot said that at 6000 feet MSL the engine began to miss and got worse. He tried to correct the situation but could not. He requested and was given vectors to the princeton arpt. The arpt was closed at the time due to snow covered ruts on the rnwy and…NTSB CHI83LA136Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Northome, MNThe acft collided with a snowbank while landing on the airport at Northome, MN. There was no UNICOM at Northome and NOTAMS advised the runway was closed. The weather was VMC but overcast with freezing rain. The pilot reported he made a precautionary landing…NTSB CHI83LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garden City, MNThe pilot elected to land to the west on a blacktop road. After touchdown, he initiated a go-around. During the go-around, the aircraft collided with the top wire of a power line on the right side of the road and crashed. The pilot estimated that the wind was…NTSB CHI83LA130Accident · No injuriesLimited investigationFinal reportCessna T-210L · Farmington, MNDuring an IFR flight, the engine lost power at 4000 ft MSL and the pilot was unable to restart the engine. He broke out of the clouds at a low altitude in the vicinity of a lake that was covered with ice. The pilot did not know the condition of the ice, so he…NTSB CHI83LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ely, MNAbout 2 min after takeoff, at about 1,000 ft AGL, the eng siezed. The plt then glided onto a frozen lake. The acft did not have a current annual inspection. The last oil change recorded was during the annual on 7/15/81. Engine teardown revealed severe…NTSB CHI83LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Worthington, MNThe plt reported that he was able to maintain visual ground contact after he left blue earth, MN. However, as he was following an interstate highway near Worthington, MN, the visibility decreased. He attempted to get to the arpt at Worthington, but saw a…NTSB CHI83LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNDuring final the acft started to drift & the rate of descent increased. The plt was late in adding power & the acft touched down 75 ft short of the rwy in 20 inches of snow & nosed over.NTSB CHI83LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Campbell, MNThe pilot made a forced landing on a country road during a cross-country flight. During the ground roll the acft left the road and collided with a ditch collapsing the nose gear. The two occupants were not injured. The pilot started this flight the previous…NTSB CHI83LA082Accident · No injuriesLimited investigationFinal reportMaule M4-180C · Brainerd, MNThe aircraft experienced power failure during slow descent to enter traffic pattern after a test hop. A landing was accomplished in an open snow covered field. During the roll-out in the 18 inch deep snow the aircraft nosed over. Preliminary examination of…NTSB DCA83AA013Accident · 1 fatalFinal reportConvair 580-11-A · Brainerd, MNDuring arrival, the acft was landed about 1725 ft beyond the rwy threshold. The touchdown was made with the right wing down & the right main gear about 37 ft from the right edge of the rwy. After touchdown, the acft continued to the right & the right…NTSB CHI83LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Red Wing, MNThe pilot stated that while enroute to Red Wing, MN he ran into deteriorating weather and the engine started to run rough. He decided to execute a precautionary landing into a hay field rather than encounter darkness and adverse weather conditions with a…NTSB CHI83LA036Accident · No injuriesLimited investigationFinal reportQuickie · Red Wing, MNThis was the pilot's first flight in the new home built aircraft. He had no previous flight time in this make and model and had no previous flight experience in aircraft with canard airfoils. He stated that after lift-off, the aircraft began to porpoise, and…NTSB CHI83LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marshall, MNDuring a preflight weather briefing, the pilot was warned that VFR flight was not recommended. Also, a fixed base operator warned him of the weather (there were patches of ground fog). After takeoff, fog was encountered at about 200 to 500 ft AGL. During a…NTSB CHI83LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Sacred Heset, MNWhile on a flight to photograph farms, the engine lost power and the pilot was unable to get it restarted. An emergency landing was made in a bean field that was soft from recent rains. Shortly after touchdown, the aircraft nosed over. After the accident,…NTSB CHI83LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNWhile performing a touch-and-go landing, the pilot used a higher than normal speed. After touching down, the aircraft became airborne again, then began to porpoise. After about the 3rd or 4th bounce, the nose gear failed.NTSB CHI82FA365Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Mankato, MNAt about 1530 CDT, the aircraft departed mattoon, IL on a flight to Mankato, MN. However, the pilot landed at albert lea, MN where he refueled and topped the tanks with 45.5 gal of fuel. The aircraft's usable supply was 48 gal. While refueling, he reportedly…NTSB CHI82DA351Accident · Serious injuriesFinal reportPiper PA-28-161 · Angle Inlet, MNJust after takeoff, the aircraft lost altitude and crashed beyond the departure end of the runway. The pilot stated that just after takeoff, the stall warning was heard. Also, he reported that when the aircraft reached an altitude of about 60 ft AGL, there…NTSB CHI82DA361Accident · 1 fatalFinal reportCassutt Mark II · Blaine, MNWitnesses at the accident site stated that after takeoff, the engine on N8937 began to sputter and the aircraft stalled at an altitude of approximately 50 to 100 feet AGL.NTSB CHI82DA337Accident · Serious injuriesFinal reportCessna 172H · Hackensack, MNThe pilot tookoff from a 2000 foot grass strip with 3 passengers and the aircraft near gross weight. The grass was 4-6 inches high. He made the takeoff and attained a height of 50-60 feet when gusts from a tree line raised the right wing. With the aircraft…NTSB CHI82DA336Accident · Serious injuriesFinal reportBell 47G-5A · Waconia, MNJust prior to the flight, the helicopter had been released by the maintenance section after troubleshooting a squawk concerning a "binding collective." The student and instructor (CFI) departed on a local flight and flew about an hour practicing precision…NTSB CHI82DA320Accident · No injuriesFinal reportPiper PA-22 · Houston, MNThe pilot obtained a weather briefing before departing on a cross-country flight from west bend, WI to waseca, MN. Reportedly, the ceiling was 2500 to 3000 ft or better (as briefed) until after crossing the Mississippi river. The weather then began to…NTSB CHI82DA319Accident · No injuriesFinal reportCessna 120 · St. Paul, MNPilot did not stow starter crank properly. During a landing the aircraft touched down almost sideways, went down on a wingtip and up on its nose. The starter crank was found jammed in the rudder controls.NTSB CHI82DA347Accident · No injuriesFinal reportBell 47G-4A · Near Brooten, MNThe pilot had been engaged in a spraying operation for 2.5 hrs when he returned and landed on a flat bed type trailer to service the helicopter. After the hopper was serviced with 60 gal of herbicide, the pilot began his take off. He stated that just after…NTSB CHI82DA301Accident · No injuriesFinal reportHiller 12E · Palisade, MNAircraft lost power, pilot autorotated at 20 feet AGL. Made hard forced landing and aircraft rolled over. Piston rod failed because cap bolt was undertorqued.NTSB CHI82DA300Accident · No injuriesFinal reportPiper PA-28-161 · Brainerd, MNWhile on the landing roll, the engine quit operating and the pilot turned off onto a taxiway. He then attempted to restart the hot engine. During this time, smoke began coming from under the engine cowling. The pilot exited from the aircraft and noted a small…NTSB CHI82DA296Accident · No injuriesFinal reportBeech B19 · Le Suer, MNThe aircraft landed short of the runway collapsing the nose gear and damaging the propeller.NTSB CHI82DA289Accident · No injuriesFinal reportCessna 150 · Caledonia, MNThe pilot stated that the wind was from about 135 deg at 10 KTS. He stated he made a mistake and landed on runway 31 instead of 13. Reportedly, his touchdown was too FAR down the runway for a safe landing. He initiated a go-around but the stall warning horn…NTSB CHI82DA286Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Brooklyn Park, MNThe pilot took off from a 900 ft sod airstrip with a reported 6 kt head wind. He stated that there was not enough power to climb and the aircraft remained about 20 to 30 ft AGL. Due to the proximity of obstacles a forced landing was made in an open field…