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 WPR09CA443Accident · No injuriesData collectionFinal reportCessna 305A · Helena, MTThe pilot's improper landing flare and recovery from a bounced landing.Sep 11, 2009 · N119WW · Substantial damageNTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.Sep 11, 2009 · N2929N · Substantial damageNTSB ANC09CA097Accident · No injuriesData collectionFinal reportCessna 180J · Juneau, AKThe pilot's misjudged flare and loss of control during a glassy water landing.Sep 9, 2009 · N42250 · Substantial damageNTSB WPR09CA433Accident · No injuriesData collectionFinal reportSwalley Mark H CH 701 SP · Bremerton, WAThe pilot's inadequate compensation for the gusty wind conditions and failure to maintain aircraft control.Sep 7, 2009 · N701V · Substantial damageNTSB ANC09CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKA tailwheel malfunction that limited directional control, which resulted in a runway excursion, and collision with a building.Sep 7, 2009 · N54182 · Substantial damageNTSB WPR09CA435Accident · No injuriesData collectionFinal reportPiper PA-20 · Bozeman, MTThe failure of the pilot receiving instruction to maintain directional control during the takeoff roll and the flight instructor's delayed corrective action.Sep 5, 2009 · N1544A · Substantial damageNTSB CEN09CA581Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during landing.Sep 5, 2009 · N117EM · Substantial damageNTSB ANC09CA096Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot’s decision to land on unsuitable terrain, which resulted in a loss of control and a collision with trees.Sep 5, 2009 · N5773D · Substantial damageNTSB WPR09CA440Accident · No injuriesData collectionFinal reportUniversal Globe GC-1 · Pacoima, CAThe pilot's failure to maintain directional control during the landing roll.Sep 4, 2009 · N2345B · Substantial damageNTSB CEN09LA557Accident · No injuriesLimited investigationFinal reportCessna 150F · Rosedale, MIThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident were the pilot's deteriorated physical and mental capabilities.Sep 2, 2009 · N6446F · Substantial damageNTSB WPR09CA429Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR · San Diego, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.Aug 30, 2009 · N4418 · Substantial damageNTSB CEN09CA553Accident · No injuriesData collectionFinal reportWarner Lewis Steen · Broomfield, COThe pilot's inability to maintain directional control due to an internal mechanical failure of the left wheel that caused the wheel to seize.Aug 30, 2009 · N3278K · Substantial damageNTSB WPR09CA425Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Madras, ORThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control during landing rollout.Aug 28, 2009 · N95333 · Substantial damageNTSB CEN09CA547Accident · No injuriesData collectionFinal reportCessna 182P · Sugar Land, TXThe pilot's failure to control the airplane during engine startup, and his failure to maintain clearance from other objects.Aug 24, 2009 · N1988M · Substantial damageNTSB ERA09CA475Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Tuskegee, ALThe pilot’s failure to maintain directional control during the aborted landing.Aug 23, 2009 · N1415A · Substantial damageNTSB CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.Aug 23, 2009 · N352JB · Substantial damageNTSB WPR09CA410Accident · No injuriesData collectionFinal reportPiper PA28 · Glendale, AZThe student pilot's failure to maintain directional control during the landing roll.Aug 21, 2009 · N424PA · Substantial damageNTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.Aug 19, 2009 · N4177L · Substantial damageNTSB WPR09CA404Accident · No injuriesData collectionFinal reportJabiru J230-SP · Reno, NVThe pilot’s failure to maintain directional control throughout the takeoff roll.Aug 18, 2009 · N690J · Substantial damageNTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.Aug 18, 2009 · N7556H · Substantial damageNTSB ERA09CA465Accident · No injuriesData collectionFinal reportAeronca 7AC · Finleyville, PAThe pilot’s failure to maintain directional control during landing.Aug 17, 2009 · N83661 · Substantial damageNTSB CEN09CA530Accident · No injuriesData collectionFinal reportCessna 172 · Centennial, COThe pilot's failure to maintain directional control of the airplane during the landing flare in crosswind conditions.Aug 16, 2009 · N22265 · Substantial damageNTSB WPR09CA399Accident · No injuriesData collectionFinal reportAeronca 11CC · El Cajon, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.Aug 15, 2009 · N4385E · Substantial damageNTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.Aug 15, 2009 · N4380H · Substantial damageNTSB ANC09CA082Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kaktovik, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.Aug 14, 2009 · N83278 · Substantial damageNTSB WPR09CA405Accident · No injuriesData collectionFinal reportAeronca 7DC-CONV · Winnemucca, NVThe pilot's failure to maintain directional control during landing.Aug 13, 2009 · N83024 · Substantial damageNTSB ANC09CA081Accident · No injuriesData collectionFinal reportCessna 150H · Talkeetna, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.Aug 12, 2009 · N6687S · Substantial damageNTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.Aug 11, 2009 · N939RG · Substantial damageNTSB ERA09LA458Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Sanford, FLThe pilot’s failure to maintain directional control during takeoff.Aug 11, 2009 · N9261S · Substantial damageNTSB ERA09CA461Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Rockingham, NCThe pilot's failure to maintain directional control on landing roll out.Aug 11, 2009 · N817PA · Substantial damageNTSB CEN09CA507Accident · Serious injuriesData collectionFinal reportBoeing A75L300 · Salina, KSThe pilot's failure to maintain directional control during a touch-and-go.Aug 10, 2009 · N75263 · Substantial damageNTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.Aug 9, 2009 · N32105 · Substantial damageNTSB WPR09CA394Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Sisters, ORThe pilot's failure to maintain directional control during the landing roll.Aug 9, 2009 · N7670H · Substantial damageNTSB ERA09CA449Accident · No injuriesData collectionFinal reportCessna 182 · Milford, PAThe pilot's failure to maintain control during takeoff.Aug 7, 2009 · N9432X · Substantial damageNTSB CEN09CA508Accident · No injuriesData collectionFinal reportCessna 170A · Aurora, ILThe pilot's failure to maintain directional control during the landing.Aug 6, 2009 · N9793A · Substantial damageNTSB ERA09CA443Accident · No injuriesData collectionFinal reportCessna 172S · Alabaster, ALThe student pilot's failure to maintain directional control during landing.Aug 4, 2009 · N2110Q · Substantial damageNTSB CEN09CA489Accident · Minor injuriesData collectionFinal reportCessna 182P · Gateway, COThe pilot's inability to maintain directional control due to soft runway conditions.Aug 2, 2009 · N61TM · Substantial damageNTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.Aug 1, 2009 · N8602C · Substantial damageNTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.Jul 30, 2009 · N733BS · Substantial damageNTSB ERA09CA428Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Dundee, MSThe pilot's failure to maintain aircraft control during takeoff.Jul 29, 2009 · N502AJ · Substantial damageNTSB CEN09CA500Accident · No injuriesData collectionFinal reportCessna P210N · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing.Jul 29, 2009 · N4648A · Substantial damageNTSB ANC09CA075Accident · No injuriesData collectionFinal reportCessna 180 · Buckland, AKThe improper installation of the right brake cylinder, which allowed a portion of the cylinder to disengage and jam the right rudder/brake pedal, resulting in a loss of directional control during landing. Contributing to the accident was an inadequate…Jul 29, 2009 · N540RT · Substantial damageNTSB WPR09LA457Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ely, NVThe pilot's failure to maintain directional control during the landing roll.Jul 28, 2009 · N555Q · Substantial damageNTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.Jul 27, 2009 · N2980X · Substantial damageNTSB ERA09CA424Accident · No injuriesData collectionFinal reportWhite New Standard · Rhinebeck, NYThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was a depression near the edge of the turf runway that the airplane encountered during the takeoff roll.Jul 26, 2009 · N19157 · Substantial damageNTSB WPR09CA365Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Hemet, CAThe student pilot’s failure to maintain directional control during the landing roll and excessive use of the brakes.Jul 25, 2009 · N918ZZ · Substantial damageNTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.Jul 25, 2009 · N20930 · Substantial damageNTSB WPR09CA367Accident · No injuriesData collectionFinal reportXtremeair XP-30/2002339 · Santa Ynez, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.Jul 24, 2009 · N143WP · Substantial damageNTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.Jul 23, 2009 · N595Z · Substantial damageNTSB CEN09CA464Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Fort Collins, COThe pilot's failure to maintain directional control while landing in gusty, crosswind conditions.Jul 21, 2009 · N8778D · Substantial damage