NTSB investigations, 2018

303 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 year(c.\"eventDate\") = 2018
    AND 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.

NTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.Oct 6, 2018 · N56949 · Substantial damageNTSB GAA19CA007Accident · No injuriesData collectionFinal reportMaule M7 · Medford, ORThe pilot’s failure to maintain directional control during landing.Oct 6, 2018 · N10555 · Substantial damageNTSB GAA19CA019Accident · No injuriesData collectionFinal reportChampion 7ECA · Cleveland, TXThe pilot’s failure to maintain directional control while landing in a gusting crosswind conditions.Oct 5, 2018 · N36268 · Substantial damageNTSB GAA19CA014Accident · No injuriesData collectionFinal reportCessna 172 · Stockton, CAThe student pilot's failure to maintain directional control during takeoff.Oct 5, 2018 · N78239 · Substantial damageNTSB GAA19CA005Accident · No injuriesData collectionFinal reportCessna 180 · Hailey, IDThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Oct 3, 2018 · N180BG · Substantial damageNTSB GAA19CA002Accident · Minor injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 · Frankston, TXThe pilot's improper landing flare, which resulted in the weight-shift-controlled aircraft landing crooked on a turf runway.Oct 2, 2018 · N20179 · Substantial damageNTSB GAA18CA580Accident · No injuriesData collectionFinal reportPiper PA28 · Van Nuys, CAThe pilot's failure to maintain directional control of the airplane during landing.Sep 30, 2018 · N400JW · Substantial damageNTSB ERA18LA269Accident · No injuriesLimited investigationFinal reportRobinson R44 · Westminster, MDThe pilot's attempt to move the helicopter from a sloped surface after an overspeed event, which resulted in a loss of helicopter control and impact with a car. The overspeed event resulted from misrouted and damaged wiring in the magneto, which subsequently…Sep 30, 2018 · N440SH · Substantial damageNTSB GAA18CA576Accident · Minor injuriesData collectionFinal reportRaymon A. King Super CUB Replica · Saratoga Springs, UTThe pilot's failure to maintain directional control during the takeoff roll with crosswind conditions.Sep 29, 2018 · N1698K · Substantial damageNTSB GAA18CA570Accident · No injuriesData collectionFinal reportAviat A1 · Raquette Lake, NYThe pilot’s failure to maintain lateral control after landing on water in gusting wind conditions.Sep 24, 2018 · N52DA · Substantial damageNTSB GAA18CA566Accident · No injuriesData collectionFinal reportVans RV-14 · Heber City, UTThe pilot's loss of directional control during the landing roll and his subsequent attempted go-around.Sep 24, 2018 · N823HE · Substantial damageNTSB ERA18LA258Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Georgetown, SCA loss of directional control during landing due to overstress failure of the left seat’s left rudder pedal arm clevis, which occurred as a result of manufacturing defects.Sep 22, 2018 · N435RB · Substantial damageNTSB GAA18CA564Accident · No injuriesData collectionFinal reportCessna 150 · Roseburg, ORThe pilot's loss of directional control during landing.Sep 21, 2018 · N8382G · Substantial damageNTSB GAA18CA562Accident · No injuriesData collectionFinal reportRutan Rutan Long EZ · Independence, ORThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.Sep 19, 2018 · N5RJ · Substantial damageNTSB GAA18CA577Accident · No injuriesData collectionFinal reportAviat A1 · Grand Island, NEThe pilot’s failure to maintain directional control during the landing roll in tailwind and crosswind conditions. Contributing to the accident was the pilot’s fatigue.Sep 18, 2018 · N811YD · Substantial damageNTSB GAA18CA560Accident · Minor injuriesData collectionFinal reportPiper PA22 · Hillsdale, MIThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.Sep 17, 2018 · N3544A · Substantial damageNTSB GAA18CA569Accident · No injuriesData collectionFinal reportMaule M7 · Grass Valley, ORThe pilot’s failure to maintain directional control during the landing roll.Sep 16, 2018 · N760AC · Substantial damageNTSB ERA18LA253Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Montauk, NYThe pilot's failure to properly secure his seat before initiating the takeoff, which resulted in the seat sliding back as the airplane accelerated during takeoff, his inability to reach the pedals, and the subsequent loss of directional control and impact…Sep 16, 2018 · N161DL · Substantial damageNTSB GAA18CA556Accident · No injuriesData collectionFinal reportCessna R182 · Mount Holly, NJThe pilot’s failure to maintain lateral control of the airplane during landing, which resulted in a loss of directional control and subsequent runway excursion.Sep 15, 2018 · N7304T · Substantial damageNTSB GAA18CA558Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent loss of directional control on an unimproved airstrip.Sep 13, 2018 · N7184B · Substantial damageNTSB GAA18CA553Accident · Minor injuriesData collectionFinal reportPiper PA28 · Spanish Fork, UTThe student pilot’s failure to maintain the runway heading during takeoff and the flight instructor’s decision to conduct primary flight instruction in an airplane without dual controls.Sep 13, 2018 · N7223J · Substantial damageNTSB WPR18LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to secure his seat position prior to takeoff, which resulted in a loss of airplane control and subsequent hard landing.Sep 12, 2018 · N24ME · Substantial damageNTSB GAA18CA552Accident · No injuriesData collectionFinal reportCessna 182 · Page, AZThe pilot's improper landing flare, which resulted in a bounced landing.Sep 11, 2018 · N5198N · Substantial damageNTSB GAA18CA548Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Carson, NVThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control in gusting, right quartering tailwind conditions.Sep 11, 2018 · N289MM · Substantial damageNTSB GAA18CA555Accident · No injuriesData collectionFinal reportHimmeroeder Hansgeorg Bearhawk · Williams, CAThe pilot’s failure to maintain directional control during the landing roll.Sep 9, 2018 · N152GH · Substantial damageNTSB GAA18CA545Accident · Minor injuriesData collectionFinal reportCirrus SR22 · Mason City, IAThe pilot’s improper hand propping procedure, which resulted in a runaway airplane and subsequent impact with a hangar.Sep 8, 2018 · N669HT · Substantial damageNTSB GAA18CA584Accident · No injuriesData collectionFinal reportCessna 305 · Groveland, CAThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and subsequent ground-loop.Sep 5, 2018 · N119PP · Substantial damageNTSB WPR18LA255Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Richland, MOA loss of directional control during a touch-and-go landing in gusting crosswind conditions.Sep 4, 2018 · N8028F · Substantial damageNTSB GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.Sep 4, 2018 · N230DE · Substantial damageNTSB GAA18CA572Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot’s failure to maintain lateral control of the airplane during a step-turn takeoff.Sep 2, 2018 · N95EA · Substantial damageNTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.Sep 2, 2018 · N4077M · Substantial damageNTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.Sep 1, 2018 · N34107 · Substantial damageNTSB GAA18CA550Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.Sep 1, 2018 · N27WE · Substantial damageNTSB GAA18CA527Accident · No injuriesData collectionFinal reportCessna 170 · Tulsa, OKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Sep 1, 2018 · N2303D · Substantial damageNTSB GAA18CA526Accident · No injuriesData collectionFinal reportCessna 172 · Karluk, AKThe pilot’s failure to maintain proper pitch for a soft-field landing, which resulted in a loss of airplane control.Sep 1, 2018 · N3835S · Substantial damageNTSB GAA18CA525Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff.Sep 1, 2018 · N5373Y · Substantial damageNTSB GAA18CA523Accident · Minor injuriesData collectionFinal reportEggleston Daniel S-18 Thorp · Porterville, CAThe pilot’s failure to maintain directional control during the takeoff roll.Sep 1, 2018 · N575DG · Substantial damageNTSB GAA18CA579Accident · Minor injuriesData collectionFinal reportPiper PA28 · Porterville, CAThe pilot's failure to maintain directional control during the landing roll.Aug 31, 2018 · N8172N · Substantial damageNTSB CEN18WA404Accident · No injuriesClass 5 · ForeignCessna 680 · Burgas, BulgariaAug 31, 2018 · TC-OYD · Substantial damageNTSB GAA18CA524Accident · No injuriesData collectionFinal reportLuscombe 8 · Fulton, MOThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Aug 28, 2018 · N1211B · Substantial damageNTSB GAA18CA513Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's failure to maintain directional control during the takeoff roll.Aug 27, 2018 · N53051 · Substantial damageNTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.Aug 26, 2018 · N201BS · Substantial damageNTSB GAA18CA517Accident · No injuriesData collectionFinal reportChampion 7GCBC · Ocklawaha, FLThe pilot’s failure to maintain directional control during landing.Aug 25, 2018 · N7618S · Substantial damageNTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.Aug 25, 2018 · N7635F · Substantial damageNTSB GAA18CA509Accident · No injuriesData collectionFinal reportCessna 170 · Prineville, ORThe pilot's failure to maintain directional control during the landing roll.Aug 25, 2018 · N4569C · Substantial damageNTSB ANC18CA068Accident · Minor injuriesData collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during the landing roll when the left main landing gear wheel got caught in a ditch, which resulted in a subsequent nose-over.Aug 25, 2018 · N5392Y · Substantial damageNTSB GAA18CA510Accident · No injuriesData collectionFinal reportMaule MX7 · Post Mills, VTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.Aug 24, 2018 · N524TR · Substantial damageNTSB GAA18CA507Accident · Minor injuriesData collectionFinal reportVans RV10 · Spring Branch, TXThe pilot's failure to maintain the proper glidepath and his subsequent abrupt maneuver to avoid trees, which led to the exceedance of the airplane's critical angle of attack and resulted in an aerodynamic stall during landing and a subsequent loss of…Aug 23, 2018 · N110DV · Substantial damageNTSB GAA18CA505Accident · No injuriesData collectionFinal reportCessna 172 · Churchville, MDThe pilot's failure to maintain directional control after landing left of the runway centerline, which resulted in a runway excursion and impact with a power box.Aug 23, 2018 · N419SP · Substantial damageNTSB GAA18CA504Accident · No injuriesData collectionFinal reportPiper PA18 · McGrath, AKThe pilot’s failure to maintain directional control during takeoff in a crosswind.Aug 20, 2018 · N6727A · Substantial damage