NTSB investigations
1,681 cases where the first occurrence was “Overrun”.
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.\"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."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 CHI04LA137Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Blissfield, MIThe pilot selected the wrong runway on which to land which resulted in exceeding the proper touchdown point during landing. Factors associated with the accident were the tailwind condition and the drainage ditch which the airplane contacted.NTSB LAX04CA236Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dunsmuir, CAthe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. The pilot's failure to use flaps and his landing at an airport with a runway shorter than he expected is a contributing factor.NTSB SEA04LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Vernonia, ORThe instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.NTSB DCA04MA049Accident · No injuriesMajor investigationFinal reportRaytheon Corporate Jets 390 Premier I · North Las Vegas, NVThe flight's unstabilized approach and excessive speed. Contributing to the excessive touchdown speed was the presence of a tailwind at landing.NTSB FTW04CA140Accident · Minor injuriesData collectionFinal reportBeech BE-58P · Oklahoma City, OKThe pilot's failure to attain the proper touchdown point of the runway. Contributing factors were the excessive airspeed and the pilot's failure to initiate a go-around.NTSB NYC04CA131Accident · No injuriesData collectionFinal reportCessna 120 · New Castle, PAThe pilot's failure to use all available takeoff area and his delay in aborting the takeoff.NTSB LAX04CA220Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Sparks, NVthe student pilot's misjudged altitude, distance, and speed, and failure to attain the proper touchdown point, resulting in an overshoot of the runway.NTSB LAX04CA212Accident · No injuriesData collectionFinal reportBeech A60 · Gualala, CAthe pilot's inadequate in-flight planning which resulted in a downwind landing. The tailwind was a contributing factor and an overrun of the runway.NTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…NTSB ATL04CA101Accident · No injuriesData collectionFinal reportBeech D95A · Athens, GAThe pilot's misjudgment of airspeed and distance which resulted in an overshoot of the runway and collision with ground. The tailwind was a factor.NTSB FTW04LA100Accident · Minor injuriesLimited investigationFinal reportMurphy Glasair III · Weatherford, TXThe pilot's misjudgment of the runway distance due to his misperception of his location point on the runway.NTSB ANC04LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Levelock, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an overrun. Factors contributing to the accident were the pilot's inadequate weather evaluation, a tailwind, and a slippery, ice-covered landing surface.NTSB ATL04LA084Accident · No injuriesLimited investigationFinal reportMaule MX-7-180A · Plains, GAThe pilot's misjudgment of the speed/distance/altitude which resulted in a overrun of the runway.NTSB ANC04LA034Accident · No injuriesLimited investigationFinal reportCessna 170A · North Pole, AKThe pilot's delayed response in initiating an aborted takeoff, which resulted in an overrun and collision with a snowbank.NTSB CHI04LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Bourbon, INThe inadequate annual inspection in that the worn brake disks were not replaced which resulted in diminished braking capability during the landing roll. A factor associated with the accident was the utility pole that the airplane contacted.NTSB NYC04CA066Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Grt. Barrington, MAThe pilot's misjudgment of the airplane's distance/speed and failure to obtain the proper touchdown point, which resulted in an overrun. A factor was the cross wind.NTSB LAX04CA105Accident · No injuriesData collectionFinal reportBeech B36TC · San Diego, CAthe pilot's misjudged speed and altitude, which led to a failure to attain the proper touchdown point and a subsequent runway overrun. Also causal was the pilot's delayed decision to perform a go-around.NTSB NYC04IA054Incident · No injuriesIncident investigationFinal reportCanadair CL-600 · Teterboro, NJThe captain's inadequate preflight planning, which resulted in an overrun during an aborted takeoff.NTSB SEA04LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Emmett, IDBrake failure as a result of inadequate hydraulic (brake) fluid in the aircraft's closed brake system. Contributing factors were the pilot's overall lack of experience in the aircraft make/model, the cold soaked brake system due to the low temperatures, and…NTSB NYC04LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Tunkhannock, PAThe pilot's misjudgment of distance resulting in an overrun.NTSB NYC04CA028Accident · No injuriesData collectionFinal reportCessna 172K · Kilbourne, OHThe pilot's failure to obtain the proper touchdown point which resulted in an overrun and subsequent nose over.NTSB LAX04LA030Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Angeles, CAThe pilot's misjudgment of distance and speed on the approach resulting in an overrun.NTSB ATL04LA022Accident · No injuriesLimited investigationFinal reportDiamond DA 20-C1 · Murfreesboro, TNThe pilot's failure to attain adequate airspeed, which resulted in a stall mush and collision with a taxiway sign. A factor was the pilot's delay in aborting the landing.NTSB MIA04CA005Accident · Minor injuriesData collectionFinal reportCessna 172N · Everglades City, FLThe pilot's improper preflight planning/preparation which resulted in the airplane's gust lock being left installed, which resulted in the airplane not being able lift off during the takeoff roll, and damage to the airplane when it overran the runway and…NTSB ATL04LA020Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Beaufort, NCThe pilot's misjudgment of speed and distance, and his failure to perform a go-around which resulted in an overrun and on ground collision with terrain.NTSB IAD04CA001Accident · No injuriesData collectionFinal reportCessna 172P · Sussex, NJThe flight instructor's failure to initiate a go-around. A factor was the wet runway conditions.NTSB CHI03LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Versailles, MOThe pilot touched down with excessive airspeed. Factors associated with the accident were the trees, the wet runway, the wet grass that the airplane traveled onto, and the ditch which the airplane contacted.NTSB LAX03LA293Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAthe pilot's misjudged speed and distance, and his failure to perform a go-around which resulted in a runway overrun.NTSB FTW03FA229Accident · 1 fatalField investigationFinal reportLearjet 25B · Del Rio, TXThe pilot's misjudged distance and speed during the approach to landing, and his failure to obtain the proper touchdown point resulting in an overrun. A contributing factor was the pilot's failure to abort the landing.NTSB NYC03LA200Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Ashland, VAThe pilot's decision to perform an aborted takeoff after he perceived a power loss. A factor was the unsuitable terrain the airplane encountered after it overran the end of the runway.NTSB ANC03LA121Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an overrun and nose over during an aborted takeoff. Factors contributing to the accident were soft, sandy terrain, and a tailwind.NTSB CHI03LA311Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Cash, ARThe delayed aborted takeoff by the pilot. The ditch was a factor to the accident.NTSB NYC03CA193Accident · No injuriesData collectionFinal reportCessna 150M · Jetersville, VAThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor was the dew on the grass.NTSB CHI03LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Deer Grove, ILThe pilot's failure to attain the proper touchdown point, and his failure to execute a go-around.NTSB FTW03LA235Accident · No injuriesLimited investigationFinal reportVelocity RG · Skiatook, OKThe pilot's delay in aborting the takeoff. A contributing factor was the high density altitude.NTSB ANC03LA101Accident · No injuriesLimited investigationFinal reportCloud-Wag Aero Sportsmen · Noatak, AKThe pilot's misjudgment of the airplane's distance and speed, which resulted in the airplane not attaining the proper landing touchdown point and overrunning the landing site.NTSB FTW03LA202Accident · Minor injuriesLimited investigationFinal reportBeech BE-36TC · Temple, TXThe pilot's failure to attain adequate airspeed and his failure to abort the takeoff roll resulting in an overrun.NTSB CHI03LA328Accident · No injuriesLimited investigationFinal reportLet L-13 Blanik · Highland, ILThe pilot's failure to extend the spoilers and his inadvertent use of the flaps during final approach, which resulted in the proper touchdown point being exceeded due to excessive airspeed. A factor to the accident was the dirt mound.NTSB ANC03LA099Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's selection of an unsuitable landing area, which resulted in an overrun and an on ground/water collision with terrain. A factor associated with the accident was a tailwind.NTSB ANC03LA104Accident · No injuriesLimited investigationFinal reportAviat A-1A · Sitka, AKThe pilot's delay in aborting the takeoff, which resulted in a collision with the shoreline during an aborted takeoff.NTSB CHI03LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · La Monte, MOThe pilot's misjudgment of speed and distance resulting in an overrun of the runway.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 CHI03LA225Accident · No injuriesLimited investigationFinal reportBeech C23 · Madison, WIThe dual student's delay in executing the aborted takeoff. Also causal was the pilot-in-command's delayed remedial action.NTSB SEA03LA149Accident · No injuriesLimited investigationFinal reportCessna 182C · Cashmere, WAThe pilot in command's misjudgment of distance and speed, and his failure to execute a go-around. A contributing factor was the fence.NTSB SEA03CA138Accident · No injuriesData collectionFinal reportBeech F90 · Sunriver, ORThe pilot's misjudgment of distance while landing, which resulted in a runway overrun. Factors include rough uneven terrain and a tailwind.NTSB SEA03LA136Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Sullivan Lake, WAThe pilot-in-command's downwind landing. A contributing factor was the tailwind condition.NTSB SEA03LA135Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Arlington, WAThe pilot's failure to maintain proper approach speed and landing touch down point resulting in a runway overrun. A factor was the tailwind condition.NTSB NYC03CA149Accident · No injuriesData collectionFinal reportBeech BE36 · Block Island, RIThe pilot misjudged speed and distance while landing, which resulted in an overrun. A factor in the accident was a wet runway.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.NTSB CHI03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Brazil, INThe delayed aborted takeoff by the pilot-in-command. A contributing factor was the fence, which the airplane contacted during the aborted takeoff.