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 NYC08CA193Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was a crosswind.May 24, 2008 · N9245Q · Substantial damageNTSB NYC08CA191Accident · Minor injuriesData collectionFinal reportCessna 172M · Chuckey, TNThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was his failure to abort the takeoff.May 22, 2008 · N74WC · Substantial damageNTSB NYC08CA188Accident · No injuriesData collectionFinal reportPilatus PC-12 · Burnsville, NCThe pilot's failure to maintain directional control while landing. Contributing to the accident was the gusty wind conditions.May 22, 2008 · N522DJ · Substantial damageNTSB CHI08CA138Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg. LC41-550FG · Columbus, OHThe pilot not maintaining directional control during the landing. Contributing to the accident were the gusty crosswinds and the airport sign that was impacted.May 21, 2008 · N1387C · Substantial damageNTSB LAX08CA148Accident · No injuriesData collectionFinal reportCessna 150H · Augusta, GAThe pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.May 20, 2008 · N7050S · Substantial damageNTSB DFW08CA151Accident · No injuriesData collectionFinal reportCessna CE-172M · San Antonio, TXThe student pilots improper short field landing procedure and excessive rate of descent. A contributing factor was the student pilots improper recovery from a bounced landing.May 18, 2008 · N1281U · Substantial damageNTSB CHI08CA148Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Delphi, INThe pilot's inadequate compensation for the gusting crosswind during landing rollout. Contributing to the accident was the gusting crosswind condition.May 17, 2008 · N1601P · Substantial damageNTSB ANC08CA069Accident · No injuriesData collectionFinal reportCessna 421 · Caldwell, NJThe pilot's failure to maintain directional control while landing. Factors in the accident were a hydroplaning condition, and a wet runway.May 17, 2008 · N777FF · Substantial damageNTSB ANC08CA068Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for a crosswind during landing. Contributing to the accident was the crosswind and an inadvertent ground loop.May 17, 2008 · N1912A · Substantial damageNTSB DFW08CA145Accident · No injuriesData collectionFinal reportWeatherly 201B · Nickerson, KSThe pilot's failure to maintain directional control during the takeoff roll.May 15, 2008 · N1264W · DestroyedNTSB CHI08CA130Accident · No injuriesData collectionFinal reportCessna 150 · Pulaski, WIThe student pilot's failure to take remedial action in response to a porpoise/pilot-induced oscillation during landing. Factors were the porpoise, the pilot's lack of experience, and the separation of the nose landing gear.May 14, 2008 · N22997 · Substantial damageNTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.May 12, 2008 · N8511Y · Substantial damageNTSB SEA08CA131Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Lakeview, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Contributing to the accident was the crosswind was a factor.May 11, 2008 · N196DC · Substantial damageNTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.May 10, 2008 · N8103E · Substantial damageNTSB SEA08CA130Accident · No injuriesData collectionFinal reportBeech B19 · Burns, ORThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. The shifting wind was a factor.May 10, 2008 · N9342S · Substantial damageNTSB LAX08CA157Accident · No injuriesData collectionFinal reportPiper PA-34 · Blythe, CAThe pilot's failure to maintain directional control.May 10, 2008 · N103JH · Substantial damageNTSB ANC08CA064Accident · No injuriesData collectionFinal reportCessna 172 · Chugiak, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was an inadvertent ground loop/swerve.May 10, 2008 · N7598T · Substantial damageNTSB ANC08CA062Accident · No injuriesData collectionFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was an inadvertent ground-loop.May 5, 2008 · N125KT · Substantial damageNTSB CHI08CA120Accident · No injuriesData collectionFinal reportCessna 177 · Bellefontaine, OHThe pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was the fence.May 4, 2008 · N29650 · Substantial damageNTSB LAX08CA129Accident · No injuriesData collectionFinal reportCessna A185F · Mexican Hat, UTThe pilot's failure to maintain directional control.May 3, 2008 · N185KH · Substantial damageNTSB SEA08CA118Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Libby, MTThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during the landing rollout.May 2, 2008 · N1083 · Substantial damageNTSB ANC08LA059Accident · No injuriesLimited investigationFinal reportCessna 560XL · Port Heiden, AKThe flying pilot’s failure to maintain directional control while landing in a crosswind. A factor contributing to the accident was a crosswind.Apr 30, 2008 · N590AK · Substantial damageNTSB CHI08CA122Accident · No injuriesData collectionFinal reportEvektor Aerotechnik SportStar Plus · Greenwood, INThe student pilot's failure to maintain control of the airplane during engine run-up.Apr 29, 2008 · N930LA · Substantial damageNTSB DEN08CA086Accident · No injuriesData collectionFinal reportMooney M20E · Erie, COThe pilot failed to maintain directional control of the airplane during the touch and go landing.Apr 28, 2008 · N79833 · Substantial damageNTSB SEA08CA112Accident · No injuriesData collectionFinal reportCessna 185E · Bend, ORThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was an unexpected crosswind gust.Apr 26, 2008 · N185NH · Substantial damageNTSB ANC08LA058Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Tetlin, AKThe instructor pilot's inadequate supervision of the student, resulting in a loss of control while landing.Apr 26, 2008 · N10987 · Substantial damageNTSB LAX08CA096Accident · No injuriesData collectionFinal reportCessna T210N · Coaldale, NVThe pilot's failure to maintain directional control after encountering an unknown object on the dirt runway.Apr 25, 2008 · N6182N · Substantial damageNTSB DFW08CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Santa Teresa, NMThe pilot's failure to maintain aircraft control. Contributing to the accident was the strong gusty crosswinds.Apr 23, 2008 · N1588P · Substantial damageNTSB CHI08CA107Accident · No injuriesData collectionFinal reportCessna 182T · Zionsville, INThe pilot's failure to maintain directional control during the crosswind landing. Contributing to the accident were the gusting crosswind and the runway light.Apr 20, 2008 · N46EF · Substantial damageNTSB LAX08CA119Accident · No injuriesData collectionFinal reportCarlson Quickie Q2 · Casper, WYA loss of directional control on landing due to the separation of the wing leveler trim knob and resulting reduced aileron control.Apr 19, 2008 · N39425 · Substantial damageNTSB DFW08CA102Accident · No injuriesData collectionFinal reportNorth American T-6G · Dallas, TXThe pilot's failure to maintain directional control while landing.Apr 19, 2008 · N3518G · Substantial damageNTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.Apr 18, 2008 · N2710P · Substantial damageNTSB CHI08IA113Incident · No injuriesIncident investigationFinal reportCessna 172P · Kelley's Island, OHThe pilot's failure to maintain aircraft control during landing. Contributing to the accident were the pilot's selection of the wrong runway and a tailwind.Apr 18, 2008 · N162HD · Minor damageNTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.Apr 18, 2008 · N32394 · Substantial damageNTSB LAX08CA114Accident · No injuriesData collectionFinal reportMurphy Murphy Rebel · Grass Valley, CAThe pilot's failure to maintain directional control.Apr 17, 2008 · N3VK · Substantial damageNTSB DFW08CA098Accident · No injuriesData collectionFinal reportWeatherly 620B · Coleman, TXThe pilot's failure to maintain airplane control on the landing roll. A contributing factor was the variable wind.Apr 13, 2008 · N2035J · Substantial damageNTSB NYC08CA166Accident · No injuriesData collectionFinal reportWim J Huisman Velocity 173 Fixed · Ocala, FLThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the wind gusts.Apr 12, 2008 · N127DH · Substantial damageNTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.Apr 12, 2008 · N9277E · Substantial damageNTSB LAX08CA095Accident · No injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Carlsbad, CAThe pilot's inadequate crosswind compensation and failure to maintain directional control during landing rollout.Apr 9, 2008 · N4418 · Substantial damageNTSB CHI08CA099Accident · No injuriesData collectionFinal reportPowell Vans RV-6A · French Lick, INThe pilot's failure to compensate for the crosswind condition and maintain control of the airplane. A factor was the crosswind.Apr 7, 2008 · N551MP · Substantial damageNTSB NYC08CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Lincoln, METhe pilot-rated-passenger's failure to maintain directional control during takeoff.Apr 6, 2008 · N2209K · Substantial damageNTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.Apr 6, 2008 · N42892 · Substantial damageNTSB DEN08CA073Accident · No injuriesData collectionFinal reportCessna 170B · Fort Collins, COthe pilot's failure to maintain directional control during takeoff.Apr 6, 2008 · N2232D · Substantial damageNTSB SEA08CA103Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Alturas, CAThe pilot's inadequate compensation for the gusty crosswind conditions. The wind gusts were a contributing factor.Apr 4, 2008 · N2092E · Substantial damageNTSB MIA08LA086Accident · No injuriesLimited investigationFinal reportCessna 750 · New York, NYThe co-pilot's failure to maintain directional control during the landing roll. Contributing to the accident was a loss of system A hydraulic fluid for undetermined reasons and the flight crew's failure to follow the checklist sequence.Apr 4, 2008 · N750WM · Substantial damageNTSB SEA08CA102Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Three Forks, MTThe pilot's inadequate compensation for wind conditions during landing. A gusting crosswind was a contributing factor.Apr 3, 2008 · N1139C · Substantial damageNTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.Apr 3, 2008 · N1755T · Substantial damageNTSB ANC08LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ugashik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over. A factor contributing to the accident was water on the surface of the ice-covered lake.Apr 1, 2008 · N5840Z · Substantial damageNTSB SEA08CA097Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Phoenix, AZThe pilot's failure to maintain directional control of the airplane during landing.Mar 28, 2008 · N963WW · Substantial damageNTSB DEN08CA068Accident · No injuriesData collectionFinal reportPiper PA-28-150 · Mankato, KSthe student pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the fence and trees.Mar 28, 2008 · N50GM · Substantial damage