NTSB investigations
801 cases where the defining event was Runway excursion.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') 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 CEN16LA185Accident · No injuriesLimited investigationFinal reportJewett Brandon RV 6 · McKinney, TXThe pilot’s loss of directional control during takeoff.NTSB ERA16WA223Accident · No injuriesForeign investigationCessna 550 · Charallave, VenezuelaOn May 12, 2016, about 2330 coordinated universal time (UTC), a Cessna 550, Venezuelan registration YV589T, veered off the runway during landing roll and was substantially damaged at the Oscar Machado Zuloaga Airport (SVCS), Charallave, Venezuela. The two…NTSB GAA16CA214Accident · No injuriesData collectionFinal reportRockwell International 112TC · Durango, COThe instructed pilot's interference with the flight controls during landing, which resulted in the flight instructor's inability to maintain directional control, resulting in a runway excursion and substantial damage to the firewall and left wing spar.NTSB DCA16WA149Accident · No injuriesForeign investigationBoeing 737 · Ulaanbaatar, MongoliaThe government of Mongolia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mongolia's investigation under the provisions of…NTSB DCA16WA144Incident · No injuriesForeign investigationBoeing 737 · Prishtina, SerbiaThe government of Serbia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 02, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Serbia's investigation under the provisions of…NTSB DCA16WA155Accident · No injuriesForeign investigationEmbraer ERJ190 · Cuenca, EcuadorThe Ecuador Direccion General de Aviacion Civil (DGAC) has notified the NTSB of an accident involving an Embraer E-190 that occurred on April 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the…NTSB DCA16WA160Incident · No injuriesForeign investigationBoeing 737 · Guangzhou, ChinaThe Civil Aviation Administration of China (CAAC) has notified the NTSB of an accident involving a Boeing 737 that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC's investigation under the provisions of…NTSB WPR16LA092Accident · No injuriesLimited investigationFinal reportCessna 421C · Death Valley, CAA runway overrun for reasons that could not be determined based on the available information.NTSB GAA16CA185Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Palmer, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a runway over-run and collision with trees.NTSB DCA16WA118Incident · No injuriesForeign investigationAirbus A320 · Bilbao, SpainThe government of Spain has notified the NTSB of an accident involving a AIRBUS A320 airplane that occurred on March 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB CEN16LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Del Rio, TXThe pilot’s loss of directional control while departing with a gusting tailwind.NTSB DCA16WA140Accident · No injuriesForeign investigationFairchild SA227 · Tierra del Fuego, ArgentinaThe Argentina Junta de Investigacion de Acidentes de Aviacion Civil (JIAAC) has notified the NTSB of an accident involving a Fairchild SA-226 that occurred on March 22, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC…NTSB DCA16WA115Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe government of Peru has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB ERA16LA131Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Rome, GAThe pilots’ failure to use available sources of wind information before landing and recognize cues indicating the presence of the tailwind and conduct a go-around, which resulted in their landing with a significant tailwind and a subsequent runway overrun.NTSB WPR16LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, UTThe pilot's failure to abort the takeoff from the soft runway surface, which precluded optimal acceleration during the takeoff sequence.NTSB ERA16LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Chester, CTThe pilot’s failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.NTSB CEN16LA119Accident · No injuriesLimited investigationFinal reportBeech 95 C55 · Casey, ILThe pilot's inadvertent landing on a taxiway after a reported loss of engine power in both engines, which resulted in an overrun of the paved surface. The reason for the loss of engine power could not be determined because a postaccident test run of the…NTSB DCA16WA102Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB GAA16CA141Accident · No injuriesData collectionFinal reportMaule M 4 · Anchorage, AKThe inadvertent rudder input by the passenger, resulting in a runway excursion during takeoff and collision with a taxiway sign.NTSB GAA16CA130Accident · Minor injuriesData collectionFinal reportCessna 182 · Hudson Oaks, TXThe pilot's decision to continue the high approach, resulting in excessive speed during the landing roll, a loss of directional control, runway excursion, and nose over.NTSB DCA16WA098Incident · No injuriesForeign investigationBoeing 737 · Iquitos, PeruThe Peru Comisión de Investigación de Accidentes de Aviación (CIAA) has notified the NTSB of an incident involving a BOEING 737-300 that occurred on February 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA investigation…NTSB WPR16LA061Accident · No injuriesLimited investigationFinal reportCessna 210 · Lodi, CAThe pilot's failure to attain a proper touchdown point, which led to a runway excursion.NTSB DCA16WA095Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe National Bureau of Air Accident Investigation (NBAAI) of Ukraine has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on January 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's…NTSB DCA16WA042Incident · No injuriesForeign investigationBoeing 737 · Cluj-Napoca, RomaniaThe government of Romania has notified the NTSB of an incident involving a Boeing B737-400 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accreditd Representative to assist the government of Romania's investigation under the…NTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.NTSB GAA16CA069Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Mammoth, CAThe pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…NTSB GAA16CA070Accident · Minor injuriesData collectionFinal reportStinson 108 · Sharon, KSThe pilot's decision to continue the unstabilized approach and landing and his delayed decision to go around with an insufficient climb rate, which resulted with collision with trees.NTSB GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.NTSB CEN16CA070Accident · No injuriesData collectionFinal reportCessna 172 · Rush City, MNThe student pilot did not maintain directional control of the airplane and applied excessive right rudder during landing.NTSB CEN16WA075Accident · No injuriesForeign investigationLearjet 60 · Zihuatanejo, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 60, XA-UQP, that occurred on November 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…NTSB DCA16WA017Incident · No injuriesForeign investigationMcdonnell Douglas DC 9 82(MD-82) · San Luis Potosi, MexicoThe Dirección General de Aeronáutica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a McDonnell Douglas DC-9-82, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…NTSB WPR16LA017Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Prescott, AZThe pilot's failure to maintain directional control during landing, and his inability to recover due to a malfunction of the tailwheel.NTSB ERA16WA020Accident · No injuriesForeign investigationLearjet 35A · Buenos Aires, ArgentinaNTSB GAA16LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Redding, CAThe pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing.NTSB GAA15CA295Accident · No injuriesData collectionFinal reportBeech V35B · Houston, TXThe pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.NTSB ERA15LA380Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Sarasota, FLThe pilot’s failure to attain the proper touchdown point and to adequately slow the airplane within the available runway, which resulted in a runway overrun.NTSB CEN15LA418Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Platteville, WIThe partial loss of right engine power for undetermined reasons with insufficient runway remaining for the aborted takeoff.NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB GAA15CA236Accident · No injuriesData collectionFinal reportCessna 182Q · Pineville, LAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane, resulting in a runway over-run and collision with terrain.NTSB ERA15LA322Accident · Minor injuriesLimited investigationFinal reportEclipse EA500 · Danbury, CTThe pilot's failure to attain the proper touchdown point and exceedance of the target touchdown speed, which resulted in a runway overrun.NTSB ERA15CA302Accident · Minor injuriesData collectionFinal reportCessna 206G · Titusville, FLThe pilot's landing with a tailwind at an excessive speed, which resulted in a runway excursion, and collision with a ditch.NTSB DCA15WA209Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe government of Mexico has notified the NTSB of an incident involving a Boeing 737 that occurred on July 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of ICAO Annex…NTSB ERA15LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Linden, NJThe pilot’s delayed decision to reject the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot’s failure to properly configure the flaps for maximum takeoff performance with the airplane near its maximum gross weight.NTSB GAA15CA186Accident · No injuriesData collectionFinal reportPiper J3C · Arcadia, FLThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB GAA15CA135Accident · No injuriesData collectionFinal reportWSK PZL Mielec M 18A · Nyssa, ORThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with terrain.NTSB GAA15CA114Accident · No injuriesData collectionFinal reportPiper PA 16 · Tollville, ARThe pilot's failure to maintain directional control during the landing flare, which resulted in the airplane impacting a rice field and nosing over.NTSB ANC15RA074Accident · No injuriesForeign investigationCessna 525 · Okayama Preffecture, JapanOn June 23, 2015, a privately owned Cessna 525A, registered JA021R, took off from Tokyo International Airport at about 14:41 (JST: UTC+9hrs) and landed at Kohnan Aerodrome in Okayama prefecture at about 15:46. The landing ended up a runway overrun. It rested…NTSB GAA15CA117Accident · No injuriesData collectionFinal reportAir Tractor AT 401 · Wall, SDThe pilot's failure to adjust the airplane's useful load to compensate for the high temperature, which resulted in an insufficient climb rate to clear surrounding terrain, and a runway excursion.NTSB ERA15LA244Accident · No injuriesLimited investigationFinal reportRaddatz Steve RV 8 · Monroe, NCThe pilot's failure to maintain directional control during the landing.NTSB GAA15CA098Accident · No injuriesData collectionFinal reportSchweizer SGS 1 26B · Mocksville, NCThe glider pilot over-ran the runway and impacted a structure after encountering a strong updraft on short final.