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 CEN17LA148Accident · No injuriesLimited investigationFinal reportCessna T210M · Detroit Lakes, MNThe malfunction of the right main landing gear actuator for reasons that could not be determined because postaccident examination revealed no mechanical anomalies that would have precluded normal operation. Contributing to the accident was the improper…NTSB GAA17CA215Accident · Minor injuriesData collectionFinal reportCessna 182 · Blue Earth, MNThe pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…NTSB GAA17CA203Accident · No injuriesData collectionFinal reportAeronca 11AC · Warroad, MNThe pilot’s improper landing flare and his subsequent failure to maintain directional control during the landing in tailwind conditions.NTSB CEN17LA117Accident · Serious injuriesLimited investigationFinal reportJude Mike C Side Winder · Paynesville, MNThe pilot’s inadequate preflight inspection, during which he failed to ensure that there was sufficient coolant in the engine reservoir, which resulted in the engine getting too hot and the engine control module shutting down the engine.NTSB CEN17LA101Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Ellendale, MNThe pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.NTSB GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.NTSB CEN17LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Longville, MNThe in-flight encounter with wind shear and gusting wind conditions, which resulted in a bounced landing and runway excursion.NTSB CEN17LA058Accident · No injuriesLimited investigationFinal reportBellanca 17 30A · Blaine, MNA total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.NTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.NTSB CEN17LA021Accident · Serious injuriesLimited investigationFinal reportZenith CH-750 · Morristown, MNA total loss of engine power due to fuel vapor lock. Contributing to the loss of engine power were the corrosion of the spark plugs and the spacing of the electrode gaps.NTSB CEN17FA012Accident · 2 fatalField investigationFinal reportFairchild Hiller FH 1100 · Lino Lakes, MNThe separation of the main rotor assembly due to mast bumping.NTSB CEN16LA391Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cloquet, MNA lack of lubrication in the engine for reasons that could not be determined based on the available information, which resulted in a failure of the No. 4 connecting rod and a subsequent total loss of engine power.NTSB CEN16FA372Accident · Serious injuriesField investigationFinal reportAgusta A109 · Alexandria, MNThe pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.NTSB CEN16LA369Accident · No injuriesLimited investigationFinal reportStinson V77 · Jordan, MNA partial loss of engine power due to carburetor icing.NTSB CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.NTSB CEN16LA326Accident · 1 fatalLimited investigationFinal reportThrush S2R T660 · Ruthton, MNThe pilot's failure to see and avoid the tower guy-wire during an agricultural spraying operation.NTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.NTSB CEN16LA324Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Lino Lakes, MNA partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with vegetation and terrain during takeoff.NTSB CEN16LA303Accident · No injuriesLimited investigationFinal reportHughes 269A · Morris, MNThe pilot's failure to maintain clearance from terrain due to his distraction by the navigation system.NTSB GAA16CA399Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Bird Island, MNThe pilot's diverted attention inside the cockpit and failure to maintain the airplane's altitude while maneuvering at a low altitude, resulting in an impact with terrain.NTSB CEN16LA287Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Dodge Center, MNA partial loss of engine power due to carburetor ice.NTSB CEN16LA242Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Wyoming, MNThe pilot’s inadequate flight planning and navigation for a flight at night, which resulted in his having to conduct a precautionary landing on an interstate highway due to low fuel and impacting the post of a wire road divider.NTSB CEN16LA231Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blaine, MNThe pilot's failure to maintain a proper airspeed during the landing approach, which resulted in an improper flare and hard landing.NTSB GAA16LA325Accident · No injuriesLimited investigationFinal reportMD Helicopter 369E · Brainerd, MNThe failure of the helicopter’s windscreen for reasons that could not be determined based on the available information, which resulted in substantial damage to the main rotor blades and horizontal stabilizer.NTSB GAA16CA293Accident · No injuriesData collectionFinal reportBell 47G · Hastings, MNThe pilot's failure to attain a positive rate of climb during takeoff from a service truck, which resulted in an impact with terrain and substantial damage to the tail boom and fuselage.NTSB GAA16CA255Accident · Minor injuriesData collectionFinal reportJohn Steven Caturia Replica PA18 · Braham, MNThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB GAA16CA256Accident · No injuriesData collectionFinal reportCirrus Design SR20 · South St Paul, MNThe pilot's excessive nose high pitch attitude, which resulted in a tail strike during the landing flare.NTSB CEN16LA175Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge X Classic · Rush City, MNThe student pilot's failure to maintain the appropriate pitch attitude during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the student pilot’s decision to conduct a solo flight without a solo endorsement in an…NTSB CEN16LA156Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Arden Hills, MNA partial loss of engine power for reasons that could not be determined based on the available evidenceNTSB GAA16CA189Accident · No injuriesData collectionFinal reportTL Ultralight Sro TL-3000 Sirius · South St. Paul, MNThe pilot's failure to maintain a proper landing flare in gusty wind conditions, which resulted in a hard landing and substantial damage to the firewall.NTSB DCA16CA089Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 132 · Minneapolis, MNan encounter with turbulence that resulted in a serious injury to a passenger who was standing when the fasten seatbelt sign was illuminated.NTSB CEN16LA061Accident · Minor injuriesLimited investigationFinal reportGlobe GC 1B · Lake Elmo, MNA loss of engine power due to the carburetor’s primary venturi, fuel nozzle, or both separating after takeoff.NTSB CEN16CA070Accident · No injuriesData collectionFinal reportCessna 172 · Rush City, MNThe student pilot did not maintain directional control of the airplane and applied excessive right rudder during landing.NTSB GAA16CA050Accident · No injuriesData collectionFinal reportCessna 182Q · Bowstring, MNThe pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with a wind sock and terrain.NTSB GAA16CA019Accident · No injuriesData collectionFinal reportMaule M 7-235C · Mankato, MNThe pilot's failure to maintain directional control during the go-around, which resulted in a collision with terrain.NTSB CEN15LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA 22-160 · Tyler, MNThe student pilot's failure to adequately ensure the carburetor was clear of ice before takeoff, which resulted in a partial loss of engine power during takeoff due to carburetor icing.NTSB GAA15CA222Accident · No injuriesData collectionFinal reportCessna A185F · Emily, MNThe pilot's failure to retract the landing gear, which resulted in a gear down water landing and a nose over.NTSB CEN15LA326Accident · No injuriesLimited investigationFinal reportEagle Eagle DW 1 · Hector, MNThe intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…NTSB CEN15FA321Accident · 3 fatalField investigationFinal reportChristensen Steve Wheeler Express · Holland, MNThe pilot’s failure to maintain adequate airspeed during a high-pitch, steep right turn, which resulted in the exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall, loss of control, and impact with terrain. Contributing to…NTSB GAA15CA206Accident · No injuriesData collectionFinal reportCessna T210L · Duluth, MNThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's diverted attention to another airplane in the vicinity and that he inaccurately…NTSB CEN15LA309Accident · No injuriesLimited investigationFinal reportCessna 172RG · Anoka, MNFailure of the left landing gear actuator for reasons that could not be determined because the actuator was not made available for examination.NTSB CEN15CA304Accident · No injuriesData collectionFinal reportCessna 340 · South St. Paul, MNThe airplane's inability to takeoff for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies. The aborted takeoff resulted in a runway overrun and impact with a fence.NTSB GAA15CA151Accident · No injuriesData collectionFinal reportFlight Design Ctls · Andover, MNThe pilot's improper fuel management and preflight planning, which resulted in the total loss of engine power due to fuel exhaustion and a forced landing in a field where the airplane nosed over.NTSB GAA15CA109Accident · Minor injuriesData collectionFinal reportKretsinger Bensen B8M · Maple Plain, MNThe pilot's failure to maintain airspeed, resulting in a loss of control, and a collision with terrain.NTSB GAA15CA086Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 200 · Glenwood, MNThe pilot's improper lateral/ bank level off during the landing flare, which resulted in the right wing impacting the water and a subsequent loss of control.NTSB CEN15FA181Accident · 2 fatalField investigationFinal reportPiper J-4A · Pine River, MNThe pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…NTSB CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.NTSB CEN15CA041Accident · No injuriesData collectionFinal reportCessna 510 · Faribault, MNAn inflight collision with a goose while descending to land at the destination airport.NTSB DCA15CA012Accident · No injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MNthe B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.NTSB CEN15CA036Accident · Minor injuriesData collectionFinal reportFlight Design CTLSi · White Bear Lake, MNThe pilot's exceedance of the airplane's critical angle of attack during the landing, which resulted in an inadvertent aerodynamic stall, a hard landing, and a nose over.