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 MKC89FA135Accident · 1 fatalField investigationFinal reportCessna A185F · Ely, MNLoss of engine power for an undetermined reason. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB MKC89LA131Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-101 · Stanton, MNFailure of the pilot to maintain control of the glider. Contributing factors were: improper use of flight controls by the pilot and his lack of total experience in the type of glider.NTSB MKC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Buffalo, MNMisjudgement of altitude and distance by the student and inadequate supervision of flight by the instructor (CFI). Contributing factors were: unfavorable wind conditions, high vegetation (grass), and a ditch.NTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.NTSB MKC89LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Duluth, MNThe failure of the pilot to maintain control of the aircraft while attempting to land in turbulent gusty wind conditions.NTSB MKC89LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ramsey, MNThe passengers interference with the flight controls and the pilot's failure to maintain control of the aircraft. Contributing to the severity of the accident was the ditch located short of the runway which the aircraft contacted.NTSB MKC89FA107Accident · Serious injuriesField investigationFinal reportCessna 152 · Cottage Grove, MNPoor judgement of the pilot by flying while physically impaired from consumption of alcohol; and his failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and collision with wooded/hilly terrain.NTSB MKC89LA106Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, MNThe pilots failure to properly calculate fuel consumption which resulted in an inadequate fuel reserve and fuel exhaustion prior to reaching his destination. During the ensuing forced landing the pilot failed to maintain airspeed which resulted in an…NTSB MKC89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Brainerd, MNThe pilot's failure to follow procedures which resulted in the failure to extend the landing gear prior to touchdown. A contributing factor was the pilot's inattentiveness.NTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.NTSB CHI89IA083Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNFailure of the hydraulic power transfer unit shut-off (ptu s/o) valve due to failed (fatigued) valve body attach screws.NTSB MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.NTSB MKC89LA088Accident · No injuriesLimited investigationFinal reportMooney M20E · Lake Elmo, MNFuel tank selector improperly positioned, emergency procedure improperly performed by the pilot, and fuel starvation.NTSB MKC89LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Marshall, MNThe failure of an unapproved weld between the exhaust system and muffler. The failed weld resulted in the muffler separating and an in-flight fire.NTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.NTSB MKC89LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Rapids, MNThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the gusty crosswind conditions.NTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.NTSB MKC89LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNPremature raising of flaps and the failure of the instructor pilot to maintain runway alignment during the attempted go around.NTSB MKC89FA055Accident · 1 fatalField investigationFinal reportChampion 7EC · Luxemburg, MNThe pilot failed to maintain adequate airspeed which resulted in a stall and loss of aircraft control. The pilot's failure to observe weight and balance limitations of the aircraft was a contributing factor.NTSB MKC89LA052Accident · No injuriesLimited investigationFinal reportStinson 108-1 · South St. Paul, MNThe failure of the pilot to maintain directional control of the airplane. Contributing to the accident were the crosswind conditions.NTSB MKC89LA053Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Malmo, MNThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), which resulted in his loss of aircraft control, due spatial disorientation. A related factor to the accident was: the adverse weather condition.NTSB MKC89IA048Incident · No injuriesIncident investigationFinal reportGulfstream Commander 690A · St. Paul, MNThe PIC had prefltd his commander turboprop and prepared for takeoff fm the St. Paul arpt. During the takeoff roll just as the acft was rotated to takeoff attitude, the rt eng failed. The PIC eased the acft back to the rwy, reduced pwr and came to a stop on…NTSB MKC89LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Hibbing, MNWhile practicing takeoffs and landings on a patchy snow and ice covered runway, the student pilot lost directional control on takeoff and veered off the runway into a snow bank. The acft nosed down and damaged the prop and right wing.NTSB MKC89LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Little Falls, MNWhile attempting a touch and go ldg during a student solo cross country flt, directional control was lost during the takeoff phase on the snow packed runway. The student pilot said he had never landed and taken off under those runway conditions. The acft…NTSB MKC89LA028Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lino Lakes, MNShortly after takeoff and climbing to about 150 AGL, the pilot said the engine began sputtering and losing power. Attempts to correct the situation by pumping the throttle and working the engine primer failed to correct the situation, and shortly thereafter…NTSB MKC89IA024Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-31 · Minneapolis, MNThe failure of the left main landing gear tire carcass and the ingestion of the tire debris into the left engine which hindered normal operation.NTSB CHI89LA017Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Mora, MNNTSB CHI89LA015Accident · No injuriesLimited investigationFinal reportCessna 175A · Wyoming, MNNTSB CHI89LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Alexandria, MNPoor judgement of the plt by flying while physically impaired from consumption of alcohol, his improper inflight planning/decision, and fuel exhaustion from his inadequate supply of fuel. The light conditions at night and uneven terrain (highway median) were…NTSB CHI89LA008Accident · Minor injuriesLimited investigationFinal reportCessna 120 · St Peter, MNThe plt had intended to make a touch-&-go landing on a grass strip, but stated that he came in 'somewhat high.' He rprtd the acft was still airborne about halfway down the rwy when he elected to go around. He attempted to add power, but the eng 'sputtered &…NTSB CHI88FA244Accident · 1 fatalField investigationFinal reportPiper PA-28 · Hutchinson, MNFailure of the student rated pilot to use proper control inputs and procedures to regain and maintain control of the airplane while executing a go-around from a bounced landing. The pilots lack of total experience is a contributing factor in the cause.NTSB CHI88LA243Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Benson, MNWitnesses reported that the aircraft bounced twice on the runway before the right wing tip struck the ground on the right side of the runway. The aircraft 'cartwheeled' and came to a rest on it's left side.NTSB CHI88DER12Accident · No injuriesFinal reportCessna A188B · Clearbrook, MNOn initial climb the right cowling door came open. The pilot was unable to maintain a climb and elected to make an emergency landing in a hay field. The aircraft encountered unsuitable terrain and received substantial damage. Post accident inspection of the…NTSB CHI88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Detroit Lakes, MNDuring the initial climbout, as the aircraft climbed through approximately 200' AGL, the powerplant failed completely. The pilot executed a forced landing in an plowed field, substantially damaging the aircraft. Post-accident examination of the engine…NTSB CHI88FA233Accident · No injuriesField investigationFinal reportBoeing 727-200 · Minneapolis, MNFailure of the captain to follow company pushback procedures and not getting a release before starting to taxi.NTSB CHI88DER14Accident · 1 fatalFinal reportHomebuilt Woodstock · Mankato, MNAircraft structural failure due to overload induced by pilot in the performance of unauthorized maneuvers.NTSB CHI88DER13Accident · No injuriesFinal reportPiper PA-22-150 · Cohasset, MNFailure of the PIC to maintain a proper glide path in order to clear obstructions along the flight path of his final approach.NTSB CHI88LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Burnsville, MNDuring a local pleasure/aerial photography flight, the pilot failed to handle the aircraft properly. Subsequently the pilot was unable to maintain sufficient airspeed and/or altitude to remain clear of obstacles. The aircraft was configured for slow flight as…NTSB CHI88LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Eden Prairie, MNOn landing the aircraft bounced resulting in a porpoise. The nose gear collapsed rendering substantial damage to the aircraft.NTSB CHI88FA192Accident · 1 fatalField investigationFinal reportAeronca 7AC · Pierz, MNPilot failed to maintain adequate control of the aircraft while maneuvering at a low altitude, resulting in a stall and collision with the ground. A factor contributing to the accident was the pilot's lack of recent flight experience and training.NTSB CHI88DER08Accident · Serious injuriesFinal reportCessna T337D · Jacobson, MNDuring the climb from takeoff, the front engine sustained a total power loss due to a fuel leak. The pilot secured the engine, however was unable to maintain altitude, losing about 50 ft per minute. Due to a thunderstorm at the departure airport, he elected…NTSB CHI88DER07Accident · 2 fatalFinal reportChampion 7CCM · Int'L Falls, MNThere were no eyewitnesses to this accident. The aircraft with an instructor and student aboard was reported missing. When located the seaplane had descended into a wooded swamp and the aircraft was substantially damaged and both occupants received fatal…NTSB CHI88DER06Accident · No injuriesFinal reportHiller UH-12E · Buffalo Lake, MNWhen the helicopter lifted off, the left tail rotor cable separated. Directional control was lost and the aircraft collided with the terrain. The pilot reported no injuries, however the helicopter sustained substantial damage. An inspection of the left tail…NTSB CHI88DER05Accident · Minor injuriesFinal reportVans RV-3A · Walker, MNThe pilot reported that after making a low level pass over a lake, he attempted to climb to pattern altitude in preparation for landing at a nearby airport. When the climb was initiated, the aircraft did a loop and the plt lost control. The acft subsequently…NTSB CHI88DER04Accident · No injuriesFinal reportPiper PA-25 · Elbow Lake, MNThe pilot was practicing low level flight in preparation for his certification under 14 CFR 137 when the aircraft experienced a collision with wires. The aircraft was substantially damaged during this collision and the subsequent collision with trees and the…NTSB CHI88LA173Accident · No injuriesLimited investigationFinal reportPiper J-3 · Minneapolis, MNWhile practicing a landing on a solo instructional flight, the student pilot allowed the aircraft to drift off the left side of the runway and strike the VASI lights. The student pilot had only flown 2 hours, including 10 takeoffs and landings, in the past 90…NTSB CHI88LA167Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Mankato, MNAs the pilot leveled off at his intended cruise altitude, he noted a loss of oil pressure, then saw oil spread up over the windshield, restricting his visibility. The pilot performed emergency procedures, and began descending to the nearest airport. During…NTSB CHI88FA163Accident · No injuriesField investigationFinal reportBoeing 727 · St Paul, MNAfter push back from the gate, the captain received an unrestricted taxi clearance & elected to taxi to the north side of a construction area. Subsequently, the left wing of the acft struck a parked vehicle in a nonmovement area, which resulted in substantial…NTSB CHI88LA154Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Thief Rvr Falls, MNNTSB CHI88FA153Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Hamm Lake, MNLoss of control in flight, either by the student or by the instructor, at an altitude insufficient to allow for a recovery, by the flight instructor, before the resulting out of control descent caused the accident airplane to strike the terrain.