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 CEN11CA303Accident · Minor injuriesData collectionFinal reportBell 206 · Venice, LAThe pilot's improper use of the collective and cyclic control during taxi operations, which induced a dynamic rollover.NTSB CEN11CA288Accident · No injuriesData collectionFinal reportPiper PA-30 · Austin, TXThe pilot’s loss of directional control during landing which resulted in a runway excursion.NTSB WPR11LA205Accident · Minor injuriesLimited investigationFinal reportBennett Midjet Mustang I · Ramona, CAThe pilot's inability to maintain directional control during the landing roll due to the overload separation of the left brake master cylinder from the left rudder pedal assembly.NTSB CEN11CA276Accident · No injuriesData collectionFinal reportCessna 182P · Troy, MIThe pilot's inadequate compensation for wind conditions and subsequent loss of control.NTSB ANC11CA024Accident · No injuriesData collectionFinal reportCessna 180H · Palmer, AKThe pilot’s loss of directional control during the landing roll resulting in a ground-loop.NTSB WPR11CA194Accident · No injuriesData collectionFinal reportCessna 172R · Othello, WAThe pilot's failure to maintain directional during the landing roll.NTSB CEN11TA279Accident · No injuriesFinal reportRockwell International 500-S · Eden Prairie, MNThe pilot's inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.NTSB CEN11CA261Accident · No injuriesData collectionFinal reportCessna 172N · Colorado Springs, COThe pilot loss of directional control during landing in gusty crosswind conditions.NTSB CEN11LA281Accident · No injuriesLimited investigationFinal reportReeves Avid Mark IV · Brookfield, MOThe pilot’s failure to maintain directional control during landing, which resulted in the airplane departing the runway.NTSB WPR11CA178Accident · No injuriesData collectionFinal reportCirrus SR22 · Winslow, AZThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.NTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN11CA271Accident · No injuriesData collectionFinal reportCessna 172N · Appleton, WIThe student pilot's failure to maintain directional control of the airplane during takeoff.NTSB CEN11LA251Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Canadian, TXThe pilot’s continuation of the approach with excessive airspeed, which resulted in a hard landing and a loss of directional control.NTSB ERA11CA212Accident · No injuriesData collectionFinal reportMooney M20J · St. Petersburg, FLThe pilot’s failure to maintain directional control during a crosswind landing.NTSB CEN11CA256Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Wichita, KSThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11LA265Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 10 · Sellersburg, INThe pilot's failure to maintain control of the airplane during landing in strong and gusty wind conditions.NTSB CEN11LA273Accident · No injuriesLimited investigationFinal reportCessna 414A · Aberdeen, SDThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.NTSB CEN11CA268Accident · Minor injuriesData collectionFinal reportCub Crafters CC11-160 · Kiowa, COThe pilot's failure to maintain directional control following a hard landing.NTSB ERA11CA199Accident · No injuriesData collectionFinal reportLuscombe 8E · Taunton, MAThe pilot's inadvertent application of the brakes during recovery from a ground loop which resulted in a nose over.NTSB CEN11CA238Accident · No injuriesData collectionFinal reportCessna 305A · Anoka, MNThe pilot's failure to maintain control of the airplane during the go-around, which resulted in an inadvertent stall.NTSB CEN11IA234Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145XR · Akron, OHThe uncommanded left deflection of the airplane's nosewheel for reasons that could not be determined because postincident examination of the nosewheel steering system did not reveal any anomalies that would have precluded normal operation.NTSB ERA11CA194Accident · No injuriesData collectionFinal reportRobinson R44 · Petersburg, WVThe pilot's failure to maintain control during the takeoff.NTSB CEN11CA233Accident · No injuriesData collectionFinal reportMaule M-4-220C · Albuquerque, NMThe pilot's failure to maintain control of the airplane during landing, which resulted in a runway excursion.NTSB CEN11CA236Accident · No injuriesData collectionFinal reportPiper PA-22-150 · South St. Paul, MNThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB WPR11CA165Accident · No injuriesData collectionFinal reportBellanca 14-13-2 · Mesquite, NVThe malfunction of the brake system which led to the pilot's failure to maintain directional control during the landing roll.NTSB ANC11CA016Accident · No injuriesData collectionFinal reportCessna 140 · Anchorage, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop.NTSB ERA11CA188Accident · No injuriesData collectionFinal reportCessna 182T · Waynesburg, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB WPR11FA158Accident · No injuriesField investigationFinal reportCessna 208B · Bakersfield, CAThe malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…NTSB WPR11CA162Accident · No injuriesData collectionFinal reportCessna 180 · Pine, AZThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with terrain.NTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.NTSB ERA11CA177Accident · No injuriesData collectionFinal reportQuist Kitfox · Indian Trail, NCThe pilot's failure to maintain directional control during an aborted landing, resulting in a runway excursion and collision with a vehicle.NTSB ERA11CA178Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Ridgely, MDThe pilot's failure to compensate for crosswind conditions and loss of directional control during landing, resulting in a runway excursion and nose over.NTSB ERA11CA174Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Maysvile, NCThe pilot-rated passenger’s loss of directional control during takeoff and the pilot’s delayed remedial action, which resulted in a runway excursion and collision with trees.NTSB CEN11CA206Accident · No injuriesData collectionFinal reportWaco SRE · Vidalia, LAThe pilot’s failure to maintain directional control during landing in gusty wind conditions.NTSB WPR11LA143Accident · No injuriesLimited investigationFinal reportMooney M20F · Nephi, UTThe failure of the nose gear during landing for reasons that could not be determined due to postaccident damage.NTSB WPR11LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Twin Falls, IDThe pilot’s failure to compensate for the wind, which resulted in the airplane being blown over after completion of the landing roll.NTSB WPR11CA134Accident · No injuriesData collectionFinal reportBal-Air Inc/Wayne John K Christen Eagle · Groveland, CAThe pilot's failure to compensate for crosswind conditions and maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.NTSB CEN11CA181Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lansing, ILThe pilot’s loss of directional control during the landing.NTSB ERA11CA138Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's loss of directional control during the landing rollout, resulting in a runway excursion.NTSB CEN11LA178Accident · No injuriesLimited investigationFinal reportBeech A36 · Danville, ILThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Minden, NVThe pilot's loss of directional control during landing.NTSB WPR11CA118Accident · Serious injuriesData collectionFinal reportCessna 182 · Eastsound, WAThe pilot’s failure to properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.NTSB ERA11CA153Accident · No injuriesData collectionFinal reportOtterback Nicholas J Lightning · Crescent City, FLThe pilot's inadequate flare and failure to recover from a bounced landing which resulted in a runway excursion.NTSB CEN11CA191Accident · No injuriesData collectionFinal reportErcoupe 415-CD · Newaygo, MIThe pilot's loss of directional control during takeoff from a frozen lake.NTSB ERA11CA132Accident · No injuriesData collectionFinal reportCessna 172S · St. Petersburg, FLThe student pilot's failure to maintain directional control while attempting to turn the airplane onto a taxiway after landing.NTSB CEN11CA170Accident · No injuriesData collectionFinal reportCessna 182 · Meeker, COThe pilot’s loss of directional control while taxiing due to his improper seat position.NTSB ANC11CA011Accident · No injuriesData collectionFinal reportMiller Gregory Scott GOT Rocks · Anchorage, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.NTSB CEN11CA171Accident · No injuriesData collectionFinal reportCessna 172R · Shreveport, LAThe student pilot's loss of directional control during the landing.NTSB WPR11CA109Accident · No injuriesData collectionFinal reportCessna 180H · Helena, MTThe certified flight instructor's loss of airplane control during the landing roll in a gusting crosswind.