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 CHI92LA285Accident · No injuriesLimited investigationFinal reportCessna 177B · Norcross, MNThe pilot's premature liftoff which resulted in inadequate airspeed for takeoff. Factors related to the accident were the crosswind conditions, the pilot's inadequate compensation for the crosswind, and the pilot's total lack of experience.NTSB CHI92FA257Accident · 3 fatalField investigationFinal reportCessna 310D · Crystal, MNThe pilot's failure to maintain aircraft control during takeoff/initial climb in gusty, shifting crosswind conditions.NTSB CHI92LA256Accident · No injuriesLimited investigationFinal reportCessna A185F · St. Cloud, MNFailure of the pilot-in-command to abort takeoff before overrunning the lake edge.NTSB CHI92LA244Accident · No injuriesLimited investigationFinal reportBeech 19A · Park Rapids, MNA hard landing due to excessive descent rate.NTSB CHI92DER03Accident · No injuriesFinal reportSchneider/Brashear Sorrell SNS-7 · Alexandria, MNThe pilot's failure to maintain directional control during the landing roll.NTSB CHI92LA235Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Paul, MNThe pilot's inattentiveness and improper use of the airplanes brakes. A factor which contributed to this accident was the incorrect brake system installed on the airplane.NTSB CHI92LA234Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Pinecreek, MNThe pilot-in-command's failure to obtain a proper climb rate.NTSB CHI92LA216Accident · No injuriesLimited investigationFinal reportCessna 150H · Bowlus, MNThe fracture of the number four cylinder's connecting rod cap.NTSB CHI92LA205Accident · No injuriesLimited investigationFinal reportCessna 180H · Blaine, MNThe pilot's inadvertent activation of wheel brakes.NTSB CHI92DER02Accident · No injuriesFinal reportPiper PA-25-235 · Badger, MNThe pilot's failure to maintain aircraft control while maneuvering at low altitude in gusty winds.NTSB CHI92FA201Accident · 4 fatalField investigationFinal reportCessna 172N · St Paul, MNInadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…NTSB CHI92DER01Accident · Serious injuriesFinal reportGoehring Quickie · So. St. Paul, MNA loss of engine power due to carburetor ice. The lack of suitable terrain for the forced landing was a factor.NTSB CHI92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Breezy Point, MNThe partial failure of the tail wheel assembly due to a fatigue fracture of an internal spring.NTSB CHI92LA175Accident · 1 fatalLimited investigationFinal reportChampion 7GCAA · Brainerd, MNAn excessive pull up and failure to maintain an airspeed above stalling speed by the pilot in command.NTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.NTSB CHI92LA108Accident · No injuriesLimited investigationFinal reportCessna 150 · Waseca, MNDirectional control was not maintained by the pilot.NTSB CHI92LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sandstone, MNThe collision with the deer, the damage to the gascolator which resulted from the collision and the pilot's decision to abort the landing after the collision.NTSB CHI92LA081Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Minneapolis, MNA misjudged autorotation.NTSB CHI92LA071Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Grand Rapids, MNThe pilot's lack of familiarity with aircraft systems which resulted in his failure to extend the landing gear by the alternate system. A factor was the loss of engine power.NTSB CHI92LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Lake Elmo, MNThe proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.NTSB CHI92LA055Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Roseau, MNThe pilot's failure to maintain proper alignment with, and not selecting the proper touchdown point on the landing runway. Factors associated with the accident are a dark night light condition and crosswinds.NTSB CHI92LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Minneapolis, MNRemedial action was not performed by the CFI. A factor related to the accident was directional control was not maintained by the student pilot.NTSB CHI92LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rochester, MNImproper use of autopilot during approach which resulted in proper alignment not maintained by the pilot. Factors related to the accident were turbulence and crosswinds, over confidence in aircraft's capability and overconfidence in personal ability.NTSB CHI92LA040Accident · No injuriesLimited investigationFinal reportMooney M20J · Morris, MNFailure to maintain proper glidepath. A factor related to the accident is the failure to perform remedial action, the dark night, and the snow shower in progress at the time.NTSB CHI92LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-200 · Lakeville, MNThe failure of both pilots to maintain visual separation from each other. Contributing factors to this accident were an inadequate visual lookout by both pilots and the pilot-in-command's failure to follow procedures and directives.NTSB CHI92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Willmar, MNAn inadequate weather evaluation which resulted in flight into icing conditions. Factors in the accident were the icing conditions and the excessive descent during landing.NTSB CHI92FA035Accident · 4 fatalField investigationFinal reportCessna 172RG · Litchfield, MNPilot factor in that he had spatial disorientation. Factors related to the accident are; VFR flight into IMC, disregarding hazardous weather advisories, performing flight into known adverse weather conditions, and overconfidence in personal ability by the…NTSB CHI92LA034Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Brainerd, MNAn engine failure due to a seized fuel pump rotor shaft.NTSB CHI92LA031Accident · No injuriesLimited investigationFinal reportCessna 310R · South St Paul, MNThe inadequate design of the propeller hub assembly which resulted in metal fatigue and propeller blade separation during initial climbout.NTSB CHI92LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Faribault, MNThe pilot's improper starting procedures and the passenger's inattentiveness. A related factor is the pilot's lack of supervision.NTSB CHI92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNInadequate preflight planning and preparation by the pilot in command, the non performance o fan emergency procedure and not maintaining a positive rate of climb on behalf of the pilot in command. Factors contributing to the accident were the pilot in…NTSB CHI92LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maple Lake, MNThe loss of engine power for an undetermined reason.NTSB CHI92FA009Accident · 2 fatalField investigationFinal reportBeech A36 · Lakeville, MNThe pilot-in-command's decision to continue flight into known adverse weather. Contributing to the accident was the encounter with weather conditions favorable for formation of airframe icing.NTSB CHI91LA287Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Lake Elmo, MNA loss of engine power for undetermined reasons. A factor contributing to the accident was the unsuitable terrain on which the pilot had to land.NTSB CHI91LA293Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Duluth, MNPremature touchdown while landing by the pic/cfi. Factors related to the accident were low ceilings, rain, and haze; weather evaluation misjudged by the pic/cfi; and visual outlook reduced.NTSB CHI91LA288Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Afton, MNThe pilot's inadvertent lowering of the wheels during the water landing.NTSB CHI91DER14Accident · Serious injuriesFinal reportMilner, Dick G Glasair II · Milaca, MNThe pilot's failure to maintain aircraft control during takeoff and departure which resulted in a dragged wing and ground impact. Related factors are the rough airstrip, the pilot's lack of expereince in the type of operation, and the premature lift-off.NTSB CHI91DER13Accident · No injuriesFinal reportBell 47G-3B-1 · Maple Grove, MNThe pilot's failure to maintain directional control of the helicopter during the forced landing. Related factors are the loss of engine power, loss of rotor RPM, the eroded compressor blades, the pilot's operation with known deficiencies in equipment and…NTSB CHI91LA255Accident · No injuriesLimited investigationFinal reportCessna 180 · Walker, MNDirectional control after landing was not maintained by the pilot. Factors related to the accident were a gusty crosswind and a downhill embankment (ditch).NTSB CHI91LA250Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Loman, MNFuel exhaustion due to fuel consumption calculations misjudged by the pilot.NTSB CHI91LA253Accident · No injuriesLimited investigationFinal reportCessna 180 · Eveleth, MNThe pilot's failure to maintain the proper descent rate and adequate airspeed during the approach. A factor related to the accident is the lack of recent total experience.NTSB CHI91LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Maple Lake, MNDirectional control was not maintained by the pilot. A factor related to the accident was the pilot's lack of total experience.NTSB CHI91LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Winona, MNImproper flare performed by the pilot. A factor related to the accident was lack of total experience by the pilot.NTSB CHI91LA240Accident · No injuriesLimited investigationFinal reportPiper J-3 · Saint Leo, MNPerformance data was misjudged resulting in a positive climb not being attained by the pilot. A factor related to the accident was high density altitude.NTSB CHI91DER12Accident · Serious injuriesFinal reportLacey B D4 · Albert Lea, MNThe pilot's failure to take adequate remedial action. Related factors are the tall grass runway conditions, and the inadequate airspeed.NTSB CHI91LA206Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlos, MNThe pilot's failure to use adequate carburetor heat. Factors to the accident were the carburetor icing conditions and the wires.NTSB CHI91DER10Accident · Serious injuriesFinal reportKolb Twinstar MK II · Staples, MNThe disconnected elevator trim cable. Related factors are the inadequate maintenance/installation, and the pilot's inability to maintain aircraft control.NTSB CHI91DER11Accident · No injuriesFinal reportPiper OA25-235 · Clinton, MNThe pilot's failure to maintain adequate control of the aircraft while maneuvering in aerial application operations. Related factors are wake turbulence and low altitude.NTSB CHI91DER09Accident · No injuriesFinal reportEagle Eagle DW-1 · Windom, MNThe pilot's improper aircraft handling. Related factors are the pilot's inattention and the airplane's deteriorated performance capability.NTSB CHI91DER08Accident · 1 fatalFinal reportBellanca 8GCBC · St. Hilaire, MNThe pilot's failure to maintain sufficient altitude while maneuvering.