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 ANC93LA035Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Bradley Lake, AKThe pilot in command not removing the frost from the plane's airfoil surfaces before takeoff and not aborting the takeoff when the airplane showed no sign of wanting to fly at the initial rotation point/airspeed. A factor in the accident was the icing…NTSB FTW93LA088Accident · No injuriesLimited investigationFinal reportCessna 340A · Clovis, NMThe pilot's failure to execute a go around. Factors were the tailwind, the icy runway conditions and the pilot's improper touchdown pointNTSB BFO93IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Portland, METhe pilot in command's excessive airspeed during approach, and his failure to follow the proper braking procedures during landing as per company training. Factors contributing to the accident include a tailwind and a wet, downhill runway.NTSB FTW93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ruston, LAFailure at a hydraulic fitting, which resulted in a hydraulic leak, loss of hydraulic fluid, and subsequent loss of braking action during the landing roll.NTSB CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.NTSB NYC93LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Valley Point, WVThe failure of the pilot to make a rejected landing when the airplane failed to decelerate properly. A factor related to the accident was the failure of the pilot to close the throttle upon touchdown.NTSB CHI93LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Streator, ILThe pilot's failure to perform a go-around. The tailwind and the pilot's selection of the downwind runway were factor.NTSB ATL93LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's failure to attain the proper touchdown point, and his improper recovery from a bounced landing. A factor was the pilot's lack of total experience in the airplane.NTSB CHI93LA062Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Milwaukee, WIFailure of the pilot to perform an aborted landing and failure to select a proper touchdown point on the runway.NTSB FTW93LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Little Rock, ARThe certified flight instructor's failure to attain the proper touchdown point.NTSB NYC93LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Andover, NJThe pilot's failure to abort the landing which resulted in a overrun of the runway. Contributing was the pilot's misjudgement of distance and an improper touchdown point.NTSB NYC93LA047Accident · No injuriesLimited investigationFinal reportBeech C-24R · Meriden, CTThe pilot's improper airplane preflight, resulting in no airspeed indication during takeoff, and the subsequent abort with insufficient runway available to stop prior to a collision with the terrain.NTSB SEA93FA040Accident · Serious injuriesField investigationFinal reportDassault-Breguet Falcon 10 · Mccall, IDThe failure of the flight crew to follow the checklist and release the parking brake before takeoff. The inoperative parking brake warning light and the failure of the pilot to abort the takeoff were factors.NTSB LAX93LA067Accident · Minor injuriesLimited investigationFinal reportBeech 23-C23 · Oceanside, CAThe pilot's failure to attain the proper touchdown point and to initiate a timely go around when the landing over shoot became apparent.NTSB MIA93LA026Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Groveland, FLThe pilot's encounter with shifting winds on the takeoff roll, that caused the airplane to overrun the runway. Contributing to the accident was the failure of the pilot in command to perform an aborted takeoff.NTSB FTW93LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-108 · Vilonia, ARThe pilot's failure to execute a go-around.NTSB BFO93LA012Accident · No injuriesLimited investigationFinal reportLearjet 25B · Cleveland, OHThe pilot misjudged distance and altitude which resulted in a landing touchdown with insufficient runway length remaining and a subsequent landing overrun. Contributing was the pilot's failure to initiate a go around, a tailwind, and a downsloping runway.NTSB SEA93LA028Accident · No injuriesLimited investigationFinal reportCessna A152 · Tremonton, UTDelayed remedial action. Factors include a tailwind.NTSB MIA93LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Key Largo, FLThe pilot in command's failure to obtain the proper touchdown point on landing. Contributing to the accident was the pilot in command's improper preflight planning preparation and selection of the wrong runway relative to the wind.NTSB BFO93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Griswold, CTThe pilot's improper planning or decision, by not either using all available runway or making a go around. The wet grass condition of the airstrip was a related factor.NTSB LAX93LA039Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG400 · Calistoga, CAThe failure of the brakes due to a separation of the brake cable for undetermined reasons. A factor in the accident was the tailwind condition during the landing rollout.NTSB BFO93LA004Accident · No injuriesLimited investigationFinal reportCessna 402 · Brookville, OHThe presence of animals on the runway, causing the pilot to execute an aborted takeoff and overrun the runway in an attempt to avoid the animals. Factors related to the accident were low lighting conditions and wet grass.NTSB NYC93LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodstown, PAThe pilot's improperly planned approach and delayed decision to initiate a go-around, which resulted in a touchdown too FAR down the runway and the subsequent collision with a ditch. A factor related to the accident was the pilot's lack of recent flight…NTSB ATL93LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Apex, NCThe pilot's improper in-flight planning and his inadequate compensation for wind conditions, which resulted in the overrun of the runway. Factors were the tail wind conditions, and the downhill, grass runway.NTSB CHI93LA003Accident · No injuriesLimited investigationFinal reportCessna 172P · Kokomo, INThe pilot's delayed remedial action.NTSB LAX92LA402Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gasquet, CAThe pilot failed to receive available wind information and selected the wrong landing runway. A contributing factor related to his expecting the local wind to be coming from the same direction as it had been reported at a neighboring airport.NTSB SEA92LA211Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Blakely Island, WAThe removal of the control gust lock was not performed. Factors to the accident were: inadequate preflight, the checklist was not used, and the control gust lock marking flag was gone due to previous damage.NTSB ANC92LA176Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Chitina, AKPilot in command preflight decision/planning in attempting takeoff without prudent and sufficient preparation to assess wind direction. A factor relating to the accident was: the trees in the clearway at the airstrip end.NTSB ANC92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Pole, AKPilot's decision to attempt takeoff without removing snow from aircraft surfaces. Factor related to the accident was the snow contaminated wing and other flight surfaces.NTSB CHI92LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Scotland, INThe pilot's delay in aborting a takeoff attempt after failing to attain flying speed during a takeoff ground run.NTSB BFO92LA130Accident · No injuriesLimited investigationFinal reportSchweizer 1-26D · Blairstown, NJThe pilot's failure to use spoilers which resulted in a landing overrun. Contributing was the pilot's lack of familiarity with the aircraft.NTSB CHI92LA256Accident · No injuriesLimited investigationFinal reportCessna A185F · St. Cloud, MNFailure of the pilot-in-command to abort takeoff before overrunning the lake edge.NTSB ANC92LA146Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKProper touchdown point was not attained by the pilot. Factors related to the accident were: the tailwind and the improper approach procedure used by the pilot, an inadequate background check of pilot in hiring by company/mgmt, inadequate training and check of…NTSB DEN92LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crested Butte, COThe pilot's selection of the wrong runway for landing, and the use of a flap setting less than a landing flap configuration.NTSB SEA92LA187Accident · No injuriesLimited investigationFinal reportCessna 182F · Alderwood Manor, WAThe pilot selected the wrong runway for wind conditions.NTSB CHI92LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Houghton Lake, MIA premature lift-off.NTSB SEA92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pacific City, ORThe pilot selected the wrong runway relative to the wind and then delayed in aborting the landing. The tailwind was a factor.NTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.NTSB ANC92LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Iliamna, AKThe pilot's failure to abort the takeoff. Contributing to the accident was the rough/uneven terrain.NTSB NYC92LA148Accident · Minor injuriesLimited investigationFinal reportBeech 24R · Eliot, METhe pilot allowed the airspeed to get excessive, resulting in the airplane touching down too long and too fast.NTSB ANC92LA129Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's improper inflight planning/decision, and his failure to perform a go around. Contributing to the accident was the rough/uneven terrain.NTSB ANC92LA117Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Anaktuvuk Pass, AKThe pilot in commands improper planning and decision to commence a takeoff in unfavorable wind conditions. Contributing factors to the accident were the impossibility of the pilot to maintain the proper climb rate, the unfavorable wind conditions, and the…NTSB LAX92LA321Accident · No injuriesLimited investigationFinal reportCessna R182 · Redding, CAThe pilots selection of the wrong runway for takeoff under the existing wind conditions.NTSB FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.NTSB MIA92LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Valkaria, FLExcessive airspeed on final approach by the pilot in command resulting in failure to attain the proper touchdown point and running off the runway colliding with a tree.NTSB BFO92LA118Accident · Minor injuriesLimited investigationFinal reportWaco AVN-8 · Hamilton, OHThe pilot misjudged distance and altitude which resulted in a landing overrun.NTSB SEA92LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Sisters, ORThe improper use of flight controls by the PIC during an aborted takeoff. Factors relating to the accident were the unfavorable wind (windshift) encountered during takeoff ground roll, the tailwind and high da weather conditions.NTSB BFO92LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Marston Mills, MAThe pilot's inadequate preflight preparation. Contributing was the pilot's failure to use all available runway and overconfidence in his own abilities.NTSB LAX92LA279Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Shelter Cove, CAThe pilot's inadequate preflight inspection of the aircraft and his failure to ensure that the control surface locks were removed prior to flight.NTSB ATL92LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Huntsville, ALThe pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.