Fatal NTSB investigations, 2010

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

Cases per year

20082026
Fatal NTSB investigations, 2010 per year, 2008–2026: 70 cases
20083
20095
20105
20113
20124
20131
20142
20151
20163
20172
20185
20193
20204
20215
20228
20238
20246
20252

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\") = 2010
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 WPR10LA462Accident · 1 fatalLimited investigationFinal reportCosmos Phase II · El Mirage, CAThe pilot's improper preflight and starting procedures, which resulted in an inadvertent takeoff with the gust lock still installed.Sep 20, 2010 · N56078 · Substantial damageNTSB CEN10LA427Accident · 1 fatalLimited investigationFinal reportCessna 180 · Davant, LAThe pilot’s improper application of the flight controls and throttle during landing, which resulted in a nose over and subsequent inverted immersion in the water. Contributing to the accident was the flight instructor’s delayed remedial action and inadequate…Jul 24, 2010 · N7812K · Substantial damageNTSB ERA10LA365Accident · 1 fatalLimited investigationFinal reportTexas Air Ventures Comp AIR 8 · Mount Pleasant, SCThe pilot's failure to retrim the airplane and maintain aircraft control during an aborted landing, which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.Jul 19, 2010 · N882X · Substantial damageNTSB WPR10LA354Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe pilot's loss of directional control while attempting to move the helicopter laterally without first lifting it fully off its landing platform.Jul 16, 2010 · N944DW · Substantial damageNTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.Jul 12, 2010 · N527MJ · Substantial damage