NTSB investigations, 2015
211 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\") = 2015
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.
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") = 2015 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
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 GAA15CA064Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe landing airplane pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground collision with a taxiing airplane.NTSB GAA15CA060Accident · No injuriesData collectionFinal reportWatson David E Skybolt · Carson City, NVThe pilot's failure to maintain directional control of the airplane during takeoff, resulting in substantial damage to the airplane.NTSB GAA15CA059Accident · No injuriesData collectionFinal reportCessna 180K · Pearland, TXThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.NTSB GAA15CA073Accident · No injuriesData collectionFinal reportCessna 182T · Newburyport, MAThe pilot's failure to recover from a bounced landing, which resulted in substantial damage to the airplane during the runway overrun.NTSB GAA15CA056Accident · No injuriesData collectionFinal reportWilliam D Durkee RV-6 · Tunica, MSThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA15CA049Accident · No injuriesData collectionFinal reportCessna 172M · Clearwater, FLThe pilot's excessive airspeed during landing, which resulted in abnormal runway contact, a runway excursion, and substantial damage to the airplane.NTSB GAA15CA047Accident · Minor injuriesData collectionFinal reportPiper PA 16 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA15CA052Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · West Plains, MOThe pilot's failure to maintain control while landing in gusty wind conditions.NTSB ERA15LA192Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Fort Myers, FLThe pilot's improper decision to land the airplane with a quartering, gusting tailwind and his subsequent failure to flare the airplane and maintain directional control after it bounced, which resulted in a runway excursion.NTSB GAA15CA055Accident · No injuriesData collectionFinal reportBeech C 50 · Honesdale, PAThe pilot's failure to stop the airplane on the runway during landing, resulting in an overrun, landing gear collapse and substantial damage to the airplane.NTSB GAA15CA045Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Newport, RIThe pilot's failure to maintain directional control during landing.NTSB CEN15LA212Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Smithville, TXThe noncertificated pilot's loss of directional control during takeoff, which resulted in impact with a utility pole and hangar. Contributing to the accident was the pilot's failure to obtain flight instruction before attempting to fly the aircraft.NTSB CEN15CA203Accident · No injuriesData collectionFinal reportCessna 195A · Independence, IAThe pilot's attempt to land in strong crosswind conditions, resulting in his on-ground loss of control. Contributing to the accident was the crosswind that exceeded the crosswind limits of the airplane.NTSB GAA15CA050Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Deer Lodge, MTThe pilot's inadequate recovery from a bounced landing, resulting in a loss of control and collision with terrain.NTSB ERA15CA196Accident · No injuriesData collectionFinal reportCessna 172P · Sebastian, FLThe pilot's misjudged airspeed and glidepath, which resulted in a landing area overshoot and runway excursion.NTSB GAA15CA040Accident · No injuriesData collectionFinal reportTrom Wayne Vans RV6A · LaFayette, GAThe pilot's failure to maintain directional control during the landing roll in variable, gusting wind conditions, resulting in a runway excursion, and substantial damage to the airplane.NTSB CEN15CA196Accident · No injuriesData collectionFinal reportAeronca 7AC · Cambridge, OHThe pilot's failure to maintain control of the airplane while encountering a wind gust after landing.NTSB GAA15CA034Accident · Minor injuriesData collectionFinal reportCessna 182F · Portland, TNThe pilot's failure to perform a go-around in time to prevent a runway overrun and collision with terrain.NTSB WPR15LA148Accident · No injuriesLimited investigationFinal reportCessna 206H · Honolulu, HIA blown nose landing gear tire during landing, which resulted in the pilot’s inability to maintain directional control.NTSB GAA15CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cornelia, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA15CA033Accident · No injuriesData collectionFinal reportLancair LC 40 550FG · Middleton, WIThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's inadequate compensation for the crosswind during landing.NTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.NTSB GAA15CA030Accident · No injuriesData collectionFinal reportCessna R172E · Fort Meade, MDThe flight instructor's decision to land the airplane without sufficient runway to stop, resulting in a runway excursion and substantial damage to the right wing of the airplane.NTSB WPR15LA129Accident · No injuriesLimited investigationFinal reportCessna 310Q · St. George, UTFailure of the left main landing gear lower adjusting bolt due to overstress, which resulted in the left main landing gear collapse during landing.NTSB ERA15LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Woodstock, GAThe pilot's failure to attain the proper touchdown point on the short, wet, turf runway. Contributing to the accident was the pilot’s use of a high approach speed.NTSB GAA15CA072Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA40 · Fuquay-Varina, NCThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway overrun.NTSB WPR15LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA30 - NO Series · Red Bluff, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.NTSB GAA15CA014Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MDThe pilot's failure to maintain directional control during takeoff.NTSB GAA15CA031Accident · Minor injuriesData collectionFinal reportCessna 140 · Easton, MDThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA011Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Boulder, COThe pilot's loss of directional control during a bounced landing, which resulted in a runway excursion.NTSB GAA15CA007Accident · No injuriesData collectionFinal reportAviat A1 - B · Afton, WYThe pilot's failure to maintain directional control during landing.NTSB GAA15CA010Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Hondo, TXThe student pilot's failure to maintain directional control during landing roll, which resulted in a loss of control. Contributing to this accident was the flight instructor's delayed remedial action.NTSB WPR15FA125Accident · 1 fatalField investigationFinal reportBAE Systems MK-67 Hawk · Yuma, AZThe pilot’s initiation of an early rotation during takeoff, which led to an aerodynamic stall and loss of airplane control. Contributing to the accident were the pilot's use of nose up pitch trim and the operator's policy to use nose-up pitch trim during…NTSB GAA15LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garrison, IAThe malfunction of the right brake for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB GAA15CA004Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Hurricane, UTThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB CEN15CA168Accident · No injuriesData collectionFinal reportJones Ronald C Bearhawk · Walters, OKThe pilot did not maintain control of the airplane during the landing roll at night on an unlit grass strip.NTSB GAA15CA003Accident · No injuriesData collectionFinal reportSchupp Edward W SKY Ranger II · San Manuel, AZThe pilot's failure to maintain directional control during landing.NTSB GAA15CA001Accident · No injuriesData collectionFinal reportWaco UPF 7 · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.NTSB DCA15FA085Accident · No injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD 88 · New York, NYthe captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…NTSB ERA15CA154Accident · No injuriesData collectionFinal reportBeech 58 · Monroe, NCThe pilot's failure to maintain a proper glidepath and failure to perform a go-around once a safe landing could not accomplished, which resulted in a landing area overshoot and runway excursion.NTSB WPR15LA137Accident · No injuriesLimited investigationFinal reportPiper PA 46-310P · Redmond, ORA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA15LA140Accident · Serious injuriesLimited investigationFinal reportBombardier Canadair CL600-2A12 · Marco Island, FLThe failure of a spring inside the No. 2 brake’s upper brake control valve and the fracture of the coupling subassembly of the No. 1 wheel speed sensor during landing, which resulted in the loss of braking action, and the pilot-in-command’s (PIC) deactivation…NTSB WPR15CA114Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN15CA151Accident · No injuriesData collectionFinal reportCessna 172P · Kankakee, ILThe student pilot's improper flight control inputs resulting in the loss of control during the landing flare.NTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.NTSB ERA15LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lexington, KYMaintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.NTSB CEN15LA147Accident · No injuriesLimited investigationFinal reportPiper PA 31-350 · Chicago, ILThe collapse of the nose and right main landing gears during landing for reasons that could not be determined because examination of the landing gear system revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR15IA105Incident · No injuriesIncident investigationFinal reportEvo13 Lancair Evolution · San Carlos, CAThe collapse of the nose landing gear (NLG) due to the separation of the right trunnion pin from the NLG strut as a result of reverse-bending fatigue.