NTSB investigations, 2010, GA

8 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2010, GA per year, 2008–2026: 110 cases
20086
20095
20108
20114
20128
20132
20144
20157
20168
20179
20185
20194
20209
202110
20225
20235
20248
20252
20261

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.\"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\" = '300' 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 ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.Oct 1, 2010 · N48417 · Substantial damageNTSB ERA10CA476Accident · No injuriesData collectionFinal reportGoodman Robert Bruce RV-4 · Gainesville, GAThe pilot's failure to see and avoid marked power lines during low-level flight over a lake.Sep 12, 2010 · N311U · Substantial damageNTSB ERA10CA418Accident · No injuriesData collectionFinal reportCessna 182F · Canon, GAThe pilot’s improper recovery from a bounced landing.Aug 12, 2010 · N3562Y · Substantial damageNTSB ERA10CA339Accident · No injuriesData collectionFinal reportPiper J3C-65 · Thomaston, GAThe pilot’s failure to maintain directional control during landing.Jun 28, 2010 · N41242 · Substantial damageNTSB ERA10LA351Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Thomasville, GAThe improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.Jun 17, 2010 · N73PC · Substantial damageNTSB ERA10CA239Accident · No injuriesData collectionFinal reportNew Standard D-25 · Vidalia, GAThe pilot’s failure to maintain directional control during landing.Apr 23, 2010 · N9194 · Substantial damageNTSB ERA10CA230Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Augusta, GAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.Apr 5, 2010 · N541VB · Substantial damageNTSB ERA10LA121Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Madison, GAThe pilot’s failure to maintain directional control while landing with a tailwind.Jan 19, 2010 · N2750K · Substantial damage