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 CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB CHI95LA168Accident · No injuriesLimited investigationFinal reportCessna 180D · Eveleth, MNthe pilot's improper setting of the flaps to the 30 degree position and an excessive descent rate during the landing.NTSB CHI95LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Hutchinson, MNthe pilot's not maintaining aircraft control. A factor was the crosswind condition.NTSB CHI95LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · East Gull Lake, MNthe pilot's failure to maintain clearance from the trees. Factors in the accident were the crosswind and gusts.NTSB CHI95TA174Accident · No injuriesFinal reportCessna 180 · Orr, MNthe pilot's inadequate compensation for the crosswind weather condition. A factor was the crosswind.NTSB CHI95IA342Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNinadequate design of the fly-by-wire flight control system which allowed false signals from the sidestick transducer units to generate uncommanded rolls.NTSB CHI95TA151Accident · No injuriesFinal reportCessna 172 · Hutchinson, MNThe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the crosswind and soft terrain.NTSB CHI95FA121Accident · 3 fatalField investigationFinal reportCessna P-210N · Belle Plaine, MNthe failure to replace the deteriorated deicing boots, and the failure of the boots to operate when the airplane encountered icing condition. An additional causes were the pilot's failure to maintain adequate airspeed and the excessive pullup performed by the…NTSB CHI95FA114Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Rush City, MNThe pilot's poor judgment in attempting to land in the existing wind conditions. His lack of experience was a factor.NTSB CHI95LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Baudette, MNan encountered with a hidden obstruction during taxi. A factor was the ski assembly not having been installed.NTSB CHI95LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeville, MNThe pilot misjudged distance and altitude during landing.NTSB CHI95LA094Accident · No injuriesLimited investigationFinal reportBeech 1900 · Minneapolis, MNthe pilot-in-command's failure to maintain clearance from obstacles during taxi operations. Related factors are the dark night light conditions and the wrong taxi route.NTSB CHI95LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Cotton, MNthe pilot's failure to gain sufficient clearance over the trees during the aborted landing.NTSB CHI95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Minneapolis, MNan inadequate windshield deicing system for the inflight icing encountered, airframe icing, and the pilot's inability to maintain a proper descent rate. Factors associated with this accident were an inadequate weather forecast and icing conditions.NTSB CHI95LA110Accident · No injuriesLimited investigationFinal reportCessna 172 · Nevis, MNthe loss of engine power due to a blockage caused by ice. A factor in the accident was the snow.NTSB CHI95LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Int'L Falls, MNengine oil exhaustion due to a frozen crankcase breather line and noncompliance with an airworthiness directive.NTSB CHI95LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Minneapolis, MNthe pilot's misjudging of distance and airspeed during the approach to landing which resulted in an overrun. Factors associated with the accident were the separation of the exhaust pipe and the pilot's not understanding communications from the air traffic…NTSB CHI95FA061Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Rochester, MNFailure of the pilot to maintain control of the airplane, while climbing in instrument meteorological conditions (IMC) after takeoff. Factors related to the accident were: fog, low ceiling, the pilot's lack of recent instrument experience, and the excessive…NTSB CHI95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe student pilot's failure to maintain directional control during the takeoff roll. A factor in the accident was the pilot's lack of total experience.NTSB CHI95LA043Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Thief Rvr Falls, MNthe flight instructor's delayed remedial action during a simulated forced landing. A factor in the accident is the student pilot's improper landing flare.NTSB CHI95LA031Accident · Serious injuriesLimited investigationFinal reportBoeing 757-231 · St Paul, MNFailure of ground personnel to identify the unsafe/hazardous situation regarding the closeness of the airplane to the baggage carts, and the captain's improper planning/decision concerning the situation.NTSB CHI95LA026Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Inver Grove Hts, MNthe pilot's improper altitude and inadequate visual lookout.NTSB CHI95FA011Accident · 2 fatalField investigationFinal reportBeech 58 · Park Rapids, MNthe pilot-in-command's failure to obtain/maintain clearance. Factors were a dark night, low ceiling, high terrain, and weather service not used by the pilot-in-command.NTSB CHI95FA001Accident · 1 fatalField investigationFinal reportCessna 150G · Lamberton, MNThe pilot's failure to maintain airspeed. A factor in the accident was the pilot's ostentatious display by buzzing.NTSB CHI94LA336Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNAn inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.NTSB CHI94LA338Accident · No injuriesLimited investigationFinal reportCessna 172 · Mora, MNwas an improper touchdown by the pilot-in-command. Factor's associated with this accident were the pilot's diverted attention due to his perception of a crosswind condition and the pilot not performing a recovery from a bounced landing.NTSB CHI94LA320Accident · Serious injuriesLimited investigationFinal reportWeatherly 201C · Stephen, MNimproper rigging of the parking brake control cable resulting in inadvertent application of the left wheel brake.NTSB CHI94DER03Accident · Serious injuriesFinal reportSmart CP 301 · Remer, MNthe failure of the alternator/electrical system, and subsequent total loss of engine power during cruise flight over wooded terrain.NTSB CHI94LA304Accident · No injuriesLimited investigationFinal reportCessna 210L · Orr, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the false indication from the fuel quantity gauges, and terrain condition in the emergency landing area.NTSB CHI94LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, MNthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were the soft terrain and the ditch.NTSB CHI94LA300Accident · No injuriesLimited investigationFinal reportBell 47 MARK-6 · Lake City, MNThe loss of lift resulting from the pilot's failure to maintain rotor RPM during an aerial application turn. The power available from the engine was less than that required to regain the lost rotor RPM.NTSB CHI94LA297Accident · No injuriesLimited investigationFinal reportBellanca 7EAC · Alexandria, MNThe second pilot's failure to remove carburetor heat during the takeoff phase resulting in a loss of power and inadvertent stall.NTSB CHI94LA296Accident · No injuriesLimited investigationFinal reportCessna 172 · Anoka, MNthe pilots decision to attempt a landing ahead of the approaching thunderstorm, and his failure to maintain directional control. A factor was the gusting crosswind ahead of the storm.NTSB FTW94FA274Accident · No injuriesField investigationFinal reportBell 230 · Albert Lea, MNThe pilot's failure to execute the proper approach and the ensuing settling with power. Factors were the tailwind, and the congestion around the airport.NTSB CHI94LA276Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Sargeant, MNthe pilot's failure to maintain clearance from a transmission wire during an agricultural spray run. A factor in the accident is the transmission wire.NTSB CHI94DER02Accident · No injuriesFinal reportAir Tractor AT-301 · Halstad, MNthe commercial pilot's failure to maintain clearance from terrain during the attempted takeoff. Related factors are the soft terrain and the deterioration in aircraft performance due to the high gross weight.NTSB CHI94LA244Accident · No injuriesLimited investigationFinal reportMontana Coyote · Blaine, MNthe loss of engine power due to the blocked vent line.NTSB CHI94LA243Accident · Serious injuriesLimited investigationFinal reportInman Acro Sport 1 · Albert Lea, MNthe pilot's failure to make a precautionary landing on the remaining runway. Factors in the accident were the blocked fuel injector and inadvertent stall.NTSB CHI94LA232Accident · No injuriesLimited investigationFinal reportCessna 180 · Battle Lake, MNloss of engine power due to fuel exhaustion which resulted from inaccurate fuel consumption calculations. A factor related to the accident was the inaccurately placarded fuel tanks.NTSB CHI94LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Andover, MNthe flight instructor's improper procedures and directives by electing to pull the mixture control to the 'off' position during simulated emergency procedures. A factor associated with the accident is the existence of weather conditions conducive to…NTSB CHI94LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Waseca, MNinadequate preflight planning/preparation and the pilot's failure to refuel the airplane. Factors related to the accident were a poorly planned forced landing approach and high vegetation.NTSB CHI94FA212Accident · 3 fatalField investigationFinal reportBeech A35 · Lakeville, MNThe jamming of the elevator control which resulted in the pilot's inability to control the pitch attitude of the airplane. The airplane encountered a stall-spin and impacted level terrain in an uncontrolled descent.NTSB CHI94LA208Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warren, MNthe pilot's improper use of the parking brake.NTSB BFO94FA103Accident · 3 fatalField investigationFinal reportBeech A-36 · Brainerd, MNThe pilot's failure to follow the published missed approach procedure, and his failure to obtain and/or maintain adequate altitude to avoid collision with the terrain. Factors in the accident were: the pilot's lack of instrument flying experience, and the…NTSB CHI94LA199Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Clear Lake, MNthe private pilot's failure to maintain directional control during the landing roll. Related factors are the rough/uneven terrain, and excessive brake application.NTSB CHI94T#A04Accident · No injuriesFinal reportBell 47G3B1 · Medina, MNNTSB CHI94LA196Accident · Serious injuriesLimited investigationFinal reportPopehn Arthur J. Coot A · Circle Pines, MNthe pilot-in-command's inattention to the fuel supply. Factors were the pilot-in-command's diverted attention, his not performing refueling, and rough/uneven terrain.NTSB CHI94LA168Accident · No injuriesLimited investigationFinal reportCessna 182B · Glencoe, MNcollision with a fence post during landing roll after an inadvertent landing at the wrong field.NTSB CHI94LA164Accident · No injuriesLimited investigationFinal reportBeech B23 · Faribault, MNa hard landing as a result of the flight instructor's delayed remedial action. A factor associated with the accident is the student pilot's improper flair.NTSB CHI94LA163Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Kettle River, MNThe pilot's improper use of carburetor heat and the lack of suitable terrain for a forced landing. The carburetor icing weather condition was a factor.