NTSB investigations, 2013

216 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\") = 2013
    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 ERA13CA422Accident · No injuriesData collectionFinal reportUniversal Stinson 108 1 · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing, resulting in a ground loop, runway excursion, and structural damage to the right wing.Sep 19, 2013 · N8384K · Substantial damageNTSB ANC13CA104Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Delta Junction, AKThe pilot's inadequate takeoff planning and judgment that did not consider the reduced acceleration due to snow-covered terrain, which resulted in an aborted takeoff and collision with terrain.Sep 19, 2013 · N7190D · Substantial damageNTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.Sep 18, 2013 · N58482 · Substantial damageNTSB WPR13LA414Accident · No injuriesLimited investigationFinal reportCessna 180 - B · Redmond, ORThe pilot's inability to counter an unexpected wind gust after touchdown, which resulted in a loss of directional control.Sep 16, 2013 · N5112E · Substantial damageNTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.Sep 15, 2013 · N321BA · Substantial damageNTSB WPR13CA409Accident · No injuriesData collectionFinal reportCessna 195A · Meadow Creek, MTThe pilot's failure to maintain directional control during the takeoff roll on a rough turf runway.Sep 14, 2013 · N4324N · Substantial damageNTSB ANC13CA098Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Akhiok, AKThe pilot's failure to maintain directional control during takeoff in a gusty tailwind.Sep 14, 2013 · N1544 · Substantial damageNTSB ERA13CA419Accident · No injuriesData collectionFinal reportPiper PA28 151 · Abingdon, VAThe failure of the pilot to maintain directional control during a crosswind landing resulting in collision with terrain and aft displacement of the nose landing gear.Sep 13, 2013 · N4379F · Substantial damageNTSB CEN13CA544Accident · No injuriesData collectionFinal reportCessna 170A · Victoria, TXThe student pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.Sep 11, 2013 · N170TP · Substantial damageNTSB ERA13LA418Accident · No injuriesLimited investigationFinal reportFleet 7 · Louisa, VAMaintenance personnel’s improper service, adjustment, and inspection of the brakes, which resulted in a runway excursion and subsequent noseover.Sep 7, 2013 · N9433 · Substantial damageNTSB CEN13LA541Accident · No injuriesLimited investigationFinal reportCessna 180 · Gallup, NMThe pilot's failure to maintain airplane directional control during the landing roll due to his diverted attention.Sep 7, 2013 · N561AT · Substantial damageNTSB CEN13LA534Accident · No injuriesLimited investigationFinal reportBarrow Rose Parrakeet · Castroville, TXThe failure of the left main landing gear wheel on landing due to overstress, which resulted in the pilot’s loss of directional control. Contributing to the accident was the pilot's improper decision to install wheels with insufficient loading capacity for…Sep 7, 2013 · N1732 · Substantial damageNTSB CEN13CA532Accident · No injuriesData collectionFinal reportCessna 150G · Denver, COThe pilot's failure to maintain directional control during landing which resulted in an impact with the runway surface. A contributing factor was the certified flight instructor delayed response to the pilot's improper landing.Sep 6, 2013 · N4791X · Substantial damageNTSB ERA13LA410Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Woodrow, SCA failure of the right rudder pedal arm due to corrosion as a result of inadequate maintenance and inspection of the rudder pedal assembly.Sep 4, 2013 · N59JK · Substantial damageNTSB CEN13CA529Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluff, IAThe student pilot's loss of directional control during takeoff.Sep 4, 2013 · N368ES · Substantial damageNTSB CEN13CA526Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Edgerton, MNThe pilot's delay in aborting the landing which resulted in the airplane contacting the terrain off the departure end of the runway.Sep 4, 2013 · N7393W · Substantial damageNTSB WPR13CA394Accident · No injuriesData collectionFinal reportHenderson Michael E Glastar · Sequim, WAThe pilot's improper soft field landing technique, and failure to maintain aircraft control during the landing.Aug 31, 2013 · N789MH · Substantial damageNTSB CEN13LA531Accident · No injuriesLimited investigationFinal reportCessna/Weaver 305 - E · Paris, TXThe failure of a landing gear O-ring, which prevented the pilot from being able to maintain directional control of the airplane during landing.Aug 31, 2013 · N862 · Substantial damageNTSB ERA13CA394Accident · No injuriesData collectionFinal reportHoskins Samuel R Quickie Q2 · Zelienople, PAThe pilot's loss of directional control during takeoff due to right main landing gear contact with a pool of standing water on the runway which resulted in a runway excursion.Aug 30, 2013 · N202SH · Substantial damageNTSB ANC13CA086Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's loss of control of the airplane during takeoff, resulting in a ground loop.Aug 27, 2013 · N2583C · Substantial damageNTSB CEN13CA522Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Iowa City, IAThe pilot failed to maintain directional control of the airplane while landing.Aug 25, 2013 · N5761Z · Substantial damageNTSB CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 25, 2013 · N4888Z · Substantial damageNTSB ERA13CA377Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s decision to depart with a known deficiency following a hard landing. Contributing to the accident was an anomaly of the airplane’s nosewheel steering that could not be replicated during post-accident examination.Aug 24, 2013 · N98923 · Substantial damageNTSB CEN13LA497Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · Zanesville, OHThe pilot’s loss of directional control during landing.Aug 20, 2013 · N727Y · Substantial damageNTSB ANC13CA082Accident · No injuriesData collectionFinal reportCessna 185 · Sleetmute, AKThe pilot's failure to maintain directional control during landing.Aug 16, 2013 · N185SN · Substantial damageNTSB WPR13CA372Accident · No injuriesData collectionFinal reportPiper PA-20 · Aurora, ORThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground-loop.Aug 14, 2013 · N6939K · Substantial damageNTSB ANC13CA078Accident · No injuriesData collectionFinal reportPiper PA-18-150 · McCarthy, AKThe pilot's loss of directional control during takeoff.Aug 12, 2013 · N3897Z · Substantial damageNTSB CEN13CA479Accident · Minor injuriesData collectionFinal reportKerr Matthew Starduster TOO · Frankenmuth, MIThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and subsequent impact with a corn field.Aug 10, 2013 · N159MK · Substantial damageNTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.Aug 10, 2013 · N7811W · Substantial damageNTSB CEN13LA486Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Dumas, ARThe pilot's failure to maintain directional control of the airplane during landing.Aug 9, 2013 · N36538 · Substantial damageNTSB CEN13LA482Accident · No injuriesLimited investigationFinal reportGlos Wallis Richard JR LONG-EZ · Schaumburg, ILThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.Aug 9, 2013 · N721EZ · Substantial damageNTSB WPR13LA364Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Burlington, WAThe pilot's inadequate control inputs during a crosswind landing, which resulted in a hard landing and loss of directional control.Aug 8, 2013 · N67045 · Substantial damageNTSB ANC13CA073Accident · No injuriesData collectionFinal reportCessna U206F · Kokhanok, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.Aug 5, 2013 · N5364Q · Substantial damageNTSB WPR13CA377Accident · No injuriesData collectionFinal reportAviat A-1B · West Jordan, UTThe pilot’s failure to maintain directional control during landing.Aug 4, 2013 · N211AM · Substantial damageNTSB ERA13CA351Accident · No injuriesData collectionFinal reportCessna 170B · Meridian, MSThe pilot’s failure to maintain directional control during the landing roll.Aug 4, 2013 · N4251 · Substantial damageNTSB CEN13CA485Accident · No injuriesData collectionFinal reportCessna 150D · Hermleigh, TXThe pilot's improper positional awareness, which resulted in an off airport landing and impact with terrain.Aug 4, 2013 · N4281U · Substantial damageNTSB WPR13CA356Accident · No injuriesData collectionFinal reportCessna 170B · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Aug 3, 2013 · N8249A · Substantial damageNTSB WPR13CA362Accident · No injuriesData collectionFinal reportBellanca 7GCBC · West Yellowstone, MTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with an approach slope indicator system component.Aug 1, 2013 · N926BW · Substantial damageNTSB CEN13CA457Accident · No injuriesData collectionFinal reportStearman A75 · Appleton, WIThe pilot’s inadequate compensation for the crosswind, which resulted in a loss of directional control.Aug 1, 2013 · N234X · Substantial damageNTSB WPR13LA351Accident · Minor injuriesLimited investigationFinal reportStribling RV4 · San Manuel, AZThe pilot’s loss of directional control during takeoff with a tailwind, which resulted in a runway excursion.Jul 31, 2013 · N70AC · Substantial damageNTSB CEN13CA453Accident · No injuriesData collectionFinal reportLuscombe 8A · Ellinwood, KSThe pilot failed to maintain directional control during takeoff.Jul 31, 2013 · N45957 · Substantial damageNTSB CEN13CA450Accident · No injuriesData collectionFinal reportCessna 172N · Mesquite, TXThe student pilot failed to maintain directional control during the touch-and-go landing and during the subsequent aborted takeoff during crosswind conditions.Jul 31, 2013 · N738RQ · Substantial damageNTSB CEN13LA451Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Lombardville, ILThe pilot's failure to maintain airplane control during takeoff.Jul 29, 2013 · N36612 · Substantial damageNTSB ERA13LA343Accident · No injuriesLimited investigationFinal reportCessna 175 · Willimantic, CTThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Jul 27, 2013 · N9388B · Substantial damageNTSB CEN13CA449Accident · No injuriesData collectionFinal reportDean David E Kitfox Classic 4 · Grinnell, IAThe pilot did not maintain control of the airplane while landing with a crosswind.Jul 27, 2013 · N84SD · Substantial damageNTSB WPR13CA352Accident · No injuriesData collectionFinal reportCessna 180J · Hungry Horse, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jul 26, 2013 · N9286C · Substantial damageNTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.Jul 26, 2013 · N5401C · Substantial damageNTSB WPR13CA341Accident · No injuriesData collectionFinal reportCessna A185F · Pocatello, IDThe pilot's failure to maintain directional control during landing with gusting wind and a quartering tailwind.Jul 25, 2013 · N31YH · Substantial damageNTSB WPR13CA339Accident · No injuriesData collectionFinal reportPiper PA-18 · Challis, IDThe pilot's failure to maintain directional control during the takeoff roll.Jul 25, 2013 · N4249Z · Substantial damageNTSB ANC13LA067Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe pilot’s loss of directional control of the airplane during a wheel landing.Jul 24, 2013 · N4814 · Substantial damage