NTSB investigations, GA

8 cases where NTSB found Rough terrain.

Cases per year

20082026
NTSB investigations, GA per year, 2008–2026: 8 cases
20082
20112
20131
20141
20161
20211

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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03021015'))
  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 ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.Sep 25, 2021 · N5656H · Substantial damageNTSB GAA17CA058Accident · No injuriesData collectionFinal reportBeech 58TC · Valdosta, GAThe pilot’s failure to ensure that adequate fuel was onboard for the flight, which resulted in fuel exhaustion and the loss of engine power.Nov 5, 2016 · N2CH · Substantial damageNTSB ERA14LA089Accident · No injuriesLimited investigationFinal reportFK Lightplanes FK9 ELA SW · Canton, GAA partial loss of engine power during cruise flight due to an overly lean fuel-air mixture, which resulted from an incorrectly installed float chamber vent line and led to a subsequent off-airport landing.Jan 4, 2014 · N611SP · Substantial damageNTSB ERA13FA256Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Macon, GAA total loss of engine power due to oil starvation for reasons that could not be determined due to extensive postcrash fire and heat damage to the engine components.May 27, 2013 · N4489F · DestroyedNTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.Nov 26, 2011 · N5AW · Substantial damageNTSB ERA11LA307Accident · No injuriesLimited investigationFinal reportFlightstar Flightstar II · Grantville, GAA total loss of engine power while maneuvering due to a seized piston.May 22, 2011 · N194PG · Substantial damageNTSB MIA08LA156Accident · Minor injuriesLimited investigationFinal reportDiamond DA-20-C1 · Peachtree City, GAA partial loss of engine power for undetermined reasons.Aug 1, 2008 · N227RD · Substantial damageNTSB NYC08LA112Accident · No injuriesLimited investigationFinal reportBeech A36 · Athens, GAThe loss of propeller thrust due to the unseating of an internal propeller hub bushing. Contributing to the accident was the manufacturer's inadequate procedure to secure the bushing.Feb 26, 2008 · N623CQ · Substantial damage