NTSB investigations, 2013, GA

13 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2013, GA per year, 2008–2026: 311 cases
200826
200918
201022
201122
201226
201313
201421
201517
201627
201717
201818
201913
20206
202115
202213
202316
202413
20255
20263

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\") = 2013
    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\" = '470' 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 ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…Dec 3, 2013 · N87NF · DestroyedNTSB ERA14FA002Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Tifton, GAThe noninstrument-rated pilot’s improper decision to continue visual flight rules flight into known instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Oct 18, 2013 · N11ML · DestroyedNTSB ERA13CA435Accident · Minor injuriesData collectionFinal reportAeronca 65 CA · Thomaston, GAThe pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.Sep 30, 2013 · N33879 · Substantial damageNTSB ERA13CA422Accident · No injuriesData collectionFinal reportUniversal Stinson 108 1 · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing, resulting in a ground loop, runway excursion, and structural damage to the right wing.Sep 19, 2013 · N8384K · Substantial damageNTSB ERA13CA417Accident · Serious injuriesData collectionFinal reportMiller/Culpepper Christen Eagle II · Blythe, GAThe pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.Sep 14, 2013 · N887AS · 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 ERA13LA252Accident · No injuriesLimited investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in the airplane being loaded in excess of its maximum gross weight at an aft center of gravity for a takeoff with a quartering tailwind and high-density altitude conditions, all of which degraded the…May 23, 2013 · N8225T · Substantial damageNTSB ERA13CA250Accident · Minor injuriesData collectionFinal reportThomas David W Rans S-12 XL · Cleveland, GAThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.May 18, 2013 · N81788 · Substantial damageNTSB ERA13CA222Accident · No injuriesData collectionFinal reportCirrus Design SR22T · Milledgeville, GAThe student pilot’s failure to maintain a proper approach path for landing and the flight instructor’s delayed remedial action, which resulted in a runway undershoot and collision with a taxiway sign.Apr 24, 2013 · N228DF · Substantial damageNTSB ERA13CA150Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe pilot's failure to maintain directional control while landing in a strong, gusting crosswind.Feb 28, 2013 · N135CD · Substantial damageNTSB ERA13MA139Accident · 5 fatalMajor investigationFinal reportBeech 390 · Thomson, GAThe pilot's failure to follow airplane flight manual procedures for an antiskid failure in flight and his failure to immediately retract the lift dump after he elected to attempt a go-around on the runway. Contributing to the accident were the pilot's lack of…Feb 21, 2013 · N777VG · DestroyedNTSB ERA13LA126Accident · No injuriesLimited investigationFinal reportMccowan Steve A Shttd · Montrose, GAA total loss of engine power during cruise flight due to the separation of the No. 2 piston connecting rod.Feb 4, 2013 · N4201S · Substantial damageNTSB ERA13LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Winder, GAA total loss of engine power due to a cracked fuel pump line fitting O-ring seal at the inlet to the engine driven fuel pump. Contributing to the accident was the failure of the aircraft operator to comply with the engine manufacturer’s recommended time…Jan 12, 2013 · N3898T · Substantial damage