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 ANC96LA048Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB ATL96LA072Accident · No injuriesLimited investigationFinal reportCessna 140 · Elkin, NCfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB CHI96LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIFailure of the student pilot to maintain directional control of the airplane during the takeoff roll. The snowbank was a related factor.NTSB LAX96LA138Accident · Minor injuriesLimited investigationFinal reportBeech E33A · Mesquite, NVthe pilot's poor judgment in attempting to take off in the existing wind conditions.NTSB SEA96LA069Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Sunriver, ORthe pilot's failure to maintain directional control during the landing rollout. A factor contributing to the accident was the presence of a tree near the edge of the runway.NTSB ANC96LA034Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's improper use of the brakes during landing. The snow berm along the edge of the runway was a factor.NTSB CHI96LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · Ulysses, KSFailure of the pilot to maintain directional control of the airplane during the takeoff roll, and his improper use of brakes and elevator control, while aborting the takeoff. A factor relating to the accident was the gusty wind condition.NTSB CHI96LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIthe pilot's failure to maintain directional control and his improper use of the rudder in an attempt to regain control.NTSB SEA96LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eugene, ORthe student pilot's inadvertent activation of the brakes and his failure to maintain directional control, which resulted in an inadvertent ground swerve.NTSB LAX96LA128Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bishop, CAfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve. The unfavorable wind condition was a related factor.NTSB ANC96LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's failure to maintain directional control during landing.NTSB MIA96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · Merritt Island, FLThe pilot's inadequate compensation for crosswind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.NTSB MIA96LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAthe pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB LAX96LA125Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Auburn, CAfailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve.NTSB LAX96FA122Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Grand Canyon, AZthe failure of the pilot to maintain directional control of the aircraft after landing. Contributing to the accident was the icy runway conditions with poor braking.NTSB NYC96LA075Accident · No injuriesLimited investigationFinal reportCessna 172M · Warehouse Point, CTthe pilot's inadequate compensation for the crosswind and gusts. The wind conditions were factors.NTSB CHI96LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, ILFailure of the student pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the crosswind condition.NTSB ATL96LA054Accident · No injuriesLimited investigationFinal reportCessna 210 · Kinston, NCThe pilot's failure to compensate for the crosswind and his inadequate weather evaluation. A factor was the gusty crosswind.NTSB ATL96LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Birmingham, ALthe pilot's failure to maintain directional control during landing,NTSB IAD96LA042Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Cynthiana, KYThe pilot's failure to obtain proper assistance to secure the airplane.NTSB LAX96LA113Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18-A · Blythe, CAthe pilot's premature lift-off and subsequent loss of control due to his failure to monitor the airspeed indicator during the takeoff roll.NTSB SEA96LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Salmon, IDfailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. A factor relating to the accident was: the rock pile to the left of the runway.NTSB MIA96LA077Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Winter Haven, FLFailure of the pilot to maintain control of the aircraft after initiating a go-around, which resulted in the right wing contacting the ground. The unfavorable wind condition was a related factor.NTSB LAX96LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAthe student pilot's improper use of the rudder control and resultant failure to maintain directional control of the airplane during the landing rollout. Factors relating to the accident were: the student allowed the airspeed to be excessive during the…NTSB FTW96LA112Accident · No injuriesLimited investigationFinal reportMasnic SKY Hopper II · Edgewood, NMthe pilot exceeding the airplane's crosswind component which led to his inability to compensate for the crosswind conditions. A factor was the gusty winds.NTSB CHI96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Marion, INthe pilot's failure to maintain directional control during landing.NTSB LAX96LA111Accident · 1 fatalLimited investigationFinal reportBell 47G-2A1 · Honiara, Solomon Islandsthe pilot and the ship crew's failure to assure the tie down strap was removed prior to liftoff.NTSB CHI96LA084Accident · No injuriesLimited investigationFinal reportConnell Kitfox · Omaha, NEthe pilot's inadequate preflight of the aircraft and the frozen left landing gear wheel.NTSB CHI96LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sandstone, MNthe pilot's selection of an ice-covered runway for takeoff. A factor was the icy runway.NTSB NYC96LA055Accident · No injuriesLimited investigationFinal reportCessna 150M · Readington, NJThe student pilot's unapproved landing at a second destination during his first solo cross-country, and his inadequate compensation for a cross wind, which resulted in the airplane veering off of the runway and the subsequent nose over.NTSB NYC96LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwood, MAFailure of the student pilot to maintain directional control of the airplane after touchdown, which resulted in an inadvertent ground swerve and collision with a snowbank.NTSB FTW96LA103Accident · No injuriesLimited investigationFinal reportCessna A185F · Belle Chase, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of directional control and subsequent encounter with a ditch. The crosswind was a related factor.NTSB FTW96LA101Accident · No injuriesLimited investigationFinal reportCessna 180 · Buena Vista, COThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control. A factor relating to the accident was: the crosswind.NTSB MIA96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and subsequent overload failure of the nose gear.NTSB CHI96LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zionsville, INthe pilot's failure to maintain directional control of the airplane on the ground. A factor relating to this accident is the snowbank.NTSB CHI96LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Forks, NDthe pilot's failure to maintain control of the airplane while taxiing. Factors in the accident were the icy condition of the taxiway and the high gusting wind.NTSB ATL96LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Myers, FLthe student pilot's improper flare to touchdown.NTSB CHI96LA080Accident · No injuriesLimited investigationFinal reportCessna 182J · Waukon, IAthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control while taxiing. Factors in the accident were the icy runway and the gusty wind conditions.NTSB MIA96LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Port Richey, FLFailure of the pilot to maintain directional control of the airplane, while landing with a crosswind, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB NYC96LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Wildwood, NJfailure of the student pilot to maintain directional control of the airplane. Factors relating to the accident were: the student's selection of the wrong runway, and the crosswind condition.NTSB CHI96LA062Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Excelsior Sprg, MOthe pilot's selection of the wrong runway for landing and the delayed aborted landing. Factors associated with the accident were the tailwind condition and the pilot's inadequate level-off.NTSB NYC96LA043Accident · No injuriesLimited investigationFinal reportPiper J3F · Westerly, RIthe pilot's inadequate compensation for the wind condition, which subsequently resulted in the aircraft nosing over. The gusty crosswind condition was a related factor.NTSB LAX96LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Quartzsite, AZthe failure of the pilot to maintain directional control during landing.NTSB NYC96LA042Accident · No injuriesLimited investigationFinal reportCessna 150G · East Hampton, NYfailure of the flight instructor to adequately supervise the dual student pilot and ensure that directional control of the airplane was maintained. The icy runway was a related factor.NTSB DCA96MA029Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 747-136 · Jamaica, NYthe captain's failure to reject the takeoff in a timely manner when excessive nosewheel steering tiller inputs resulted in a loss of directional control on a slippery runway. Inadequate Boeing 747 slippery runway operating procedures developed by Tower Air,…NTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.NTSB ANC96LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Newtok, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident are the snow covered runway, and gusty crosswinds.NTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.NTSB NYC96LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Moultonboro, NHfailure of the pilot to maintain directional control of the airplane during the landing, which allowed the plane to depart the runway and collide with a snowbank. A factor relating to the accident was: the icy runway condition.NTSB LAX96LA064Accident · No injuriesLimited investigationFinal reportEmroth Emair MA-1B · Pahala, HIthe failure of the pilot to adequately compensate for wind conditions, and to maintain directional control of the aircraft during the landing.