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 WPR10LA349Accident · No injuriesLimited investigationFinal reportCessna 310K · El Monte, CAThe pilot’s failure to maintain directional control during the takeoff ground roll.Jul 14, 2010 · N6909L · Substantial damageNTSB ERA10CA358Accident · No injuriesData collectionFinal reportCessna 172 · Fairhope, ALThe student pilot's failure to maintain directional control during a crosswind takeoff.Jul 13, 2010 · N295SP · Substantial damageNTSB WPR10CA346Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Yellow Pine, IDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the wet condition of the grass runway.Jul 12, 2010 · N2185K · Substantial damageNTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.Jul 12, 2010 · N527MJ · Substantial damageNTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.Jul 12, 2010 · N523RL · Minor damageNTSB ERA10CA360Accident · No injuriesData collectionFinal reportPiper PA28R · Sarasota, FLThe pilot's loss of directional control during the takeoff roll.Jul 11, 2010 · N142TV · Substantial damageNTSB CEN10CA407Accident · No injuriesData collectionFinal reportAeronca 7AC · Santa Fe, NMThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.Jul 10, 2010 · N84723 · Substantial damageNTSB CEN10LA389Accident · No injuriesLimited investigationFinal reportCessna 210 · Houston, TXThe failure of a hydraulic fluid line, which caused a loss of hydraulic pressure to the landing gear extension system and resulted in the partial collapse of the right main landing gear during touchdown.Jul 9, 2010 · N2157S · Substantial damageNTSB CEN10CA375Accident · No injuriesData collectionFinal reportPiper PA32 · Albuquerque, NMThe pilot's failure to maintain directional control of the airplane during takeoff.Jul 6, 2010 · N106C · Substantial damageNTSB WPR10TA335Accident · No injuriesFinal reportPiper PA-18-150 · Dillon, MTThe pilot's failure to maintain directional control during landing.Jul 5, 2010 · N6110A · Substantial damageNTSB CEN10CA377Accident · No injuriesData collectionFinal reportAero Commander 100 · Jacksonville, ARThe pilot's failure to maintain an appropriate approach speed and his delayed decision not to initiate a go-around. Contributing to the accident was the pilot's lack of experience in the airplane type.Jul 3, 2010 · N3792X · Substantial damageNTSB CEN10CA366Accident · No injuriesData collectionFinal reportAviat A-1B · Centennial, COThe student pilot's failure to maintain directional control and the certified flight instructor's delay in remedial action.Jul 2, 2010 · N80HY · Substantial damageNTSB WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.Jun 30, 2010 · N2990P · Substantial damageNTSB ERA10CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Farmingdale, NYThe student pilot's failure to maintain directional control during a crosswind landing.Jun 30, 2010 · N388MA · Substantial damageNTSB ERA10CA339Accident · No injuriesData collectionFinal reportPiper J3C-65 · Thomaston, GAThe pilot’s failure to maintain directional control during landing.Jun 28, 2010 · N41242 · Substantial damageNTSB WPR10CA329Accident · No injuriesData collectionFinal reportCornett Steven M Glastar · Smiley Creek, IDThe pilot's decision to not use all available runway length and his delay in aborting the takeoff, which resulted in the airplane sliding off the end of the grass strip and colliding with a ditch.Jun 27, 2010 · N51MW · Substantial damageNTSB ERA10CA334Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Gordonsville, VAThe student pilot’s failure to maintain directional control, and his excessive braking during the landing rollout.Jun 26, 2010 · N1516B · Substantial damageNTSB CEN10CA436Accident · Minor injuriesData collectionFinal reportCessna 310C · Ashdown, ARThe pilot’s loss of directional control during the takeoff roll and his lack of experience in the airplane.Jun 24, 2010 · N18RR · Substantial damageNTSB WPR10LA312Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Parker, AZThe pilot's failure to maintain directional control while landing with a crosswind.Jun 23, 2010 · N432PB · Substantial damageNTSB WPR10CA304Accident · No injuriesData collectionFinal reportCessna A185F · Bryce Canyon, UTThe pilot's inadequate compensation for the crosswinds during takeoff.Jun 23, 2010 · N55TA · Substantial damageNTSB CEN10LA335Accident · No injuriesLimited investigationFinal reportCessna 525A · Storm Lake, IAThe pilot’s decision to land on a water contaminated runway, which resulted in a runway excursion during the landing roll. Contributing to the accident was the pilot’s lack of knowledge regarding the landing distance required and the limited braking…Jun 21, 2010 · N800VT · Substantial damageNTSB ERA10LA322Accident · Serious injuriesLimited investigationFinal reportCessna 172N · West Milford, NJThe student pilot’s control interference which resulted in a landing with a higher than normal airspeed, and the commercial pilot’s failure to initiate a go-around to avoid the runway overrun.Jun 20, 2010 · N738QZ · Substantial damageNTSB CEN10CA343Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Virden, ILThe pilot's decision to take off from a wet grass runway at an airplane weight and density altitude that precluded a normal takeoff and climb.Jun 19, 2010 · N5120E · Substantial damageNTSB ERA10LA351Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Thomasville, GAThe improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.Jun 17, 2010 · N73PC · Substantial damageNTSB ERA10CA329Accident · No injuriesData collectionFinal reportNorth American SNJ-4 · Suffolk, VAThe pilot's failure to maintain directional control during the landing.Jun 17, 2010 · N43NA · Substantial damageNTSB DCA10RA069Accident · Minor injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaJun 16, 2010 · N847HK · Substantial damageNTSB CEN10CA328Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Arcola, TXThe student pilot’s failure to maintain directional control of the tailwheel-equipped airplane during the landing roll.Jun 16, 2010 · N72EB · Substantial damageNTSB WPR10CA303Accident · No injuriesData collectionFinal reportStinson 108-1 · Townsend, MTThe pilot's failure to maintain directional control during the landing roll.Jun 14, 2010 · N8706K · Substantial damageNTSB WPR10CA291Accident · No injuriesData collectionFinal reportCessna 188B · Blackfoot, IDA loss of directional control during the landing roll as a result of a worn tail wheel locking mechanism.Jun 14, 2010 · N9357K · Substantial damageNTSB ERA10CA310Accident · Serious injuriesData collectionFinal reportCessna 170 · Campbellsville, KYThe pilot’s failure to maintain directional control during an aborted landing.Jun 13, 2010 · N4273V · Substantial damageNTSB CEN10CA323Accident · Serious injuriesData collectionFinal reportMcculley Ronald W-8 · Lamoni, IAThe non-certificated pilot's decision to attempt a takeoff that exceeded the airplane's performance capability, which resulted in an overrun.Jun 12, 2010 · N8519N · Substantial damageNTSB ERA10CA331Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Perry, NYThe pilot's failure to attain the proper touchdown point, resulting in an overrun.Jun 11, 2010 · N800GT · Substantial damageNTSB CEN10CA321Accident · No injuriesData collectionFinal reportCessna A188B · Orange, TXThe loss of directional control during the takeoff roll due to an incorrectly maintained left main landing gear.Jun 9, 2010 · N9510J · Substantial damageNTSB ERA10CA304Accident · No injuriesData collectionFinal reportCessna 305A · Toms River, NJThe pilot-in-command's loss of airplane control during landing, which resulted in a ground-loop.Jun 8, 2010 · N5075K · Substantial damageNTSB CEN10CA318Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Brookshire, TXThe pilot's failure to maintain directional control during the landing roll.Jun 7, 2010 · N55208 · Substantial damageNTSB ERA10LA296Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Rainelle, WVThe pilot's failure to adequately assess the runway conditions prior to attempting a takeoff and his failure to abort the takeoff in a timely manner resulting in an on-ground collision with trees.Jun 4, 2010 · N111VP · Substantial damageNTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.Jun 4, 2010 · N421KB · Substantial damageNTSB ERA10CA303Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Block Island, RIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with a fence.Jun 2, 2010 · N47661 · Substantial damageNTSB CEN10CA283Accident · No injuriesData collectionFinal reportCessna 182A · Franksville, WIThe pilot’s inadequate preflight inspection and delay in aborting the takeoff.Jun 2, 2010 · N4974D · Substantial damageNTSB WPR10CA282Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Chandler, AZThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.May 31, 2010 · N6075L · Substantial damageNTSB ERA10CA289Accident · No injuriesData collectionFinal reportCessna 172N · Sterling, MAThe pilot’s decision to not continue with the go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s distraction due to the passenger’s panicked condition.May 31, 2010 · N6371D · Substantial damageNTSB ERA10CA288Accident · Minor injuriesData collectionFinal reportCessna 182H · Oliver Springs, TNThe pilot's failure to execute a go-around, which resulted in a long landing, runway overrun, and the airplane's subsequent descent into a stream.May 31, 2010 · N8311S · Substantial damageNTSB ERA10CA295Accident · No injuriesData collectionFinal reportCessna 182D · Chateaugay, NYThe pilot's misjudgedment of his speed and distance during landing, which resulted in an overrun.May 30, 2010 · N9985T · Substantial damageNTSB WPR10CA281Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Avalon, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun.May 29, 2010 · N314CP · Substantial damageNTSB CEN10LA279Accident · Serious injuriesLimited investigationFinal reportThunderbird TOP DOG UL · Luling, TXPoor engine performance due to the modified engine parameters and installation of the fuel nozzles which produced a lean fuel condition resulting in decreased aircraft performance and subsequent impact with the trees.May 29, 2010 · N2574V · Substantial damageNTSB WPR10CA266Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · St. George, UTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.May 26, 2010 · N40800 · Substantial damageNTSB ERA10CA278Accident · No injuriesData collectionFinal reportCessna 172S · East Haddam, CTThe pilot's delayed decision to attempt a go-around, and his subsequent failure to maintain directional control while landing.May 24, 2010 · N169ER · Substantial damageNTSB WPR10LA260Accident · No injuriesLimited investigationFinal reportSocata TBM · Lost Hills, CAA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot's failure to obtain the proper…May 23, 2010 · N750AB · Substantial damageNTSB WPR10CA296Accident · No injuriesData collectionFinal reportCessna P210N · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll in gusty crosswind conditions.May 22, 2010 · N210SL · Substantial damageNTSB WPR10CA254Accident · No injuriesData collectionFinal reportBoeing B75 · Yerington, NVThe pilot's inadequate compensation for the crosswind condition, resulting in the loss of directional control during the landing roll.May 22, 2010 · N1193N · Substantial damage