NTSB investigations
3,664 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 CHI08CA291Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot's excessive airspeed during the approach and landing and failure to perform a go-around. Contributing to the accident were the barricade and the down-sloping terrain at the end of the runway.NTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.NTSB DEN08CA156Accident · No injuriesData collectionFinal reportCessna 177RG · Ellsworth, KSThe student pilot's failure to maintain directional control during the landing roll.NTSB ANC08CA128Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's selection of an unsuitable takeoff area. A Factor contributing to the accident was a short, rough and uneven takeoff site.NTSB SEA08CA198Accident · No injuriesData collectionFinal reportCessna 152 · Columbia, CAThe student pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot's improper use of the throttle control.NTSB SEA08CA202Accident · No injuriesData collectionFinal reportMooney M20K · Trinity Center, CAThe complete loss of engine power due to fuel exhaustion as a result of a leak in the fuel system. Contributing to the accident was the rough terrain the airplane encountered during the forced landing.NTSB MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.NTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.NTSB NYC08CA313Accident · No injuriesData collectionFinal reportDiamond Aircraft Industry DA 20-C1 · Stevensville, MDThe student pilot's failure to maintain directional control during takeoff.NTSB NYC08CA312Accident · No injuriesData collectionFinal reportCessna 177 · Warwick, NYThe pilot's failure to obtain the proper touchdown point while landing.NTSB LAX08CA293Accident · No injuriesData collectionFinal reportBrubaker F1 · Truckee, CAThe failure of the bolts securing the tail wheel to its attach point that resulted in a loss of directional control.NTSB DEN08CA154Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Leadville, COThe pilot's failure to maintain aircraft control during takeoff.NTSB DFW08CA227Accident · No injuriesData collectionFinal reportCessna 172RG · Almogordo, NMThe pilot's failure to extend the airplane's landing gear before landing.NTSB MIA08CA182Accident · No injuriesData collectionFinal reportCessna 172K · Tunkhannock, PAThe pilot's improper airspeed while landing.NTSB SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.NTSB NYC08CA301Accident · No injuriesData collectionFinal reportSteppling RV-6A · Toughkenamon, PAThe pilot's improper recovery from a bounced landing.NTSB DFW08CA221Accident · No injuriesData collectionFinal reportCessna 560 · Telluride, COThe pilot's failure to maintain control during landing. A factor was the reported wind shear.NTSB DEN08CA147Accident · No injuriesData collectionFinal reportPiper PA-22 · Star City, ARThe pilot failed to maintain directional control during landing. Contributing to the accident were the crosswinds and the rough terrain near the runway.NTSB ANC08CA114Accident · Minor injuriesData collectionFinal reportCessna 207 · Fairbanks, AKThe pilot's delay in aborting the landing. A factor contributing to the accident was a variable wind.NTSB LAX08CA287Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Dillon, MTThe pilot-certificated passenger's failure to maintain directional control during landing and the pilot's delayed remedial action and inadequate supervision.NTSB CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.NTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.NTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB LAX08CA280Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Wasco, ORThe pilot's failure to maintain directional control while landing.NTSB NYC08LA291Accident · No injuriesLimited investigationFinal reportCessna 441 · Baltimore, MDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the pilot's attempted takeoff with a propeller start lock inadvertently engaged.NTSB MIA08LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Jeannette, PAFailure of the brakes to function due to inadequate inspection of the brake cable by maintenance personnel.NTSB SEA08CA189Accident · No injuriesData collectionFinal reportAeros Venture · Maricopa, AZThe pilot's selection of unsuitable terrain for a precautionary landing and subsequent takeoff attempt, and his misjudging of the required takeoff distance. The soft terrain was a factor.NTSB CHI08CA247Accident · No injuriesData collectionFinal reportBellanca 17-30A · Waukegan, ILThe pilot's inability to maintain directional control of the airplane following a failure of the right brake.NTSB NYC08LA273Accident · No injuriesLimited investigationFinal reportOuzts Rodney Rutan-LongEZ · Winder, GAThe failure of the left brake due to contamination of the brake fluid.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB LAX08CA255Accident · No injuriesData collectionFinal reportPiper PA-20 · Grass Valley, CAThe pilot's failure to maintain directional control due to his foot slipping off one rudder pedal while braking.NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.NTSB CHI08CA231Accident · No injuriesData collectionFinal reportWeatherly 201B · Creston, ILThe pilot's selection of the unsuitable terrain next to the runway to avoid the landing traffic. Contributing to the accident was the hill in the middle of the runway that blocked the pilot's view of the other traffic and the high vegetation near the runway.NTSB NYC08FA261Accident · No injuriesField investigationFinal reportEclipse EA500 · West Chester, PAThe pilot's failure to obtain the proper touchdown point, and his excessive airspeed on approach.NTSB ANC08LA093Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control during an aborted landing.NTSB ANC08CA091Accident · No injuriesData collectionFinal reportCessna T206H · King Salmon, AKThe pilot's misjudged speed and distance during a water landing.NTSB DFW08CA200Accident · No injuriesData collectionFinal reportCurtiss-Wright 12Q · Erie, COFailure of the tail wheel control cable during landing roll out, which resulted in a loss of control.NTSB CHI08LA216Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot's failure to maintain adequate airspeed during the go-around, resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed recovery from the bounced landing.NTSB CHI08CA206Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Lowell, MIThe inadequate preflight planning/preparation and the short field takeoff procedure not followed by the pilot. An additional cause was the delayed aborted takeoff by the pilot. A contributing factor was the trees.NTSB CHI08LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Sparta, WIThe pilot's inadequate preflight planning and the pilot's delay in aborting the takeoff. Contributing to the accident was the airplane's overgross weight condition.NTSB SEA08FA161Accident · 1 fatalField investigationFinal reportCessna 441 · Sunriver, ORThe pilot's misjudged landing flare and improper recovery from a bounced landing, and the pilot's failure to maintain directional control during the go-around after one of the airplane's propellers struck the runway.NTSB CHI08LA195Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Frankfort, KYThe student pilot's improper landing flare and the flight instructor's delayed remedial action.NTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.NTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.NTSB LAX08LA226Accident · No injuriesLimited investigationFinal reportJonsson Sonerai · Hood River, ORThe pilot's failure to maintain directional control during the emergency landing roll with a tailwind. Contributing was the partial separation of the left aileron that prompted the pilot to attempt the emergency landing.NTSB SEA08LA164Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik SportStar · Arlington, WAThe pilot's failure to maintain directional control of the airplane during the takeoff roll in gusty conditions.NTSB CHI08LA185Accident · No injuriesLimited investigationFinal reportTraxler John N Kitfox · Hartford, CTThe pilot's failure to compensate for crosswinds resulting in a loss of directional control while landing. Contributing to the accident was the pilot's lack of experience and training in tailwheeled airplanes.NTSB NYC08CA233Accident · No injuriesData collectionFinal reportCessna T182T · Lincoln Park, NJThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the wet runway and hydroplaning conditions.NTSB DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.