Skip to content

NTSB investigations

6,629 cases where the first occurrence was “Loss of control - on ground/water”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
  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.

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB DEN03LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Richfield, UTthe pilot's failure to maintain aircraft control during landing roll resulting in a ground loop/swerve and subsequent nose over. A contributing factor was the gusty wind conditions.Mar 7, 2003 · N8205W · Substantial damage NTSB CHI03LA079Accident · No injuriesLimited investigationFinal reportCessna 172R · St. Paul, MNThe loss of directional control by the solo student pilot. A factor to the accident was the excessive speed during landing.Mar 5, 2003 · N35307 · Substantial damage NTSB LAX03LA105Accident · Serious injuriesLimited investigationFinal reportAero Commander 690A · Tracy, CAthe failure of the pilot to maintain directional control during the departure roll on a narrow runway. A factor in the accident was the pilot's limited experience in the airplane.Mar 3, 2003 · N132JH · Substantial damage NTSB NYC03LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Cincinnati, OHThe student pilot's failure to maintain directional control.Feb 26, 2003 · N733XP · Substantial damage NTSB IAD03LA034Accident · No injuriesLimited investigationFinal reportCessna 150J · Williamson, NYThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor was the snow-covered runway.Feb 25, 2003 · N51126 · Substantial damage NTSB LAX03LA094Accident · No injuriesLimited investigationFinal reportLuscombe T-8F · El Cajon, CAThe pilot's inadequate compensation for the crosswind conditions and loss of directional control during landing.Feb 24, 2003 · N1822B · Substantial damage NTSB FTW03LA101Accident · 1 fatalLimited investigationFinal reportBell 407 · High Island 443The pilot's failure to maintain directional control of the helicopter during the hot refueling operation which resulted in the main rotor blades striking the passenger. A contributing factor was the high wind conditions.Feb 22, 2003 · N740PH · Minor damage NTSB LAX03LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's inadequate compensation for the existing crosswind conditions and failure to maintain directional control during the touch-and-go takeoff. A factor was his improper use of (failure to reduce) the throttle and normal brakes during the…Feb 21, 2003 · N3550X · Substantial damage NTSB CHI03LA077Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Cahokia, ILThe pilot failed to maintain directional control of the airplane during landing. Factors associated with the accident were the snow covered runway, the crosswind, and the overload failure of the nose gear.Feb 16, 2003 · N30TF · Substantial damage NTSB CHI03LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Clare, MIThe student pilot failed to maintain directional control of the airplane during takeoff roll. A factor was the snow bank.Feb 14, 2003 · N693SA · Substantial damage NTSB ANC03LA028Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Sitka, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop, and the collapse of the right main landing gear.Feb 11, 2003 · N71X · Substantial damage NTSB FTW03LA095Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lockhart, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.Feb 9, 2003 · N25324 · Substantial damage NTSB SEA03LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · McMinnville, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds and soft terrain in the area where the aircraft departed the side of the runway.Feb 8, 2003 · N734KU · Substantial damage NTSB LAX03LA086Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Oceano, CAthe pilot's failure to maintain directional control of the airplane.Feb 8, 2003 · N7686B · Substantial damage NTSB SEA03LA032Accident · No injuriesLimited investigationFinal reportCessna 180 B · Klamath Falls, ORFailure to adequately compensate for wind conditions while landing.Feb 2, 2003 · N59180 · Substantial damage NTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.Feb 1, 2003 · N75392 · Substantial damage NTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.Jan 28, 2003 · N48769 · Substantial damage NTSB DEN03LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Elbert, COthe pilot's inability to maintain aircraft control resulting in the ground loop. Factors relating to the accident were the crosswinds and the wind gusts.Jan 25, 2003 · N9335K · Substantial damage NTSB ANC03LA024Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Kipnuk, AKThe captain's inadequate compensation for crosswind conditions, and his failure to maintain directional control during the landing roll on an icy runway, which resulted in an excursion from the runway and collision with a snow berm. Contributing factors in…Jan 21, 2003 · N206EH · Substantial damage NTSB LAX03LA071Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZfailure of the pilot to maintain directional control of the airplane during landing.Jan 18, 2003 · N2005U · Substantial damage NTSB IAD03LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Laconia, NHThe pilot's loss of directional control during landing, which resulted in an impact with a snowbank, and overstress fracture of the nose gear actuator and engine mount foot attachment. A factor in the accident was the icy runway conditions.Jan 18, 2003 · N9170X · Substantial damage NTSB LAX03LA083Accident · No injuriesLimited investigationFinal reportBeech 76 · Truckee, CAfailure of the CFI to ensure that the pilot under instruction adequately understood the engine out procedure during the preflight planning phase of the flight; failure of the pilot under instruction to obtain/maintain directional control; and the inadequate…Jan 17, 2003 · N5400M · Substantial damage NTSB LAX03LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Salinas, CAThe student pilot's inadequate compensation and his failure to maintain directional control. Contributing factors were wet and dirt terrain.Jan 16, 2003 · N25562 · Substantial damage NTSB ATL03LA035Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control during landing roll which resulted in a loss of control and collision with a ditch. A factor was separation of the spring clip from the landing gear steering system.Jan 11, 2003 · N415JB · Substantial damage NTSB ATL03LA034Accident · No injuriesLimited investigationFinal reportCessna 172S · Mt. Pleasant, SCThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a loss of control and collision with terrain.Jan 11, 2003 · N5199H · Substantial damage NTSB LAX03LA064Accident · Minor injuriesLimited investigationFinal reportWaco SRE · Prescott, AZThe pilot's failure to maintain directional control during landing resulting in a collision with a runway sign. Factors in the accident were the tailwind and the malfunctioning brake system.Jan 10, 2003 · N1252W · Substantial damage NTSB FTW03LA079Accident · No injuriesLimited investigationFinal reportCessna 172S · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.Jan 8, 2003 · N142ME · Substantial damage NTSB ATL03LA032Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Geneva, ALThe pilot's failure to achieve takeoff due to a mistrimmed elevator, and his failure to maintain directional control.Jan 8, 2003 · N3628X · Substantial damage NTSB FTW03LA078Accident · No injuriesLimited investigationFinal reportChampion 7FC · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.Jan 4, 2003 · N5271V · Substantial damage NTSB FTW03LA069Accident · Serious injuriesLimited investigationFinal reportWood Thorp T-18 · Stephenville, TXThe pilot's loss of directional control as result of his failure to compensate for the prevailing wind conditions. A contributing factor was the gusty crosswinds.Jan 1, 2003 · N335BW · Substantial damage NTSB NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.Dec 30, 2002 · N6780B · Substantial damage NTSB FTW03LA074Accident · No injuriesLimited investigationFinal reportCessna 170A · West Helena, ARThe pilot's failure to maintain directional control during landing. A contributing factor was the deflated tire.Dec 22, 2002 · N1392D · Substantial damage NTSB FTW03LA065Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Denver City, TXThe pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.Dec 21, 2002 · N9096Q · Substantial damage NTSB ANC03LA019Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Soldotna, AKThe flightcrew's selection of an unsuitable landing area, which resulted in a loss of directional control and an on ground encounter with terrain. A factor associated with the accident was a snow-covered, unplowed runway.Dec 19, 2002 · N55ZP · Substantial damage NTSB MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.Dec 16, 2002 · N9852J · Substantial damage NTSB NYC03IA030Incident · No injuriesIncident investigationFinal reportPiper PA-601P · Manassas, VAThe pilot' failure to maintain directional control during an aborted takeoff.Dec 13, 2002 · N141AJ · Minor damage NTSB CHI03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Greensburg, INFailure of the pilot to maintain directional control during the takeoff roll. Contributing factors included inadequate planning/decision by the pilot for attempting to depart from the slush covered runway, the slush covered runway itself, and the falling snow.Dec 13, 2002 · N793MA · Substantial damage NTSB MIA03CA026Accident · No injuriesData collectionFinal reportPiper PA38 · Pensacola, FLThe student pilot's attempt to turn off the runway at an excessive taxi speed resulting in a loss of directional control and collision with a taxiway sign.Dec 8, 2002 · N2585B · Substantial damage NTSB ATL03LA024Accident · No injuriesLimited investigationFinal reportCessna 172N · Cartersville, GAThe student pilot's failure to maintain directional control, during the landing roll resulted in the on ground collision with a ravine.Dec 6, 2002 · N5891E · Substantial damage NTSB LAX03LA042Accident · No injuriesLimited investigationFinal reportCessna 170B · Mobile, AZthe pilot's improper compensation for the crosswind conditions at touchdown and failure to maintain proper alignment of the tail wheel equipped airplane during landing, which resulted in a ground loop. The crosswind was a contributory factor.Nov 28, 2002 · N4465B · Substantial damage NTSB LAX03LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Hollister, CAthe pilot's failure to maintain directional control of the airplane.Nov 28, 2002 · N2423E · Substantial damage NTSB ATL03LA018Accident · No injuriesLimited investigationFinal reportHickman Murphy Rebel · Hilton Head, SCThe pilot's failure to maintain directional control during an aborted landing that resulted in the in-flight collision with a ditch.Nov 23, 2002 · N14UJ · Substantial damage NTSB FTW03LA039Accident · Serious injuriesLimited investigationFinal reportLarson Kitfox III · Little Rock, ARThe pilot's failure to maintain aircraft control during an intentional taxi resulting in the inadvertent lift-off of the airplane and subsequent inadvertent stall. Contributing factors were the pilot's lack of total experience in the make and model of…Nov 13, 2002 · N5278U · Destroyed NTSB LAX03LA030Accident · No injuriesLimited investigationFinal reportCessna 182T · Scottsdale, AZThe pilot's failure to apply adequate crosswind compensation, which resulted in a loss of directional control. Factors were the crosswind and the pilot's lack of experience in the make and model of airplane.Nov 11, 2002 · N794SA · Substantial damage NTSB LAX03LA028Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Bermuda Dunes, CAthe pilot's inadequate compensation for gusty crosswind conditions and his failure to maintain directional control.Nov 11, 2002 · N275HP · Substantial damage NTSB CHI03LA042Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Faulkton, SDThe directional control not maintained during an after landing taxi on the runway by the student pilot. The student pilot's lack of experience and downhill terrain off the runway were contributing factors.Nov 11, 2002 · N2557F · Substantial damage NTSB LAX03LA035Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Livermore, CAThe pilot's failure to maintain directional control during landing. A factor in the accident was the crosswind.Nov 10, 2002 · N88408 · Substantial damage NTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.Nov 10, 2002 · N707D · Substantial damage NTSB LAX03LA023Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, NVThe pilot's failure to maintain directional control during takeoff. A contributing factor was the ditch.Nov 5, 2002 · N13265 · Substantial damage NTSB DEN03LA013Accident · No injuriesLimited investigationFinal reportMooney M20E · Broomfield, COthe pilot's failure to maintain directional control after landing due to a sheared steering horn attach bolt that should have been replaced by maintenance personnel in compliance with an outstanding service bulletin. Contributing factors included the pilot's…Nov 4, 2002 · N9288M · Substantial damage