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 MKC90LA138Accident · No injuriesLimited investigationFinal reportHiller 12-E · Watson, MNPilot misjudged his flare and collided with the terrain.NTSB MKC90LA135Accident · No injuriesLimited investigationFinal reportCallair A-9 · Barrett, MNInadequate visual outlook and a delayed pull-up by the pilot in command.NTSB MKC90LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Cottage Grove, MNFuel exhaustion and remedial action not performed by the pilot in command.NTSB MKC90LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Deer River, MNAirspeed not maintained and stall/spin encountered by the pilot in command.NTSB MKC90LA116Accident · 1 fatalLimited investigationFinal reportRollins-Bowers FLY Baby 1A · Bemidji, MNThe wing attachment bolts were not installed resulting in inflight wing separation.NTSB MKC90LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Starbuck, MNCompensation for wind conditions were misjudged and aircraft control was not maintained by the pilot in command.NTSB MKC90LA093Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Eden Prairie, MNCollision with animal, factors in the accident were light condition, dusk, and remedial action was not possible.NTSB MKC90LA088Accident · Serious injuriesLimited investigationFinal reportBell 47 · Oakdale, MNA slipping rotor drive clutch assembly due to improper maintenance by company personnel. Contributing factors were static wires in the path.NTSB MKC90LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Two Harbors, MNPilot factor in that he failed to maintain flying speed.NTSB MKC90LA086Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Eden Prairie, MNDirectional control was not maintained by the pilot in command.NTSB MKC90LA077Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Minneapolis, MNFailure of the pilot to maintain directional control of the aircraft during the landing. The failed (flat) right main tire was a related factor.NTSB MKC90LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Minneapolis, MNAircraft control not maintained by the pilot in command. His lack of experience in the type of aircraft was a factor.NTSB CHI90LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · Grygla, MNThe pilot's inadequate preflight preparation/planning, and subsequent fuel exhaustion due to an inadequate supply of fuel. The light condition at dusk, icy terrain (road) and tree were related factors.NTSB CHI90LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Brainerd, MNThe failure of the pilot to maintain proper alignment with the runway.NTSB MKC90FA057Accident · 1 fatalField investigationFinal reportBeech B36TC · Inver Grove Hgt, MNPremature lift-off by the pilot, while taking off with a heavy gross weight in unfavorable winds, and the pilot's failure to attain/maintain adequate airspeed, which resulted in an inadvertent stall/mush.NTSB MKC90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ely, MNImproper planning/decision by the pilot. A factor related to the accident was: the strong/gusty crosswind condition.NTSB MKC90LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Crane Lake, MNFailure of the connecting rod assembly. Factors related to the accident were: terrain conditions in the emergency landing area.NTSB MKC90LA052Accident · No injuriesLimited investigationFinal reportCessna 150 · Clear Lake, MNFailure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.NTSB MKC90LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · York, MNPowerplant failure due to undetermined causes.NTSB MKC90LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNInadequate visual outlook by the pilot and his failure to maintain clearance from the light pole. The location of the pole was considered to be a related factor.NTSB MKC90LA041Accident · No injuriesLimited investigationFinal reportMancini Rotorway Exec · Mountain Iron, MNFailure of the non-certificated pilot to maintain adequate altitude, while maneuvering the helicopter. The pilot's lack of experience and proper certification (qualification) were related factors.NTSB MKC90LA033Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Richmond, MNImproper use of the fuel tank selector by the pilot and his improper use of emergency procedures, which resulted in fuel starvation after a fuel tank had emptied. Contributing factors were: inoperative fuel quantity gauges, pilot's operation with known…NTSB MKC90FA032Accident · No injuriesField investigationFinal reportBeech 95-B55B · Lakeville, MNInadequate visual lookout by the pilot in command in both aircraft.NTSB MKC90LA024Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas 369HS · Oklee, MNAn undetermined power plant failure. Factors related to the accident were: the snow covered terrain, snow, and gusty wind.NTSB MKC90LA021Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Saint Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Darkness was a related factor.NTSB MKC90LA018Accident · No injuriesLimited investigationFinal reportPierce MP-2 · Caledonia, MNThe pilots loss of control during recovery from bounced landing.NTSB MKC90LA016Accident · No injuriesLimited investigationFinal reportHughes 369HS · Ogilvie, MNLoss of engine power for an undetermined reason. Factors related to the accident were: the unsuitable terrain conditions in the emergency landing area.NTSB MKC90LA014Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Brooten, MNThe pilot's failure to use proper starting procedures and the excessive throttle setting.NTSB MKC90FA005Accident · 2 fatalField investigationFinal reportPiper PA-28 · Delavan, MNFailure of the pilot to maintain proper altitude during a low pass, and to see-and-avoid obstructions (inadequate visual lookout). Factors related to the accident were: the pilot's ostentatious display and the obstructions (powerlines).NTSB MKC89FA202Accident · No injuriesField investigationFinal reportFokker F27 · Bemidji, MNThe pilot's failure to maintain a proper descent rate and compensate for the downdraft encountered while on short final approach.NTSB MKC89FA201Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · St. Charles, MNThe pilot's failure to maintain a positive rate of climb during a night takeoff. Contributing factor(s) was: an out-of-c.g airplane, takeoff with only one magneto operating; and the limited vision of the pilot.NTSB MKC89LA200Accident · No injuriesLimited investigationFinal reportHughes 269C · Bloomington, MNFailure of the engine crankshaft. The light conditions at dawn and the vehicles were considered to be contributing factors.NTSB MKC89LA198Accident · No injuriesLimited investigationFinal reportBeech 80 · Littlefork, MNTotal failure of the electrical system during IFR operations & the aircraft's collision with a rock fence during the subsequent gear-up precautionary landing.NTSB MKC89LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Barnesville, MNThe pilot's failure to insure that the aircraft contained an adequate fuel supply to complete the flight.NTSB MKC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chanhassen, MNEngine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.NTSB MKC89FA191Accident · 2 fatalField investigationFinal reportPiper PA-20 · Moose Lake, MNSevere corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…NTSB MKC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Park Rapids, MNThe pilot misjudged the clearance between the helicopter and the power line. The power line (transmission wire) was considered to be a contributing factor.NTSB MKC89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Clear Lake, MNThe pilot's improper decision in attempting to land with inadequate visual cues which precluded identification of a correct runway alignment. A suitable alternative airport was readily available.NTSB MKC89LA184Accident · Minor injuriesLimited investigationFinal reportDormoy TKD Bathtub · Carlisle, MNFailure of the mixture control cable and inadequate maintenance (repair) by the pilot. The terrain conditions were considered to be contributing factors.NTSB MKC89LA181Accident · Minor injuriesLimited investigationFinal reportBell 47G-B3 · Waseca, MNInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. The tailwind, high obstruction (power line), and crop (beans) were contributing factors.NTSB MKC89LA174Accident · No injuriesLimited investigationFinal reportStinson L-5 · Minneapolis, MNThe pilot selected the wrong runway and failed to maintain directional control. The crosswind was a contributing factor.NTSB MKC89LA176Accident · No injuriesLimited investigationFinal reportBell 206-B2 · Sebeka, MNPower plant failure due to a fracture of the first stage turbine wheel, resulting in an uncontrolled autorotation.NTSB MKC89LA164Accident · No injuriesLimited investigationFinal reportCessna 172 · Duluth, MNAircraft control was not maintained by the pilot in command due to improper use of the aircraft flight controls.NTSB MKC89LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Crystal, MNAircraft control was not maintained by the pilot in command, due to an improper landing flare which resulted in several bounces. The landing gear failed in overload during the bounced landing.NTSB MKC89DER01Accident · 1 fatalFinal reportCessna T188C · Wannaska, MNThe pilot-in-command did not maintain airspeed, resulting in an inadvertent stall.NTSB MKC89LA145Accident · 1 fatalLimited investigationFinal reportCessna U206 · Eveleth, MNThe pilot's improper flare during the water landing. The pilot's lack of recent experience in seaplane operations and the lack of experience in the accident aircraft contributed to the accident.NTSB MKC89LA140Accident · No injuriesLimited investigationFinal reportCessna 188B · Grygla, MNInadequate preflight planning and preparation by the pilot. Tall grass (high vegetation) at the end of the strip was a contributing factor.NTSB MKC89LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Sauk Rapids, MNFailure of the pilot to properly secure the oil cap when he serviced the aircraft and oil starvation. Contributing factors were the terrain conditions.NTSB MKC89LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Bemidji, MNThe continued approach and landing by the pilot in known adverse weather. Contributing factors were the weather conditions and the ditch.NTSB MKC89LA139Accident · No injuriesLimited investigationFinal reportCessna A185F · Int'L Falls, MNThe pilot's inability to maintain aircraft control after encountering a strong gust of wind during the landing flare/touchdown.