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 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.NTSB ATL93LA088Accident · Serious injuriesLimited investigationFinal reportExtra 300 · Ridge Springs, SCThe pilot's failure to determine the landing distance required for a landing on a wet sod runway, which resulted in the overrun of the landing area and the collision with a treeNTSB ATL93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Macon, GAThe pilot's failure to attain the proper touchdown point. A factor was the pilot's failure to select another airport for landing and the intermittant runway and VASI lighting system.NTSB NYC93LA092Accident · No injuriesLimited investigationFinal reportCessna P337 · Holland, VAThe pilot's improper inflight planning during the approach for landing, resulting in a touchdown too FAR down the runway, and the subsequent collision with objects off the end of the runway.NTSB ANC93LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Kasigluk, AKThe pilot's improper planning/decision and delay in aborting the takeoff. Factors related to the accident were: loose gravel on the surface of the runway and the snowbank (berm) on the overrun (stopway).NTSB FTW93LA121Accident · No injuriesLimited investigationFinal reportCessna 150J · Waterproof, LAThe pilot's misjudged landing point and the excessive airspeed. A factor was the wet grass stripNTSB CHI93LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Lyons, WIThe pilot's use of an unsuitable runway.NTSB ATL93LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · Blountville, TNThe intentional operation of the aircraft with a partial failure of the brake system and the failure of the pilot to attain the proper touchdown point. Factors in the accident were the sunglare and the partial loss of the aircraft brake system.NTSB CHI93LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Demotte, INThe pilot's poor planned approach to the runway.NTSB FTW93LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Overbrook, OKThe pilot's failure to assure that the elevator trim was properly set for takeoff and his delay in aborting the takeoffNTSB LAX93LA146Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Avalon, CAThe pilot's poorly planned approach, excessive airspeed, and failure to attain the proper touchdown point. The pilot's lack of familiarity with the airport is a factor in this accident.NTSB ANC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Egegik, AKThat the lift off airspeed was not attained by the pilot in command because of the snow covered runway.