NTSB investigations, 2018, ID

9 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2018, ID per year, 2008–2026: 161 cases
20089
20096
201011
20114
201212
20136
20146
20157
20167
201710
20189
201912
20207
202113
20229
202312
202412
20256
20263

Latest cases

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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
    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 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 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 GAA18CA501Accident · No injuriesData collectionFinal reportCessna A185 · McCall, IDThe disconnection of the brake cylinder actuator rod, which resulted in the pilot’s inability to maintain directional control during the landing roll.Aug 20, 2018 · N93039 · Substantial damageNTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.Aug 1, 2018 · N57477 · Substantial damageNTSB GAA18CA315Accident · No injuriesData collectionFinal reportJim Green CCX · Couer D'Alene, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.May 28, 2018 · N18JG · Substantial damageNTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.May 28, 2018 · N2004U · Substantial damageNTSB GAA18CA245Accident · No injuriesData collectionFinal reportAyres S2R · Weipee, IDThe pilot’s failure to maintain directional control during the takeoff roll.Apr 18, 2018 · N40170 · Substantial damageNTSB GAA18CA188Accident · No injuriesData collectionFinal reportPiper J3C · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Mar 30, 2018 · N24751 · Substantial damageNTSB GAA18CA106Accident · No injuriesData collectionFinal reportCessna A185 · Lowman, IDThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.Jan 12, 2018 · N2W · Substantial damage