NTSB investigations
3,846 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '230') 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 WPR09CA443Accident · No injuriesData collectionFinal reportCessna 305A · Helena, MTThe pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.NTSB ANC09CA097Accident · No injuriesData collectionFinal reportCessna 180J · Juneau, AKThe pilot's misjudged flare and loss of control during a glassy water landing.NTSB WPR09CA433Accident · No injuriesData collectionFinal reportSwalley Mark H CH 701 SP · Bremerton, WAThe pilot's inadequate compensation for the gusty wind conditions and failure to maintain aircraft control.NTSB ANC09CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKA tailwheel malfunction that limited directional control, which resulted in a runway excursion, and collision with a building.NTSB WPR09CA435Accident · No injuriesData collectionFinal reportPiper PA-20 · Bozeman, MTThe failure of the pilot receiving instruction to maintain directional control during the takeoff roll and the flight instructor's delayed corrective action.NTSB CEN09CA581Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC09CA096Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot’s decision to land on unsuitable terrain, which resulted in a loss of control and a collision with trees.NTSB WPR09CA440Accident · No injuriesData collectionFinal reportUniversal Globe GC-1 · Pacoima, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09LA557Accident · No injuriesLimited investigationFinal reportCessna 150F · Rosedale, MIThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident were the pilot's deteriorated physical and mental capabilities.NTSB WPR09CA429Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR · San Diego, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN09CA553Accident · No injuriesData collectionFinal reportWarner Lewis Steen · Broomfield, COThe pilot's inability to maintain directional control due to an internal mechanical failure of the left wheel that caused the wheel to seize.NTSB WPR09CA425Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Madras, ORThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control during landing rollout.NTSB CEN09CA547Accident · No injuriesData collectionFinal reportCessna 182P · Sugar Land, TXThe pilot's failure to control the airplane during engine startup, and his failure to maintain clearance from other objects.NTSB ERA09CA475Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Tuskegee, ALThe pilot’s failure to maintain directional control during the aborted landing.NTSB CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.NTSB WPR09CA410Accident · No injuriesData collectionFinal reportPiper PA28 · Glendale, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.NTSB WPR09CA404Accident · No injuriesData collectionFinal reportJabiru J230-SP · Reno, NVThe pilot’s failure to maintain directional control throughout the takeoff roll.NTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.NTSB ERA09CA465Accident · No injuriesData collectionFinal reportAeronca 7AC · Finleyville, PAThe pilot’s failure to maintain directional control during landing.NTSB CEN09CA530Accident · No injuriesData collectionFinal reportCessna 172 · Centennial, COThe pilot's failure to maintain directional control of the airplane during the landing flare in crosswind conditions.NTSB WPR09CA399Accident · No injuriesData collectionFinal reportAeronca 11CC · El Cajon, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.NTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.NTSB ANC09CA082Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kaktovik, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.NTSB WPR09CA405Accident · No injuriesData collectionFinal reportAeronca 7DC-CONV · Winnemucca, NVThe pilot's failure to maintain directional control during landing.NTSB ANC09CA081Accident · No injuriesData collectionFinal reportCessna 150H · Talkeetna, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.NTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.NTSB ERA09LA458Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Sanford, FLThe pilot’s failure to maintain directional control during takeoff.NTSB ERA09CA461Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Rockingham, NCThe pilot's failure to maintain directional control on landing roll out.NTSB CEN09CA507Accident · Serious injuriesData collectionFinal reportBoeing A75L300 · Salina, KSThe pilot's failure to maintain directional control during a touch-and-go.NTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.NTSB WPR09CA394Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Sisters, ORThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09CA449Accident · No injuriesData collectionFinal reportCessna 182 · Milford, PAThe pilot's failure to maintain control during takeoff.NTSB CEN09CA508Accident · No injuriesData collectionFinal reportCessna 170A · Aurora, ILThe pilot's failure to maintain directional control during the landing.NTSB ERA09CA443Accident · No injuriesData collectionFinal reportCessna 172S · Alabaster, ALThe student pilot's failure to maintain directional control during landing.NTSB CEN09CA489Accident · Minor injuriesData collectionFinal reportCessna 182P · Gateway, COThe pilot's inability to maintain directional control due to soft runway conditions.NTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.NTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.NTSB ERA09CA428Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Dundee, MSThe pilot's failure to maintain aircraft control during takeoff.NTSB CEN09CA500Accident · No injuriesData collectionFinal reportCessna P210N · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC09CA075Accident · No injuriesData collectionFinal reportCessna 180 · Buckland, AKThe improper installation of the right brake cylinder, which allowed a portion of the cylinder to disengage and jam the right rudder/brake pedal, resulting in a loss of directional control during landing. Contributing to the accident was an inadequate…NTSB WPR09LA457Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ely, NVThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.NTSB ERA09CA424Accident · No injuriesData collectionFinal reportWhite New Standard · Rhinebeck, NYThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was a depression near the edge of the turf runway that the airplane encountered during the takeoff roll.NTSB WPR09CA365Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Hemet, CAThe student pilot’s failure to maintain directional control during the landing roll and excessive use of the brakes.NTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.NTSB WPR09CA367Accident · No injuriesData collectionFinal reportXtremeair XP-30/2002339 · Santa Ynez, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.NTSB CEN09CA464Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Fort Collins, COThe pilot's failure to maintain directional control while landing in gusty, crosswind conditions.