NTSB investigations, 2008, MT

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

Cases per year

20082026
NTSB investigations, 2008, MT per year, 2008–2026: 90 cases
200810
20094
20105
20114
20126
20137
20146
20156
20168
20173
20184
20196
20202
20216
20222
20234
20241
20251
20265

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\") = 2008
    AND c.\"eventStateOrRegion\" = 'MT' 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 WPR09CA063Accident · No injuriesData collectionFinal reportCessna 180C · Great Falls, MTThe pilot's failure to maintain directional control during the landing roll.Dec 21, 2008 · C-FIWA · Substantial damageNTSB SEA08CA201Accident · No injuriesData collectionFinal reportStinson 108-1 · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing.Sep 16, 2008 · N8963K · Substantial damageNTSB LAX08CA287Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Dillon, MTThe pilot-certificated passenger's failure to maintain directional control during landing and the pilot's delayed remedial action and inadequate supervision.Aug 31, 2008 · N4143D · Substantial damageNTSB SEA08CA169Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Helena, MTThe failure of the pilot receiving instruction to adequately compensate for the crosswind condition and failure to maintain directional control. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.Jul 27, 2008 · N50476 · Substantial damageNTSB SEA08CA166Accident · No injuriesData collectionFinal reportCessna 180 · Lewistown, MTThe pilot's inadequate compensation for the variable and gusting winds, and his failure to maintain directional control. Contributing to the accident were variable winds that were gusting to 25 knots.Jul 20, 2008 · N1710C · Substantial damageNTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.May 10, 2008 · N8103E · Substantial damageNTSB SEA08CA118Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Libby, MTThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during the landing rollout.May 2, 2008 · N1083 · Substantial damageNTSB SEA08CA102Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Three Forks, MTThe pilot's inadequate compensation for wind conditions during landing. A gusting crosswind was a contributing factor.Apr 3, 2008 · N1139C · Substantial damageNTSB LAX08CA062Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kalispell, MTThe pilot's failure to maintain alignment with the runway while landing and executing a go-around.Feb 17, 2008 · N5481T · Substantial damageNTSB SEA08CA074Accident · No injuriesData collectionFinal reportMaule M-7-235 · Red Lodge, MTThe pilot's inadequate compensation for the crosswind and failure to maintain directional control during the landing roll.Feb 10, 2008 · N997RM · Substantial damage