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.

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.May 21, 2010 · N3633C · Substantial damageNTSB ERA10CA276Accident · No injuriesData collectionFinal reportCessna P210N · Cambridge, NYThe pilot's loss of directional control during takeoff.May 21, 2010 · N234JK · Substantial damageNTSB CEN10CA265Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Roe, ARThe pilot's decision to take off with a tailwind, resulting in a runway overrun.May 21, 2010 · N107CA · Substantial damageNTSB 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,…May 20, 2010 · N313PC · Substantial damageNTSB ERA10CA273Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Farmingdale, NYThe pilot's failure to maintain directional control during a go-around attempt.May 20, 2010 · N960JB · Substantial damageNTSB CEN10CA262Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · D'Hanis, TXThe pilot's failure to properly set the airplane's flaps prior to takeoff.May 20, 2010 · N3159D · Substantial damageNTSB 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.May 18, 2010 · N236CC · Substantial damageNTSB CEN10CA260Accident · No injuriesData collectionFinal reportCessna 180 · Duluth, MNThe pilot's failure to maintain directional control during landing.May 16, 2010 · N6545A · Substantial damageNTSB WPR10CA243Accident · No injuriesData collectionFinal reportCessna 170B · Moab, UTThe pilot's failure to maintain directional control during the landing roll.May 15, 2010 · N8379A · Substantial damageNTSB WPR10LA241Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDA loss of directional control and runway excursion for undetermined reasons.May 14, 2010 · N3142C · Substantial damageNTSB CEN10CA349Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Webster, IAThe pilot misjudged his speed and distance during landing, which resulted in an overrun.May 9, 2010 · N8083C · Substantial damageNTSB CEN10LA243Accident · No injuriesLimited investigationFinal reportMooney M20G · Benton, ARThe pilot's failure to maintain directional control of the airplane during the aborted takeoff.May 8, 2010 · N9221V · Substantial damageNTSB ERA10CA257Accident · No injuriesData collectionFinal reportCessna 305A · Fort Pierce, FLThe pilot's failure to maintain directional control during a crosswind landing.May 6, 2010 · N5312G · Substantial damageNTSB 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.May 3, 2010 · N91603 · Substantial damageNTSB WPR10CA225Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Yuba City, CAThe pilot's failure to maintain directional control during the landing roll.May 3, 2010 · N6018T · Substantial damageNTSB 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.May 1, 2010 · N6628X · Substantial damageNTSB CEN10CA237Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Houston, TXThe pilot's failure to attain the proper touchdown point which resulted in an overrun.Apr 30, 2010 · N4397T · Substantial damageNTSB CEN10CA232Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · Highland, ILThe pilot's inadequate preflight planning and his delayed aborted takeoff.Apr 28, 2010 · N400HK · Substantial damageNTSB ERA10CA244Accident · No injuriesData collectionFinal reportCessna 172N · Poughkeepsie, NYThe pilot's failure to maintain directional control on the landing rollout.Apr 24, 2010 · N5371D · Substantial damageNTSB ERA10CA239Accident · No injuriesData collectionFinal reportNew Standard D-25 · Vidalia, GAThe pilot’s failure to maintain directional control during landing.Apr 23, 2010 · N9194 · Substantial damageNTSB 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.Apr 21, 2010 · N4326D · Substantial damageNTSB 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.Apr 19, 2010 · N6045C · Substantial damageNTSB CEN10CA221Accident · No injuriesData collectionFinal reportPiper PA-24-250 · West Chicago, ILThe pilot's failure to maintain directional control of the airplane during landing.Apr 19, 2010 · N7748P · Substantial damageNTSB WPR10LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fruitland, UTThe pilot’s improper landing flare.Apr 17, 2010 · N9019D · Substantial damageNTSB 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.Apr 16, 2010 · N779MA · Substantial damageNTSB 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.Apr 12, 2010 · N3470R · Substantial damageNTSB 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.Apr 12, 2010 · N93876 · Substantial damageNTSB 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.Apr 10, 2010 · N1128K · Substantial damageNTSB 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.Apr 8, 2010 · N217AT · Substantial damageNTSB WPR10LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Columbia, CAThe pilot's failure to maintain directional control during landing roll.Apr 7, 2010 · N2629D · Substantial damageNTSB ERA10CA230Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Augusta, GAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.Apr 5, 2010 · N541VB · Substantial damageNTSB CEN10CA192Accident · Minor injuriesData collectionFinal reportStroup Robert RV-6 · Muleshoe, TXThe pilot's failure to maintain directional control during takeoff in strong, gusting winds.Apr 5, 2010 · N58BD · Substantial damageNTSB 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.Apr 5, 2010 · N62040 · Substantial damageNTSB 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.Apr 3, 2010 · N79234 · Substantial damageNTSB ERA10CA209Accident · Minor injuriesData collectionFinal reportCessna 182S · Montauck, NYThe pilot’s excessive airspeed on final approach and his failure to achieve the proper touchdown point.Apr 3, 2010 · N127S · Substantial damageNTSB CEN10CA190Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe pilot’s failure to maintain directional control during the landing rollout with gusting winds.Apr 3, 2010 · N222UN · Substantial damageNTSB 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.Mar 31, 2010 · N43BS · Substantial damageNTSB ERA10CA200Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot's inadequate recovery from a bounced landing.Mar 30, 2010 · N21394 · Substantial damageNTSB 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.Mar 27, 2010 · N32077 · Substantial damageNTSB CEN10CA175Accident · No injuriesData collectionFinal reportVan Dusen John M Longeze · Houston, TXThe pilot's failure to maintain directional control while landing with a quartering tailwind.Mar 27, 2010 · N164JV · Substantial damageNTSB CEN10CA176Accident · No injuriesData collectionFinal reportCessna 172S · Mckinney, TXThe student pilot's loss of directional control while landing with a crosswind.Mar 26, 2010 · N18563 · Substantial damageNTSB 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.Mar 25, 2010 · N6063M · Substantial damageNTSB WPR10CA178Accident · No injuriesData collectionFinal reportHardie James D KIT FOX XL · Willows, CAThe pilot’s improper flare, resulting in a bounced landing and ground loop.Mar 24, 2010 · N42JH · Substantial damageNTSB 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.Mar 24, 2010 · N4200V · Substantial damageNTSB WPR10CA176Accident · No injuriesData collectionFinal reportCessna 182Q · Fallbrook, CAThe pilot’s failure to maintain directional control of the airplane during landing.Mar 23, 2010 · N735KL · Substantial damageNTSB 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.Mar 22, 2010 · N616CP · Substantial damageNTSB 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.Mar 18, 2010 · N66PB · Substantial damageNTSB WPR10LA160Accident · Serious injuriesLimited investigationFinal reportMigas RV9-A · Twin Falls, IDThe pilot's loss of directional control during landing roll for an undetermined reason.Mar 15, 2010 · N951DM · Substantial damageNTSB CEN10CA158Accident · No injuriesData collectionFinal reportCessna 172M · Waupaca, WIThe student pilot's failure to maintain directional control while taking off in gusting winds.Mar 15, 2010 · N1472U · Substantial damageNTSB ERA10CA182Accident · No injuriesData collectionFinal reportFrederickson Charles A Pitts S-2E · Okeechobee, FLThe pilot’s failure to maintain directional control during a crosswind landing.Mar 13, 2010 · N17CF · Substantial damage