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 WPR10CA455Accident · No injuriesData collectionFinal reportMaule MX7 · Willows, CAThe pilot's inadequate compensation for the gusty crosswind condition and his failure to maintain directional control.Sep 11, 2010 · N6138Y · Substantial damageNTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.Sep 10, 2010 · N330JH · Substantial damageNTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.Sep 10, 2010 · N226CP · Minor damageNTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.Sep 9, 2010 · N2753M · Substantial damageNTSB WPR10CA480Accident · No injuriesData collectionFinal reportCessna A185 · Santa Ynez, CAThe pilot's failure to maintain directional control, likely due to the inadvertent control interference by a passenger. A finding in the accident was the pilot's improper pre flight briefing.Sep 6, 2010 · N4622C · Substantial damageNTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.Sep 6, 2010 · N515CW · Substantial damageNTSB ANC10CA088Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Arctic Village, AKThe pilot's failure to maintain control of the airplane during an off-airport landing.Sep 6, 2010 · N9128D · Substantial damageNTSB CEN10CA530Accident · No injuriesData collectionFinal reportCullis Ultracruiser Sport · Defiance, OHThe pilot's failure to maintain aircraft control during the landing roll.Sep 5, 2010 · N716CS · Substantial damageNTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.Sep 3, 2010 · N9980J · Substantial damageNTSB WPR10CA453Accident · No injuriesData collectionFinal reportCessna 150C · Fields, ORThe pilot's misjudged landing flare, resulting in a bounced landing and loss of directional control. Contributing to the accident was the pilot's inaccurate perception of the airplane’s proximity to the ground as a result of the featureless white landing area.Sep 3, 2010 · N2068Z · Substantial damageNTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.Sep 3, 2010 · N7415B · Substantial damageNTSB WPR10CA444Accident · Minor injuriesData collectionFinal reportSchweizer 164B · Murtaugh, IDThe pilot’s inadequate compensation for the wind and failure to maintain directional control during the takeoff roll.Sep 2, 2010 · N7502Y · Substantial damageNTSB DCA10WA093Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanOn September 2, 2010, at 1337 UTC, an Eva Airways Boeing 747-400 ran off the edge of runway 24 upon landing at Tao Yuan International Airport, Taipei, Taiwan. The aircraft was registered in Taiwan a B-16410 and was on a scheduled passenger flight from Poo…Sep 2, 2010 · B-16410 · Minor damageNTSB CEN10CA516Accident · No injuriesData collectionFinal reportChampion 7KCAB · North Fork, NEThe student pilot's loss of directional control during landing, which resulted in a ground loop.Sep 2, 2010 · N1678G · Substantial damageNTSB CEN10CA513Accident · No injuriesData collectionFinal reportCessna 172P · Bartlesville, OKThe student pilot's loss of directional control during takeoff due to an improper flap setting.Aug 28, 2010 · N52071 · Substantial damageNTSB ERA10CA448Accident · No injuriesData collectionFinal reportCessna 182E · Edenton, NCThe pilot's inadequate compensation for crosswind conditions while landing, which resulted in a loss of directional control.Aug 27, 2010 · N3351Y · Substantial damageNTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.Aug 27, 2010 · N9730P · Substantial damageNTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.Aug 26, 2010 · N1321C · Substantial damageNTSB CEN10CA505Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Waynesville, OHThe pilot's loss of aircraft control during the tow for takeoff.Aug 25, 2010 · N31TS · Substantial damageNTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.Aug 23, 2010 · N29100 · Substantial damageNTSB ERA10CA440Accident · No injuriesData collectionFinal reportBeech P35 · Hartford, CTThe pilot's inadequate compensation for the crosswind, resulting in a loss of directional control during landing.Aug 23, 2010 · N8667M · Substantial damageNTSB WPR10CA418Accident · No injuriesData collectionFinal reportWilde Daniel L Zenith 701 · Turlock, CAThe pilot’s inadequate compensation for the crosswind and failure to maintain runway alignment.Aug 21, 2010 · N948DW · Substantial damageNTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.Aug 21, 2010 · N123TA · Substantial damageNTSB CEN10CA495Accident · No injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Madisonville, TXThe pilot's failure to maintain control of the glider while landing in a crosswind.Aug 20, 2010 · N710RJ · Substantial damageNTSB CEN10CA490Accident · Serious injuriesData collectionFinal reportPiper PA-46-310P · Austin, TXThe pilot's failure to maintain a stabilized approach, which resulted in a loss of control on landing with a tailwind.Aug 20, 2010 · N106LB · Substantial damageNTSB CEN10CA488Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA18-225 · Denver, COThe pilot's failure to maintain control of the airplane during landing.Aug 20, 2010 · N755K · Substantial damageNTSB ERA10TA429Accident · No injuriesFinal reportBell UH1H · Warrenton, VAThe pilot receiving instruction's failure to maintain a proper pitch attitude during the practice autorotation maneuver.Aug 16, 2010 · UNREG · Substantial damageNTSB ERA10CA418Accident · No injuriesData collectionFinal reportCessna 182F · Canon, GAThe pilot’s improper recovery from a bounced landing.Aug 12, 2010 · N3562Y · Substantial damageNTSB CEN10LA475Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Silver City, NMThe pilot's loss of directional control during takeoff and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.Aug 11, 2010 · N4546E · Substantial damageNTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.Aug 11, 2010 · N4492 · Substantial damageNTSB CEN10LA472Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions.Aug 11, 2010 · N350CC · Substantial damageNTSB WPR10CA394Accident · Minor injuriesData collectionFinal reportCessna 170 · Salt Lake City, UTThe pilot’s failure to maintain aircraft control during the landing roll.Aug 9, 2010 · N179MM · Substantial damageNTSB ERA10CA413Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe student pilot’s failure to maintain directional control of the airplane during takeoff.Aug 9, 2010 · N927LA · Substantial damageNTSB ANC10CA072Accident · No injuriesData collectionFinal reportPiper J5C · Skwentna, AKThe pilot's failure to maintain directional control during landing, and his selection of unsuitable terrain for landing.Aug 9, 2010 · N38532 · Substantial damageNTSB WPR10CA431Accident · No injuriesData collectionFinal reportHemmer MINI-MAX 1600R · Davis, CAThe airplane’s encounter with the wake turbulence of another aircraft.Aug 8, 2010 · N71031 · Substantial damageNTSB WPR10CA391Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Bridgeport, CAThe pilot’s failure to maintain directional control during the landing roll.Aug 8, 2010 · N230SS · Substantial damageNTSB ERA10LA405Accident · No injuriesLimited investigationFinal reportGlines Sportsman GS-2 · Morrisville, VTThe pilot's improper flare during a forced landing. Contributing to the accident was a loss of fuel pressure for undetermined reasons.Aug 7, 2010 · N546SG · Substantial damageNTSB CEN10CA473Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Watkins, COThe pilot's failure to maintain aircraft control during the landing, resulting in a ground-loop.Aug 5, 2010 · N8576Y · Substantial damageNTSB WPR10CA380Accident · No injuriesData collectionFinal reportPiper PA-12 · White Sulphur Springs, MTThe pilot’s loss of directional control while attempting to avoid a herd of antelope crossing the runway during the landing rollout.Aug 2, 2010 · N3098M · Substantial damageNTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.Aug 2, 2010 · N5177E · Substantial damageNTSB CEN10CA451Accident · No injuriesData collectionFinal reportPiper PA-12 · Wild Rose, WIThe pilot's loss of directional control during the takeoff roll.Aug 2, 2010 · N775PA · Substantial damageNTSB ERA10CA397Accident · No injuriesData collectionFinal reportLuscombe 8C · Zelienople, PAThe pilot's loss of directional control while taking off with a gusting wind.Aug 1, 2010 · N4113M · Substantial damageNTSB WPR10CA378Accident · No injuriesData collectionFinal reportPorter James Grant Superior CUB · Caldwell, IDThe pilot’s failure to maintain directional control during landing.Jul 31, 2010 · N97RP · Substantial damageNTSB CEN10CA452Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Pittsfield, ILThe pilot's loss of directional control during a precautionary off-field landing that he performed after encountering deteriorating weather conditions.Jul 30, 2010 · N17MX · Substantial damageNTSB CEN10CA439Accident · No injuriesData collectionFinal reportBeers Tailwind 10 · Delta, COA loss of control on the ground due to a malfunction of the right brake caliper.Jul 26, 2010 · N375JX · Substantial damageNTSB CEN10LA427Accident · 1 fatalLimited investigationFinal reportCessna 180 · Davant, LAThe pilot’s improper application of the flight controls and throttle during landing, which resulted in a nose over and subsequent inverted immersion in the water. Contributing to the accident was the flight instructor’s delayed remedial action and inadequate…Jul 24, 2010 · N7812K · Substantial damageNTSB ERA11CA163Accident · No injuriesData collectionFinal reportAeronca 11AC · Randolph, NYThe certified flight instructor's delayed response to the student pilot's loss of directional control during takeoff, which resulted in a runway excursion and collision with a building.Jul 20, 2010 · N9120E · Substantial damageNTSB WPR10CA358Accident · No injuriesData collectionFinal reportAviat A-1B · Casper, WYThe pilot's failure to maintain directional control during landing.Jul 19, 2010 · N115XT · Substantial damageNTSB ERA10LA365Accident · 1 fatalLimited investigationFinal reportTexas Air Ventures Comp AIR 8 · Mount Pleasant, SCThe pilot's failure to retrim the airplane and maintain aircraft control during an aborted landing, which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.Jul 19, 2010 · N882X · Substantial damageNTSB CEN10CA421Accident · No injuriesData collectionFinal reportNord 3202 · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll.Jul 19, 2010 · N2256Y · Substantial damage