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 NYC00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cross Keys, NJThe operator's inadequate 100-hour inspection of the airplane, and the pilot's continued operation with known deficiencies in equipment.NTSB DEN00LA168Accident · No injuriesLimited investigationFinal reportCessna A185F · Ruidoso, NMthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind weather condition.NTSB CHI00LA290Accident · No injuriesLimited investigationFinal reportBeech B19 · Dodge Center, MNthe student pilot not maintaining aircraft control and the instructor pilot's delayed remedial action. A factor relating to the accident was the ditch.NTSB FTW00LA249Accident · No injuriesLimited investigationFinal reportCessna 170A · Mexia, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswind and the pilot's failure to perform a go-around upon encountering a windshift/crosswind.NTSB ANC00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ruby, AKThe pilot's inadvertent ground loop/swerve during the landing roll.NTSB DEN00LA162Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Laramie, WYThe pilot's failure to maintain directional control. A factor was his improper inflight decision in selecting a less-than-favorable runway on which to land that resulted in a ground loop.NTSB LAX00LA334Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Paso Robles, CAthe pilot's failure to brief his passenger about the operation of the controls.NTSB FTW00LA247Accident · Minor injuriesLimited investigationFinal reportAeronca BL7-AC · Hot Springs, ARThe pilot's failure to maintain control during landing. A factor was the wind gusts.NTSB DEN00TA160Accident · Minor injuriesFinal reportBell 212 · Jackson, WYLoss of control for undetermined reasons.NTSB DEN00LA158Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Broomfield, COthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB CHI00LA287Accident · No injuriesLimited investigationFinal reportCessna 172R · New Lenox, ILThe pilot's failure to maintain directional control during landing. Factors to the accident were the pipe that was struck, the crosswind, and the pilot's runway selection.NTSB LAX00LA313Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Cameron Park, CAfailure of the pilot to verify the seat latch was secure, resulting in the pilot's inability to reach the flight controls necessary to maintain directional control.NTSB CHI00LA280Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bolivar, MOThe pilot failed to maintain directional control of the airplane on landing. A factor associated with the accident was the crosswind.NTSB MIA00LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Cullman, ALfailure of the pilot to maintain directional control of the aircraft during the landing rollout, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it collided with a dirt bank.NTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.NTSB NYC00LA238Accident · No injuriesLimited investigationFinal reportAviat A-1B · Newberryport, MAthe failure of the pilot to maintain directional control during landing and a subsequent rejected landing. Factors were the crosswind, and the delayed corrective action by the pilot.NTSB NYC00LA268Accident · No injuriesLimited investigationFinal reportAerosports Connection FB-582 · Perth Amboy, NJThe pilot's failure to maintain directional control while taxiing for take off on water.NTSB LAX00LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Scottsdale, AZFailure of the pilot to maintain directional control on the landing rollout. Also causal to the accident was his failure to retract flaps during the aborted landing attempt, which lead to a loss of lift and a hard landing followed by a ground loop.NTSB FTW00LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · San Antonio, TXThe pilot's failure to maintain control during landing. A factor was the reported wind gust.NTSB DEN00LA156Accident · No injuriesLimited investigationFinal reportCessna 180K · Douglas, WYThe pilot's failure to maintain control of the aircraft during landing roll. Factors were high winds and crosswinds.NTSB MIA00LA243Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · St. Petersburg, FLThe pilot's improper judgment not to sit in the pilot's seat (rear seat) and improper use of brakes on landing roll resulting in a loss of directional control and subsequent nose over.NTSB IAD00LA077Accident · No injuriesLimited investigationFinal reportFoulke Europa TRI-GEAR · Doylestown, PAThe pilot's failure to maintain directional control during landing.NTSB SEA00LA164Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe pilot's failure to maintain directional control during the balked landing.NTSB DEN00LA154Accident · No injuriesLimited investigationFinal reportWaco AGC-8 · Ogden, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were a tail wind, inadequate weather evaluation by the pilot, and lack of experience in make and model.NTSB SEA00LA159Accident · No injuriesLimited investigationFinal reportBoeing E75 · Mcminnville, ORThe disconnection of the left tailwheel control cable spring resulting in the positioning of the tailwheel in a right turn condition.NTSB NYC00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot's improper recovery from a bounced landing.NTSB IAD00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Lynchburg, VAPilot's failure to maintain directional control during the landing roll-out.NTSB SEA00LA153Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Challis, IDThe pilot's inadequate compensation for wind conditions. Factors include variable winds during landing.NTSB NYC00LA218Accident · No injuriesLimited investigationFinal reportBeech BE-58 · West Milford, NJThe pilot's failure to maintain directional control during the landing flare and touchdown, which resulted in a blown tire, and a continued loss of directional control during the landing roll.NTSB LAX00LA287Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Davis, CAthe dual student's improper response to a simulated engine failure and the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB CHI00LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Bloomington, ILthe pilot not maintaining directional control of the airplane. Factors were the crosswind weather condition, the airport sign, and the collapsed nose gear.NTSB CHI00FA237Accident · 1 fatalField investigationFinal reportPiper J-5A · Belton, MOThe student pilot not maintaining directional control during the takeoff roll resulting in the inadvertent ground loop.NTSB CHI00LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Jeffersonville, INThe pilot failed to maintain directional control of the airplane while landing. A factor associated with the accident was the crosswind.NTSB CHI00LA231Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kirksville, MOthe pilot failed to maintain directional control during landing.NTSB LAX00LA282Accident · Serious injuriesLimited investigationFinal reportDaniel J. Lee Express 90 · Cottonwood, CAThe pilot's failure to maintain directional control during landing roll, which resulted in the on ground collision with trees.NTSB IAD00LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Princeton, NJthe student pilot's failure to maintain control of the airplane during the aborted landing.NTSB FTW00LA227Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rayville, LAThe flight instructor's failure to maintain directional control. A factor was the wind gusts.NTSB FTW00LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Calico Rock, ARthe pilot's inability to maintain airplane control during the landing roll due to the airplane hydroplaning on the wet runway.NTSB DEN00LA140Accident · No injuriesLimited investigationFinal reportCessna A188 · Gallup, NMThe pilot's failure to compensate for the wind conditions. Factors were the pilot's selection of the wrong runway, and the tailwind/crosswind weather conditions.NTSB SEA00LA147Accident · No injuriesLimited investigationFinal reportCessna A185F · Tillamook, ORThe pilot's failure to maintain directional control.NTSB SEA00LA145Accident · No injuriesLimited investigationFinal reportRoot Sherpa · Helena, MTThe pilot's failure to maintain directional control while landing.NTSB CHI00FA229Accident · No injuriesField investigationFinal reportCessna 195A · Oshkosh, WIThe pilots failure to maintain directional control. A factor was the landing gear being out of alignment.NTSB CHI00LA225Accident · Minor injuriesLimited investigationFinal reportComeau Avid Flyer · Gladstone, MIaircraft control not maintained by the pilot.NTSB ANC00LA098Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for crosswind conditions.NTSB SEA00LA139Accident · No injuriesLimited investigationFinal reportCessna 180H · Hailey, IDFailure to adequately compensate for wind conditions.NTSB NYC00LA204Accident · No injuriesLimited investigationFinal reportBoeing PT17 · Easton, MDThe pilot's failure to maintain aircraft control.NTSB MIA00LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Jesup, GAThe failure of the student pilot to maintain directional control during takeoff resulting in an excursion off the runway and collision with adjacent foliage. A factor in the accident was the student's decision to takeoff downwind.NTSB ANC00LA091Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Big Lake, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.NTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.NTSB CHI00LA194Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Olivia, MNthe failure of the pilot to maintain directional control of the aircraft. A factor to the accident was the pocket gopher mound in the wheat field.