NTSB investigations, 2004
48 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 131 |
|---|---|
| 1983 | 132 |
| 1984 | 124 |
| 1985 | 86 |
| 1986 | 59 |
| 1987 | 77 |
| 1988 | 65 |
| 1989 | 62 |
| 1990 | 66 |
| 1991 | 51 |
| 1992 | 69 |
| 1993 | 70 |
| 1994 | 62 |
| 1995 | 75 |
| 1996 | 60 |
| 1997 | 52 |
| 1998 | 46 |
| 1999 | 50 |
| 2000 | 42 |
| 2001 | 36 |
| 2002 | 46 |
| 2003 | 53 |
| 2004 | 48 |
| 2005 | 47 |
| 2006 | 41 |
| 2007 | 31 |
Where
Latest 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 year(c.\"eventDate\") = 2004
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 year(c."eventDate") = 2004 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 LAX05LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Waialua, HIthe pilot misjudged distance and altitude and failed to attain the proper landing touchdown point.NTSB IAD05CA025Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Wheeling, WVThe pilot misjudged his distance/speed, and his intentional landing on an unsuitable taxiway at night. A factor in the accident was the night light conditions.NTSB ANC05LA068Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Utopia, AKThe pilot's misjudged distance/speed while on final approach to land, which resulted in an overrun during the landing roll. Factors associated with the accident are the pilot's inadequate weather evaluation, and a gusty tailwind.NTSB DFW05LA030Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 20 · Pine Bluff, ARThe pilot's misjudgment of speed/distance which resulted in a runway overrun. Contributing factors were the moderate rain and the reported encounter with hydroplaning conditions.NTSB LAX05CA043Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Monica, CAthe certified flight instructor's inadequate supervision, inadequate compensation for the tailwind condition, and delayed remedial action, which resulted in a runway overrun and collision with a ditch.NTSB IAD05CA018Accident · No injuriesData collectionFinal reportPiper PA 28-181 · York, PAThe pilot's inadequate weather evaluation and his decision to depart from a rain-soaked runway with strong quartering tailwinds, which resulted in a runway overrun and collision with a fence during the aborted takeoff.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.NTSB MIA05LA012Accident · No injuriesLimited investigationFinal reportRockwell 112A · Tampa, FLThe pilot's failure to properly set flaps for takeoff which resulted in the aborted takeoff and subsequent impact with water during an overrun of the runway and seawall.NTSB DFW05CA006Accident · No injuriesData collectionFinal reportGunnoe Velocity · Myrick, OKThe pilot's improper wind evaluation. Contributing factors were the tailwind and the short runway.NTSB LAX05CA006Accident · Minor injuriesData collectionFinal reportCessna 182RG · Placerville, CAthe pilot's misjudged distance and speed, and failure to attain the proper touchdown point, which resulted in the airplane overrunning the runway surface and nosing over after encountering soft terrain.NTSB CHI04CA286Accident · No injuriesData collectionFinal reportCessna C-150J · Oxford, IAThe student pilot's failure to attain a proper glidepath which resulted in exceeding the proper touchdown point. An additional cause was his failure to abort the landing. The embankment was a factor.NTSB ATL04CA196Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Charlotte, NCThe pilot's misjudgment of speed and distance resulting in an overrun and collision with trees.NTSB SEA04CA193Accident · No injuriesData collectionFinal reportPiper PA-28 · Deer Harbor, WAThe pilot's failure to perform remedial action during the landing sequence. A factor contributing to the accident was the wet runway surface.NTSB SEA04CA185Accident · Minor injuriesData collectionFinal reportCessna 180H · McCall, IDThe pilot's failure to attain proper touchdown point for landing on the backcountry airstrip. Contributing factors were downdraft weather conditions and the pilot's excessive speed for landing.NTSB NYC04CA207Accident · No injuriesData collectionFinal reportCessna 402C · Charleston, WVThe pilot's improper decision to abort the takeoff with insufficient runway remaining. A factor was the wet runway.NTSB ATL04CA174Accident · No injuriesData collectionFinal reportGrumman American AA1C · Boone, NCThe pilot's selection of the wrong runway, and his misjudgment of the distance and speed during the approach to land, which resulted in the overrun of the runway surface and subsequent collision with trees. A factor was tailwind.NTSB ATL04CA172Accident · No injuriesData collectionFinal reportCessna 152 · Waycross, GAThe pilot misjudged the approach speed to touchdown, and the hydroplaning of the airplane during the landing roll resulted in the overrun of the runway surface and the subsequent collision with a fence. .NTSB CHI04CA239Accident · No injuriesData collectionFinal reportCessna 150H · Golden, MOThe pilot's misjudgment of speed and distance. A factor was the tires positioned at the end of the runway.NTSB FTW04CA228Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe pilot's misjudged distance and his failure to abort the landing. A factor was the prevailing tailwind.NTSB LAX04CA288Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe student pilot's failure to abort the takeoff. A contributing factor was the pilot's failure to maintain directional control.NTSB CHI04LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Bradford, ILThe pilot's misjudgment of speed and distance, and his failure to perform a go-around. Additional factors were the wet runway and the ditch.NTSB CHI04LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Custer, SDThe pilot's poor preflight planning/preparation and the pilot used improper aborted takeoff procedures by not reducing the throttle. Factors associated with the accident were the high density altitude and the tailwind.NTSB CHI04CA195Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Omaha, NEThe pilot's failure to attain a proper touchdown point on the runway during landing. Contributing factors were the pilot's failure to perform a go-around, the ditch and the roadway encountered during the overrun.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 SEA04CA141Accident · No injuriesData collectionFinal reportCessna 172D · Morton, WAThe pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.NTSB MIA04CA118Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Sugar Loaf Key, FLThe failure of the pilot to attain the proper touchdown point resulting in a landing overrun and subsequent on-ground collision with trees.NTSB MIA04FA107Accident · No injuriesField investigationFinal reportLearjet 55 · Fort Lauderdale, FLThe flight crew's decision to continue the approach into known area of potentially severe weather (Thunderstorm), which resulted in the flight encountering a 30 knot cross wind, heavy rain, low-level wind shear, and hydroplaning on a ungrooved contaminated…NTSB LAX04CA262Accident · No injuriesData collectionFinal reportManoucher Lancair 360 Mkii · Pacoima, CAthe pilot misjudged the airplane's distance/speed which resulted in an overrun. A contributing factor was the tailwind.NTSB ATL04CA134Accident · Minor injuriesData collectionFinal reportCessna T210N · Ellijay, GAThe pilot misjudged his airspeed, distance and intended proper touchdown point which resulted in an overrun of the runway surface and the subsequent collision with an embankment.NTSB MIA04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lake Wales, FLThe pilot's delay in aborting the takeoff resulting in an overrun of the runway and subsequent impact with water. A finding in the accident was the pilot's failure to extend the flaps to the second notch (25 degrees).NTSB CHI04CA139Accident · No injuriesData collectionFinal reportCessna TR182 · Hamberg, NDThe pilot's inadequate in-flight planning/decision and his misjudgment of speed and distance.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.