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 CHI96LA300Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Walnut Grove, MNthe pilot's failure to maintain proper clearance from the transmission wire.NTSB CHI96LA275Accident · No injuriesLimited investigationFinal reportBeech V35B · Walker, MNfailure of the pilot to properly flare the airplane for landing, and her improper recovery from a bounced landing.NTSB CHI96LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Backus, MNthe pilot's failure to maintain adequate altitude and his abrupt maneuver to avoid the tree tops. The dark night was a factor.NTSB CHI96LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Emily, MNthe pilot misjudged his altitude and distance to the runway on final approach, and he failed to maintain obstacle clearance during landing. A factor relating to the accident was: the parked car.NTSB CHI96LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Beltrami, MNthe pilot's inadequate preflight planning. Factors in the accident were the pilot's failure to jettison the load and the soft runway overrun area.NTSB CHI96LA242Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Belle Plaine, MNthe pilot's misjudgment of the distance and speed during the landing, and his delay in initiating a go-around. Factors relating to the accident were: the tall grass and ravine at the end of the runway.NTSB CHI96LA226Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 Viking · Alexandria, MNthe flight instructor's failure to assure a proper fuel tank selector position. Factors associated with the accident were improper preflight preparation and complacency by the flight instructor.NTSB CHI96LA210Accident · 1 fatalLimited investigationFinal reportFarland Genesis · Le Sueur, MNthe pilot's impairment of judgment and performance due to drugs, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent and collision with terrain. Factors related to the accident were: the pilot's limited aeronautical…NTSB CHI96LA203Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Oslo, MNthe pilot not using carburetor heat when the engine began to lose power. Factors in this accident were carburetor ice formation and the soft landing surface the pilot had to use for landing.NTSB CHI96LA198Accident · No injuriesLimited investigationFinal reportPiper J-3 · Princeton, MNLoss of engine power for an undetermined reason.NTSB CHI96LA195Accident · No injuriesLimited investigationFinal reportCessna 150M · Red Wing, MNthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply. A factor relating to the accident was: soft terrain in the emergency landing area.NTSB CHI96FA184Accident · 4 fatalField investigationFinal reportPiper PA-46-310P · Aitkin, MNthe pilot's continued flight into known adverse weather conditions and the pilot exceeding the design stress limits of the airplane. Factors contributing to this accident were: the thunderstorms, hail, and wind gusts, and the airplane's over maximum gross…NTSB CHI96LA177Accident · No injuriesLimited investigationFinal reportCessna U206 · Inver Grove, MNthe pilot's improper recovery from the bounced landing. The gusty wind condition was a factor.NTSB CHI96LA186Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Crookston, MNcatastrophic engine failure.NTSB CHI96LA168Accident · No injuriesLimited investigationFinal reportCessna 188 · Roseau, MNthe pilot failed to maintain directional control during takeoff. The crosswind was a factor.NTSB CHI96LA166Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgregor, MNthe nose gear collapsed when it hit a soft spot in the runway.NTSB CHI96LA151Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Big Lake, MNthe pilot's inadequate preflight of the helicopter by not having removed a tiedown strap before attempting takeoff.NTSB CHI96LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Blaine, MNthe student pilot's inadvertent encounter with the propblast from another airplane. A factor relating to the accident was: failure of the student to communicate with the pilot(s) of the other airplane before taxiing behind it.NTSB CHI96LA147Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Blaine, MNfailure of the pilot to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall/spin.NTSB CHI96LA137Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Aitkin, MNthe pilot's improper planning/decision, which resulted in his failure (or inability) to adequately compensation for wind conditions. Factors relating to the accident were: the gusty crosswind condition and the snowbank.NTSB CHI96LA132Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Anoka, MNA loose exhaust system that had become disconnected and blocked, which resulted in partial loss of engine power.NTSB CHI96LA129Accident · Minor injuriesLimited investigationFinal reportCessna T310Q · Minneapolis, MNthe inadequate fuel supply for the intended flight which resulted in fuel exhaustion. Factors related to the accident were the pilot operating the airplane with an inoperative fuel gauge and the embankment which the airplane traveled down during the forced…NTSB CHI96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Thief Rvr Falls, MNA ruptured oil line, which resulted in oil exhaustion and subsequent loss of engine power.NTSB CHI96FA116Accident · 1 fatalField investigationFinal reportCirrus VK30 · Duluth, MNthe inadequate handling/performance design capabilities of the airplane which resulted in the inability to recover from an aft center of gravity spin. Factors were the lack of any antispin or deep stall recovery devices, and the aft center of gravity.NTSB CHI96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Paul, MNthe pilot's failure to assure an adequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the signs contacted by the airplane during the forced landing.NTSB CHI96LA106Accident · No injuriesLimited investigationFinal reportCessna 172E · Tofte, MNthe pilot's failure to perform adequate preflight planning which resulted in landing at a closed airport. The snow covered runway was a factor.NTSB CHI96LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Worthington, MNProgressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.NTSB CHI96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Warren, MNthe dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.NTSB CHI96LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sandstone, MNthe pilot's selection of an ice-covered runway for takeoff. A factor was the icy runway.NTSB CHI96IA066Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Bemidji, MNinadequate maintenance installation and inspection of the elevator flight control system which led to restricted flight control elevator movement due to a loose bolt.NTSB CHI96FA065Accident · 2 fatalField investigationFinal reportMumm Lancair · Morris, MNthe partially blocked elevator and improper installation of the elevator bob weight by the owner/builder which prevented full travel of the elevator control system. Factors relating to this accident were the intentional stall and inability to adequately…NTSB CHI96LA057Accident · No injuriesLimited investigationFinal reportBeech 58 · Minneapolis, MNthe pilot-in-command's abrupt maneuvering during the circling approach. The factors involved were the airframe ice and fog.NTSB CHI96LA050Accident · No injuriesLimited investigationFinal reportBeech B90 · Eden Prairie, MNthe pilot's failure to maintain clearance with the hangar while taxiing. A factor associated with the accident was the pilot's impairment due to alcohol.NTSB CHI95LA308Accident · No injuriesLimited investigationFinal reportLet L-23 Super Blanik · White Bear Lake, MNthe pilot's delayed retraction of the spoilers. Factors were the excessive sink rate and the power lines.NTSB CHI95LA311Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Staples, MNthe pilot's delay in the application of carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent forced landing in a swampy area. The carburetor icing (weather) condition was a related factor.NTSB CHI95FA307Accident · 1 fatalField investigationFinal reportCessna 172M · Orr, MNthe pilot misjudged the landing flare. Factors associated with the accident were the visual illusion caused by the glassy smooth water condition and the forward center of gravity.NTSB CHI95LA292Accident · Minor injuriesLimited investigationFinal reportCessna TC206G · Orr, MNthe pilot's failure to retract the landing gear prior to touchdown. A factor associated with the accident was the pilot's diverted attention.NTSB CHI95LA272Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Wadena, MNthe pilot's inattentiveness during the reversal turn, the pilot not maintaining control of the airplane, and the stall/mush encountered by the pilot.NTSB CHI95LA277Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Prague, MNthe failure of the pilot to maintain adequate airspeed to permit control of the aircraft and to prevent an inadvertent stall. Contributing factors include gusty wind conditions and turbulence.NTSB CHI95LA245Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Oklee, MNthe pilot failed to maintain clearance with trees. Factors associated with the accident were the trees and the pilot's diverted attention.NTSB CHI95LA244Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Morris, MNthe pilot failed to maintain obstacle clearance.NTSB CHI95LA240Accident · No injuriesLimited investigationFinal reportCessna 550 · Minneapolis, MNfailure of the landing gear braking system for undetermined reason(s) and the pilot's failure to perform the emergency procedure of operating the emergency brake system. Rough/uneven terrain was a related factor.NTSB CHI95LA239Accident · Minor injuriesLimited investigationFinal reportK. Davey And B. Davey WAG-AERO · Hokah, MNthe pilot performing low altitude flight and the failure to maintain clearance with the trees. A factors associated with the accident was the trees.NTSB CHI95LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Motley, MNthe pilot's failure to maintain control of the airplane during a soft field takeoff.NTSB CHI95LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot's failure to maintain altitude and/or clearance at the beginning of the spray run. A factor was turbulence due to the different Air temperatures of adjoining terrain.NTSB CHI95LA195Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNThe pilot's improper inflight planning/decision, which resulted in continued flight into adverse weather. Factors relating to the accident were: the thunderstorm outflow, and inadequate weather evaluation by the pilot.NTSB CHI95LA190Accident · No injuriesLimited investigationFinal reportCessna 150M · Bovey, MNThe pilot's delay in aborting the takeoff.NTSB CHI95LA169Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Clear Lake, MNfailure of the pilot to maintain directional control of the airplane during the takeoff roll. The proximity of trees to the runway was a related factor.NTSB CHI95LA172Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Dawson, MNthe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control of the airplane on takeoff. A factor in the accident was the tall grass.NTSB CHI95LA170Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-211 · St Paul, MNthe captain's not maintaining crew/group coordination. Factors were the captain's diverted attention and his not maintaining visual separation.