NTSB investigations, MT
16 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 3 |
Where
Open the mapLatest cases
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\" = 'MT' 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" = 'MT' 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 SEA07LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTThe student pilot's misjudged distance/speed during final approach, which resulted in an overrun during landing roll and collision with a fence.NTSB SEA06LA138Accident · No injuriesLimited investigationFinal reportCessna Citation 560 · Hamilton, MTThe pilot's failure to attain the proper touchdown point and to execute a go-around, which lead to an overrun of the runway surface. Contributing to the accident was his failure to maintain the correct landing approach speed (Vref), his failure to maintain…NTSB SEA06CA106Accident · No injuriesData collectionFinal reportCessna 170B · West Glacier, MTThe pilot's failure to attain sufficient airspeed for flight, his attempt to abort the takeoff, and the airplane's subsequent departure off the end of the runway. Contributing factors were the impacted fence and vegetation, and his total lack of experience in…NTSB SEA04CA142Accident · No injuriesData collectionFinal reportCessna 182N · Bainville, MTThe pilot's misjudgment of his airspeed on landing, and his subsequent overrunning of the runway. A contributing factor was the trees.NTSB SEA03CA155Accident · Minor injuriesData collectionFinal reportCessna 170B · Schafer, MTThe pilot's delayed remedial action during the takeoff roll. Factors include wet terrain, a fence and an embankment located at the end of the runway.NTSB SEA96LA138Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTthe pilot's failure to follow the proper short field takeoff procedure as specified in the Airplane Flight Manual, his improper use of wing flaps during the takeoff, and his failure to abort the takeoff (while there was sufficient runway remainin). A factor…NTSB SEA95LA193Accident · No injuriesLimited investigationFinal reportHall Kitfox 1 · Pompeys Pillar, MTthe pilot's delayed decision to abort the takeoff. High density altitude, unavailabilty of aircraft takeoff performance data, and the short rough takeoff area were factors in the accident.NTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.NTSB DEN89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTMisjudgement of the proper touchdown point by the pilot, which resulted in an overrun of the landing area and collision with a post. The downhill terrain condition and location of the fence post were related factors.NTSB DEN88LA012Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Ekalaka, MTDuring the takeoff roll the pilot encountered an unexpected tailwind. The pilot reported that he tried to abort the takeoff but tall grass and the tailwind did not allow the aircraft to decelerate properly. The aircraft ran through two drainage ditches and…NTSB DEN86LA234Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Dillon, MTPlt said he called UNICOM for arpt advisory and heard operator say something about six. He thought she said rwy 6 was the preferred rwy (there is no rwy 6 at Dillon arpt). Operator actually said rwy 16 was the preferred rwy. Plt landed past midway point of…NTSB DEN83LA066Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cut Bank, MTThe acft nosed over after overrunning the end of the runway during an aborted takeoff. The runway was grass and there was a 90 degree crosswind. During takeoff a downdraft put the acft back on the ground. The pilot decided to abort the takeoff and retarded…NTSB DEN82DA203Accident · No injuriesFinal reportPiper PA-28-151 · Near Darby, MTSince the shook mountain resort airport was new to the pilot, he called the airport to get further information. He stated that the person who answered reported it was a nice day and the wind sock had blown down. During arrival, he approached from the…NTSB DEN82DA179Accident · No injuriesFinal reportBeech A23-19 · Helena, MTAccording to a witness, the pilot was attempting to land on a dirt road that is also used as a landing strip. The aircraft touched down approximately 1500 feet at the downhill end of the runway, ballooned by a wind gust and moved to the east extreme of the…NTSB DEN82DA051Accident · No injuriesFinal reportCessna 182K · St. Ignatius, MTThe pilot stated that he and his passengers attempted to remove as much snow as possible from the aircraft and that he was confident that the propeller blast would blow away whatever snow remained. Although the wind at surrounding stations was generally…NTSB DEN82DA048Accident · No injuriesFinal reportCessna T182RG · Laurel, MTThe aircraft landed long on a down slope runway and ran off the end collapsing the landing gear. The pilot stated that he should have used full flaps instead of the 20 degrees he used.