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 CHI94LA144Accident · No injuriesLimited investigationFinal reportHelio H-800 · Foley, MNThe pilot-in-command's failure to perform accurate fuel consumption calculations. A factor was the soft gravel road landing area.NTSB CHI94LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Willmar, MNthe failure of the pilot in command to maintain directional control during touch and go landings. A factor was the pilot in command's lack of total experience and the snowbank located off the side of the runway.NTSB CHI94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hutchinson, MNthe pilot's failure to maintain directional control. Factors associated with the accident were the crosswind, the pilot's lack of total experience, the concrete block and the dirt back.NTSB CHI94LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Eden Prairie, MNThe pilot's poorly planned approach and remaining below a proper glide path during final approach. The pilot's lack of total expereince was a factor.NTSB CHI94FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Waseca, MNContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the ground. Factors related to the accident were: an inaccurate weather forecast by…NTSB CHI94LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Little Falls, MNan improper preflight by the pilot-in-command and the pilot's failure to maintain airspeed during a turn. A factor associated with the accident was contaminated fuel.NTSB CHI94LA059Accident · No injuriesLimited investigationFinal reportBeech C23 · Eden Prairie, MNan inadequate preflight by both the CFI and student pilot. Factors contributing to the accident was poor communications between the CFI and student pilot, and hilly terrain.NTSB DCA94MA022Accident · 18 fatalClass 1 · MajorFinal reportJetstream BA-3100 · Hibbing, MNThe captain's actions that led to a breakdown in crew coordination and the loss of altitude awareness by the flightcrew during an unstabilized approach in night instrument meteorological conditions. Contributing to the accident were: the failure of the…NTSB CHI94LA027Accident · No injuriesLimited investigationFinal reportCessna 170B · Maple Plain, MNThe pilot's improper compensation for wind conditions, failure to maintain runway alignment, and failure to maintain adequate airspeed during the aborted landing. Factors related to the accident were: high obstructions and the adverse wind conditions.NTSB CHI94LA026Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Saint Paul, MNother maintenance personnel's improper maintenance installation and fuel system line fitting undertorqued. Factors related to the accident were the dark night, along with the fence and posts which were contacted.NTSB CHI94IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Thief Rvr Falls, MNFatigue failure of the propeller blade, originating from a corrosion pit.NTSB CHI94LA007Accident · Minor injuriesLimited investigationFinal reportBoeing 75N1 · St Paul, MNFailure of the pilot to maintain proper altitude.NTSB CHI93IA382Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Grand Rapids, MNthe fractured aileron cable and other maintenance personnel's inadequate maintenance/adjustment.NTSB CHI93LA326Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Marshall, MNThe pilot's improper decision to depart after receiving a weather briefing which forecasted IMC en route and his loss of aircraft control due to spatial disorientation.NTSB CHI93FA322Accident · 2 fatalField investigationFinal reportPiper J-3C-85 · Salol, MNThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall. The pilot's lack of recent flight experience is a related factor.NTSB CHI93LA309Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L2B · Friedenberg, MNthe pilot's decision to fly the airplane with know deficiencies which resulted in a restricted fuel flow to the engine.NTSB CHI93LA300Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Ortonville, MNthe pilot's failure to refuel prior to fuel exhaustion.NTSB CHI93LA303Accident · No injuriesLimited investigationFinal reportSchweizer G167B · Borup, MNthe loss of engine power due to a cracked cylinder head.NTSB CHI93LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crookston, MNThe pilot in command's delayed in-flight decision. A factor to the accident is the pilot in command's failure to attain a proper touchdown point.NTSB CHI93LA254Accident · No injuriesLimited investigationFinal reportGrumman G164B · Eldred, MNthe pilot's failure to maintain directional control during the takeoff roll.NTSB CHI93LA257Accident · No injuriesLimited investigationFinal reportCessna T188C · Wheaton, MNThe pilot's failure to maintain alignment during takeoff roll.NTSB CHI93LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Felton, MNThe pilot-in-command's failure to maintain airspeed. Factors contributing to the accident were a cracked carburetor float, fuel starvation, and the failure to perform an annual inspection.NTSB CHI93LA240Accident · No injuriesLimited investigationFinal reportCessna R172K · Rice, MNThe pilot in command's failure to maintain proper clearance.NTSB CHI93LA231Accident · No injuriesLimited investigationFinal reportMooney M20C · Eveleth, MNThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Cloud, MNthe pilot's improper starting procedures.NTSB CHI93LA219Accident · No injuriesLimited investigationFinal reportBeech B19 · Victoria, MNThe loss of engine power due to a jammed carburetor float and the inability of the pilot to maintain clearance during the emergency landing.NTSB CHI93LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Elbow Lake, MNthe pilot's failure to maintain an adequate visual outlook during aerial application manuevers.NTSB CHI93LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Ely, MNthe pilot's decision to continue flight with a known deficiency in the airplane's hydraulic system. Factors associated with the accident are the loss of power in the left engine due to fuel contamination, and a leak in the hydraulic system.NTSB CHI93FA180Accident · 1 fatalField investigationFinal reportBeech C-18S · North Branch, MNexcessive use of brakes by the pilot-in-command.NTSB CHI93DER01Accident · 1 fatalFinal reportPitts S1 · Madison, MNThe pilot's failure to maintain adequate terrain clearance during aerobatic maneuvers.NTSB CHI93DER02Accident · No injuriesFinal reportMiller Quickie · Glencoe, MNThe disconnection of the ignition switch wiring.NTSB CHI93LA146Accident · No injuriesLimited investigationFinal reportChampion 7GCBA · Duluth, MNPilot in command failed to maintain directional control.NTSB CHI93LA147Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Middle River, MNThe total failure of the ignition system's magneto.NTSB CHI93LA134Accident · 1 fatalLimited investigationFinal reportCessna T188C · Belview, MNThe pilot-in-command's not maintaining proper altitude.NTSB CHI93LA195Accident · No injuriesLimited investigationFinal reportCessna A150L · Blaine, MNThe failure of the pilot of the Cessna 150, N6059J, and the pilot of the challenger to see and avoid each other.NTSB CHI93LA112Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Brainerd, MNThe pilot's improper flare which resulted in a bounced, hard landing and the subsequent loss of directional control.NTSB CHI93LA094Accident · No injuriesLimited investigationFinal reportBeech B90 · Albert Lea, MNAn inadvertent stall due to ice in the pitot/static system.NTSB CHI93LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Austin, MNThe pilot's failure to maintain altitude. The pilot's continued flight into IMC, diverted attention and the environmental conditions were factors.NTSB CHI93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-12 · White Bear Lake, MNThe pilot selected unsuitable terrain for landing. The snow covered runway was a factor.NTSB CHI93LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Warren, MNThe pilot's inadequate compensation for variable wind conditions during landing. The crosswind was a factor.NTSB CHI93LA080Accident · No injuriesLimited investigationFinal reportCessna 172D · Slayton, MNThe pilot's inadequate compensation for the crosswind condition. The crosswind was a factor.NTSB CHI93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · South St. Paul, MNThe pilot's inadequate compensation for the existing crosswind condition. The crosswind was a factor.NTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.NTSB CHI93LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, MNThe student pilot's failure to maintain directional control.NTSB CHI93MA061Accident · No injuriesMajor investigationFinal reportSaab-Scania 340A · Hibbing, MNThe first officer's failure to maintain a proper descent rate during the landing, and the captain's inadequate supervision by not taking timely action to ensure a safe landing. Factors which contributed to the accident were: the company's failure to provide…NTSB CHI93LA057Accident · No injuriesLimited investigationFinal reportBeech V35A · Marshall, MNThe pilot's improper aircraft handling during ground operation with a gusty tailwind.NTSB CHI93LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Elk River, MNFailure of the pilot to refuel the airplane before the flight.NTSB CHI93LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNThe pilot's failure to select a proper fuel selector position.NTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.NTSB CHI92LA295Accident · Serious injuriesLimited investigationFinal reportFunk, D.D. B85C · Buffalo, MNThe contamination of the carburetor, inadequate maintenance inspection by maintenance personnel, and the inadequate maintenance servicing by the pilot/owner.