NTSB investigations
3,662 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 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.
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 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
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 CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.NTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA444Accident · No injuriesData collectionFinal reportCessna 195 · Hood River, ORThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA439Accident · No injuriesData collectionFinal reportWayne D. Teel Waiex · Kinsey, KSThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB GAA18CA437Accident · No injuriesData collectionFinal reportCessna 180 · Bozeman, MTThe pilot's failure to maintain directional control during landing.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 GAA18CA429Accident · No injuriesData collectionFinal reportCessna 170 · Spearfish, SDThe pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining.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 GAA18CA426Accident · No injuriesData collectionFinal reportPiper PA 20 · Dayton, OHThe pilot's inadequate compensation for variable crosswind conditions during landing, which resulted in a runway excursion.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 GAA18CA404Accident · No injuriesData collectionFinal reportCessna 180 · Cut Bank, MTThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA403Accident · No injuriesData collectionFinal reportRockwell 114 · Corsicana, TXThe pilot’s failure to maintain the runway heading during a soft-field takeoff with a tailwind, which resulted in a rejected takeoff.NTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.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 GAA18CA420Accident · No injuriesData collectionFinal reportCirrus SR22 · Hudson, NYCollision with a deer during landing.NTSB CEN18LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT502 · Tappen, NDThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18LA241Accident · No injuriesLimited investigationFinal reportCessna T210 · Pocahontas, ARThe pilot's excessive use of wheel brakes while landing, which resulted in both brakes locking up, a loss of directional control, a runway excursion, and a nose over.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 GAA18CA381Accident · No injuriesData collectionFinal reportPiper PA 30 · Goodyear, AZThe pilot receiving instruction’s failure to maintain directional control during the landing roll.NTSB GAA18CA372Accident · Minor injuriesData collectionFinal reportBeech D17 · Hamilton, MTThe pilot’s failure to maintain directional control during the landing roll and his subsequent inability to recover due to his foot being stuck.NTSB OPS18IA015Incident · No injuriesClass 3 · IncidentFinal reportBoeing 747 · Chicago, ILInterference with the localizer signal resulting in a Multipath condition experienced by CAL5148 while conducting an ILS CAT III (autoland) approach. This condition resulted in a runway excursion and subsequent go-around. The interference was most likely…NTSB ERA18LA175Accident · Minor injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Newburyport, MAThe pilot's failure to adequately compensate for existing crosswind conditions during the final approach and landing flare, which led to the airplane drifting left of the runway, and his delayed decision to go around, which resulted in the airplane touching…NTSB GAA18CA365Accident · No injuriesData collectionFinal reportCraig A Reed Starduster II · Morrilton, ARThe pilot’s loss of directional control during an aborted landing.NTSB GAA18CA368Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Columbia, SCThe pilot's failure to maintain directional control during landing.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 GAA18CA441Accident · No injuriesData collectionFinal reportPiper PA · East Sound, WAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control in a gusting, left quartering headwind.NTSB GAA18CA364Accident · No injuriesData collectionFinal reportCessna 182T · Sebring, FLThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB 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.NTSB 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.NTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.NTSB 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.NTSB 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…NTSB 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.NTSB GAA18CA338Accident · No injuriesData collectionFinal reportLuscombe 8 · Phoenix, AZThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB 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…NTSB GAA18CA344Accident · No injuriesData collectionFinal reportBeech A36 · Arcadia, FLThe pilot’s loss of directional control during landing due to a flat tire.NTSB ERA18LA162Accident · No injuriesLimited investigationFinal reportBryan C L/Labrash R D Searey · Englewood, FLThe partial loss of engine power due to carburetor icing.NTSB 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.NTSB 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.NTSB GAA18CA327Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Springdale, ARThe student pilot’s failure to maintain directional control during takeoff.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 GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB 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…NTSB GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.NTSB 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.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 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.