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 CHI87LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNThe plt stated that while practicing touch-and-go landings, he extended full flaps on final apch and maintained rwy alignment. According to the plt, the acft touched down hard and began to porpoise. A police officer witnessed the acft bounce three times after…NTSB CHI87DER06Accident · 1 fatalFinal reportBell 47G-2A · New Prague, MNAfter about a 5 min flight, the helicopter collided with the ground during a downwind turn on an agricultural turnaround. Impact was on a heading of 210 degrees. Wind was from 326 degrees at 14 KTS, gusts to 22 KTS. No evidence was found of powerplant, flight…NTSB CHI87DER05Accident · Minor injuriesFinal reportPiper PA-25 · Henning, MNAfter experiencing a rough running engine the pilot initiated an emergency landing. During the off airport landing, the aircraft received substantial damage and the pilot reported minor injuries. This was this pilot's first experience in this type of…NTSB CHI87DER04Accident · Minor injuriesFinal reportPiper PA-32-260 · Pine Center, MNAfter noticing a loss in oil pressure, the pilot initiated an emergency landing in a swamp. The aircraft impacted trees and received substantial damage. The pilot reported minor injuries. Subsequent investigation revealed that the oil sump contained several…NTSB CHI87DER03Accident · No injuriesFinal reportHiller UH-12ET · Big Lake, MNAircraft was being maneuvered for landing on a ground support trailer when it experienced a power failure. Due to high trees autorotation was made to adjacent field. Aircraft landed on rough/uneven terrain and rolled over. Investigation revealed contaminated…NTSB CHI87LA105Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Hibbing, MNThe plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first.NTSB CHI87IA100Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNThe aircraft landed uneventfully after the right engine failed during a descent. The shutdown occurred after failed antirotation pins allowed gas loads to drive normally stationary third stage vane clusters in the low pressure turbine area. Rotation of the…NTSB CHI87FA083Accident · 4 fatalField investigationFinal reportCessna 172N · Fergus Falls, MNFollowing a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions…NTSB CHI87FA070Accident · 3 fatalField investigationFinal reportMooney M20J · Waskish, MNDuring the preflight wx briefing the non-instrument rated pilot was advised that VFR flight was not recommended. Shortly before the accident, the acft was observed flying over a state highway under a low overcast in poor visibility. The acft was witnessed to…NTSB CHI87LA080Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Big Fork, MNAfter several unsuccessful attempts to takeoff from a snow-covered lake, the plt found a plowed area leading to a fish house. He taxied to the area and began to takeoff towards the east. On lift-off, the left aileron struck the top of the fish house. The plt…NTSB CHI87LA079Accident · No injuriesLimited investigationFinal reportCessna 150K · Clear Lake, MNThe plt stated that near the touchdown point a gust 'jarred' the acft and the throttle in the forward position. According to the plt, the acft 'took a steep left' and he leveled the wings, however there was not time to avoid trees which were about 100-150…NTSB CHI87LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNDuring takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed.NTSB CHI87DER02Accident · Serious injuriesFinal reportCessna 150M · Lakeville, MNThe student & instructor (CFI) were preflighting the acft to fly on a cold morning. To facilitate better eng starting, the CFI elected to turn the prop while the student 'pushed the primer in.' He told the student to check that the mag & master sws were off &…NTSB CHI87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mcgrath, MNAfter descending to maintain VFR and accumulating clear ice on both the structure and windscreen, the plt decided to make a precautionary landing. During landing in an open area, the left wing struck two apple trees and the acft became airborne again. After…NTSB CHI87LA042Accident · No injuriesLimited investigationFinal reportCessna 152II · Anoka, MNThe acft was on the fifth touch & go of the student plt training flt when a loss of power occurred at 100-200 ft AGL during climbout. The CFI had to land the acft in unsuitable terrain which resulted in substantial damage to the acft. Examination of eng and…NTSB CHI87DER01Accident · No injuriesFinal reportCessna 185D · St. Paul, MNDuring landing after the skis had touched down the acft began to swerve. As the acft left the rwy the plt attemtped a go-around, however, one ski dug into the ground and the acft flipped over onto it's back. Post accident exam revealed the right ski had…NTSB CHI87LA031Accident · No injuriesLimited investigationFinal reportCessna 150F · Nicollet, MNThe plt experienced fuel exhaustion and made an emergency forced landing. With the help of a farmer he refueled the acft and got it to nearby highway 14, where he attempted to takeoff while state police provided road blocks. While on takeoff, the plt lost…NTSB CHI87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Minneapolis, MNThe pilot flew for an hour trying to get the gear extended, but was unable. After making a gear up landing, an exam revealed the centering cam on the left side of the nose gear was bent and broken. This could have caused the gear to jam and not extend.NTSB CHI87LA017Accident · No injuriesLimited investigationFinal reportCessna 150M · Ramsey, MNThe newly certficated pilot thought his fuel gages were not indicating properly and did not dip the tanks during preflight. On the last leg of the round robin flt fuel exhaustion occurred and the acft nosed over during the forced landing. The plt reported he…NTSB CHI87FA015Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Becker, MNThe helicopter (hel) was being used on an external load opn to psn a 2500 lb ventilator to the roof of a bldg. On the next to last load, the plt radioed that he noted a momentary illumination of the fuel bypass advisory light. He elected to cont the opn &…NTSB CHI87FA012Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Int'L Falls, MNThe acft was observed maneuvering over the passengers house just prior to the accident. The plt circled the residence with the acft wings almost perpendicular to the ground at an alt between 150 and 200 ft AGL. According to witnesses, as the wings reached the…NTSB CHI87LA002Accident · No injuriesLimited investigationFinal reportLet L-13 · White Bear Lake, MNThe plt reported that he entered the traffic pattern for rwy 30 at aprx 900 ft and completed a right turn to base. The plt stated that while on base, he realized the aircraft was too high and deployed the spoilers halfway. As he turned to final, he stated…NTSB CHI86LA232Accident · Serious injuriesLimited investigationFinal reportMcculloch J-2 · Rush City, MNJust after lift off, while taking off with a tail wind, the plt diverted his attention to the instrument panel & did not realize the gyrocopter was going into an unusual attitude. He said that when he did notice what had happened, he 'just got ready for the…NTSB CHI86LA228Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · St. Paul, MNAt the end of an uneventful flight the pilot lowered the landing gear and noted three gear down indicator lights. Upon landing rollout the nose gear collapsed. An inspection following the accident revealed that a hydraulic leak was present near the hydraulic…NTSB CHI86LA189Accident · No injuriesLimited investigationFinal reportRobinson R22A · Eden Prairie, MNThe CFI reported that upon liftoff, the aircraft began drift left. When he tried to correct this condition he found that he could not move the cyclic to the right. While drifting to the left, the left rear skid hit the ground, the aircraft tilted back and the…NTSB CHI86FER16Accident · No injuriesFinal reportAero Commander Callair A9B · Argyle, MNWhile setting up for a swath run the pilot struck the ground in a wings level descent. He stated that a 'whirlwind' or 'downdraft' prevented him from pulling up in time to pre-vent impact with the ground.NTSB CHI86FER15Accident · No injuriesFinal reportSamuel R. Hoskins Q-200 · Eden Prairie, MNAircraft was being test flown following ground adjustment of rudder control cables. During the flight rudder control was lost when rudder bearing blocks detached from their mounting surfaces. Pilot was unable to maintain directional control during landing…NTSB CHI86LA180Accident · No injuriesLimited investigationFinal reportCessna 152 · Duluth, MNThe student pilot landed the aircraft on a road and it collided with a road sign after experiencing fuel exaustion on a solo cross-country flight. The flight lasted approximately 3.2 hours and covered 289 miles. The student stated that both fuel tanks looked…NTSB CHI86FER14Accident · No injuriesFinal reportBell-Campbell CHG-2 · Brooklyn Park, MNAccording to the pilot after making three quarter-mile passes over the field the engine quit and he was forced to make an emergency landing in a field. The pilot stated, prior to takeoff the helicopter had been refueled by a ground crew member. According to…NTSB CHI86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Benson, MNThe pilot reported that he ran the right fuel tank dry before switching to the left tank in cruise flight. On final approach for a landing the engine began to falter and quit running shortly thereafter. The aircraft was landed short of the runway gear up in…NTSB CHI86FER13Accident · 1 fatalFinal reportBell 47G-5 · Elrosa, MNThe helicopter was seen flying at a low altitude by witnesses and appeared to be flying straight and level and sounded normal. The helicopter impacted the ground in a northeasterly direction, 180 degrees from it's observed flight path. There were no witnesses…NTSB CHI86FER12Accident · Minor injuriesFinal reportPiper PA-25-235 · New Richland, MNThe aircraft performed a forced landing which resulted in substantial damage. Water was found in the fuel system. Water was also found in the underground fuel supply used to refuel the crop duster.NTSB CHI86LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Int'L Falls, MNAcft struck power lines on approach to private airstrip. The plt stated that an air pocket pulled the plane down. Weather at international Falls, six miles from the accident site, reported winds at 7 KTS with no gusts. The plts flt time was not reported.NTSB CHI86LA161Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, MNThe plt was attempting to takeoff from a field when the accident occurred. During takeoff, the acft failed to clear trees at the departure end of the field. The acft contacted the trees and descended to the terrain. The plt had diverted to this field during a…NTSB CHI86LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grand Rapids, MNThe CFI and sp were returning from a transition. Enroute the #3 exhaust valve push rod failed. When the CFI smelled 'something burning' she shut down the engine. During the descent struck power lines. Acft ld in swampy terrain and nosed over inverted.NTSB CHI86FER11Accident · Serious injuriesFinal reportBell 47G-5 · Brooten, MNAccording to the pilot, the helicopter collective control failed to respond to a climb input to level off after a descent for an agricultural swath run. Fire and impact damage to the helicopter was extensive, however one broken rod end in the collective…NTSB CHI86LA153Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Breckenridge, MNAircraft collided with a truck while engaged in aerial application work. Pilot was unable to maintain control and the aircraft collided with terrain after an uncontrolled descent. Investigation revealed that the aileron had separated due to the collision.NTSB CHI86FER10Accident · 2 fatalFinal reportAeronca 65-TAC · White Bear Lake, MNThe acft stalled & crashed following the initial takeoff. Witnesses stated that the plt aborted the 1st takeoff attempt. During the 2nd takeoff witnesses said that the acft nose was never lowered from a nose high position. After the acc the elevator trim was…NTSB CHI86FA146Accident · 3 fatalField investigationFinal reportBellanca 7GCBC · E. Grand Forks, MNWitnesses rprtd the acft had just left the restricted lndg area (rla) when it entered a climbing maneuver, then dscndd &impacted the gnd & burned. Two witnesses said it went straight up, then straight down, before it crashed. Another 2 wit-nesses noted a pwr…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 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 CHI86FER06Accident · 1 fatalFinal reportCessna 180 · Brainerd, MNA witness reported seeing the floatplane descending 'abnormally' in a nose low attitude just prior to water impact. The plt reported making the apch to the lake in a nose up attitude with partial power on. The plt remembers no further events leading up to the…NTSB CHI86FER05Accident · Serious injuriesFinal reportCessna A188B · Greenbush, MNThe plt reported that the acft contacted a soft spot, caused by recent rains, in the sod runway during takeoff. The acft decelerated, however, the plt attempted to continue the takeoff as not enough runway remained to abort. The acft did not obtain sufficient…NTSB CHI86FER04Accident · Serious injuriesFinal reportPiper PA-28-181 · Brooklyn Center, MNWhen the aircraft experienced a total power failure due to fuel exhaustion and the pilot determined that it was not possible to make a forced landing on an airport, the pilot elected to land on a highway. The pilot stated that when he was not able to land in…NTSB CHI86LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172-RG II · St Paul, MNDuring climbout after t.o. and passing thru 4000 ft smoke began to enter the cabin. Plt declared an emergency and turned toward arpt. Eng then began to shake violently. Acft was cleared to ld but plt continued to a point four mi past base leg, attempted to…NTSB CHI86IA115Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Minneapolis, MNN508US was operating as nwa flt 150. The captain stated after the incident that the flt was uneventful until landing. Upon landing and spoiler deployment, the acft pitched up abruptly, to an attitude of 10 degrees. The landing was completed without incident.…NTSB CHI86FER03Accident · Minor injuriesFinal reportHughes 269A (TH-55A) · Lakeville, MNThe CFI reported the accident occurred during a demonstration of wind effect during turns around a point. The CFI reported that as the helicopter was turned downwind it began descending from an alt of aprx 200 ft AGL. It continued it's descent until the right…NTSB CHI86FER02Accident · Minor injuriesFinal reportMonnett Moni · Winona, MNThe acft crash landed off the arpt due to a reported loss of power. The plt landed in a small field surrounded by hills. The acft sink rate during the landing was high and the acft was damaged. Inspection of the eng after the acc was not accomplished due to…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 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…