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 GAA17CA127Accident · No injuriesData collectionFinal reportVaughan Gerald R Side Winder TD · McCook, NEThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA125Accident · No injuriesData collectionFinal reportGreat Lakes 2T1A · Canon City, COThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s unstabilized approach.NTSB GAA17CA123Accident · No injuriesData collectionFinal reportPiper PA 28R · Wichita, KSThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.NTSB CEN17LA123Accident · No injuriesLimited investigationFinal reportBeech C 99 · Durango, COThe pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.NTSB ERA17LA091Accident · Serious injuriesLimited investigationFinal reportAmerican Legend AL3 · Pierson, FLThe pilot's improper braking during takeoff, which resulted in a nose-over.NTSB GAA17CA114Accident · No injuriesData collectionFinal reportBeech B200 · Coalinga, CAThe pilot’s failure to maintain directional control during takeoff.NTSB GAA17CA110Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Milton-Freewater, ORThe pilot's decision to take off from unsuitable terrain with a tailwind, which resulted in a nose-over.NTSB CEN17FA067Accident · 1 fatalField investigationFinal reportDemmer BD-4 · Brookfield, WIThe pilot's failure to abort the takeoff when he was not able to maintain directional control in the strong crosswind conditions.NTSB GAA17CA106Accident · Minor injuriesData collectionFinal reportMaule M7 · Palouse, WAThe pilot’s failure to maintain directional control on an ice- and snow-covered runway during taxi with a crosswind, which resulted in a runway excursion.NTSB GAA17CA105Accident · No injuriesData collectionFinal reportPiper PA 46 · Nashville, TNThe pilot’s loss of directional control during the aborted landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB CEN17LA090Accident · No injuriesLimited investigationFinal reportCessna 172B · Prairie Du Sac, WIThe pilot's decision to taxi the airplane from the roadway and his subsequent failure to maintain clearance from signs and a fence after a successful emergency landing following a total loss of engine power.NTSB DCA17WA047Accident · Minor injuriesForeign investigationBoeing 737 · Dabolim, Goa, IndiaThe India Air Accident Investigation Bureau (AAIB) has notified the NTSB of an accident involving a Boeing 737-800 airplane that occurred on December 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…NTSB GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.NTSB GAA17CA096Accident · No injuriesData collectionFinal reportPiper PA28 · Madisonville, TNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.NTSB GAA17CA094Accident · No injuriesData collectionFinal reportSchauer William A JR Starduster TOO SA300 · Kapolei, HIThe pilot's failure to maintain directional control during the landing roll.NTSB GAA17CA093Accident · No injuriesData collectionFinal reportPiper PA 34 · Denton, TXThe flight instructor’s decision to continue to taxi the airplane to the parking area with a known brake malfunction, which resulted in a loss of directional control and subsequent impact with a parked airplane.NTSB GAA17CA091Accident · No injuriesData collectionFinal reportCessna 170 · Martinsville, VAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR17LA030Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Scottsdale, AZThe pilot’s loss of directional control during the landing roll, which resulted in the runway excursion onto the rock-covered runway safety area.NTSB GAA17CA084Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Pensacola, FLThe student pilot’s incorrect brake application during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA085Accident · No injuriesData collectionFinal reportHundley Michael J Vans RV8 · Roopville, GAThe pilot’s overcorrection with the right rudder during the landing roll, which resulted in a loss of directional control and a runway excursion.NTSB ERA17LA063Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bluefield, WVThe pilot's failure to maintain directional control during the aborted takeoff.NTSB ERA17LA053Accident · Minor injuriesLimited investigationFinal reportBroussard Broussard MH 1521 · Simpsonville, SCThe pilot’s inability to maintain directional control during the landing roll due to a flat left main landing gear tire.NTSB GAA17CA080Accident · No injuriesData collectionFinal reportCessna 172 · Woodbine, NJThe student pilot's improper landing flare, which resulted in a porpoised landing.NTSB GAA17CA081Accident · No injuriesData collectionFinal reportCessna 172 · Destin, FLThe student pilot’s overcorrection with right rudder, which resulted in a loss of directional control, and the flight instructor’s delayed remedial action.NTSB GAA17CA082Accident · Serious injuriesData collectionFinal reportCameron A315 · Winters, CAThe passenger's improper egress from the balloon basket, which resulted in a serious injury.NTSB GAA17CA071Accident · No injuriesData collectionFinal reportCessna 120 · Lincoln, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA066Accident · No injuriesData collectionFinal reportLuscombe 8 · Conway, ARThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and ground loop.NTSB GAA17CA073Accident · No injuriesData collectionFinal reportCarter Richard L Buddy Baby Lakes · Hurricane, UTThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB GAA17CA068Accident · No injuriesData collectionFinal reportMaule MX7 · Port Aransas, TXThe pilot’s failure to maintain directional control of the airplane during landing with a crosswind.NTSB ERA17LA042Accident · 1 fatalLimited investigationFinal reportNorth American Navion · Blairstown, NJThe pilot's improper engine start procedure, which resulted in a loss of control on the ground and collision with a tree.NTSB GAA17CA062Accident · No injuriesData collectionFinal reportAeronca L 3B · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA056Accident · No injuriesData collectionFinal reportBeech 76 · Davis, CAThe pilot's failure to maintain directional control during a simulated left engine failure during takeoff. Also causal to the accident was the flight instructor's delayed remedial action to maintain directional control and reduce the right engine mixture…NTSB GAA17CA059Accident · Minor injuriesData collectionFinal reportHaring Clay RV6 · Eureka, KSThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA054Accident · No injuriesData collectionFinal reportCessna A185 · Winnemucca, NVThe pilot's failure to maintain directional control during the landing roll.NTSB GAA17CA049Accident · No injuriesData collectionFinal reportAviat A-1C · Placerville, CAThe pilot’s failure to maintain directional control of the airplane during landing in gusty crosswind conditions.NTSB GAA17CA046Accident · No injuriesData collectionFinal reportCirrus SR22 · Kirksville, MOThe pilot’s improper compensation for changing wind during the landing flare, which resulted in an off-centered landing and a subsequent loss of directional control.NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN17LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Buffalo, WYThe pilot’s failure to set the proper flap position before the short field takeoff, which resulted in a runway excursion and impact with terrain.NTSB GAA17CA043Accident · No injuriesData collectionFinal reportAeronca 11AC · Winter Haven, FLThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion.NTSB GAA17CA050Accident · No injuriesData collectionFinal reportCessna 305 · Llano, TXThe pilot's failure to maintain directional control during the landing roll in cross wind conditions.NTSB GAA17CA041Accident · No injuriesData collectionFinal reportCessna A185 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll.NTSB GAA17CA039Accident · No injuriesData collectionFinal reportEvolution Revo · Carson City, NVThe pilot receiving instruction's inadvertent application of throttle during the engine start, which led to an inadvertent acceleration and a roll-over.NTSB CEN17LA023Accident · No injuriesLimited investigationFinal reportStinson 108 · Austin, TXThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB GAA17CA042Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.NTSB GAA17CA037Accident · No injuriesData collectionFinal reportPiper PA24 · Wagoner, OKThe pilot's failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA024Accident · Minor injuriesData collectionFinal reportCessna 182 · Leesburg, VAThe pilot's improper landing flare, which resulted in a hard landing and subsequent runway excursion.NTSB GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.NTSB DCA17WA012Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaThe government of Indonesia (KNKT/NTSC) has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on October 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's…NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.