NTSB investigations, MS
11 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
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\" = 'MS' 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" = 'MS' 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 DFW07CA045Accident · No injuriesData collectionFinal reportErcoupe 415-C · Lakeshore, MSThe landing overrun for unknown reasons. A factor was the ditch.NTSB ATL05FA061Accident · No injuriesField investigationFinal reportCanadair CL-600 · Tupelo, MSThe inadequate design of the microphone jack assembly Supplemental Type Certificate by production design personnel resulting in the aft restriction of the control column at rotation airspeed, aborted takeoff, and collapse of the nose gear on the overrun.NTSB MIA03LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Foxworth, MSThe failure of the pilot to perform a go-around, his failure to attain the proper touchdown point, and his delay in applying the normal brakes resulting in his inability to stop the airplane and subsequent on-ground collision with a fence.NTSB MIA00LA237Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Perthshire, MSthe pilot's failure to perform a weight and balance check that resulted in overloading of the airplane with spraying material, for the weather conditions that existed at the time of takeoff. Factors in this accident were extremely high temperatures, which…NTSB MIA98LA178Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clarksdale, MSThe pilot's failure to extend the flaps for takeoff. A factor was his diverted attention to the loading of the airplane.NTSB MIA95LA184Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Ruleville, MSThe pilot-in-command's failure to abort the takeoff when the aircraft accelerated slowly. Contributing to the accident was the over loading of the aircraft by ground personnel and the failure of the pilot-in-command to verify the loading of the aircraft.NTSB MIA90LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, MSThe student pilot landed long and delayed applying power during the ground roll of the touch-and-go landing.NTSB MIA89LA209Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Ackerman, MSThe pilot's selection of the wrong runway and his improper inflight planning/decision which resulted in a situation from which he could neither go-around nor stop on the remaining runway. The thunderstorms, inoperative (disrepaired) wind sock, and rough…NTSB ATL85LA095Accident · No injuriesLimited investigationFinal reportBeech 58 · Natchez, MSPlt descended below mda to 720 ft MSL until observing the rwy during a LOC 17 apch at night. An arpt attendant said plt did not call UNICOM for wind info. Plt acknowledged touchdown at midfield with a 30 kt tailwind on the 5000 ft rwy. The plt said braking…NTSB ATL84LA229Accident · No injuriesLimited investigationFinal reportCessna A188B · Crenshaw, MSThe pilot acknowledged that he attempted to take off on an aerial application flt with the acft loaded above its maximumcertificated gross weight. He stated that he had previously flown with chemical loads & had not encountered problems taking off. Prior to…NTSB ATL82FKQ13Accident · Serious injuriesFinal reportCessna 182P · Winona, MSThe pilot stated that after a takeoff run, the controls locked and he could not pull the aircraft off of the runway. Subsequently, the plane collided with a dirt bank beyond the end of the runway, became inverted, and slid backwards. An inspection of the…