NTSB investigations, 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, 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 CHI88LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lonsdale, MNThe pilot was executing a power-off glide and when an attempt was made to recover by adding power, the engine did not respond. The pilot was then forced to make an emergency landing in a field. During the forced landing the pilot was unable to maintain…NTSB CHI88FA145Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Detroit Lakes, MNNTSB CHI88LA136Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC2-MK I · Warroad, MNThe pilot decided to land in the lake approximately 1000 yds from the sea plane base and was attempting a step-taxi back to the base when the acft struck a sand bar. The pilot stated that he was taxiing near tall grass where he thought the water was deep…NTSB CHI88DER10Accident · No injuriesFinal reportAnderson-Tucker Evans VP-1 · Duquette, MNOn the initial flight of this amateur built aircraft the pilot lowered the nose after liftoff to allow the aircraft to accelerate. However, the aircraft settled and the pilot was unable to keep the aircraft from colliding with trees.NTSB CHI88DER03Accident · No injuriesFinal reportCessna 172K · Mora, MNDrg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.…NTSB CHI88LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairmont, MNThe student pilot was attempting to land. Just prior to touchdown a gust of wind pushed the aircraft to the left of the runway. The pilot was unable to maintain control of the aircraft resulting in the aircraft encountering a stall and colliding with the…NTSB CHI88LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe student pilot was making the fourth leg of a solo cross country flight totalling 314 nautical miles. Although he departed with full fuel, none was added during the trip. The aircraft experienced a power failure, due to fuel exhaustion, approximately five…NTSB CHI88LA108Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Minneapolis, MNThe pilot was executing a downwind takeoff, the winds reportedly gusting to 25 knots, loaded with two passengers, when just after takeoff the pilot stated the helicopter experienced a loss of power. The pilot then attempted to execute an autorotation, but…NTSB CHI88LA106Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Eden Prairie, MNWhile on an aircraft familiarization for purpose of check out, the pilot encountered a gusty crosswind on landing and failed to maintain aircraft control. The instructor pilot took over the controls, but was unable to regain directional control, and the…NTSB CHI88LA104Accident · No injuriesLimited investigationFinal reportBeech K35 · Milaca, MNNTSB CHI88FA101Accident · 1 fatalField investigationFinal reportCessna 152 · Lonsdale, MNThe student pilot was on his first solo flight outside the airport traffic area and was practicing maneuvers prescribed by his flight instructor including slow flight and stall type maneuvers. The aircraft experienced a loss of control, followed by an…NTSB CHI88LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Sauk Center, MNWhile enroute on the last leg of a solo cross country instructional flight, the student pilot experienced a rough running engine, followed by an engine failure. The pilot elected to land on a frozen lake, executed emergency procedures, and made a hard landing…NTSB CHI88FA091Accident · No injuriesField investigationFinal reportBeech B90 · St. Paul, MNMechanical failure and sticking of the pilots thumb operated trim switch causing nose down pitch command. The failure of the cabin heater and the low cabin temperature are contributing factors.NTSB CHI88FA092Accident · 1 fatalField investigationFinal reportCessna 207 · Hardwick, MNWitnesses observed the aircraft for aprx 8 minutes in erratic diving, climbing, and steep-turning maneuvers which culminated in a 12 degree descent to the ground. The sound of the eng was heard throughout the sequence and other evidence indicated engine power…NTSB CHI88FA087Accident · 2 fatalField investigationFinal reportBeech 35-C33A · Onamia, MNPilot's poor judgement in continuing VFR flight into IMC conditions, and his subsequent disorientation and failure to maintain aircraft control.NTSB CHI88DER02Accident · 2 fatalFinal reportBellanca 7GCBC · Warroad, MNThe aircraft experienced a loss of control and rapid descent onto the ice in what witnesses described as a spin type maneuver from a low altitude. The purpose of the flight was a low level photo mission. The aircraft was destroyed. The pilot and passenger…NTSB CHI88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNStudent pilot stated that airplane went off runway at 50 KIAS after losing control during landing rollout. Airplane sustained substantial damaged when nose gear collapsed.NTSB CHI88LA086Accident · No injuriesLimited investigationFinal reportMooney M-20C · Minneapolis, MNWhile executing touch and go landings the pilot's attention was diverted inside the aircraft while adjusting the interior lights to determine the position of the flaps. He lost control of the aircraft and it departed the runway striking a snow bank.NTSB CHI88LA044Accident · No injuriesLimited investigationFinal reportBeech A36 · St Paul, MNNTSB CHI88LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Buffalo, MNNTSB CHI88LA050Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Red Lake Falls, MNNTSB CHI88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mankato, MNNTSB CHI88IA040Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Minneapolis, MNAircraft experienced a loss of aileron ctl when ice formed around aileron control cables and restricted their movement. Water draining through open plenum drains in the main landing gear wheel well froze when exposed to below freezing temperatures at 35,000…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.…