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 GAA18CA432Accident · No injuriesData collectionFinal reportPiper PA28 · Oregon, WIThe pilot's improper decision to take off with a known brake malfunction, which resulted in a collision with a barn during landing on a wet runway.NTSB ANC18CA054Accident · Minor injuriesData collectionFinal reportCurtiss Wright C46 · Manley Hot Springs, AKThe pilot's failure to attain the proper touchdown speed and his decision to land with a tailwind without ensuring that there was adequate runway length for the touchdown.NTSB DCA18WA245Accident · Minor injuriesForeign investigationDouglas DC3 · Guainia, ColombiaThe government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB DCA18WA241Incident · No injuriesForeign investigationBoeing 737 · Djerba, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the provisions of…NTSB ENG18WA042Incident · No injuriesForeign investigationHonda HA-420 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau (AIB) of the Kingdom of Saudi Arabia has notified the NTSB of an incident involving a Honda HA-420, which occurred on July 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation…NTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.NTSB WPR18LA179Accident · No injuriesLimited investigationFinal reportCessna 340A · Orlando, FLThe pilot's delayed decision to discontinue the takeoff when confronted with abnormal acceleration and airspeed indication; the reason for the abnormal acceleration could not be determined based on the available information.NTSB GAA18CA356Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 · Winnsboro, SCThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructor’s improper decision to provide instruction in an airplane with only one control stick.NTSB GAA18CA364Accident · No injuriesData collectionFinal reportCessna 182T · Sebring, FLThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB CEN18WA212Accident · No injuriesForeign investigationCessna 525 · La Môle, FranceOn June 6, 2018, about 1100 UTC, a Cessna 525A airplane, German registration D-IULI, had a runway excursion on landing at the La Môle – Saint-Tropez Airport (LFTZ), La Môle, France. Two of the three occupants inside the airplane sustained serious injuries.…NTSB CEN18LA194Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Qulin, MOThe pilot’s improper weight-and-balance calculations and his decision to take off with the airplane at a high gross weight in high density altitude conditions, which resulted in an attempted takeoff that exceeded the airplane’s performance capability. Also…NTSB CEN18RA187Accident · Minor injuriesForeign investigationIsrael Aircraft Industries Gulfstream 200 · Tegucigalpa, HondurasimportNTSB GAA18CA266Accident · Minor injuriesData collectionFinal reportDiven Robert Nieuport 17 · Las Cruces, NMThe pilot’s failure to attain a positive climb rate after takeoff in high-density altitude conditions, which resulted in a collision with terrain.NTSB DCA18WA160Incident · No injuriesForeign investigationBoeing 737 · Gorontalo, IndonesiaThe National Transportation Safety Committee of Indonesia has notified the NTSB of an incident involving a Boeing 737, which occurred on April 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the…NTSB GAA18CA236Accident · No injuriesData collectionFinal reportL-Bird CCX-2000 · Hood River, ORThe pilot’s decision to take off in gusting wind conditions, which resulted in a loss of directional control.NTSB ERA18LA136Accident · No injuriesLimited investigationFinal reportCessna 402 · Barre Plains, MAThe pilot's improper decision to land with a tailwind, which resulted in a touchdown with insufficient runway remaining to stop the airplane.NTSB GAA18CA227Accident · No injuriesData collectionFinal reportIrvin Stephen D Rutan Long E Z · Tucson, AZThe pilot’s excessive ground speed and loss of directional control while exiting the taxiway.NTSB WPR18LA124Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-220T · Clewiston, FLThe pilot's failure to maintain directional control during takeoff following an overboost of the right engine during takeoff.NTSB GAA18CA224Accident · No injuriesData collectionFinal reportMooney M20R · San Antonio, TXThe pilot’s landing long in tailwind conditions with insufficient runway remaining to stop the airplane.NTSB CEN18WA380Accident · No injuriesForeign investigationRobin DR-400 · St. Chamont, FranceOn March 31, 2018, a Robin DR400-120 airplane, French registration F-GIKQ, experienced a runway excursion during takeoff from Saint Chamond - L'Horme airport (LFHG), near L'Horme, France. The airplane departed then end of runway 28 and came to rest along a…NTSB ERA18LA115Accident · No injuriesLimited investigationFinal reportCessna 180K · Canton, MSThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion. Contributing to the pilot's decision to land with a tailwind was a partial loss of engine power due to his failure to effectively use carburetor heat in conditions…NTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB DCA18WA103Incident · No injuriesForeign investigationBoeing 737 · Guayaquil, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an incident involving a Boeing 737-400, which occurred on March 4, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13. All investigative…NTSB DCA18WA226Accident · No injuriesForeign investigationMcdonnell Douglas MD83 · Omagwa, NigeriaThe Accident Investigation Bureau (AIB) of Nigeria has notified the NTSB of an accident involving a McDonnel Douglas MD-83, which occurred on February 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under the…NTSB CEN18LA094Accident · No injuriesLimited investigationFinal reportRaytheon 400A · Cleveland, OHThe airplane's reduced braking performance due to an ice-covered runway, which resulted in a runway excursion. Contributing to the accident was the crew's selection of a runway with a tailwind.NTSB WPR18WA083Accident · No injuriesForeign investigationGulfstream GULFSTREAM200 · Abuja, NigeriaOn January 25, 2018, at 1818 Universal Coordinated Time (UTC), a Nigerian registered Gulfstream G-200, 5N-BTF experienced a runway excursion during the landing rollout at Nnamdi Azikiwe International Airport (DNAA), Abuja, Nigeria. The airplane departed the…NTSB WPR18WA068Accident · No injuriesForeign investigationGulfstream GULFSTREAM200 · Albay, PhilippinesJanuary 10, 2018, at 1132 local time, a Gulfstream 200, RP-C280, was substantially damaged while landing at the Legazpi City Airport, Lagazpi, Albay, Philippines. The airplane was owned by the Asian Aerospace Corporation and operated under the pertinent civil…NTSB CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.NTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.NTSB WPR18WA086Incident · No injuriesForeign investigationHawker Beechcraft 390 · Germiston, South AfricaOn November 22, 2017, at 1423 coordinated universal time, a Hawker Premier Jet airplane, registration ZS-CBI, sustained minor damage during a runway excursion at Rand Airport (FAGM), Germiston, South Africa. The pilot and passenger were not injured. The…NTSB DCA18WA038Incident · No injuriesForeign investigationBoeing 737 · Foz do Iguacu County, BrazilThe government of Brazil has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on November 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB DCA18WA025Incident · No injuriesForeign investigationBoeing 737 · Singapore, SingaporeThe TSIB of Singapore has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSIB's investigation under the provisions of ICAO Annex 13 as…NTSB DCA18WA030Incident · No injuriesForeign investigationBoeing 747 · Maastricht, NetherlandsThe Dutch Safety Board has notified the NTSB of an incident involving a Boeing 747, which occurred on November 11, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of Manufacture and…NTSB ENG18RA002Accident · Minor injuriesForeign investigationSwearingen SA227 · Thompson, CanadaThe Transportation Safety Board of Canada has notified the NTSB of an accident involving a Fairchild SA227-AC airplane which occurred on November 3, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…NTSB CEN18WA022Accident · No injuriesForeign investigationCessna 550 · Bremen, GermanyOn October 29, 2017, about 1740 UTC, a Cessna 550/551 SP airplane, Russian Federation / RA-67560, was involved in a runway excursion at the Bremen Airport (EDDW), Bremen, Germany. Damage to the airplane was not yet known. The three crewmembers and two…NTSB ERA17WA331Accident · Minor injuriesForeign investigationCessna 650 · Istanbul, TürkiyeOn September 21, 2017, at 1820 universal coordinated time, a Cessna 650 (Citation III), Turkish registration TC-KON, operated by Avione Jet, was destroyed by postimpact fire after a runway excursion at Istanbul Atatürk Airport, Istanbul, Turkey (LTBA). The…NTSB DCA17WA201Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe government of India Ministry of Civil Aviation Aircraft Accident Investigation Bureau (AAIB) has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 19, 2017. The NTSB has appointed a U.S. Accredited…NTSB DCA17WA204Incident · No injuriesForeign investigationBoeing 737 · Aqaba, JordanThe Jordan Civil Aviation Regulatory Commission (CARC) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jordan's…NTSB DCA17WA229Incident · No injuriesForeign investigationBoeing 737 · Conakry, GuineaThe government of Guinea has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guinea's investigation under the provisions…NTSB GAA17CA558Accident · No injuriesData collectionFinal reportBellanca 14 19 · Redding, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA500Accident · No injuriesData collectionFinal reportBeech C23 · Rexburg, IDThe pilot's delayed decision to land the airplane with insufficient runway remaining after realizing the airplane wasn't climbing.NTSB ERA17LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT 402A · Shaw, MSThe pilot’s decision to attempt takeoff at high gross weight, in high density altitude conditions, and with insufficient runway length. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.NTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…NTSB DCA17WA156Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Civil Aviation Safety Investigation and Analysis Center (CASIAC) of Romania has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB WPR17LA160Accident · No injuriesLimited investigationFinal reportCessna 182L · Arbuckle, CAThe pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.NTSB DCA17WA157Incident · No injuriesForeign investigationBoeing 737-86J · Belfast, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 737-86J airplane that occurred on July 21, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO…NTSB ERA17CA250Accident · No injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB DCA17WA166Incident · No injuriesForeign investigationBoeing 747-87UF · Narita, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 747-87UF airplane that occurred on July 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…NTSB DCA17WA149Incident · No injuriesForeign investigationBoeing 737 · Helsinki, FinlandThe government of Finland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Finland's investigation under the provisions of…