NTSB investigations, 2010
230 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\") = 2010
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") = 2010 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 WPR10LA253Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Robbins, CAThe failure of the wheel hub flange, which allowed the over size tire to expand and impinge on the brake disc and caliper, which resulted in a loss of control during the landing.NTSB ERA10CA276Accident · No injuriesData collectionFinal reportCessna P210N · Cambridge, NYThe pilot's loss of directional control during takeoff.NTSB CEN10CA265Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Roe, ARThe pilot's decision to take off with a tailwind, resulting in a runway overrun.NTSB ERA10WA514Accident · No injuriesForeign investigationPiper PA42 · Jundiaí, BrazilOn May 20, 2010, about 1935 universal coordinated time (1735 local time), a Piper PA-42-1000, N313PC, was substantially damaged during a runway excursion after the application of reverse thrust during landing at Rolim Adolfo Amaro Airport (SBJD), Jundiai,…NTSB ERA10CA273Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Farmingdale, NYThe pilot's failure to maintain directional control during a go-around attempt.NTSB CEN10CA262Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · D'Hanis, TXThe pilot's failure to properly set the airplane's flaps prior to takeoff.NTSB CEN10CA258Accident · No injuriesData collectionFinal reportCalcote Clarence E Glasair RG · Lee's Summit, MOThe failure of the landing gear to fully extend and lock in the down position for unknown reasons.NTSB CEN10CA260Accident · No injuriesData collectionFinal reportCessna 180 · Duluth, MNThe pilot's failure to maintain directional control during landing.NTSB WPR10CA243Accident · No injuriesData collectionFinal reportCessna 170B · Moab, UTThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10LA241Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDA loss of directional control and runway excursion for undetermined reasons.NTSB CEN10CA349Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Webster, IAThe pilot misjudged his speed and distance during landing, which resulted in an overrun.NTSB CEN10LA243Accident · No injuriesLimited investigationFinal reportMooney M20G · Benton, ARThe pilot's failure to maintain directional control of the airplane during the aborted takeoff.NTSB ERA10CA257Accident · No injuriesData collectionFinal reportCessna 305A · Fort Pierce, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB WPR10CA227Accident · No injuriesData collectionFinal reportCessna 182M · Angwin, CAThe pilot's inadequate compensation for the crosswind resulting in the loss of directional control during the landing roll.NTSB WPR10CA225Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Yuba City, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10CA236Accident · No injuriesData collectionFinal reportBeech 76 · Willows, CAThe student pilot's inadequate compensation for the gusting crosswind conditions and the certified flight instructor's inadequate supervision, resulting in a loss of directional control during landing.NTSB CEN10CA237Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Houston, TXThe pilot's failure to attain the proper touchdown point which resulted in an overrun.NTSB CEN10CA232Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · Highland, ILThe pilot's inadequate preflight planning and his delayed aborted takeoff.NTSB ERA10CA244Accident · No injuriesData collectionFinal reportCessna 172N · Poughkeepsie, NYThe pilot's failure to maintain directional control on the landing rollout.NTSB ERA10CA239Accident · No injuriesData collectionFinal reportNew Standard D-25 · Vidalia, GAThe pilot’s failure to maintain directional control during landing.NTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.NTSB WPR10TA213Accident · No injuriesFinal reportCessna T206H · Fullerton, CAThe pilot’s inadequate compensation for the wind conditions during the landing flare and failure to maintain directional control on the ground.NTSB CEN10CA221Accident · No injuriesData collectionFinal reportPiper PA-24-250 · West Chicago, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR10LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fruitland, UTThe pilot’s improper landing flare.NTSB ERA10LA237Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Parkersburg, WVThe inadequate design of the engine mount by the manufacturer, resulting in collapse of the nose landing gear. Contributing to the accident was the failure of the operator to adhere to the manufacturer's suggested engine mount inspection schedule.NTSB CEN10LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Three Rivers, MIThe pilot's inability to maintain directional control during landing due to the failure of the left main landing gear torque link as a result of fatigue.NTSB CEN10LA203Accident · No injuriesLimited investigationFinal reportUnivair 415-C · Columbiaville, MIThe pilot misjudged his speed and distance while landing, which resulted in an overrun and subsequent collision with terrain.NTSB ERA10CA225Accident · No injuriesData collectionFinal reportLuscombe 8A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in a ground loop.NTSB WPR10CA204Accident · No injuriesData collectionFinal reportMathis Melvin R Bushby Mustang II · Apple Valley, CAThe CFI's inability to overcome the improper control inputs of the private pilot, who was handling the flight controls, which resulted in their loss of directional control during landing.NTSB WPR10LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Columbia, CAThe pilot's failure to maintain directional control during landing roll.NTSB ERA10CA230Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Augusta, GAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB CEN10CA192Accident · Minor injuriesData collectionFinal reportStroup Robert RV-6 · Muleshoe, TXThe pilot's failure to maintain directional control during takeoff in strong, gusting winds.NTSB CEN10CA191Accident · No injuriesData collectionFinal reportMaule M-5-210C · Bismarck, NDThe pilot’s failure compensate for the crosswinds resulting in a loss of directional control while landing.NTSB ERA10CA212Accident · Minor injuriesData collectionFinal reportCessna 172K · Romney, WVThe pilot's improper decision to land with a 20-knot tailwind and his failure to initiate a go-around, which resulted in a runway overrun.NTSB ERA10CA209Accident · Minor injuriesData collectionFinal reportCessna 182S · Montauck, NYThe pilot’s excessive airspeed on final approach and his failure to achieve the proper touchdown point.NTSB CEN10CA190Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe pilot’s failure to maintain directional control during the landing rollout with gusting winds.NTSB ERA10CA201Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Sevierville, TNThe pilot's inadvertent retraction of the landing gear on the ground during a touch-and-go landing.NTSB ERA10CA200Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot's inadequate recovery from a bounced landing.NTSB CEN10CA213Accident · No injuriesData collectionFinal reportWaco YPF-7 · Houston, TXThe pilot's inability to maintain control during landing due to the failure of the tailwheel locking mechanism to remain engaged prior to landing.NTSB CEN10CA175Accident · No injuriesData collectionFinal reportVan Dusen John M Longeze · Houston, TXThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB CEN10CA176Accident · No injuriesData collectionFinal reportCessna 172S · Mckinney, TXThe student pilot's loss of directional control while landing with a crosswind.NTSB WPR10CA179Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Lebanon, ORThe pilot's failure to release his brake application after adding power to regain directional control during the landing roll.NTSB WPR10CA178Accident · No injuriesData collectionFinal reportHardie James D KIT FOX XL · Willows, CAThe pilot’s improper flare, resulting in a bounced landing and ground loop.NTSB WPR10CA177Accident · No injuriesData collectionFinal reportCessna 170 · Kingman, AZThe pilot’s failure to maintain directional control during landing rollout. Contributing to the accident was flight control interference by the passenger.NTSB WPR10CA176Accident · No injuriesData collectionFinal reportCessna 182Q · Fallbrook, CAThe pilot’s failure to maintain directional control of the airplane during landing.NTSB CEN10CA167Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Sugar Land, TXThe pilot's failure to maintain a proper glidepath and rate of descent during approach, resulting in a hard landing.NTSB WPR10LA171Accident · No injuriesLimited investigationFinal reportCarr RV-4 · Arlington, WAThe failure of both main landing gear's drag link bolts in overstress and the subsequent collapse of the landing gear during landing rollout.NTSB WPR10LA160Accident · Serious injuriesLimited investigationFinal reportMigas RV9-A · Twin Falls, IDThe pilot's loss of directional control during landing roll for an undetermined reason.NTSB CEN10CA158Accident · No injuriesData collectionFinal reportCessna 172M · Waupaca, WIThe student pilot's failure to maintain directional control while taking off in gusting winds.NTSB ERA10CA182Accident · No injuriesData collectionFinal reportFrederickson Charles A Pitts S-2E · Okeechobee, FLThe pilot’s failure to maintain directional control during a crosswind landing.