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 CHI94LA293Accident · No injuriesLimited investigationFinal reportSnow 600B · Grundy Center, IAthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were condition of the runway, the road, and the ditch.NTSB BFO94LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Waynesboro, VAThe pilot's misjudgement of speed and distance which resulted in a landing overrun. A contributing factor is the pilot's delay in intiating a go-around.NTSB BFO94LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wolfeboro, NHThe pilot's inadequate inflight decision, which resulted in a downwnind landing and overrun of the runway.NTSB ANC94LA102Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Bethel, AKThe pilot misjudged the strength of the tailwind and did not perform a go-around in a timely fashion so as to avoid landing the airplane halfway down the strip. Factors in the accident were the wet landing strip and the tailwind.NTSB NYC94LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Pennington, NJThe pilot's misjudged distance and speed during an aborted takeoff which resulted in an overrun. A contributing factor was the wet grass.NTSB CHI94LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Lone Rock, WIthe pilot's failure to attain a proper touchdown point on the runway.NTSB NYC94LA150Accident · Minor injuriesLimited investigationFinal reportBeech 58P · Newport, RIThe pilot's inflight planning/decision and failure to attain the proper touchdown point.NTSB FTW94LA260Accident · Serious injuriesLimited investigationFinal reportMaule M-5-210TC · Mosca, COThe pilot's failure to attain the proper touchdown point.NTSB CHI94LA252Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Flushing, MIthe pilot's improper touchdown position on the runway. A factor associated with the accident is the moving vehicle on the adjacent road.NTSB CHI94LA247Accident · No injuriesLimited investigationFinal reportCessna 182 · Greenwood, ILthe pilot-in-command's (CFI) inadequate aircraft preflight inspection and improper aborted takeoff. Related factors are the blocked pitot/static system, and the CFI's inadequate supervision during the preflight and takeoff.NTSB ANC94LA082Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kenai, AKThe pilot did not use the takeoff checklist to confirm that the flaps were extended for the takeoff.NTSB NYC94LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-700P · White Plains, NYThe pilot's delay in aborting the takeoff. A factor was internal obstruction of the pitot tube.NTSB ATL94LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Chapel Hill, NCThe pilot's failure to attain a proper touchdown point during landing. Factors were the wet, grass runway conditions.NTSB CHI94LA228Accident · No injuriesLimited investigationFinal reportBeech 58 · Oelwein, IAthe pilot's decision to land on a runway with a tailwind. Factors associated with the accident were the tailwind and the wet runway.NTSB FTW94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ravenna, TXThe pilot overshooting the landing and his failure to execute a G0-around. The wet grass was a factor.NTSB FTW94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Watson, ARWas the excessive airspeed during approach and the pilot's failure to execute a missed approach.NTSB BFO94LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Quarryville, PAThe pilot's failure to touchdown at the proper point and his delayed remedial action. A factor related to the accident was a tailwind.NTSB NYC94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphi, OHThe pilot's inadequate decision and his delay in aborting the takeoff, which resulted in an overrun of the runway and collision with obstaclesNTSB SEA94LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Hubbard, ORDelayed in flight planning/decision.NTSB LAX94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sonoma, CAThe pilot's failure to attain the proper touchdown point and his failure to initiate a go-around.NTSB ATL94FA110Accident · Serious injuriesField investigationFinal reportBeech 58P · Burnsville, NCThe failure of the pilot to attain a proper touchdown point, resulting in a long landing, and his delayed decision to go around. Factors were the mountainous conditions at the landing site, the existing tailwind, and the pilot's lack of familiarity with the…NTSB CHI94LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSthe pilot-in-command (CFI's) improper compensation for wind conditions and his poor in flight decision making. Factors were a tailwind and a vehicle on the runway.NTSB CHI94LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Weeping Water, NEthe pilot-in-command's misjudging compensation for wind conditions. Factors were tailwind, and wind information confusing.NTSB CHI94LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Mackinac Island, MIExcessive airspeed and a failure to attain the proper touchdown point on the runway. Factors related to the accident were the wet runway and the fence which was contacted.NTSB CHI94LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Harlan, IAthe delayed remedial action by the flight instructor. A factor related to the accident was the wet runway surface.NTSB DCA94MA053Accident · 8 fatalClass 1 · MajorFinal reportPiper PA31 · Stratford, CTThe failure of the captain to use the available ILS glideslope, his failure to execute a go-around when conditions were not suitable for landing, and his failure to land the airplane at a point sufficient to allow for a safe stopping distance; the fatalities…NTSB SEA94LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Hanksville, UTThe excess airspeed maintained by the pilot on final approach, and his failure to attain the proper touchdown point. Factors include loose gravel, and a berm off the end of the intended landing strip.NTSB SEA94LA102Accident · No injuriesLimited investigationFinal reportCessna 172L · Colville, WAThe pilot's failure to attain a proper touchdown point, and his excessive airspeed at the point of touchdown. Factors include the student pilot's lack of recent experience, and a ravine off the end of the runway.NTSB FTW94LA137Accident · No injuriesLimited investigationFinal reportJacobson SE5A Replica · Rosenberg, TXThe pilot's improper compensation for the winds. A factor was the tailwind.NTSB ATL94LA073Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boone, NCThe excessive speed used on final approach to the short runway by the pilot, and the failure of the pilot to use the proper touchdown point on the runway for landing.NTSB SEA94LA093Accident · No injuriesLimited investigationFinal reportCessna 210D · Cobalt, IDThe pilot selected unsuitable terrain for landing. Factors in the accident were: the wet runway and rising terrain that precluded a go-around.NTSB NYC94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Fairfield, NJThe failure of the pilot to attain a proper touchdown, at the proper speed which resulted in an overrun and contact with a fence. A factor was the failure of the pilot to follow his initial air traffic instructions.NTSB NYC94LA060Accident · No injuriesLimited investigationFinal reportCessna 172K · Dayton, OHthe pilot's failure to maintain directional control which resulted in a runway overrun. Factors are the pilot's improper recovery from a bounced landing, and his lack of experience.NTSB ATL94LA057Accident · No injuriesLimited investigationFinal reportCessna 182RG · Concord, NCThe pilot's inadequate preflight planning and preparation, in that he did not consider the effects of a wet, grass runway on aircraft performance. Factors were the wet, grass conditions of the runway surface.NTSB DCA94MA038Accident · Minor injuriesClass 1 · MajorFinal reportMcdonnell Douglas MD-82 · Flushing, NYThe failure of the flightcrew to comply with checklist procedures to turn on an operable pitot/static heat system, resulting in ice and/or snow blockage of the pitot tubes that produced erroneous airspeed indications, and the flightcrew's untimely response to…NTSB LAX94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Las Vegas, NVThe cfi's improper remedial action by failing to go-around instead of landing, the cfi's excessive touchdown speed, and his failure to obtain the proper touchdown point. The dual student's initial excessive airspeed and the ditch were factors in this accident.NTSB LAX94LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Watsonville, CAThe pilot's inadequate preflight inspection by failing to remove the pitot tube cover and delay in his remedial action by not beginning to stop the airplane until it was about 1,000 feet before the end of the runway. The soft terrain and the collapsed nose…NTSB ATL94LA044Accident · No injuriesLimited investigationFinal reportCessna 310A · Dyersburg, TNThe failure of the pilot to attain a proper touchdown point, which resulted in a long landing and an overrun of the runway. Factors were the weather conditions (sky obscuration, low ceiling, fog and drizzle) at the time of the accident, and the wet runway…NTSB SEA94LA049Accident · Minor injuriesLimited investigationFinal reportGrumman American AA1B · Lacey, WAThe pilot in command's failure to attain the proper touchdown point. Factors contributing to the accident were tailwinds and wet terrain.NTSB LAX94LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · El Monte, CAThe pilot's delayed decision to abort the takeoff and improper use of the airplane's throttle.NTSB NYC94LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-301T · Norwood, MAThe pilot's delay in aborting the takeoff which resulted in a overrun of the runway. Factors were a snow covered runway, takeoff speed not attained, brakes not used, and a ditch.NTSB LAX94LA068Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Monica, CAThe pilot's failure to attain the proper touchdown point and improper recovery from a bounced landing.NTSB SEA94LA033Accident · No injuriesLimited investigationFinal reportCessna C-172N · Idaho Falls, IDThe pilot's failure to attain the proper touchdown point. Factors include tailwind conditions and an airport perimeter fence.NTSB CHI94LA033Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Moberly, MOthe failure of the pilot-in-command to use all of the available runway.NTSB LAX94LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Redding, CAthe pilot's use of an excessive airspeed on final approach, the failure to attain the proper touchdown point on the runway, and, the failure to initiate a go around when it became clear that the aircraft would excessively overshoot the intended touchdown…NTSB NYC94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Tewksbury, MAwas an improperly planned approach, and excessive compensation for the winds by the pilot which resulted in an overrun, and on ground collision with a fence and vehicle. A factor was the gusty crosswinds.NTSB SEA94LA012Accident · No injuriesLimited investigationFinal reportCessna T-337E · Yamhill, ORThe pilot failed to attain the proper touchdown point. The tailwind was a factor.NTSB BFO93LA187Accident · No injuriesLimited investigationFinal reportCessna 150B · Woodford, VAThe pilot misjudging his altitude and airspeed and not attaining the proper touchdown point resulting in the airplane exiting the runway and colliding with pine trees. Factors in this accident were: 1) the wet runway, 2) rain which resulted in poor braking…NTSB ANC93LA187Accident · No injuriesLimited investigationFinal reportCessna 180A · Charlie Lake, AKThe pilot delayed his decision to abort the takeoff, and did not follow the standard procedures/directives for the aborted takeoff. Factors were the pilot's improper preflight planning/decision, and the rough/uneven terrain.NTSB CHI93LA370Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Lenox, ILSelection of the wrong runway by the pilot after misreading the wind sock. The resultant tailwind was a related factor.