NTSB investigations

3,846 cases where the defining event was 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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230')
  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 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 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 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 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 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 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 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 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 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 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 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 damage