NTSB investigations, 2010

235 cases where the sequence of events included Loss of control on ground.

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\" = '230' 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 WPR10CA368Accident · No injuriesData collectionFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's inadequate compensation for a wind gust during the landing roll.Jul 18, 2010 · N619VM · Substantial damageNTSB CEN10CA412Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Edmore, NDThe pilot's selection of unsuitable terrain for landing.Jul 17, 2010 · N8774S · Substantial damageNTSB WPR10LA354Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe pilot's loss of directional control while attempting to move the helicopter laterally without first lifting it fully off its landing platform.Jul 16, 2010 · N944DW · Substantial damageNTSB ANC10CA091Accident · No injuriesData collectionFinal reportAvions Max Holste MH 1521 Broussard · Skwentna, AKThe pilot's inadequate crosswind compensation, which resulted in a loss of directional control.Jul 15, 2010 · N5833E · Substantial damageNTSB 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 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 ERA10CA360Accident · No injuriesData collectionFinal reportPiper PA28R · Sarasota, FLThe pilot's loss of directional control during the takeoff roll.Jul 11, 2010 · N142TV · Substantial damageNTSB WPR10CA344Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Dutch John, UTThe pilot’s inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.Jul 10, 2010 · N376DC · Substantial damageNTSB WPR10CA342Accident · No injuriesData collectionFinal reportPiper PA32RT · Sedona, AZThe pilot’s failure to maintain runway alignment during approach and subsequent loss of directional control during landing.Jul 10, 2010 · N36402 · Substantial damageNTSB ERA10CA352Accident · No injuriesData collectionFinal reportVans RV8 · Port Orange, FLThe pilot's failure to maintain directional control during the landing rollout.Jul 10, 2010 · N801RG · 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 CEN10CA387Accident · No injuriesData collectionFinal reportCessna 140 · Franklin, INThe pilot's improper touchdown point and excessive braking, which resulted in a nose over.Jul 10, 2010 · N72609 · 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 ERA10LA345Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fairfield, PAThe pilot's improper touchdown point which resulted in an overrun.Jul 3, 2010 · N9809P · 2 aircraft · 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 WPR10CA333Accident · No injuriesData collectionFinal reportCessna 180 · Missoula, MTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during the landing roll.Jul 1, 2010 · N3642C · 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 CEN10LA351Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Indianapolis, INThe pilot's inability to maintain directional control during landing due to the airplane not being equipped with a steerable or locking tailwheel as required by the airplane's design.Jun 26, 2010 · N469RH · 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 WPR10CA301Accident · No injuriesData collectionFinal reportCessna 180 · Big Creek, IDThe pilot’s failure to maintain directional control while taxiing at an unfamiliar airstrip.Jun 21, 2010 · N2350C · Substantial damageNTSB ERA10CA324Accident · No injuriesData collectionFinal reportCessna 150G · Jasper, TNThe pilot under instruction's failure to maintain directional control during landing, and his failure to relinquish the flight controls when directed.Jun 21, 2010 · N8321J · Substantial damageNTSB ERA10CA321Accident · Minor injuriesData collectionFinal reportAeronca 7BCM · Bolivar, TNThe pilot's failure to maintain directional control while landing.Jun 19, 2010 · N2553B · Substantial damageNTSB CEN10CA329Accident · No injuriesData collectionFinal reportPiper/Wally'S Flyers J3C-65 · Crystal, MNThe pilot's failure to maintain directional control during the crosswind landing and the instructor pilot's delayed remedial action.Jun 19, 2010 · N25WF · 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 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 WPR10CA290Accident · No injuriesData collectionFinal reportWaco UKC-S · Seattle, WAThe pilot’s inadequate compensation for the crosswind condition, resulting in a loss of directional control during the landing roll.Jun 14, 2010 · N14611 · 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 ANC10CA052Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's failure to maintain directional control while landing in variable wind conditions.Jun 12, 2010 · N2886C · 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 ANC10CA051Accident · No injuriesData collectionFinal reportStinson 108-1 · Galena, AKThe pilot's failure to maintain directional control during takeoff, resulting in a ground-loop, and collapse of the right main landing gear.Jun 8, 2010 · N136SP · Substantial damageNTSB CEN10CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Northwood, NDThe pilot’s failure to maintain adequate clearance from the transmission wire.Jun 7, 2010 · N9620S · Substantial damageNTSB ERA10CA305Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, MDThe pilot’s improper flare, which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to land during a thunderstorm.Jun 4, 2010 · N789EP · Substantial damageNTSB WPR10LA275Accident · Minor injuriesLimited investigationFinal reportAirborne Windsports PTY Edge X · Alturas, CAFracture of a mast support cable due to corrosion, which resulted in a loss of control during the landing roll.Jun 2, 2010 · N354MB · 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 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 CEN10CA288Accident · No injuriesData collectionFinal reportMoe-Pietenpol Aircamper A · Early, TXThe pilot's selection of an unsuitable takeoff site.May 29, 2010 · N3472 · Substantial damageNTSB ANC10CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Anchorage, AKThe pilot's failure to maintain directional control during the landing.May 29, 2010 · N5844D · 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 WPR10CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kona, HIThe student pilot's improper use of the anti-torque controls and failure to maintain directional control during takeoff.May 25, 2010 · N220PE · Substantial damageNTSB ANC10LA044Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Anchorage, AKThe commercial pilot’s loss of airplane control while landing in a crosswind, resulting in a nose-over. Contributing to the accident was the check pilot's inadequate supervision of the commercial pilot while landing.May 24, 2010 · N4793C · Substantial damageNTSB ANC10CA043Accident · No injuriesData collectionFinal reportPiper PA-12 · Tanana, AKThe pilot's excessive application of the brakes during the landing roll resulting in a nose over.May 24, 2010 · N2507M · 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 damage