NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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 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 CHI04CA156Accident · No injuriesData collectionFinal reportYoukey Lancair 235 · Hays, KSThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the gusty crosswind, the runway marker sign, and the taxiway lights…NTSB CHI04CA150Accident · No injuriesData collectionFinal reportMaule MX7235 · Waukesha, WIThe pilot failed to maintain directional control and his inadequate compensation for wind conditions. Factors associated with the accident were the gusty crosswind and the concrete culvert that the airplane contacted.NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB ANC04LA064Accident · No injuriesLimited investigationFinal reportdeHavilland DHC-2 · Wasilla, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with a log. Factors contributing to the accident were a tailwind, a lack of brake pedals at the second pilot station, and the second…NTSB NYC04CA138Accident · No injuriesData collectionFinal reportCessna 152 · Elyria, OHThe student pilot's inadequate recovery from a bounced landing.NTSB DEN04LA084Accident · No injuriesLimited investigationFinal reportCessna 310J · Morgan, UTthe poor friction value on the runway rendering braking action inadequate. Contributing factors include the excessive approach speed, and the pilot's inability to maintain directional control of the aircraft.NTSB ANC04LA060Accident · No injuriesLimited investigationFinal reportCessna 180E · Kenai, AKThe pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control which resulted in an inadvertent ground loop and nose over. A factor contributing to the accident was a direct crosswind.NTSB LAX04CA222Accident · No injuriesData collectionFinal reportCessna A188A · Minden, NVthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground loop. A contributing factor was the pilot's lack of experience in the accident airplane.NTSB LAX04LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, CAthe pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop.NTSB LAX04CA224Accident · No injuriesData collectionFinal reportCessna 177B · Grand Canyon, AZthe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control.NTSB FTW04LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Levelland, TXThe student pilot's failure to maintain directional control and his inadequate compensation for the winds.NTSB MIA04CA091Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Carthage, MSThe failure of the student pilot to maintain control of the airplane resulting in the airplane departing the runway and impacting with terrain. A factor related to this accident was the student pilot's lack of total flight experience.NTSB ANC04LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and subsequent structural damage to the airplane when it struck the runway.NTSB FTW04CA139Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Beedeville, ARThe pilot's failure to maintain directional control of the airplane during landing roll-out. Contributing factors were the crosswind and condition of the the runway.NTSB LAX04CA231Accident · No injuriesData collectionFinal reportGlenn L Smith RV-8 · Boulder City, NVthe pilot's failure to maintain directional control of the airplane. Contributing to the accident was a sudden wind shift.NTSB LAX04CA221Accident · No injuriesData collectionFinal reportAmerican Blimp A-1-50 · North Las Vegas, NVthe ground crew's inability to maintain control of the airship and the pilot's inability to obtain a sufficient rate of climb. Contributing to the accident was unfavorable winds.NTSB LAX04CA217Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Livermore, CAthe pilot's failure to maintain directional control.NTSB ATL04CA120Accident · No injuriesData collectionFinal reportStinson SR-8E · Peachtree City, GAThe pilot's failure to maintain directional control on landing roll out resulting in a loss of control and ground loop.NTSB MIA04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Pembroke Pines, FLThe pilot's failure to establish a climb and his failure to maintain directional control of the airplane during an aborted landing leading to the airplane departing the runway and incurring substantial damage.NTSB SEA04LA087Accident · No injuriesLimited investigationFinal reportCessna 185A · Polson, MTThe pilot's inadequate compensation for the changing wind conditions at the time of the landing. Factors include gusty, variable, crosswinds, and a runway marker near the edge of the runway the pilot was landing on.NTSB LAX04CA209Accident · No injuriesData collectionFinal reportCessna 180 · Kingman, AZthe pilot under instruction's excessive and improper use of the rudder control during the landing roll and the flight instructor's inadequate supervision, which resulted in an inadvertent ground loop and nose over.NTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.NTSB MIA04LA081Accident · No injuriesLimited investigationFinal reportBeech A23A · Crystal River, FLThe pilots failure to maintain directional control during the landing rollout, which resulted in the airplane departing the runway and incurring damage.NTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.NTSB LAX04LA199Accident · No injuriesLimited investigationFinal reportCessna 195 · Riverside, CAthe pilot's failure to maintain directional control, resulting in a veer off the runway and collision with terrain.NTSB IAD04LA019Accident · Minor injuriesLimited investigationFinal reportKrotje VM-1 Esqual · Cambridge, OHThe pilot's failure to maintain directional control. A factor was the inadequate brake system installed on the airplane.NTSB SEA04LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · North Bend, WAThe pilot's failure to maintain aircraft control during the landing roll. A rough landing surface and tailwind gusts were factors.NTSB NYC04CA115Accident · No injuriesData collectionFinal reportMooney M20C · Front Royal, VAThe pilot's failure to maintain directional control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB LAX04LA195Accident · No injuriesLimited investigationFinal reportSpirangam Velocity · Boulder City, NVthe pilot's failure to maintain directional control of the airplane during the landing rollout.NTSB SEA04LA072Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe right seat pilot's failure to maintain directional control during the initial part of the landing roll, and his improper handling of the aircraft (excessive braking) as the aircraft departed the side of the runway. Factors include the pilot's lack of…NTSB DEN04CA066Accident · No injuriesData collectionFinal reportCessna 182K · Durango, COthe pilot's inadequate in-flight planning and decision making. Contributing factors include the crosswind and the crosswind component exceeded.NTSB LAX04LA192Accident · No injuriesLimited investigationFinal reportAeronca Champ 7AC · Hayward, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB ANC04LA041Accident · No injuriesLimited investigationFinal reportChampion 7GC · Wasilla, AKThe flight instructor's inadequate supervision of the student pilot which resulted in a loss of directional control during the takeoff roll, and subsequent collision with a ditch. A factor contributing to the accident was the student pilot's failure to…NTSB LAX04CA189Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Minden, NVthe pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control of the airplane, resulting in a collision with terrain.NTSB SEA04LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Everett, WAThe pilot's failure to maintain directional control of the aircraft as a result of a locked main gear brake during the landing roll. An inadvertent ground loop was a factor.NTSB MIA04LA087Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air 4000 · Port St. Lucie, FLThe pilot's failure to maintain directional control during landing, which resulted in an inadvertent swerve, the right main landing gear wheel separating, and the airplane impacting trees and incurring structural damage.NTSB MIA04LA072Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5B · Lakeland, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the airplane departing the right side of the runway, collapsing the left main landing gear, the left wing striking the ground, and the airplane…NTSB DEN04CA062Accident · No injuriesData collectionFinal reportCessna 180A · Las Vegas, NMthe pilot's decision to takeoff in wind conditions that consisted of a quarterly tailwind and a crosswind in excess of the maximum demonstrated crosswind component, and his failure to maintain directional control.NTSB LAX04CA185Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Grass Valley, CAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Factors in the accident were wind gusts and tailwind/crosswind conditions.NTSB LAX04CA183Accident · No injuriesData collectionFinal reportCessna 182C · Garberville, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane. Factors in the accident were the terrain induced turbulent conditions, wind shear, a sudden wind shift, and a tailwind.NTSB ANC04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe student pilot's loss of directional control during the landing roll, which resulted in the airplane entering deep snow alongside the runway, and nosing over.NTSB FTW04CA107Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Friona, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were prevailing crosswind, rain, and the restricted vision from water on the windscreen, and a vehicle parked near the runway.NTSB ANC04LA038Accident · No injuriesLimited investigationFinal reportGrumman G21 · Unalaska, AKThe inadvertent ground loop/swerve by the second pilot during the landing roll, and the first (check) pilot's inadequate supervision of the second pilot, which resulted in a loss of control and substantial damage to the airplane. Factors associated with the…NTSB FTW04LA102Accident · No injuriesLimited investigationFinal reportWaco RBA · Temple, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the locked wheel.NTSB CHI04LA097Accident · No injuriesLimited investigationFinal reportCessna 172R · Kalamazoo, MIThe air traffic control procedures/directives not followed by tower air traffic controller, the inadequate compensation for wind conditions by the student pilot during landing, the lack of total experience by the student pilot, and the recommended crosswind…NTSB SEA04LA061Accident · No injuriesLimited investigationFinal reportCessna 305A · Bozeman, MTThe pilot's failure to maintain directional control during the landing roll in the tail wheel-equipped aircraft, leading to an inadvertent ground-loop, during which the aircraft's wing impacted the ground.NTSB CHI04LA096Accident · No injuriesLimited investigationFinal reportSwearingen SA226-T · Omaha, NEThe pilot failed to maintain directional control during takeoff. Contributing factors to the accident were the runway light and the soft terrain.NTSB CHI04CA094Accident · No injuriesData collectionFinal reportCessna 180 · Long Lake, WIThe pilot flared improperly and failed to maintain directional control during landing.NTSB NYC04LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Factoryville, PAAn encounter with a deer, as reported by the pilot. A factor in this accident was the muddy grass off the left side of the runway.NTSB NYC04CA097Accident · No injuriesData collectionFinal reportCessna 182T · Perkasie, PAThe pilots' inadequate compensation for winds and his failure to maintain directional control during landing. A factor related to the accident was the gusting wind conditions.