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 ERA15LA360Accident · No injuriesLimited investigationFinal reportJ. Schilling S-19 · East Falmouth, MAThe experimental airplane builder's failure to properly secure the stabilator trim tab push-pull tube’s connection, which resulted in the tube’s separation and a subsequent hard landing. Contributing to the accident was the pilot/owner's failure to detect the…NTSB ANC15LA070Accident · No injuriesLimited investigationFinal reportHelio H 295 · Delta Junction, AKA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA260Accident · No injuriesData collectionFinal reportRocci Martignoni JA30 Superstol · Santa Rosa, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and a ground loop.NTSB GAA15CA269Accident · No injuriesData collectionFinal reportMooney M20TN · Myakka City, FLThe pilot's failure to maintain directional control during the landing roll in windy conditions, resulting in a runway excursion and collision with a fence.NTSB CEN15LA411Accident · No injuriesLimited investigationFinal reportBrown Mark Space Walker · Cahokia, ILThe pilot's failure to maintain a proper descent rate during the attempted landing and the flight instructor's delayed attempt to execute a go-around, which resulted in a hard landing, failure of the left main landing gear, and subsequent loss of directional…NTSB GAA15CA263Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Doylestown, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane. Contributing to the accident was the pilot's fatigue during the flight.NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB ANC15CA072Accident · No injuriesData collectionFinal reportCessna 150D · Delta Junction, AKThe pilots decision to land on an unfamiliar, unimproved airstrip which resulted in a loss of control and runway excursion.NTSB ANC15LA069Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · North Pole, AKThe student pilot’s loss of directional control during landing with a tailwind, which resulted in a runway excursion and collision with trees.NTSB GAA15CA244Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Truckee, CAThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion, ground loop, and impact with terrain. Contributing to the accident was the pilot's lack of experience from the back seat.NTSB GAA15CA250Accident · No injuriesData collectionFinal reportGrumman American Avn. G 164A · Welsh, LAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a ground loop.NTSB GAA15CA240Accident · No injuriesData collectionFinal reportPiper PA 28-180 · DeFuniak Springs, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, and collision with a ditch.NTSB GAA15CA236Accident · No injuriesData collectionFinal reportCessna 182Q · Pineville, LAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane, resulting in a runway over-run and collision with terrain.NTSB ERA15LA322Accident · Minor injuriesLimited investigationFinal reportEclipse EA500 · Danbury, CTThe pilot's failure to attain the proper touchdown point and exceedance of the target touchdown speed, which resulted in a runway overrun.NTSB GAA15CA249Accident · No injuriesData collectionFinal reportStinson L 5E · Tucson, AZThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and a collision with an object.NTSB GAA15CA235Accident · No injuriesData collectionFinal reportCessna 172N · Kalispell, MTThe pilot's loss of directional control, which resulted in a runway excursion, and collision with runway and taxiway lights and terrain.NTSB CEN15LA369Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bolivar, MOTotal electrical failure due to a failed voltage regulator and the pilot’s failure to maintain a proper airspeed during a precautionary landing, which resulted in a loss of directional control and a runway excursion.NTSB GAA15CA231Accident · Minor injuriesData collectionFinal reportCessna 180H · Ione, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.NTSB ERA15CA320Accident · Minor injuriesData collectionFinal reportSanderson Herbert H SHA Glasair · Bladenboro, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch.NTSB GAA15CA228Accident · No injuriesData collectionFinal reportCessna 337F · Danbury, CTThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing, nose gear collapse, runway excursion, and collision with terrain.NTSB GAA15CA223Accident · Minor injuriesData collectionFinal reportCessna 170B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB ERA15CA302Accident · Minor injuriesData collectionFinal reportCessna 206G · Titusville, FLThe pilot's landing with a tailwind at an excessive speed, which resulted in a runway excursion, and collision with a ditch.NTSB GAA15CA218Accident · No injuriesData collectionFinal reportCessna 170A · East Haddam, CTThe pilot's failure to maintain directional control during the landing roll, and excessive use of brakes, which resulted in a runway excursion and nose over.NTSB ERA15LA300Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hot Springs, VAA partial loss of engine power during initial climb due to the failure of a magneto. Contributing to the accident was the pilot's decision to operate the airplane without a current annual inspection.NTSB GAA15CA226Accident · No injuriesData collectionFinal reportStick & Rag Flying Club CB 1 · Kingman, KSThe separation of the left wheel from the landing gear assembly during the landing touchdown, which precipitated a loss of directional control, runway excursion, and nose over.NTSB GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.NTSB GAA15CA212Accident · Minor injuriesData collectionFinal reportMain Air Rapier · Reidsville, NCThe student pilot landed with variable wind conditions, which resulted in an in-flight loss of control and subsequent impact with terrain.NTSB GAA15CA209Accident · No injuriesData collectionFinal reportBellanca 17 30A · Tallahassee, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a forced landing on a road where the left wing impacted vegetation and sustained substantial damage.NTSB GAA15CA210Accident · No injuriesData collectionFinal reportExperimental Amat Built Kitfox III · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with terrain.NTSB ERA15LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Perkasie, PAThe pilot's failure to use the mixture control to override a throttle anomaly and reduce engine power, which resulted in excessive airspeed upon landing and a subsequent runway overrun. Contributing to the accident was the pilot’s inability to reduce the…NTSB ERA15CA307Accident · Minor injuriesData collectionFinal reportJohnny F Anderson Buckeye Dream Machin · Trenton, SCThe non-certificated pilot's inadequate preflight inspection, which resulted in a loss of directional control during takeoff, and collision with trees during the subsequent rejected takeoff.NTSB GAA15CA220Accident · No injuriesData collectionFinal reportCessna 150M · Apopka, FLFollowing a bird strike during takeoff, the pilot's decision to land without sufficient runway remaining to safely stop the airplane, which resulted in an over-run, collision with terrain, and nose over.NTSB GAA15CA203Accident · No injuriesData collectionFinal reportWelch Floyd L Quickie Q 2 · Hazleton, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB GAA15CA201Accident · No injuriesData collectionFinal reportAeronca 7BCM · Warsaw, MOThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a collision with terrain.NTSB ERA15LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fort Lauderdale, FLThe undetected fatigue cracks in the engine and nose landing gear (NLG) strut mount assembly, which prevented the proper alignment of the NLG after it was extended and the pilots from being able to maintain directional control after touchdown.NTSB DCA15WA209Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe government of Mexico has notified the NTSB of an incident involving a Boeing 737 that occurred on July 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of ICAO Annex…NTSB GAA15CA194Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Monte Vista, COThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with objects.NTSB GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.NTSB ERA15LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Linden, NJThe pilot’s delayed decision to reject the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot’s failure to properly configure the flaps for maximum takeoff performance with the airplane near its maximum gross weight.NTSB GAA15CA192Accident · No injuriesData collectionFinal reportCessna R172K · Fairfield, NCThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA189Accident · No injuriesData collectionFinal reportCessna 182Q · Hanksville, UTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with terrain.NTSB GAA15LA191Accident · Minor injuriesLimited investigationFinal reportCelier Xenon RST · Livingston, TXThe pilot’s loss of directional control after aborting the takeoff due to a grinding noise coming from the main rotor area, which resulted in a runway excursion.NTSB GAA15CA207Accident · No injuriesData collectionFinal reportCessna 170B · Rosamond, CAThe pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.NTSB GAA15CA188Accident · No injuriesData collectionFinal reportChampion 7GCAA · Kingsland, TXThe pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.NTSB GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.NTSB ERA15LA266Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Southbridge, MAThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB GAA15CA185Accident · No injuriesData collectionFinal reportBarron Starduster SA 300 · Whiteville, NCThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.NTSB CEN15CA304Accident · No injuriesData collectionFinal reportCessna 340 · South St. Paul, MNThe airplane's inability to takeoff for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies. The aborted takeoff resulted in a runway overrun and impact with a fence.NTSB ERA15CA267Accident · No injuriesData collectionFinal reportBrandt Leroy E Challenger II · Batavia, NYThe pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.NTSB ERA15LA270Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Climax, GAA loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.