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 WPR09CA266Accident · No injuriesData collectionFinal reportCessna 172S · Flagstaff, AZThe student pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control during landing.May 17, 2009 · N541ER · Substantial damageNTSB WPR09CA265Accident · No injuriesData collectionFinal reportBoeing E75 · Cottonwood, AZThe pilot's inadequate compensation for the crosswinds during the landing roll.May 17, 2009 · N4787V · Substantial damageNTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.May 17, 2009 · N8042D · Substantial damageNTSB ERA09LA295Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout, which resulted in excessive side loads to the right main landing gear and the separation of the outer main landing gear rib from the right wing.May 16, 2009 · N323JT · Substantial damageNTSB ANC09CA046Accident · Minor injuriesData collectionFinal reportWinship Kent S Dogger Craft · Palmer, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a nose over and substantial damage to the airplane.May 16, 2009 · N530KW · Substantial damageNTSB ANC09CA043Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane.May 15, 2009 · N1999P · Substantial damageNTSB CEN09CA298Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Midland, TXThe student pilot's failure to maintain directional control during takeoff.May 14, 2009 · N225BC · Substantial damageNTSB CEN09CA293Accident · No injuriesData collectionFinal reportCessna 170B · Roswell, NMThe pilot's failure to maintain directional control while landing.May 13, 2009 · N3210A · Substantial damageNTSB WPR09CA240Accident · No injuriesData collectionFinal reportFagan BearHawk · Hadley, NVThe pilot's inadequate compensation for the gusting crosswinds during takeoff.May 12, 2009 · N232PF · Substantial damageNTSB CEN09LA291Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe · Brighton, MIThe pilot's failure to attain the proper touchdown point, and his failure to initiate a go-around.May 12, 2009 · N99811 · Substantial damageNTSB CEN09CA292Accident · No injuriesData collectionFinal reportCessna 172N · Springdale, ARThe student pilot's failure to maintain control of the airplane during the landing roll and subsequent go-around.May 12, 2009 · N73842 · Substantial damageNTSB ANC09CA039Accident · No injuriesData collectionFinal reportCessna 170B · Kenai, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop. A factor contributing to the accident was the pilot's diverted attention during the landing.May 12, 2009 · N3469C · Substantial damageNTSB WPR09LA242Accident · No injuriesLimited investigationFinal reportCessna 182M · Madera, CAThe pilot’s failure to maintain directional control of the airplane throughout the landing.May 9, 2009 · N71165 · Substantial damageNTSB WPR09CA280Accident · No injuriesData collectionFinal reportAeronca 7AC · El Cajon, CAThe pilot's failure to maintain directional control while landing with gusting crosswinds.May 9, 2009 · N3370E · Substantial damageNTSB WPR09CA233Accident · No injuriesData collectionFinal reportCessna 172R · Coeur d'Alene, IDThe student pilot's inadequate compensation for the crosswinds while landing.May 9, 2009 · N2383Q · Substantial damageNTSB CEN09CA282Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Seminole, OKThe pilot's failure to maintain directional control during takeoff.May 6, 2009 · N7271J · Substantial damageNTSB ERA09CA275Accident · No injuriesData collectionFinal reportPiper PA-12 · Georgetown, SCThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot’s lack of experience in the make and model airplane.Apr 29, 2009 · N3036M · Substantial damageNTSB ANC09LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe non-certificated pilot’s decision to attempt to "ski" atop a water-covered tidal area in an airplane equipped with over-sized main landing gear tires, resulting in a loss of control and a nose over.Apr 26, 2009 · N3256B · Substantial damageNTSB ERA09CA268Accident · No injuriesData collectionFinal reportDiamond DA20 · Townsend, GAThe pilot's failure to maintain directional control during a landing roll with a crosswind. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Apr 25, 2009 · N561CS · Substantial damageNTSB WPR09CA229Accident · No injuriesData collectionFinal reportSiai-Marchetti SM 1019 · Novato, CAThe pilot's inadequate compensation for the gusting crosswinds. Contributing to the accident was the flight instructor's failure to take timely remedial action.Apr 24, 2009 · N391RV · Substantial damageNTSB WPR09CA210Accident · No injuriesData collectionFinal reportCessna 172E · Tucson, AZThe pilot’s inadequate compensation for the gusting crosswinds.Apr 22, 2009 · N3880S · Substantial damageNTSB CEN09CA261Accident · No injuriesData collectionFinal reportAmerican Legend AL-3C · McKinney, TXTHe pilot's failure to maintain control of the airplane during landing. Contributing to the accident were gusty crosswinds.Apr 20, 2009 · N273MS · Substantial damageNTSB CEN09CA259Accident · No injuriesData collectionFinal reportZenith CH-250 · Hollister, MOThe pilot's failure to maintain directional control during landing.Apr 20, 2009 · N931CE · Substantial damageNTSB ERA09CA251Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Southbridge, MAThe pilot's inadequate compensation for the gusting wind conditions.Apr 18, 2009 · N96552 · Substantial damageNTSB WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.Apr 17, 2009 · N375CB · Substantial damageNTSB WPR09LA204Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Los Angeles, CAThe pilot's inadequate compensation for the crosswinds and failure to maintain directional control during the landing roll.Apr 16, 2009 · N9219E · Substantial damageNTSB ERA09CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Bessemer, ALThe pilot's failure to maintain aircraft control while landing with a crosswind.Apr 14, 2009 · N269WB · Substantial damageNTSB CEN09CA249Accident · No injuriesData collectionFinal reportPiper J3C · Montrose, COThe pilot's failure to maintain directional control during the takeoff roll.Apr 13, 2009 · N41427 · Substantial damageNTSB ERA09CA246Accident · No injuriesData collectionFinal reportPiper PA20 · Scranton, PAThe pilot’s inadequate compensation for wind conditions during landing. Contributing to the accident was the distraction of smoke in the cockpit.Apr 9, 2009 · N7653K · Substantial damageNTSB CEN09CA246Accident · No injuriesData collectionFinal reportCessna 195 · Burnet, TXThe pilot's inadequate compensation for the gusting crosswinds during landing.Apr 9, 2009 · N4495C · Substantial damageNTSB WPR09LA221Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Bullhead City, AZThe pilot's inadequate compensation for the gusting crosswinds and his failure to maintain directional control during landing.Apr 8, 2009 · N3224Q · Substantial damageNTSB WPR09CA180Accident · No injuriesData collectionFinal reportBeech A36 · Sonoma, CAThe pilot's failure to maintain directional control.Apr 5, 2009 · N100VH · Substantial damageNTSB CEN09CA237Accident · No injuriesData collectionFinal reportPiper PA-22-160 · North Little Rock, ARThe pilot's inadequate compensation for the wind conditions during takeoff.Apr 5, 2009 · N9600D · Substantial damageNTSB ERA09CA227Accident · No injuriesData collectionFinal reportPiper PA-31-325 · Newark, NJThe pilot's decision to continue to operate the airplane with inoperative brakes on the airplane's right side.Apr 2, 2009 · N707AG · Substantial damageNTSB WPR09CA174Accident · No injuriesData collectionFinal reportAviat A-1B · Beaver, UTThe pilot's inadequate compensation for the wind gusts.Mar 28, 2009 · N665AM · Substantial damageNTSB CEN09CA235Accident · No injuriesData collectionFinal reportCessna 210 · Angel Fire, NMThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot's decision to take off on an icy runway with high crosswinds.Mar 23, 2009 · N59287 · Substantial damageNTSB WPR09CA162Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jackson, WYThe pilot's failure to maintain directional control during the landing roll.Mar 21, 2009 · N3920Z · Substantial damageNTSB ERA09CA213Accident · No injuriesData collectionFinal reportPiper PA32 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing roll.Mar 20, 2009 · N81912 · Substantial damageNTSB WPR09CA157Accident · No injuriesData collectionFinal reportPiper PA-24-250 · San Luis Obispo, CAThe pilot's inadequate compensation for the crosswinds during touchdown.Mar 17, 2009 · N8215P · Substantial damageNTSB CEN09CA215Accident · Minor injuriesData collectionFinal reportMcCurdy Pro Star PT-2 · Springfield, ILThe pilot's failure to maintain directional control during the landing roll.Mar 16, 2009 · N2102 · Substantial damageNTSB CEN09CA219Accident · No injuriesData collectionFinal reportAeronca 7AC-CONV · Stanley, NDThe pilot's failure to maintain directional control during landing.Mar 15, 2009 · N82041 · Substantial damageNTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.Mar 14, 2009 · N5098L · Substantial damageNTSB ERA09CA196Accident · No injuriesData collectionFinal reportPiper PA-28 · Darlington, SCThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the dark night and the pilot's lack of experience.Mar 12, 2009 · N82891 · Substantial damageNTSB WPR09CA143Accident · No injuriesData collectionFinal reportBellanca 17-31ATC · Bakersfield, CAThe pilot's failure to maintain directional control while landing.Mar 6, 2009 · N4134B · Substantial damageNTSB ERA09CA192Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Morristown, NJThe student pilot's failure to maintain directional control during the takeoff roll.Mar 5, 2009 · N176MA · Substantial damageNTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.Mar 2, 2009 · N2262D · Substantial damageNTSB ANC09CA024Accident · No injuriesData collectionFinal reportCessna 170B · Homer, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane. Factors contributing to the accident were a tailwind, and the pilot's decision to land downwind.Feb 27, 2009 · N2332D · Substantial damageNTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.Feb 26, 2009 · N737KR · Substantial damageNTSB CEN09CA179Accident · No injuriesData collectionFinal reportAviat A-1C · Denver, COThe pilot's failure to maintain control during taxi. A contributing factor was the gusty winds.Feb 25, 2009 · N75WY · Substantial damageNTSB WPR09CA127Accident · No injuriesData collectionFinal reportCub Crafters PA-18-150 · Buckeye, AZThe pilot's failure to maintain directional control.Feb 23, 2009 · N324A · Substantial damage