NTSB investigations
3,663 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 GAA17CA055Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Bristow, VAThe pilot’s loss of directional control during a landing attempt at night, which resulted in a delayed go-around procedure and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB ERA17LA033Accident · No injuriesLimited investigationFinal reportCessna TR182 · Watertown, NYA collapse of the main landing gear for reasons that could not be determined based on the available evidence.NTSB CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…NTSB DCA17MA022Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas MD 10-10F · Fort Lauderdale, FLThe failure of the left main landing gear (MLG) due to fatigue cracking that initiated at a corrosion pit. The pit formed in the absence of a required protective cadmium coating the cause of which could not be determined from available evidence. Contributing…NTSB WPR17WA095Incident · No injuriesForeign investigationCessna 500 · Banswara, IndiaOn October 27, 2016, at 0745 universal coordinated time (1315 local time), a Cessna 500 SII Citation, VT-KMB, sustained minor damage following a runway excursion in Banswara, India. The airplane was operated under the pertinent regulations of the Government…NTSB DCA17IA020Incident · No injuriesIncident investigationFinal reportBoeing 737 7L9 · New York, NYThe first officer's failure to attain the proper touchdown point and the flight crew's failure to call for a go-around, which resulted in the airplane landing more than halfway down the runway. Contributing to the incident were, the first officer's initiation…NTSB GAA17CA049Accident · No injuriesData collectionFinal reportAviat A-1C · Placerville, CAThe pilot’s failure to maintain directional control of the airplane during landing in gusty crosswind conditions.NTSB GAA17CA046Accident · No injuriesData collectionFinal reportCirrus SR22 · Kirksville, MOThe pilot’s improper compensation for changing wind during the landing flare, which resulted in an off-centered landing and a subsequent loss of directional control.NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA043Accident · No injuriesData collectionFinal reportAeronca 11AC · Winter Haven, FLThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion.NTSB GAA17CA050Accident · No injuriesData collectionFinal reportCessna 305 · Llano, TXThe pilot's failure to maintain directional control during the landing roll in cross wind conditions.NTSB CEN17LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Pflugerville, TXLanding gear collapse upon landing due to a hydraulic leak that led to insufficient pressure to fully extend and lock the gear in a down position.NTSB GAA17CA042Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.NTSB GAA17CA037Accident · No injuriesData collectionFinal reportPiper PA24 · Wagoner, OKThe pilot's failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA024Accident · Minor injuriesData collectionFinal reportCessna 182 · Leesburg, VAThe pilot's improper landing flare, which resulted in a hard landing and subsequent runway excursion.NTSB GAA17CA038Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Wilmington, OHThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion.NTSB GAA17CA051Accident · No injuriesData collectionFinal reportCessna 152 · Chickaloon, AKThe flight instructor's delay in aborting the takeoff from a turf runway, which resulted in a runway overrun.NTSB ERA17LA014Accident · No injuriesLimited investigationFinal reportCessna 525 · Pawtucket, RIThe flight crew's failure to maintain an appropriate approach speed and obtain an appropriate touchdown point on the runway, which resulted in a runway overrun.NTSB GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB GAA17CA016Accident · No injuriesData collectionFinal reportRobinson Stewart J Bearhawk · Calhan, COThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA015Accident · No injuriesData collectionFinal reportStinson 108 · Rifle, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA014Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.NTSB GAA17CA023Accident · No injuriesData collectionFinal reportNorth American Navion · Palmer, AKThe pilot's failure to extend the landing gear for landing.NTSB GAA17CA011Accident · No injuriesData collectionFinal reportFuller Neil H Glasair SH 2 · Bellingham, WAThe pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.NTSB GAA17CA052Accident · No injuriesData collectionFinal reportChaudoin George S RV 10 · Portsmouth, NHThe pilot’s failure to go around after recognizing that the airplane was high and fast, which resulted in a long landing on a wet runway and a runway excursion.NTSB GAA17CA029Accident · No injuriesData collectionFinal reportAirplane Factory Sling · Torrance, CAThe student pilot's improper landing flare in crosswind conditions, which resulted in a porpoised hard landing and a runway excursion.NTSB GAA17CA005Accident · No injuriesData collectionFinal reportCessna Ector 305 · Concord, NHThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA17CA003Accident · No injuriesData collectionFinal reportAndrew Harold Stol CH 701 · Berryton, KSThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion.NTSB DCA16WA233Accident · No injuriesForeign investigationBeech 1900 · Mavivi, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a BEECH 1900 airplane that occurred on September 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…NTSB ANC16LA071Accident · No injuriesLimited investigationFinal reportHelio H-295 · Delta Junction, AKThe pilot’s decision to take off from a wet, snowy airstrip and his delayed decision to abort the takeoff, which resulted in a runway excursion.NTSB ENG16RA042Accident · No injuriesForeign investigationBAE JETSTREAM4100 · Siddharthanagar, NepalThe Government of Nepal Ministry of Culture, Tourism and Civil Aviation has notified the NTSB of an accident involving a BAE Systems (Operations) Limited Jetstream 41 which occurred on September 24, 2016. The NTSB has appointed a U.S. Accredited…NTSB ERA16LA322Accident · No injuriesLimited investigationFinal reportAero Vodochody L 39 · Norfolk, VAAn uncommanded flap retraction for reasons that could not be determined, as a postaccident examination of the flap system did not reveal evidence of any preaccident anomalies.NTSB ERA16LA323Accident · No injuriesLimited investigationFinal reportLearjet 25 · San Juan, PRThe pilot’s improper decision to land the airplane on a wet runway, in heavy rain, with tires worn beyond safe limits, which resulted in a hydroplaning condition and subsequent loss of directional control.NTSB CEN16WA396Incident · No injuriesForeign investigationSwearingen SA227 · Cologne, GermanyOn September 20, 2016, at 1725 UTC, a Fairchild Swearingen Corporation SA-227-AC Metroliner, German registration D-CPSW, owned and operated by BINAIR Aero, sustained minor damage when the airplane veered off the runway while landing at the Cologne/Bonn…NTSB WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.NTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA16CA499Accident · No injuriesData collectionFinal reportAlex Michael Bantum/Tercel USA TERCEL-GYROPLANE · Blairstown, NJThe student pilot’s incorrect takeoff procedure, which resulted in a loss of main rotor rpm and the subsequent loss of directional control and runway excursion.NTSB GAA16CA498Accident · No injuriesData collectionFinal reportAirtime Cygnet · Venice, FLThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action, which resulted in a runway excursion.NTSB GAA16CA494Accident · No injuriesData collectionFinal reportBeech B23 · Raleigh, NCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA484Accident · No injuriesData collectionFinal reportCessna 182 · Olathe, KSThe pilot’s failure to reduce the throttle during the landing roll resulting in a loss of directional control.NTSB GAA16CA492Accident · No injuriesData collectionFinal reportCessna 170 · Sidney, MTThe student pilot’s improper landing flare, which resulted in a bounced landing, and the flight instructor’s inability to recover the airplane, which resulted in a runway excursion.NTSB GAA16CA476Accident · No injuriesData collectionFinal reportLuscombe 8 · Juneau, WIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion. Contributing to the accident was the foot pad cover slipping off the right rudder pedal during the landing roll.NTSB GAA16CA475Accident · No injuriesData collectionFinal reportBeech 200 · Apopka, FLThe pilot's failure to maintain directional control during an attempted aborted landing in gusty crosswind conditions, which resulted in a runway excursion and an impact with a tree.NTSB GAA16CA505Accident · No injuriesData collectionFinal reportPiper PA46R · Reserve, NMThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB GAA16CA477Accident · No injuriesData collectionFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.NTSB GAA16CA481Accident · Minor injuriesData collectionFinal reportStinson L 5 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA16CA465Accident · No injuriesData collectionFinal reportCessna TR182 · South Lake Tahoe, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's failure to remove the carburetor heat during the attempted go-around in high…NTSB GAA16CA485Accident · Minor injuriesData collectionFinal reportDormaier Monte R Baby Great Lakes · Mazama, WAThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.