NTSB investigations, 1987, MN
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year
| 1964 | 113 |
|---|---|
| 1965 | 115 |
| 1966 | 117 |
| 1967 | 130 |
| 1968 | 95 |
| 1969 | 113 |
| 1970 | 88 |
| 1971 | 80 |
| 1972 | 82 |
| 1973 | 77 |
| 1974 | 83 |
| 1975 | 98 |
| 1976 | 78 |
| 1977 | 92 |
| 1978 | 98 |
| 1979 | 76 |
| 1980 | 66 |
| 1981 | 89 |
| 1982 | 61 |
| 1983 | 68 |
| 1984 | 51 |
| 1985 | 57 |
| 1986 | 43 |
| 1987 | 40 |
| 1988 | 52 |
| 1989 | 50 |
| 1990 | 42 |
| 1991 | 59 |
| 1992 | 25 |
| 1993 | 40 |
| 1994 | 39 |
| 1995 | 37 |
| 1996 | 40 |
| 1997 | 37 |
| 1998 | 36 |
| 1999 | 33 |
| 2000 | 39 |
| 2001 | 40 |
| 2002 | 46 |
| 2003 | 40 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 29 |
| 2007 | 25 |
| 2008 | 31 |
| 2009 | 29 |
| 2010 | 32 |
| 2011 | 28 |
| 2012 | 28 |
| 2013 | 33 |
| 2014 | 24 |
| 2015 | 15 |
| 2016 | 26 |
| 2017 | 20 |
| 2018 | 14 |
| 2019 | 16 |
| 2020 | 26 |
| 2021 | 12 |
| 2022 | 24 |
| 2023 | 34 |
| 2024 | 24 |
| 2025 | 22 |
| 2026 | 13 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND 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 year(c."eventDate") = 1987 AND 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 CHI88LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Redwood Falls, MNWind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left.NTSB CHI88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlton, MNThe plt rprtd that the left main gear collapsed as he started to taxi from the ramp area on a smooth grass surface. When the gear collapsed, the left wing dropped to the ground & was substantially dmgd. The plt rprtd the left gear leg had broken off 2 inches…NTSB CHI88LA028Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Belle Plaine, MNAfter the acft was in the traffic pattern, the instructor (CFI) initiated a simulated forced landing. Just before touchdown on final apch, the student (a rated pvt plt) allowed the acft to drift to the right. The CFI attempted a go-around, but was delayed in…NTSB CHI88DER01Accident · No injuriesFinal reportPiper PA-22 · Mcgrath, MNDuring a solo cross-country flight, the aircraft sustained a power loss due to failure of the #3 connecting rod. Subsequently, the student pilot made an emergency landing in a swamp and the aircraft was damaged.NTSB CHI88FA008Accident · 4 fatalField investigationFinal reportCessna 310 · Brownton, MNAcft crashed in open farm field during night dark conditions witness heard loud roar of engs then a hard dull thud and then silence. Angle of impact was near vertical. Engs were buried 8FT and dist of wreckage was confined to within the dimensions of acft.…NTSB CHI87LA224Accident · No injuriesLimited investigationFinal reportCessna 172L · Lakeville, MNAircraft landed hard, nose wheel first, and collapsed the nose landing gear tire. PIC was concerned about a sharp knocking noise in the rear of the aircraft that he heard after liftoff. The reason for the noise was not determined. He acknowledged that he…NTSB CHI87LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Perham, MNThe pilot was landing on a farm field to the east. The nearest wx station was reporting wind from 220 at 5 KTS. The pilot said after touchdown his speed was too fast to stop so he elected to abort the landing. During climbout the acft struck trees and crashed.NTSB CHI87LA196Accident · No injuriesLimited investigationFinal reportBeech A23 · Longville, MNThe student plt rprtd that as he rounded out to land, the acft nosed down & impacted nosewheel first. Subsequently, the nose gear collapsed & the acft skidded to a stop. After coming to rest, a fire erupted, which spread & subsequently destroyed the acft.NTSB CHI87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · Monticello, MNDrg the takeoff roll, the plt lost directional control of the tailwheel equipped acft. It then swerved to the left & went into a soybean field. Drg the occurrence, the rgt main gear collapsed & the rgt wing, rgt horizontal stabilizer, prop & eng cowling were…NTSB CHI87LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Delft, MNThe acft was loaded close to its gross wt limit & the plt atmtd to takeoff on a 2160 ft strip, using short field takeoff techniques. The acft became airborne for a short time, however, it began to settle. The plt elected to abort the takeoff, but was unable…NTSB CHI87LA189Accident · No injuriesLimited investigationFinal reportAeronca 15AC · St Bonifacius, MNThe plt had just purchased the acft & had obtained a ferry permit to fly it to another arpt. He reached the vicinity of the destn & called the tower, but did not see the arpt. Aprx 15 min later, when he was sure he had passed the arpt, he made a 180 deg turn…NTSB CHI87LA182Accident · No injuriesLimited investigationFinal reportPiper J3 · Vermillion Lake, MNWhile attempting to return to land after the loss of power, the right wing tip hit the water and the aircraft flipped upside down into the lake. According to a mechanic who inspected the aircraft after the accident, the coils and condensers on both magnetos…NTSB CHI87LA178Accident · No injuriesLimited investigationFinal reportRobinson 22 · Minnetonka, MNWhile attempting to land on a flat spot on top of a hill the tail rotor hit the ground and the tail boom broke off. One witness reports that when the helicopter touched down it bounced up about 10 feet. No mechanical malfunctions were reported.NTSB CHI87FA177Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Morris, MNThe plt was ferrying the acft from Ohio to Alaska. While en route, he stopped & refueled at Morris, MN. After he took off, the plane crashed in an open field about 1/2 mi from the arpt. No known witnesses saw the acdnt, but a passerby found the acft on its…NTSB CHI87DER11Accident · 1 fatalFinal reportHendrickson Polliwagon · Ely, MNWhile on downwind to the airport the aircraft departed level flight and impacted in a wooded area in an approximate 80 degree nose down attitude. The aircraft was destroyed and the plt who was the sole occupant, received fatal injuries. This was an…NTSB CHI87DER10Accident · 1 fatalFinal reportAir Tractor AT-301 · Hollandale, MNAfter making a swath run the aircraft pulled up to clear power lines. Witnesses state that the engine cut out and aircraft pitched nose down and began to rotate. They state that the engine regained power just prior to impact. Subsequent investigation failed…NTSB CHI87LA172Accident · No injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNThe plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.…NTSB CHI87FA162Accident · 5 fatalField investigationFinal reportCessna 180 · New Brighton, MNWitnesses observed the floatplane start a climbing left turn shortly after becoming airborne from a water takeoff. The aircraft's right wing dropped and the aircraft dove into the water where it struck the surface right wing first, flipped inverted and sank.…NTSB CHI87DER12Accident · No injuriesFinal reportTaylorcraft F21A · Int'L Falls, MNWhile on initial climb the aircraft encountered downdrafts and was unable to climb over high terrain and trees. When it became obvious to the pilot that he was not going to be able to climb over these obstacles, he closed the throttle and attempted to turn…NTSB CHI87DER09Accident · 1 fatalFinal reportGreat Lakes Adams 2T-1 · Bethel/Msp, MNThe amateur built aircraft impacted in an open farm field. Although witnesses did not agree on the altitude the aircraft was flying at, they all stated that the Great lakes 2T-1 was spinning before it collided with the ground. One witness indicated that the…NTSB CHI87DER08Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring a 180 degree turn from completion of a spray swath the aircraft began to sink. The pilot dumped his load and added power, however was unable to arrest sink. When it was obvious that impact with the ground was imminent, the pilot reduced power and…NTSB CHI87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Duluth, MNRprtdly, the winds were prevailing from the northeast & were variable & gusty. The plt entered the traffic pattern to land on rwy 14, but aborted his 1st attempt. During the 2nd apch, he used a notch of flaps & corrected for the x-wind by slipping the acft…NTSB CHI87LA155Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Big Sandy Lake, MNThe engine stalled for undetermined reasons after the pilot made a wide circle turn. During a forced landing in a lake, the aircraft nosed over. The last annual aircraft inspection was 15 months prior to the date of the accident.NTSB CHI87LA138Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Inver Grove Hts, MNAfter a loss of power, aircraft stalled. Although power was regained, aircraft crashed approx. 10 feet east of a grass strip adjacent to the seaplane base. Inspection revealed no mechanical malfunction or engine problem.NTSB CHI87FA139Accident · 2 fatalField investigationFinal reportBell 47G · Dayton, MNAircraft collided with terrain after tailboom structure failed because of internal corrosion. The aircraft was not registered at the time of the accident and the pilot/operator failed to assure that proper or timely preventive maintenance was performed on the…NTSB CHI87LA134Accident · No injuriesLimited investigationFinal reportCessna U206C · Grand Rapids, MNThe plt rprtd that drg a water lndg, the left float dug in & caused the left wing to strike the water. Subsequently, the acft nosed over. The plt did not rprt any abnormal wind or water condition.NTSB CHI87DER07Accident · 1 fatalFinal reportAir Command Unknown · Dodge Center, MNBefore flt the pilot had stated that his uncertified and unregisterd gyroplane had a 'lot of bugs to work out'. After t.o. and five min of airwork the acft entered a steep 90 degree banked turn and then began to tumble. Shortly after the main rotor separated.…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 &…