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 CHI06LA100Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South St. Paul, MNThe pilot's failure to maintain directional control during landing roll, which resulted in the collapse of the right main landing gear. A factor associated with the accident was a tailwind.NTSB CHI06CA104Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Tower, MNThe unsuitable landing area selected by the pilot which led to the subsequent nose-over. The terrain condition was a factor.NTSB CHI06CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Backus, MNThe airplane stalled as a result of the low airspeed and the instructor pilot's failure to take remedial action.NTSB CHI06CA066Accident · No injuriesData collectionFinal reportCessna 120 · Hibbing, MNThe pilot used a rough frozen lake for takeoff which resulted in the overload failure of the landing ski. A factor was the rough frozen lake.NTSB CHI06LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Worthington, MNThe missed approach not performed by the pilot and the directional control not maintained by the pilot during landing. Contributing factors were the crosswind, wind information not available due to inoperative meteorological equipment, and a Notices to Airman…NTSB CHI06LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Marshall, MNA loss of engine power in both engines while on approach due to fuel exhaustion and the pilot's inaccurate fuel consumption calculations leading to him refueling the outboard tanks only.NTSB CHI06FA043Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Arco, MNThe pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…NTSB CHI06CA039Accident · Serious injuriesData collectionFinal reportLarson Aero Comp-6 · Brainerd, MNThe pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…NTSB CHI06LA036Accident · No injuriesLimited investigationFinal reportCessna T310R · Fergus Falls, MNThe presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.NTSB CHI06LA027Accident · No injuriesLimited investigationFinal reportAgusta A109-E · Robbinsdale, MNThe loss of lift for undetermined reasons.NTSB CHI06CA020Accident · No injuriesData collectionFinal reportStinson SR-6A · Glencoe, MNThe pilot's inadequate wind compensation and his failure to maintain directional control during the landing rollout. A factor to the accident was the gusting crosswind condition.NTSB CHI06CA019Accident · No injuriesData collectionFinal reportPiper PA-12 · Brainerd, MNThe pilot's inadvertent brake application during the takeoff roll, which resulted in a loss of directional control and subsequent ground loop.NTSB CHI06LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Williams, MNThe pilot's failure to maintain airspeed which resulted in the airplane stalling. Factors associated with the accident were the low level at which the airplane was maneuvering and the pilot's failure to perform weight and balance calculations prior to the…NTSB CHI06CA004Accident · Minor injuriesData collectionFinal reportCessna 172M · Lake Elmo, MNThe pilot's inadequate recovery from a bounced landing, which resulted in an overload failure of the nose landing gear. Contributing to the accident was a loss of engine power due to fuel exhaustion as a result of inadequate preflight planning by the pilot.NTSB CHI05CA258Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Fertile, MNThe flightcrew's failure to extend the landing gear prior to touchdown, and the flight instructor's inadequate supervision of the flight.NTSB CHI05TA251Accident · No injuriesFinal reportCessna 182R · New Ulm, MNThe loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.NTSB CHI05CA245Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Hector, MNThe pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.NTSB CHI05LA228Accident · No injuriesLimited investigationFinal reportAuseth Kitfox IV · Little Grand La, MNThe inadequate flare during landing by the pilot.NTSB CHI05LA223Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Brainerd, MNThe delayed go-around and inadequate flare by the pilot during landing.NTSB CHI05LA234Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Georgetown, MNThe reported loss of engine power for undetermined reasons while maneuvering and the low altitude of the operation. Related factors were the unsuitable terrain encountered by the pilot, and trees.NTSB CHI05CA215Accident · No injuriesData collectionFinal reportRosner Acro Sport II · Princeton, MNThe airplane nosed over during landing as a result of the pilot's failure to maintain control of the airplane when he applied excessive braking.NTSB CHI05CA255Accident · No injuriesData collectionFinal reportLet L 33 Solo · Stanton, MNThe pilot's failure to maintain a proper descent rate during landing due to the wind gusts. The wind gusts were a factor.NTSB CHI05CA195Accident · No injuriesData collectionFinal reportCessna 180 · Bowstring, MNThe unsuitable water conditions for takeoff selected by the pilot and his inability to maintain aircraft control in the rough water. Contributing factors were the aborted takeoff initiated by the pilot, the rough water conditions and the high, gusty winds.NTSB CHI05CA187Accident · No injuriesData collectionFinal reportMcDaniels Kitfox Classic IV · Bagley, MNThe pilot's inadvertent lift-off and failure to maintain adequate airspeed while recovering from a loss of directional control during landing. Contributing factors to the accident were the pilot's inadequate wind compensation and failure to maintain aircraft…NTSB CHI05FA162Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Grand Rapids, MNAn observed loss of engine power due to the bound/jammed turbocharger wastegate during takeoff, the pilot not maintaining airplane control, and the stall he inadvertently encountered. A factor was the maintenance personnel not replacing the turbocharger…NTSB CHI05CA168Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Minneapolis, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors associated with the accident were the crosswind and the taxiway sign.NTSB CHI05CA174Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Willmar, MNThe pilot's improper flare which resulted in a hard landing.NTSB CHI05CA152Accident · No injuriesData collectionFinal reportCessna 172M · Rochester, MNThe pilot flared improperly and failed to recover from a bounced landing.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI05MA111Accident · Serious injuriesMajor investigationFinal reportMcDonnell Douglas DC-9-51 · Minneapolis, MNthe Captain of the other aircraft's decision to shutdown the left engine during taxi with no hydraulic pressure on the right side hydraulic system to effectively operate the brakes, steering, or thrust reversers. A factor was the fatigue fracture of the…NTSB CHI05LA097Accident · No injuriesLimited investigationFinal reportCessna 310 · Clear Lake, MNThe collapse of the nose landing gear as a result of the pilot performing improper maintenance on the airplane due to his failure to properly safety the nose landing gear door.NTSB CHI05CA084Accident · No injuriesData collectionFinal reportCessna 172 · Baudette, MNThe pilot's inadequate compensation for the crosswind which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the snow covered surface on which the landing was being made, and the…NTSB CHI05LA076Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Rochester, MNThe loss of engine power due to oil starvation and the subsequent failure of a connecting rod. Additional causes were the improper maintenance due to under-torqued fasteners, and inadequate airframe manufacturer maintenance procedures resulting in an improper…NTSB CHI05CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Minneapolis, MNThe pilot's inadequate compensation for the wind conditions and his failure to maintain control of the helicopter while maneuvering to center the helicopter on a cart. A factor associated with the accident was the wind gusts.NTSB CHI05LA064Accident · No injuriesLimited investigationFinal reportCessna A185F · Minneapolis, MNA failure of the tail wheel locking mechanism which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.NTSB CHI05CA058Accident · No injuriesData collectionFinal reportCessna 172F · Willmar, MNThe student pilot's failure to properly compensate for the crosswind conditions and his failure to maintain directional control during the landing rollout. Contributing factors were the crosswind and the snow bank.NTSB CHI05FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Glenwood, MNThe pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…NTSB CHI05LA037Accident · No injuriesLimited investigationFinal reportCessna 172H · Belle Plaine, MNA loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.NTSB CHI05CA034Accident · No injuriesData collectionFinal reportCessna 172N · Lakeville, MNThe pilot misjudged his distance and speed which resulted in an overrun.. Factors were the wet runway, the grass and the berm.NTSB CHI05CA005Accident · No injuriesData collectionFinal reportBuss Rotorway Exec · Eden Prairie, MNThe pilot's inadvertent deactivation of the battery switch leading to the helicopter's loss of engine power on base leg. A factor was the crops he encountered during the emergency landing.NTSB CHI04LA285Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Perham, MNThe dual student's improper compensation for the crosswind condition and his subsequent failure to maintain control of the airplane. An additional cause was the flight instructor's inadequate remedial action. A contributing factor was the crosswind condition.NTSB CHI04FA284Accident · 1 fatalField investigationFinal reportCessna 182Q · Morris, MNThe pilot's inadequate weather evaluation that resulted flight into night instrument meteorological conditions and a subsequent loss of aircraft control. Factors to the accident were the pilot's lack of recent night experience and the low cloud ceiling at…NTSB CHI04CA291Accident · No injuriesData collectionFinal reportJohnson Titan Tornado I · Carlton, MNThe pilot's failure to abort the takeoff. Factors to the accident included the diminished takeoff performance due to the incorrect propeller pitch setting and the tree that the airplane impacted.NTSB CHI04CA252Accident · No injuriesData collectionFinal reportCessna T310R · Marshall, MNThe pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…NTSB CHI04CA244Accident · Minor injuriesData collectionFinal reportBeech BE-18 · Lakeville, MNThe pilot's inadequate flare, the improper recovery from a bounced landing, the loss of directional control, and inadequate compensation for the crosswind. A factor was the crosswind.NTSB CHI04WA235Accident · 2 fatalForeign investigationChampion 7ECA · Angle Inlet, MNNTSB CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.NTSB CHI04CA190Accident · No injuriesData collectionFinal reportSelby Dean KR-2-SS · Lake Elmo, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control. A related factor was the crosswind.NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB CHI04CA180Accident · No injuriesData collectionFinal reportTexas Helicopter M-74 · Clear Lake, MNThe pilot failed to maintain a proper glidepath to the landing zone. A factor was the truck pad.