NTSB investigations
4,591 cases where the sequence of events included Loss of control on ground.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN11CA039Accident · No injuriesData collectionFinal reportAeronca 7AC · Mount Vernon, MOThe pilot's loss of directional control while taxiing.NTSB CEN11CA015Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Richmond, INThe pilot's diverted attention to a landing gear indicator light that led to a loss of directional control and subsequent impact with terrain while taxiing.NTSB ANC11CA002Accident · No injuriesData collectionFinal reportCessna 170B · Minto Flats, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control.NTSB WPR11CA008Accident · No injuriesData collectionFinal reportCessna 172N · Salem, ORThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11CA019Accident · No injuriesData collectionFinal reportCessna 195 · Midland, TXThe private pilot’s loss of control during the landing roll and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB ANC11CA001Accident · No injuriesData collectionFinal reportPiper PA-12 · Chena Hot Springs, AKThe pilot's inadequate compensation for the wind conditions during landing, which resulted in a loss of directional control and collision with trees.NTSB ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.NTSB WPR10LA479Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Spokane, WAThe failure of a manufacturing splice of the right main landing gear tire’s inner tube, which resulted in a deflated tire and a consequent loss of directional control on landing.NTSB CEN10CA576Accident · No injuriesData collectionFinal reportCessna 172M · Belle Plaine, MNThe pilot's loss of directional control due to an encounter with soft terrain while landing.NTSB WPR10CA471Accident · No injuriesData collectionFinal reportCessna 195 · Prescott, AZThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion.NTSB ERA10CA500Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bealeton, VAThe pilot under instruction’s improper recovery from a bounced landing and the flight instructor’s delayed remedial action, which resulted in a ground loop and collision with trees.NTSB WPR10LA462Accident · 1 fatalLimited investigationFinal reportCosmos Phase II · El Mirage, CAThe pilot's improper preflight and starting procedures, which resulted in an inadvertent takeoff with the gust lock still installed.NTSB WPR10CA461Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC-2 MK.1 · Renton, WAThe pilot's failure to maintain directional control of the float-equipped airplane during an aborted water takeoff, resulting in a dragged wing.NTSB CEN10CA547Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Houma, LAThe pilot’s inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.NTSB ANC10CA095Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's improper recovery from a bounced landing.NTSB ERA10CA480Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Pleasant Garden, NCThe pilot's loss of directional control on takeoff during an encounter with a wind gust.NTSB CEN10CA552Accident · No injuriesData collectionFinal reportCessna 172P · Stow, OHThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB ANC10CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Windy Forks Strip, AKThe pilot's failure to maintain directional control while taxiing on a rough/uneven airstrip.NTSB ERA10CA476Accident · No injuriesData collectionFinal reportGoodman Robert Bruce RV-4 · Gainesville, GAThe pilot's failure to see and avoid marked power lines during low-level flight over a lake.NTSB WPR10CA455Accident · No injuriesData collectionFinal reportMaule MX7 · Willows, CAThe pilot's inadequate compensation for the gusty crosswind condition and his failure to maintain directional control.NTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.NTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.NTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB WPR10CA480Accident · No injuriesData collectionFinal reportCessna A185 · Santa Ynez, CAThe pilot's failure to maintain directional control, likely due to the inadvertent control interference by a passenger. A finding in the accident was the pilot's improper pre flight briefing.NTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.NTSB ANC10CA088Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Arctic Village, AKThe pilot's failure to maintain control of the airplane during an off-airport landing.NTSB CEN10CA530Accident · No injuriesData collectionFinal reportCullis Ultracruiser Sport · Defiance, OHThe pilot's failure to maintain aircraft control during the landing roll.NTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10CA453Accident · No injuriesData collectionFinal reportCessna 150C · Fields, ORThe pilot's misjudged landing flare, resulting in a bounced landing and loss of directional control. Contributing to the accident was the pilot's inaccurate perception of the airplane’s proximity to the ground as a result of the featureless white landing area.NTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.NTSB WPR10CA444Accident · Minor injuriesData collectionFinal reportSchweizer 164B · Murtaugh, IDThe pilot’s inadequate compensation for the wind and failure to maintain directional control during the takeoff roll.NTSB DCA10WA093Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanOn September 2, 2010, at 1337 UTC, an Eva Airways Boeing 747-400 ran off the edge of runway 24 upon landing at Tao Yuan International Airport, Taipei, Taiwan. The aircraft was registered in Taiwan a B-16410 and was on a scheduled passenger flight from Poo…NTSB CEN10CA516Accident · No injuriesData collectionFinal reportChampion 7KCAB · North Fork, NEThe student pilot's loss of directional control during landing, which resulted in a ground loop.NTSB CEN10CA513Accident · No injuriesData collectionFinal reportCessna 172P · Bartlesville, OKThe student pilot's loss of directional control during takeoff due to an improper flap setting.NTSB ERA10CA448Accident · No injuriesData collectionFinal reportCessna 182E · Edenton, NCThe pilot's inadequate compensation for crosswind conditions while landing, which resulted in a loss of directional control.NTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.NTSB CEN10CA505Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Waynesville, OHThe pilot's loss of aircraft control during the tow for takeoff.NTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.NTSB ERA10CA440Accident · No injuriesData collectionFinal reportBeech P35 · Hartford, CTThe pilot's inadequate compensation for the crosswind, resulting in a loss of directional control during landing.NTSB WPR10CA418Accident · No injuriesData collectionFinal reportWilde Daniel L Zenith 701 · Turlock, CAThe pilot’s inadequate compensation for the crosswind and failure to maintain runway alignment.NTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.NTSB CEN10CA495Accident · No injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Madisonville, TXThe pilot's failure to maintain control of the glider while landing in a crosswind.NTSB CEN10CA490Accident · Serious injuriesData collectionFinal reportPiper PA-46-310P · Austin, TXThe pilot's failure to maintain a stabilized approach, which resulted in a loss of control on landing with a tailwind.NTSB CEN10CA488Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA18-225 · Denver, COThe pilot's failure to maintain control of the airplane during landing.NTSB ERA10TA429Accident · No injuriesFinal reportBell UH1H · Warrenton, VAThe pilot receiving instruction's failure to maintain a proper pitch attitude during the practice autorotation maneuver.NTSB ERA10CA418Accident · No injuriesData collectionFinal reportCessna 182F · Canon, GAThe pilot’s improper recovery from a bounced landing.NTSB CEN10LA475Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Silver City, NMThe pilot's loss of directional control during takeoff and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.NTSB CEN10LA472Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions.