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.

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.May 7, 2015 · N5144H · 2 aircraft · Substantial damageNTSB 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.May 4, 2015 · N88FX · Substantial damageNTSB 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.May 1, 2015 · N66048 · Substantial damageNTSB 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.Apr 30, 2015 · N9085Q · Substantial damageNTSB GAA15CA056Accident · No injuriesData collectionFinal reportWilliam D Durkee RV-6 · Tunica, MSThe pilot's failure to maintain directional control during the takeoff roll.Apr 30, 2015 · N91WD · Substantial damageNTSB 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.Apr 24, 2015 · N1576V · Substantial damageNTSB GAA15CA047Accident · Minor injuriesData collectionFinal reportPiper PA 16 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll.Apr 22, 2015 · N5616H · Substantial damageNTSB GAA15CA052Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · West Plains, MOThe pilot's failure to maintain control while landing in gusty wind conditions.Apr 21, 2015 · N332AL · Substantial damageNTSB 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.Apr 19, 2015 · N88AX · Substantial damageNTSB 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.Apr 18, 2015 · N38MM · Substantial damageNTSB GAA15CA045Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Newport, RIThe pilot's failure to maintain directional control during landing.Apr 18, 2015 · N684CT · Substantial damageNTSB 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.Apr 18, 2015 · UNREG · Minor damageNTSB 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.Apr 18, 2015 · N1558D · Substantial damageNTSB 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.Apr 17, 2015 · N7374W · Substantial damageNTSB ERA15CA196Accident · No injuriesData collectionFinal reportCessna 172P · Sebastian, FLThe pilot's misjudged airspeed and glidepath, which resulted in a landing area overshoot and runway excursion.Apr 17, 2015 · N66090 · Substantial damageNTSB 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.Apr 11, 2015 · N646RV · Substantial damageNTSB CEN15CA196Accident · No injuriesData collectionFinal reportAeronca 7AC · Cambridge, OHThe pilot's failure to maintain control of the airplane while encountering a wind gust after landing.Apr 11, 2015 · N85664 · Substantial damageNTSB 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.Apr 7, 2015 · N3586Y · Substantial damageNTSB 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.Apr 4, 2015 · N245RB · Substantial damageNTSB 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.Apr 4, 2015 · N7153Z · Substantial damageNTSB 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.Apr 1, 2015 · N777XX · Substantial damageNTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.Mar 27, 2015 · N20062 · Substantial damageNTSB 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.Mar 26, 2015 · N7889N · Substantial damageNTSB 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.Mar 21, 2015 · N7770Q · Substantial damageNTSB 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.Mar 21, 2015 · N8803W · Substantial damageNTSB 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.Mar 20, 2015 · N840AB · Substantial damageNTSB 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.Mar 19, 2015 · N8403Y · Substantial damageNTSB GAA15CA014Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MDThe pilot's failure to maintain directional control during takeoff.Mar 19, 2015 · N731HG · Substantial damageNTSB GAA15CA031Accident · Minor injuriesData collectionFinal reportCessna 140 · Easton, MDThe pilot's failure to maintain directional control during the landing roll.Mar 16, 2015 · N2026V · Substantial damageNTSB 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.Mar 16, 2015 · N4785F · Substantial damageNTSB GAA15CA007Accident · No injuriesData collectionFinal reportAviat A1 - B · Afton, WYThe pilot's failure to maintain directional control during landing.Mar 13, 2015 · C-FTAD · Substantial damageNTSB 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.Mar 12, 2015 · N638J · Substantial damageNTSB 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…Mar 11, 2015 · N506XX · Substantial damageNTSB 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.Mar 9, 2015 · N83643 · Substantial damageNTSB GAA15CA004Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Hurricane, UTThe pilot's failure to maintain directional control during the landing roll.Mar 9, 2015 · N949WB · Substantial damageNTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Mar 8, 2015 · N2030M · Substantial damageNTSB 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.Mar 8, 2015 · N299BH · Substantial damageNTSB GAA15CA003Accident · No injuriesData collectionFinal reportSchupp Edward W SKY Ranger II · San Manuel, AZThe pilot's failure to maintain directional control during landing.Mar 7, 2015 · N132ES · Substantial damageNTSB GAA15CA001Accident · No injuriesData collectionFinal reportWaco UPF 7 · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll.Mar 6, 2015 · N32063 · Substantial damageNTSB GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.Mar 5, 2015 · N8905R · Substantial damageNTSB 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…Mar 5, 2015 · N909DL · Substantial damageNTSB 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.Mar 4, 2015 · N50NH · Substantial damageNTSB 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.Mar 1, 2015 · N9133G · Substantial damageNTSB 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…Mar 1, 2015 · N600NP · Substantial damageNTSB WPR15CA114Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.Feb 22, 2015 · N4155U · Substantial damageNTSB 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.Feb 21, 2015 · N54974 · Substantial damageNTSB 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.Feb 20, 2015 · N22267 · Substantial damageNTSB 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.Feb 19, 2015 · N358CD · Substantial damageNTSB 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.Feb 16, 2015 · N727SC · Substantial damageNTSB 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.Feb 15, 2015 · N3WB · Minor damage