NTSB investigations, 2018

261 cases where the sequence of events included 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 year(c.\"eventDate\") = 2018
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB GAA18CA364Accident · No injuriesData collectionFinal reportCessna 182T · Sebring, FLThe pilot’s failure to maintain directional control during landing with a crosswind.Jun 17, 2018 · N6284X · Substantial damageNTSB WPR18LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Page, AZThe failure of the airplane’s nose wheel steering/centering mechanism, which resulted in a loss of directional control and subsequent runway excursion.Jun 16, 2018 · N621PG · Substantial damageNTSB GAA18CA358Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Spanish Fork, UTThe pilot receiving instruction’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 16, 2018 · N992CT · Substantial damageNTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.Jun 15, 2018 · N3764Z · Substantial damageNTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.Jun 15, 2018 · N8273C · Substantial damageNTSB GAA18CA351Accident · No injuriesData collectionFinal reportCessna 185 · Big Lake, AKThe pilot’s inability to maintain directional control during the landing roll due to a flat tire.Jun 15, 2018 · N9964X · Substantial damageNTSB ERA18LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 34-200 · Umatilla, FLMaintenance personnel ‘s failure to complete and verify the proper installation of the main landing gear (MLG) torque links’ attachment hardware, which resulted in the right MLG torque link disconnecting and the pilot’s subsequent inability to maintain…Jun 14, 2018 · N56213 · Substantial damageNTSB GAA18CA346Accident · No injuriesData collectionFinal reportPiper PA32R · Caddo Mills, TXThe student pilot’s failure to extend the landing gear before landing and to follow the Before Landing checklist, which resulted in an attempted go-around and subsequent hard landing.Jun 13, 2018 · N82303 · Substantial damageNTSB GAA18CA338Accident · No injuriesData collectionFinal reportLuscombe 8 · Phoenix, AZThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.Jun 12, 2018 · N2094B · Substantial damageNTSB WPR18LA166Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Plant City, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun. Contributing to the accident was an engine anomaly for reasons that could not be determined based on the available information, and the pilot's failure to activate the…Jun 11, 2018 · N13RF · Substantial damageNTSB GAA18CA344Accident · No injuriesData collectionFinal reportBeech A36 · Arcadia, FLThe pilot’s loss of directional control during landing due to a flat tire.Jun 11, 2018 · N4198S · Substantial damageNTSB ERA18LA162Accident · No injuriesLimited investigationFinal reportBryan C L/Labrash R D Searey · Englewood, FLThe partial loss of engine power due to carburetor icing.Jun 7, 2018 · N907CB · Substantial damageNTSB CEN18LA220Accident · No injuriesLimited investigationFinal reportBeech A23 · Sedalia, MOThe pilot’s loss of directional control during the landing rollout due to the unexpected wind shift, which resulted in a runway excursion.Jun 7, 2018 · N8775M · Substantial damageNTSB GAA18CA335Accident · No injuriesData collectionFinal reportBeech A36 · Gilliam, LAThe pilot’s exceedance of the airplane’s critical angle of attack during a soft-field takeoff, which resulted in an aerodynamic stall.Jun 6, 2018 · N710JT · Substantial damageNTSB GAA18CA327Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Springdale, ARThe student pilot’s failure to maintain directional control during takeoff.Jun 6, 2018 · N748J · Substantial damageNTSB 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.…Jun 6, 2018 · DIULI · Substantial damageNTSB GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.Jun 3, 2018 · N67WW · Substantial damageNTSB CEN18LA211Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Parkin, ARThe improper operation of the rudder pedal adjustment mechanism for an undetermined period of time, which led to the failure of the rudder pedal adjustment track, the detachment of the rudder pedal, and the pilot’s subsequent inability to maintain directional…May 31, 2018 · N6215P · Substantial damageNTSB GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.May 28, 2018 · N84163 · Substantial damageNTSB ANC18LA039Accident · No injuriesLimited investigationFinal reportCessna T182T · Yerington, NVLoss of directional control during landing for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.May 28, 2018 · N68AX · Substantial damageNTSB 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…May 27, 2018 · N6180J · Substantial damageNTSB GAA18CA298Accident · No injuriesData collectionFinal reportGarcia Benigno Baby ACE D · St. Johns, AZThe pilot’s failure to maintain directional control during landing in gusting, quartering tailwind conditions.May 23, 2018 · N4207D · Substantial damageNTSB WPR18CA146Accident · No injuriesData collectionFinal reportAyres S2R G10 · Marysville, CAThe pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.May 22, 2018 · N32064 · Substantial damageNTSB CEN18RA187Accident · Minor injuriesForeign investigationIsrael Aircraft Industries Gulfstream 200 · Tegucigalpa, HondurasimportMay 22, 2018 · N813WM · Substantial damageNTSB GAA18CA291Accident · Minor injuriesData collectionFinal reportPiper PA28 · Farmingdale, NYThe pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.May 21, 2018 · N5560W · Substantial damageNTSB GAA18CA290Accident · No injuriesData collectionFinal reportPiper PA 14 · Vashon, WAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll due to his right foot inadvertently applying pressure to both rudder pedals.May 20, 2018 · N1423P · Substantial damageNTSB GAA18CA288Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Marlborough, MAThe pilot’s improper decision to land on a runway that was too short for a safe landing and his subsequent failure to maintain directional control in tailwind conditions.May 20, 2018 · N143RD · Substantial damageNTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.May 18, 2018 · N7265K · Substantial damageNTSB CEN18LA180Accident · Minor injuriesLimited investigationFinal reportRoger G White Glasair · Broomfield, COThe failure of the right brake line, which resulted in a loss of directional control and runway excursion.May 16, 2018 · N4EJ · Substantial damageNTSB GAA18CA279Accident · No injuriesData collectionFinal reportChampion 7ECA · Morrilton, ARThe pilot’s failure to maintain directional control in variable crosswind conditions.May 12, 2018 · N6333N · Substantial damageNTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.May 12, 2018 · N2485D · Substantial damageNTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.May 9, 2018 · N210BG · Substantial damageNTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…May 8, 2018 · N377ES · Substantial damageNTSB 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.May 8, 2018 · N315BD · Substantial damageNTSB GAA18CA269Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Goose Bay, AKThe student pilot’s failure to maintain directional control during landing with a gusting tailwind.May 7, 2018 · N2432H · Substantial damageNTSB CEN18LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Broomfield, COThe overstress fracture of the upper link of the nose landing gear torque link assembly, which resulted in the pilot’s inability to maintain directional control during landing.May 7, 2018 · N3292Y · Substantial damageNTSB GAA18CA260Accident · No injuriesData collectionFinal reportCessna 182 · Clarksville, TNThe pilot’s decision to land with a tailwind in variable crosswind and downdraft and updraft conditions on a wet runway, which resulted in a runway overrun.May 6, 2018 · N5419E · Substantial damageNTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.May 5, 2018 · N81FS · Substantial damageNTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.May 5, 2018 · N7762X · Substantial damageNTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.May 5, 2018 · N701XS · Substantial damageNTSB GAA18CA255Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Dekalb, ILThe pilot’s improper landing flare during gusting wind conditions, and the flight instructor’s delayed remedial action.May 5, 2018 · N468KM · Substantial damageNTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.May 4, 2018 · N99141 · Substantial damageNTSB GAA18CA258Accident · No injuriesData collectionFinal reportBerger Bernard M Pulsar Series III · Palmyra, PAThe pilot’s failure to maintain an appropriate approach speed, which resulted in a bounced landing and a runway overrun.May 3, 2018 · N914BB · Substantial damageNTSB WPR18FA131Accident · 1 fatalField investigationFinal reportAmerican Air Racing Thunder Mustang · Reno, NVThe pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…May 2, 2018 · N352BT · Substantial damageNTSB GAA18CA246Accident · No injuriesData collectionFinal reportCessna 182 · Page, AZThe pilot’s failure to maintain directional control during a rejected takeoff in gusting quarting tailwind conditions.Apr 29, 2018 · N7553N · Substantial damageNTSB GAA18CA242Accident · No injuriesData collectionFinal reportSeno Louis C SR KIS · Eagle Lake, TXThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Apr 29, 2018 · N66SK · Substantial damageNTSB 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…Apr 29, 2018 · PK-LOO · Minor damageNTSB GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.Apr 28, 2018 · N34459 · Substantial damageNTSB GAA18CA238Accident · No injuriesData collectionFinal reportStinson 108 · Spokane, WAThe pilot’s failure to maintain directional control during landing.Apr 28, 2018 · N35VM · Substantial damageNTSB 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.Apr 27, 2018 · N844FC · Substantial damage