NTSB investigations, 2008, GA

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

Cases per year

20082026
NTSB investigations, 2008, GA per year, 2008–2026: 86 cases
20089
20092
20108
20112
20125
20133
20142
20156
20166
20178
20186
20195
20205
20214
20224
20235
20242
20252
20262

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\" = 'GA' 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 ERA09CA118Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Brunswick, GAThe pilot's failure to maintain control of the airplane during the landing flare. Contributing to the accident were the gusting winds.Dec 31, 2008 · N7138L · Substantial damageNTSB NYC08CA283Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Cleveland, GAThe pilot's improper decision to land with a tailwind, and his failure to maintain aircraft control during the landing. Contributing to the accident was the tailwind.Aug 15, 2008 · N8906D · Substantial damageNTSB NYC08LA258Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Atlanta, GAThe pilot's improper flare during landing.Jul 26, 2008 · N925LA · Substantial damageNTSB LAX08CA148Accident · No injuriesData collectionFinal reportCessna 150H · Augusta, GAThe pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.May 20, 2008 · N7050S · Substantial damageNTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.Apr 3, 2008 · N1755T · Substantial damageNTSB NYC08CA108Accident · No injuriesData collectionFinal reportAviat A-1B · Winder, GAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the gusty crosswind condition.Feb 19, 2008 · N47EA · Substantial damageNTSB NYC08CA105Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll.Feb 19, 2008 · N8202Y · Substantial damageNTSB MIA08CA047Accident · No injuriesData collectionFinal reportCessna 150J · Dawson, GAThe pilot's failure to maintain directional control during landing roll out.Jan 28, 2008 · N51367 · Substantial damageNTSB MIA08CA042Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Atlanta, GAThe failure of the pilot-in-command to maintain directional control of the airplane during landing.Jan 14, 2008 · N3528W · Substantial damage