NTSB investigations, 2008, GA

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

Cases per year

20082026
NTSB investigations, 2008, 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\") = 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\" = '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 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 ERA09FA005Accident · Minor injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Swainsboro, GAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Oct 5, 2008 · N742EA · Substantial damageNTSB MIA08LA187Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlanta, GAThe loss of pitch control due to slippage of the elevator control cable resulting from the maintenance personnel’s improper installation and inspection of the cable.Sep 7, 2008 · N105F · Substantial damageNTSB NYC08LA273Accident · No injuriesLimited investigationFinal reportOuzts Rodney Rutan-LongEZ · Winder, GAThe failure of the left brake due to contamination of the brake fluid.Aug 6, 2008 · N622EZ · 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 MIA08FA141Accident · 1 fatalField investigationFinal reportSocata TBM700 · Kennesaw, GAThe pilot’s failure to maintain airspeed during final approach resulting in an aerodynamic stall.Jul 15, 2008 · N484RJ · Substantial damageNTSB NYC08IA244Incident · No injuriesIncident investigationFinal reportAgusta A109E · Augusta, GAThe lack of available engine power and subsequent loss of rotor rpm due to the pilot’s departing with one engine at idle. Contributing to the incident was a corroded engine control wiring harness.Jul 11, 2008 · N109DU · Minor damageNTSB MIA08CA117Accident · No injuriesData collectionFinal reportPiper J3C-65 · Fayetteville, GAThe pilot's failure to maintain control of the airplane during climbout. Contributing to the accident was the pilot's relinquish of control to a non-certificated pilot.Jun 10, 2008 · N35702 · Substantial damageNTSB MIA08CA104Accident · No injuriesData collectionFinal reportCessna 172M · Savannah, GAThe pilot's failure to maintain directional control on landing touchdown with a crosswind.May 23, 2008 · N73471 · Substantial damageNTSB CHI08LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wrightsville, GAThe pilot's failure to maintain control during takeoff. Contributing to the accident were the gusty winds.May 18, 2008 · N4553J · Substantial damageNTSB MIA08LA101Accident · No injuriesLimited investigationFinal reportHigher Class Sport Hornet · Appling, GAThe interruption of fuel flow for undetermined reasons, resulting in a loss of engine power during flight.May 4, 2008 · N104HC · Substantial damageNTSB NYC08FA174Accident · 3 fatalField investigationFinal reportBeech A35 · Americus, GAThe pilot's failure to maintain control during the initial climb for undetermined reasons.May 3, 2008 · N546B · Substantial damageNTSB NYC08LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Richmond Hill, GAThe loss of engine power during cruise flight due to fuel exhaustion, and the pilot's inadequate preflight inspection.Apr 30, 2008 · N5426W · Substantial damageNTSB NYC08LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ellijay, GAA loss of engine power for undetermined reasons.Apr 23, 2008 · N333KQ · 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 NYC08LA150Accident · Serious injuriesLimited investigationFinal reportHatle Rans S-12 · Rincon, GAThe pilot's failure to maintain airspeed during initial climb which led to an aerodynamic stall.Mar 29, 2008 · N6189 · Substantial damageNTSB NYC08FA143Accident · 2 fatalField investigationFinal reportBeech BE-76 · Rome, GAThe flight instructor's failure to maintain aircraft control while maneuvering during a simulated engine failure. Contributing to the accident was the flight instructor's lack of total experience as a multiengine flight instructor.Mar 21, 2008 · N184AA · Substantial damageNTSB NYC08CA146Accident · No injuriesData collectionFinal reportQuad City Ultralight Challenger I · Rayle, GAA loss of engine power during cruise flight for undetermined reasons.Mar 16, 2008 · UNREG · 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 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 NYC08CA096Accident · No injuriesData collectionFinal reportMaule M-7-260C · Cumming, GAThe pilot's failure to maintain directional control during an aborted landing. Contributing to the accident were the gusty crosswind conditions.Feb 10, 2008 · N721H · Substantial damageNTSB MIA08CA055Accident · Minor injuriesData collectionFinal reportWilliam P. Crowell Genesis · Warm Springs, GAThe failure of the pilot to maintain directional control of the airplane during final approach.Feb 8, 2008 · N3449 · Substantial damageNTSB MIA08CA049Accident · Serious injuriesData collectionFinal reportAirborne Redback · Jefferson, GAThe failure of the pilot-in-command to maintain control of the airplane and his poor weather evaluation before attempting to taxi the airplane. A factor in the accident was the failure of airport personnel to correct the inaccurate wind information reported…Jan 30, 2008 · N1847 · 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