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 MIA00LA212Accident · No injuriesLimited investigationFinal reportCessna 560 XL · Nashville, TNthe flight crew's failure to activate the normal brake system, and failure to follow published aircraft procedures/directives for a hard brake or no braking condition and use the emergency brake system after recognizing a normal brake system failure, which…NTSB DEN00LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spanish Fork, UTThe pilot in command's failure to maintain aircraft directional control.NTSB CHI00LA190Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Cloud, MNdirectional control not being maintained by the pilot during landing rollout.NTSB NYC00LA192Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Westminster, MDthe delayed corrective action by the flight instructor. Factors were the failure of the private pilot to maintain directional control, his failure to use the brakes, and the lack of brakes on the right side for the flight instructor.NTSB LAX00LA256Accident · No injuriesLimited investigationFinal reportCessna 172 · Chandler, AZfailure of the pilot-in-command to adequately compensate for a crosswind condition and maintain directional control during the landing roll, resulting in the airplane departing the runway and colliding with a sign.NTSB LAX00LA255Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Minden, NVfailure of the pilot to compensate for a sudden wind shift resulting in a loss of directional control and collision with high vegetation.NTSB IAD00LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fitchburg, MApilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB LAX00LA254Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6F · Grass Valley, CAfailure of the pilot to maintain directional control during the landing roll resulting in a collision with terrain.NTSB MIA00LA216Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control of the airplane during landing flare into a crosswind, resulting in a runway excursion off the runway edge and collision of the wingtip with the terrain.NTSB LAX00LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Oakland, CAfailure of the instructor to adequately supervise the student, resulting in a loss of directional control.NTSB LAX00LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZThe student pilot's failure to maintain directional control of the airplane during landing.NTSB DEN00LA123Accident · No injuriesLimited investigationFinal reportBeech G18S · Taos, NMFailure of the pilot receiving instruction to maintain directional control. Factors were a gusty crosswind, inadequate supervision by the flight instructor, and the runway light.NTSB CHI00LA182Accident · No injuriesLimited investigationFinal reportCessna 172R · Athens, MIthe failure of the student pilot to maintain control of the aircraft, the inadequate supervision by the flight instructor, and the delayed remedial action performed by the flight instructor. A factor to the accident was the runway edge light that was struck…NTSB NYC00LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · West Point, VAThe student pilot's failure to maintain directional control during the landing roll.NTSB LAX00LA249Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Pacoima, CAthe pilot's failure to recover from a bounced landing.NTSB IAD00LA056Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Ravenna, OHthe student pilot's loss of helicopter control after suffering a stroke in flight.NTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.NTSB NYC00LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Robbinsville, NJThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control. A factor was a crosswind.NTSB FTW00LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mckinney, TXThe flight instructor's inadequate supervision of the landing resulting in the loss of directional control by the student pilot.NTSB ANC00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe failure of the pilot to maintain directional control of the airplane during takeoff.NTSB ANC00LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident is the pilot's excessive use of the brakes.NTSB NYC00LA173Accident · No injuriesLimited investigationFinal reportFleet 16B · Rochester, NHThe pilot's failure to maintain directional control. A factor in the accident was the pilot's lack of experience in the accident airplane make and model.NTSB NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.NTSB NYC00LA168Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Turner, METhe pilot's failure to maintain directional control after landing. A factor in this accident was the high grass along the runway edge which disguised an embankment.NTSB NYC00LA166Accident · No injuriesLimited investigationFinal reportCessna 182 · Freedom, PAThe pilot's failure to maintain aircraft control. Factors were the soft runway, and that the pilot exceeded the aircraft's weight and balance.NTSB LAX00LA228Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Hayfork, CAThe failure of the pilot under instruction to maintain directional control during the landing roll and the inadequate supervision of the flight instructor, which resulted in a collision with a runway light, overload failure of the wheel axle, and the airplane…NTSB DEN00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Loveland, COThe failure of the pilot to maintain directional control during takeoff roll. A factor was lack of recent experience.NTSB LAX00LA227Accident · Minor injuriesLimited investigationFinal reportCurtis-Wright Travel AIR 4000 · Reno, NVThe pilot's improper bounced landing recovery technique and failure to maintain directional control in a quartering tailwind condition.NTSB DEN00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dutch John, UTThe pilot's failure to compensate for wind conditions and control the aircraft while landing in gusting wind conditions.NTSB ANC00LA069Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Levelock, AKThe pilot's failure to maintain directional control during the takeoff run. A factor associated with the accident was the pilot's diverted attention while retracting the water rudders.NTSB FTW00LA180Accident · No injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop.NTSB NYC00LA163Accident · No injuriesLimited investigationFinal reportPratt Falcon XP · Montgomery, NYThe pilot's failure to maintain control of the airplane while taxiing. Factors related to the accident were the gusting wind conditions and the pilot's improper weather evaluation.NTSB ANC00LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were a crosswind, and an inadvertent ground loop/swerve.NTSB CHI00LA158Accident · No injuriesLimited investigationFinal reportTruthan Searey · Grand Rapids, MIthe pilot's failure to maintain aircraft control when the airplane encountered high winds. Factors which related to this accident were the high crosswind, the wind gusts, and the submerged object.NTSB SEA00LA101Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bridgeport, WAAircraft control was not maintained. Inadequate remedial action and diverted attention were factors.NTSB FTW00LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mesquite, TXThe pilot's improper compensation for the existing crosswind condition. A factor was the crosswind.NTSB FTW00LA174Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop.NTSB NYC00LA151Accident · No injuriesLimited investigationFinal reportMeadows Pitts Special S-1 · Meriden, CTThe pilot's loss of control of the airplane during the landing roll, due to his locking of the brakes.NTSB LAX00LA214Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Upland, CAThe failure of the pilot-in-command to maintain directional control of the aircraft on takeoff after the cabin door became ajar.NTSB CHI00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Salem, INthe inadequate compensation for the wind conditions and the failure of the pilot to maintain directional control. A factor to the accident was the crosswind condition.NTSB FTW00LA167Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164B · Natchitoches, LAThe failure of the pilot to maintain directional control during the landing roll, which resulted in a ground loop. A factor was the crosswind.NTSB CHI00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-200 · Oakley, KSthe directional control not maintained by the pilot. The thunderstorm, quartering tailwind/crosswind and the weather evaluation by the pilot were contributing factors.NTSB LAX00LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Long Beach, CAThe student pilot's failure to maintain directional control during takeoff and his subsequent failure to relinquish control of the airplane.NTSB LAX00LA210Accident · No injuriesLimited investigationFinal reportHilyard Dragonfly · Lancaster, CAthe pilot's failure to maintain adequate airspeed while attempting to land in gusty wind conditions leading to an inadvertent stall/mush, which resulted in a porpoise and subsequent loss of directional control.NTSB FTW00LA165Accident · No injuriesLimited investigationFinal reportHard Capella XLS · Taylor, TXThe pilot's failure to maintain directional control during the landing roll. A factor was the pilot's lack of experience in the make and model of the accident aircraft.NTSB NYC00LA145Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Hammonton, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind condition.NTSB ATL00LA057Accident · No injuriesLimited investigationFinal reportJohn Thomas Cloud Dancer 2 · Franklin, NCThe pilot's failure to maintain directional control of the gyroplane during takeoff roll, resulting in a roll over.NTSB DEN00LA098Accident · No injuriesLimited investigationFinal reportRosenvall Avid MK IV · Salina, UTThe pilot's failure to maintain aircraft control during landing roll. A factor was gusting winds from nearby thunderstorms.NTSB CHI00LA143Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Green Bay, WIthe improper compensation for the wind conditions. A factor in the accident was the wind shear.NTSB MIA00LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Monticello, MSThe failure of the pilot to maintain directional control during takeoff into crosswind conditions resulting in the collision with trees. A factor in the accident was the pilot's lack of familiarity with the aircraft.