NTSB investigations, 1993
70 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
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 year(c.\"eventDate\") = 1993
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") = 1993 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 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.NTSB BFO93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Painesville, OHThe pilot's attempt to land with excessive airspeed, his improper use of the brakes, and his delay in performing remedial action.NTSB ANC93LA179Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, AKThe pilot's improper in-flight planning/decision, and his failure to attain the proper touchdown point. A factor was the rough/uneven terrain.NTSB MIA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Fernandina Bch, FLThe pilot-in-command's excessive airspeed, his failure to touch down at the proper point on the runway, and his failure to abort the landing.NTSB LAX93LA350Accident · No injuriesLimited investigationFinal reportCessna 182E · Minden, NVthe pilot's inadequate preflight planning and failure to use all available runway. A factor in the accident was the high density altitude condition.NTSB NYC93LA181Accident · No injuriesLimited investigationFinal reportBeech 19 · Wolfboro, NHThe pilot's failure to abort the takeoff which resulted in an overrun of the runway. Factors were a dirt bank, and the pilot's premature lift off, his failure to attain adequate airspeed, and his lack of recency of experience.NTSB NYC93LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Mifflin, PAThe pilot's misjudgement of speed and distance, which resulted in a landing overrun of the runway. Factors were an embankment and the pilot not being able to abort the landing.NTSB LAX93LA339Accident · Serious injuriesLimited investigationFinal reportMooney M-20M · Eureka, CAthe pilot's failure to attain the proper touch down point and the excessive airspeed.NTSB CHI93LA337Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Saint James, MIImproper planning/decision by the pilot. Factors related to the accident were: the unfavorable wind, and high obstructions near the end of the runway.NTSB CHI93LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Lincoln, NEthe pilot's failure to attain the proper touchdown point.NTSB CHI93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Point Lookout, MOThe pilot's failure to attain the proper touchdown Point.NTSB ANC93LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Black Rapids, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factor was the rough, uneven terrain.NTSB BFO93LA143Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Danielson, CTUndetermined.NTSB CHI93LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Troy, MIIs the pilot not attaining the proper touchdown point, not flying a proper glidepath, and not performing a go around.NTSB MIA93LA161Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Vero Beach, FLImproper planning/decision by the pilot, and his delay in aborting the takeoff. Factors related to the accident were: the tailwind, wet runway, and soft terrain beyond the end of the runway.NTSB CHI93LA271Accident · No injuriesLimited investigationFinal reportBeech A36 · Fowlerville, MIThe pilot-in-command's (CFI) delay in aborting the takeoff.NTSB BFO93LA130Accident · No injuriesLimited investigationFinal reportMooney M20J · Cooperstown, NYThe pilot's failure to attain the proper touchdown point and his delay in initiating a go-around. Other related factors were the rain and the wet runway.NTSB ATL93LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Summerdale, ALThe pilot's failure to attain the proper touchdown point.NTSB SEA93LA155Accident · Serious injuriesLimited investigationFinal reportBeech 60 · Fairfield, IDThe pilot's improper inflt planning/decision in selecting the wrong runway for landing. A factor relating to the accident was the strong tailwind weather conditions.NTSB BFO93LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150J · East Corinth, METhe pilot's misjudgement of airspeed while making a precautionary landing without airspeed indication, and the block pitot tube.NTSB CHI93LA261Accident · No injuriesLimited investigationFinal reportBeech F33A · Kahoka, MOThe pilot's premature liftoff. The soft runway condition was a factor.NTSB CHI93DTK01Accident · 1 fatalFinal reportCrowser Avid MK 3.75 · Philip, SDThe pilot's selection of unsuitable terrain for takeoff, and the pilot inadvertently stalling the airplane.NTSB FTW93LA213Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Ashdown, ARThe pilot's failure to abort the landing. A factor was the wet grassNTSB NYC93LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Spencer, MAThe pilot's inadequate preflight planning for the high density altitude departure and the delay in aborting the takeoff roll, with insufficient runway remaining, resulting in a collision with treesNTSB NYC93LA136Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Voluntown, CTThe pilot's failure to achieve the proper touchdown point which resulted in an overrun of the runway and collision with trees. A factor is the pilot's improper compensation for the wind condition.NTSB CHI93LA233Accident · Minor injuriesLimited investigationFinal reportBeech E35 · Virgil, ILThe pilot's failure to abort takeoff.NTSB ANC93LA098Accident · No injuriesLimited investigationFinal reportCessna 207 · Grayling, AKThe partial failure of the airplane's braking system.NTSB CHI93LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · St. James, MIThe pilot landed too long on a wet runway.NTSB NYC93LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Linden, NJThe pilot's misjudgement of speed and distance which resulted in an overrun of the runway. A wet runway is a contributing factor.NTSB ATL93LA099Accident · No injuriesLimited investigationFinal reportRockwell 114 · Woodstock, GAThe pilot's inadequate preflight planning which resulted in his failure to abort the takeoff when sufficient runway was available.NTSB ANC93LA075Accident · No injuriesLimited investigationFinal reportCessna 185F · Gustavus, AKThe pilot misjudging his speed while landing on a wet grass strip.NTSB FTW93LA164Accident · No injuriesLimited investigationFinal reportPiper PA-25-151 · Calera, OKAircraft performance exceeded and takeoff not aborted. Factors were the soft wet turf runwayNTSB ATL93LA096Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hartselle, ALThe pilot's misjudgement of distance and speed during the approach and landing.NTSB BFO93LA091Accident · No injuriesLimited investigationFinal reportCessna 172N · Petersburg, OHThe pilot's failure to attain the proper touchdown point while attempting to land on a wet grass strip, and his failure to perform a go around. The wet grass runway was a factor.NTSB BFO93LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Bath, NYThe pilot did not attain the proper touchdown point and did not go around while there was still sufficient speed to do so. The wet runway grass was a related factor.NTSB CHI93LA157Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301A · Solomon, KSThe pilot's selection of unsuitable terrain on which to takeoff and his delay in aborting the takeoff.NTSB MIA93LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Ochopee, FLThe pilot's poor judgement in attempting the takeoff from the parking ramp when a 12,000-FT runway was available.NTSB LAX93LA206Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Redlands, CAThe pilot's delayed landing abort during a downwind landing. Factors which contributed to the accident were: an incorrect advisory by the UNICOM operator, inadequate wind direction determination by the pilot which resulted in the wrong runway selected, and…NTSB BFO93LA072Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Simsbury, CTLack of braking action from the right brake. The pilot's failure to attain the proper touchdown point was a related factor.NTSB BFO93LA071Accident · Minor injuriesLimited investigationFinal reportAmerican General AG5B · Princeton, NJThe pilot's misjudgement of distance and speed during the landing, and his failure to initiate a go around, while there was still sufficient speed and runway remaining. His failure to attain the proper touchdown point for the landing was a related factor.