Skip to content

NTSB investigations, MN

19 cases where the first occurrence was “Overrun”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

Where

Latest cases

Query with SQL

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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340)
  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'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340)
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 CHI08CA042Accident · Minor injuriesData collectionFinal reportCessna 180 · Becker, MNThe pilot maintained excessive airspeed during the landing approach and failed to achieve a proper touchdown point. A factor associated with the accident was the fence that the airplane contacted.Nov 11, 2007 · N5248E · Substantial damage 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.Nov 20, 2004 · N737CR · Substantial damage NTSB CHI03LA190Accident · No injuriesLimited investigationFinal reportCessna A185F · Eveleth, MNThe pilot's misjudgment of speed and distance resulting in an overrun. Factors were the ditch embankment, and the tailwind component.Jul 1, 2003 · N30CM · Substantial damage NTSB CHI02LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Ulm, MNThe student and flight instructor not using all of the available runway, the inadequate supervision by the flight instructor and the unsuccessful remedial action by the flight instructor. The student not attaining the proper touchdown point and the plowed…Nov 6, 2001 · N523PU · Substantial damage NTSB CHI00LA300Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sandstone, MNthe pilot exceeding the proper touchdown point on the runway.Sep 15, 2000 · N4584P · Substantial damage NTSB CHI98LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Redwood Falls, MNthe pilot's not following proper short field landing procedures.Aug 15, 1998 · N4576F · Substantial damage 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.Jul 26, 1995 · N72WC · Substantial damage NTSB CHI95LA190Accident · No injuriesLimited investigationFinal reportCessna 150M · Bovey, MNThe pilot's delay in aborting the takeoff.Jun 21, 1995 · N45200 · Substantial damage NTSB CHI94LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, MNthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were the soft terrain and the ditch.Aug 28, 1994 · N1197X · Substantial damage NTSB CHI92LA256Accident · No injuriesLimited investigationFinal reportCessna A185F · St. Cloud, MNFailure of the pilot-in-command to abort takeoff before overrunning the lake edge.Aug 26, 1992 · N185RF · Substantial damage 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.Jan 11, 1992 · N9845H · Substantial damage NTSB CHI91LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNA poorly planned approach, and failure to take remedial action by the pilot.Oct 14, 1990 · N7385W · Substantial damage NTSB MKC90LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Starbuck, MNCompensation for wind conditions were misjudged and aircraft control was not maintained by the pilot in command.May 7, 1990 · N1633H · Substantial damage NTSB CHI87LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Delft, MNThe acft was loaded close to its gross wt limit & the plt atmtd to takeoff on a 2160 ft strip, using short field takeoff techniques. The acft became airborne for a short time, however, it began to settle. The plt elected to abort the takeoff, but was unable…Aug 10, 1987 · N4935F · Substantial damage NTSB CHI85LA057Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Blaine, MNInvestigation revealed that the plt landed the acft on rwy 35 with winds from 130 degrees at 15 KTS gusting to 23 KTS. The acft departed the end of the 4900 ft rwy where the left fuel tank was ruptured and a fire erupted.Nov 26, 1984 · N8336V · Destroyed NTSB CHI84LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNPreviously, the acft had been landed in a 1000 ft fld when the eng quit during a simulated emergency while on a dual instructional flt. The instructor plt decided to leave the student there & fly the acft back to the arpt. He walked down the field & made an…Jun 18, 1984 · N751AA · Substantial damage NTSB CHI83LA409Accident · No injuriesLimited investigationFinal reportCessna 172M · Grand Marais, MNThe plt took off from the departure point after an unexpected 1/2 hr delay. By the time he arrived at his destination, it was dark. No rwy lighting sys was installed, so someone at the arpt drove a car to rwy 27 to light up the approach end with the head…Sep 3, 1983 · N1857V · Substantial damage NTSB CHI83LA405Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Halstad, MNThe acft landed long and collided with an embankment at a private farm strip. The pilot stated he landed on rwy 35 and the wind was from 170 degrees at 5-10 KTS.Sep 1, 1983 · N6826G · Substantial damage NTSB CHI83LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Minneapolis, MNThe acft ran off the end of the rwy and collapsed the nose gear during an aborted takeoff. The acft exceeded the maximum gross weight for takeoff by 190 lbs. Decision to abort was made about 2/3 of the way down the rwy. Braking was good and deceleration…Jun 24, 1983 · N8310L · Substantial damage