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 ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.Aug 2, 2008 · N2357U · Substantial damageNTSB ANC08LA093Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control during an aborted landing.Jul 29, 2008 · N9952M · Substantial damageNTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.Jul 28, 2008 · N704JD · Substantial damageNTSB ANC08CA090Accident · No injuriesData collectionFinal reportCessna 180G · Anchorage, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was an inadvertent ground-loop.Jul 28, 2008 · N4631U · Substantial damageNTSB SEA08CA169Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Helena, MTThe failure of the pilot receiving instruction to adequately compensate for the crosswind condition and failure to maintain directional control. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.Jul 27, 2008 · N50476 · Substantial damageNTSB CHI08CA221Accident · Minor injuriesData collectionFinal reportCessna 150G · Grand Rapids, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the crosswind and wind gusts.Jul 25, 2008 · N8668J · Substantial damageNTSB CHI08CA207Accident · Minor injuriesData collectionFinal reportTuth RV-3 · Oshkosh, WIThe compensation for wind conditions disregarded by the pilot and the inadequate in-flight planning/decision making by the plot during approach to the destination airport. A contributing factor was the quartering tailwind.Jul 24, 2008 · N3149U · Substantial damageNTSB SEA08CA166Accident · No injuriesData collectionFinal reportCessna 180 · Lewistown, MTThe pilot's inadequate compensation for the variable and gusting winds, and his failure to maintain directional control. Contributing to the accident were variable winds that were gusting to 25 knots.Jul 20, 2008 · N1710C · Substantial damageNTSB LAX08CA232Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ogden, UTThe pilot's failure to maintain directional control of the airplane during landing.Jul 19, 2008 · N5716D · Substantial damageNTSB CHI08CA198Accident · No injuriesData collectionFinal reportRockwell S2R · Carthage, ILThe pilot failed to maintain directional control during the takeoff roll. Contributing to the accident were the uneven runway, the runway edge, and the cornfield.Jul 18, 2008 · N8466V · Substantial damageNTSB CHI08LA195Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Frankfort, KYThe student pilot's improper landing flare and the flight instructor's delayed remedial action.Jul 16, 2008 · N603EV · Substantial damageNTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.Jul 12, 2008 · N1066M · Substantial damageNTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.Jul 12, 2008 · N97484 · Substantial damageNTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.Jul 9, 2008 · N4450E · Substantial damageNTSB LAX08CA222Accident · No injuriesData collectionFinal reportCessna 172R · Byron, CAThe pilot's failure to maintain directional control during the landing rollout.Jul 9, 2008 · N354ES · Substantial damageNTSB LAX08CA243Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Canyon City, ORThe pilot's failure to maintain directional control. Contributing to the accident was the gusting tailwind.Jul 7, 2008 · N2851Z · Substantial damageNTSB CHI08CA181Accident · No injuriesData collectionFinal reportBeech C23 · Schaumburg, ILThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Contributing to the accident were the gusting crosswind, and the embankment.Jul 6, 2008 · N6715X · Substantial damageNTSB CHI08CA187Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lake In The Hil, ILThe directional control not maintained/obtained by the pilot during landing.Jul 5, 2008 · N30451 · Substantial damageNTSB DFW08CA181Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Peyton, COLanding gear collapse during the landing roll for undetermined reasons.Jul 4, 2008 · N1264C · Substantial damageNTSB LAX08CA208Accident · No injuriesData collectionFinal reportPipistrel Virus 912 · Bend, ORThe pilot's improper flare, inadequate bounced landing recovery, and his failure to maintain directional control.Jul 1, 2008 · N126BF · Substantial damageNTSB NYC08CA233Accident · No injuriesData collectionFinal reportCessna T182T · Lincoln Park, NJThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the wet runway and hydroplaning conditions.Jun 29, 2008 · N357TG · Substantial damageNTSB LAX08CA218Accident · No injuriesData collectionFinal reportCessna 180G · Heber, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was the crosswind weather conditions.Jun 29, 2008 · N98FC · Substantial damageNTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.Jun 29, 2008 · N83056 · Substantial damageNTSB LAX08CA207Accident · No injuriesData collectionFinal reportCessna T206H · Fullerton, CAThe pilot's failure to maintain control of the airplane during the landing touchdown, resulting in the wings contacting the runway surface and a propeller strike.Jun 28, 2008 · N1296M · Substantial damageNTSB DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.Jun 28, 2008 · N2879T · Substantial damageNTSB LAX08LA197Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Driggs, IDThe pilot's failure to maintain directional control during landing. Contributing to the accident was wind gusts.Jun 26, 2008 · N19BB · Substantial damageNTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.Jun 25, 2008 · N3504X · Substantial damageNTSB LAX08CA192Accident · No injuriesData collectionFinal reportCessna 172M · San Diego, CAThe student pilot's failure to maintain directional control during a touch-and-go landing.Jun 24, 2008 · N9629V · Substantial damageNTSB DEN08LA112Accident · No injuriesLimited investigationFinal reportCessna 195 · Houston, TXThe pilot's failure to maintain directional control, causing the design stress limits of the airplane to be exceeded. Excessive sideloads incurred caused the right main landing gear wheel and strut to fail.Jun 23, 2008 · N4426C · Substantial damageNTSB LAX08CA194Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Angwin, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.Jun 21, 2008 · N1993F · Substantial damageNTSB NYC08CA229Accident · No injuriesData collectionFinal reportPiper PA-18-105 · Fayetteville, NCThe pilot's failure to maintain directional control during the landing roll out.Jun 20, 2008 · N221T · Substantial damageNTSB ANC08LA082Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Chugiak, AKThe flight instructor's lack of remedial action to maintain directional control of the airplane during the landing roll, which resulted in a collision with a berm. Contributing to the accident was the pilot's failure to maintain aircraft control, and his lack…Jun 20, 2008 · N1163E · Substantial damageNTSB SEA08CA153Accident · No injuriesData collectionFinal reportHammond MH1 · McCall, IDThe pilot's failure to maintain directional control during the landing roll, resulting in a inadvertent ground loop. Contributing to the accident were variable winds that resulted in a landing tailwind, and rough terrain.Jun 19, 2008 · N234MH · Substantial damageNTSB NYC08CA220Accident · No injuriesData collectionFinal reportCessna 172P · Lancaster, PAThe student pilot's failure to maintain directional control during the landing rollout.Jun 19, 2008 · N52632 · Substantial damageNTSB CHI08CA167Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Wadena, MNThe pilot's failure to maintain control of the tail wheel airplane during the landing roll. A factor associated with the accident was the pilot's lack of recent experience in tail wheel airplanes.Jun 17, 2008 · N697DM · Substantial damageNTSB LAX08CA180Accident · No injuriesData collectionFinal reportCessna 207 · Page, AZThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the crosswind weather conditions and the high density altitude conditions.Jun 10, 2008 · N9100D · Substantial damageNTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.Jun 9, 2008 · N9328H · Substantial damageNTSB CHI08CA159Accident · No injuriesData collectionFinal reportCessna 172P · Athens, OHThe student pilot's failure to maintain directional control during landing. A factor contributing to the accident was a nose wheel vibration.Jun 9, 2008 · N230U · Substantial damageNTSB MIA08CA112Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Roseboro, NCThe pilot's failure to maintain directional control of the airplane during takeoff roll.Jun 5, 2008 · N300PB · Substantial damageNTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.Jun 2, 2008 · N8279C · Substantial damageNTSB DFW08CA159Accident · No injuriesData collectionFinal reportBeech E-18 · Guymon, OKThe pilot's failure to maintain directional control during landing roll out. Contributing to the accident was the crosswind.Jun 1, 2008 · N241X · Substantial damageNTSB SEA08CA148Accident · No injuriesData collectionFinal reportAviat A-1B · Ogden, UTThe pilot's failure to maintain directional control during landing. A contributing factor was the variable wind condition.May 31, 2008 · N172HY · Substantial damageNTSB DEN08CA099Accident · No injuriesData collectionFinal reportPiper Seneca · Plaquemine, LAThe certified flight instructor's poor decision to simulate a loss of engine on takeoff with a wet runway and the pilot's failure to maintain directional control. Contributing to the accident was the dew covered runway surface and the ditch.May 31, 2008 · N864CA · Substantial damageNTSB NYC08CA203Accident · No injuriesData collectionFinal reportCessna 180 · Kutztown, PAThe pilot's failure to maintain aircraft control.May 29, 2008 · N511MH · Substantial damageNTSB CHI08CA142Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's failure to maintained directional control during the aborted landing. Contributing to the accident was the student pilot's total lack of experience in the type of airplane.May 29, 2008 · N220ND · Substantial damageNTSB LAX08CA158Accident · No injuriesData collectionFinal reportCessna T182T · Vandenberg, FLThe pilot's unstabilized approach and failure to maintain directional control during landing, which resulted in a veer off the runway.May 28, 2008 · N2252Z · Substantial damageNTSB ANC08CA070Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was a gust of wind.May 28, 2008 · N57787 · Substantial damageNTSB CHI08CA149Accident · Serious injuriesData collectionFinal reportMischanko Buckeye Breeze · Walkerton, INThe directional control of the parachute not obtained/maintained by the pilot during the takeoff roll. A contributing factor was separation of the nose landing gear.May 27, 2008 · N623EM · Minor damageNTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.May 25, 2008 · N312DC · Substantial damageNTSB DFW08CA156Accident · No injuriesData collectionFinal reportAyres S-2R · McDonald, KSThe pilot's failure to maintain aircraft control during the takeoff. Contributing to the accident was the soft terrain.May 25, 2008 · N4002R · Substantial damage