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 BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB MIA96LA032Accident · No injuriesLimited investigationFinal reportKoutz Q-200 · Valdosta, GAThe pilot's failure to maintain directional control. The crosswind was a factor.NTSB NYC96LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Placid, NYthe pilot's failure to maintain directional control during the landing, and subsequently the airplane veered off the runway.NTSB LAX96LA051Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · San Carlos, CAthe pilot's improper recovery from a bounced landing and failure to maintain directional control, while landing at night.NTSB FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.NTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.NTSB LAX96LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAThe pilot's failure to maintain directional control which resulted in an inadvertent ground loop. The pilot's diverted attention while raising the flaps and pushing in the carburetor heat control was a factor in this accident.NTSB MIA96LA017Accident · No injuriesLimited investigationFinal reportBoeing B-17G · Fayetteville, NCthe failure of the airplane's normal brake system due to the open position of the pressure relief valve. Contributing to the accident was the pilot in command's premature engine shutdown resulting in the airplane colliding with the localizer building.NTSB FTW96LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKthe pilot's failure to maintain directional control. A factor was the wet grass runway.NTSB LAX96LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Davis, CAthe pilot's failure to maintain directional control during the takeoff roll by diverting his attention.NTSB LAX96LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bullhead City, AZThe failure of the pilot/flight instructor to adequately supervise the student pilot resulting in loss of directional control, and his abrupt overcorrection resulting in a waterloop. A contributing factor was the pilot's limited experience as a flight…NTSB LAX96LA025Accident · No injuriesLimited investigationFinal reportCessna 172 · Livermore, CAthe pilot's failure to maintain directional control during the landing roll. A contributing factor was the rough/uneven terrain.NTSB FTW96LA034Accident · No injuriesLimited investigationFinal reportCessna T210F · Tulsa, OKthe pilot's failure to secure a cellular telephone which jammed the rudder pedals.NTSB CHI96LA024Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Liberal, KSthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control and an inadvertent ground swerve.NTSB FTW96TA021Accident · No injuriesFinal reportBeech 95 · Albuquerque, NMThe pilot's improper inflight decision to make a landing on an unlit runway and his failure to maintain directional control of the airplane. Factors were the inoperative runway lights, bright lights from surrounding areas, and the pilot's attention being…NTSB ANC96LA008Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain directional control of the airplane, while attempting to negotiate a bend (dog-leg) in the runway. Factors relating to the accident were: variable/gusty wind…NTSB CHI96LA018Accident · No injuriesLimited investigationFinal reportCessna 180G · Belle Fourche, SDthe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the airplane while landing. A factor in the accident was the crosswind conditions.NTSB LAX96LA015Accident · Minor injuriesLimited investigationFinal reportPetrik Questair Venture · Crescent City, CAthe pilot's failure to maintain directional control.NTSB FTW96LA018Accident · No injuriesLimited investigationFinal reportCessna 175 · Batesville, ARthe pilot's failure to maintain control of the airplane during landing.NTSB NYC96LA010Accident · No injuriesLimited investigationFinal reportCessna 140 · Albion, NYthe pilot's inadequate planning/decision and compensation for wind conditions, resulting in the airplane nosing over during the taxi.NTSB CHI96LA009Accident · No injuriesLimited investigationFinal reportCessna 180R · Seattle, WAthe pilot's failure to maintain control of the airplane during the landing roll. A factor in the accident was the gusty wind conditions.NTSB MIA96LA005Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Opa Locka, FLThe pilot's failure to maintain directional control of the airplane on landing resulted in a loss of control, sliding off the runway into a rock collapsing the landing gear.NTSB FTW96LA014Accident · No injuriesLimited investigationFinal reportCessna 172M · Sugar Land, TXthe student pilot's diverted attention and failure to maintain directional control.NTSB SEA96LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control. A factor to the accident was inadequate remedial action.NTSB ATL96LA002Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Decatur, ALThe student pilot's failure to maintain directional control during an aborted takeoff attempt. A factor was the stripped throttle knob threads.NTSB LAX95LA347Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAthe second pilot's failure to maintain directional control and the first pilot's improper supervision of the flight.NTSB CHI96LA001Accident · No injuriesLimited investigationFinal reportLuscombe Phantom 1 · Rolla, MOmechanical failure of the left brake.NTSB BFO95LA099Accident · No injuriesLimited investigationFinal reportDeangelo Kitfox Speedster · Youngstown, OHthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A related factor was the pilot's lack of familiarity with the aircraft while carrying a passenger.NTSB MIA95LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB FTW95LA403Accident · No injuriesLimited investigationFinal reportCessna 195 · Moriarty, NMthe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB ANC95LA175Accident · No injuriesLimited investigationFinal reportCessna 150 · Coldfoot, AKThe pilot's failure to maintain control of the airplane, while landing.NTSB SEA95LA218Accident · No injuriesLimited investigationFinal reportCessna 180 · Pray, MTThe loss of directional control due to the loss of right tailwheel steering. Factors in the accident were: a left quartering crosswind and the sloped side of the road.NTSB FTW95LA396Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Searcy, ARThe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB ANC95LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions. A factor relating to the accident was: the gusty crosswind condition.NTSB ATL95LA166Accident · No injuriesLimited investigationFinal reportCessna 170 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll and failure to take appropriate remedial action. A factor was trees.NTSB FTW95LA382Accident · No injuriesLimited investigationFinal reportCessna 421B · Albuquerque, NMThe pilot's inadequate compensation for the crosswind condition. A factor was the crosswind.NTSB LAX95LA324Accident · No injuriesLimited investigationFinal reportWelles Kitfox Speedster · San Luis Obispo, CAthe pilot's failure to maintain directional control.NTSB NYC95LA213Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Meriden, CTthe pilot's failure to maintain directional control during the landing roll which resulted in the aircraft veering off the runway, and a subsequent collision with a fence.NTSB SEA95LA202Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 · Blakely Island, WAThe pilot's inadequate compensation for wind conditions during takeoff. A factor was the sudden change in wind direction.NTSB LAX95LA327Accident · No injuriesLimited investigationFinal reportCessna 180B · Cooledge, AZthe pilot's inadequate compensation for the crosswind gust.NTSB LAX95LA320Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Santa Rosa, CAthe pilot's failure to maintain directional control. The pilot's improper use of the brakes and the soft terrain were factors in this accident.NTSB FTW95LA377Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Westcliffe, COFailure by the pilot to maintain directional control. A factor was gusting cross winds.NTSB LAX95LA317Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yuma, AZthe flight instructor's inadequate supervision of the flight and the failure of both pilots to maintain directional control.NTSB LAX95LA316Accident · No injuriesLimited investigationFinal reportCessna 172A · Weed, CAthe flight instructor's failure to maintain directional control of the aircraft.NTSB BFO95LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Martinsburg, WVthe student pilot's failure to maintain control of the airplane during the landing/aborted landing sequence. A related factor is the student pilot's lack of total flight experience.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB LAX95LA312Accident · No injuriesLimited investigationFinal reportRobinson R-22 · El Monte, CAthe student's improper use of the cyclic control; the flight instructor's inadequate supervision of the flight; and the flight instructor's failure to maintain an adequate obstacle clearance distance in selection of a practice slope landing area.NTSB ANC95LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's adequate compensate for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.NTSB NYC95LA218Accident · No injuriesLimited investigationFinal reportMarkwood BD-4 · Connellsville, PALoss of braking action at the right brake, due to a low level of hydraulic fluid and inadequate maintenance, which resulted in the loss of aircraft control.