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 CHI05LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mt. Pleasant, MIThe pilot's misjudged distance/speed which led to an overrun and collision with a vehicle. Contributing to the accident was the flight instructor's delayed remedial action in executing a go-around.NTSB NYC05LA085Accident · Minor injuriesLimited investigationFinal reportCessna 525A · Atlantic City, NJThe pilot's improper decision to plan a flight to a runway of insufficient length, his improper in-flight decision to land on that inadequate runway with a tailwind, and his failure to obtain the proper touchdown point. A factor in the accident was the…NTSB ANC05LA073Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Palmer, AKThe pilot's misjudged distance and speed, which resulted in an overrun during the landing roll, and subsequent nose over. Factors contributing to the accident were a tailwind and a short landing area.NTSB MIA05CA097Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Pensacola, FLThe pilot misjudged his altitude and distance resulting in an overrun. Also causal was the pilot's failure to execute a go-around.NTSB NYC05CA073Accident · No injuriesData collectionFinal reportCessna 172N · Wellington, OHThe pilot's failure to obtain the proper touchdown point, and his failure to initiate a go-around, which resulted in an overrun during landing. A factor in the accident was the tail wind.NTSB ATL05CA068Accident · No injuriesData collectionFinal reportCessna 310J · Union City, SCThe pilot's delay in aborting the landing. A contributing factor was the pilot's failure to maintain directional control.NTSB MIA05CA078Accident · No injuriesData collectionFinal reportCessna 180A · Orange Springs, FLThe pilot's failure to abort the landing and his misjudgment of the runway distance needed to complete the landing.NTSB NYC05IA055Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-125-700A · Teterboro, NJThe pilot in command's inadequate in-flight planning, which resulted in an overrun landing on a contaminated runway. Factors were inadequate crew coordination, gusty winds, and a slush covered runway.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 DFW05LA080Accident · Minor injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Shreveport, LAThe pilot's misjudgment of airspeed and his failure to abort the landing resulting in an overrun. A contributing factor was the wet runway.NTSB DCA05MA031Accident · Serious injuriesClass 1 · MajorFinal reportBombardier CL-600-1A11 · Teterboro, NJthe pilots' failure to ensure the airplane was loaded within weight and balance limits and their attempt to takeoff with the center of gravity well forward of the forward takeoff limit, which prevented the airplane from rotating at the intended rotation…NTSB CHI05FA059Accident · No injuriesField investigationFinal reportLearjet 35A · Kansas City, MOThe contaminated runway conditions during landing. Contributing factors were the operation of the airplane without thrust reversers, flight to the planned alternate airport not performed by the flightcrew, and the insufficient runway information. Additional…NTSB CHI05CA054Accident · No injuriesData collectionFinal reportCessna 152 · Stockton, MOthe pilot's failure to attain the proper touchdown point, which resulted in an overrun. Contributing factors were the tailwind and dusk light conditions.NTSB MIA05LA049Accident · No injuriesLimited investigationFinal reportBeech B300 · Jacksonville, FLThe pilot's failure to perform a missed approach after losing sight of the runway and the misjudgment of distance on the runway which resulted in an overrun. A contributing factor was the fog.NTSB CHI05FA053Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Eureka Springs, ARThe pilot misjudged his distance/speed which resulted in the overrun and subsequent impact with trees. The wet turf runway and the trees were factors in the accident.NTSB CHI05CA051Accident · No injuriesData collectionFinal reportCessna 414A · Harbor Springs, MIThe pilot's inadequate preflight planning/preparation by his failure to remove the accumulated airframe ice which resulted in deteriorated aircraft takeoff performance. Airframe ice, the snow bank and the fence were contributing factors.NTSB LAX05LA063Accident · No injuriesLimited investigationFinal reportCessna 340 · Carefree, AZthe pilot's improper use of the throttles during an aborted landing attempt that resulted in an engine over-boost condition requiring a reduction in power that then resulted in a runway overrun and collision with a ditch.NTSB LAX05CA059Accident · No injuriesData collectionFinal reportCessna 441 · Thermal, CAthe pilot's misjudged speed and distance, which resulted in a failure to attain the proper touchdown point and a subsequent overrun of the runway. A factor in the accident was limited braking effectiveness resulting from the wet runway condition.NTSB LAX05FA058Accident · Minor injuriesField investigationFinal reportPiper PA-46-350P · Palo Alto, CAthe pilot's misjudged distance and speed on final approach, which led to a long landing and a runway overrun. Also causal was the pilot's inadequate in-flight decision to continue flight with indications of apparent serious system anomalies, failure to divert…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.