NTSB investigations, 2009, GA

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

Cases per year

20082026
NTSB investigations, 2009, 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\") = 2009
    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 ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.Oct 22, 2009 · N2121J · Substantial damageNTSB ERA09CA518Accident · No injuriesData collectionFinal reportPiper PA46 · Chamblee, GAThe pilot's failure to maintain aircraft control during landing. Contributing to the accident was pilot fatigue.Sep 14, 2009 · N664RS · Substantial damageNTSB ERA09LA516Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Atlanta, GAA total loss of engine power due to a fuel system air leak as a result of a deteriorated O-ring seal in the fuel shut-off cock. Contributing to the accident was the exceedance of the suggested overhaul schedule for the fuel shut-off cock.Sep 4, 2009 · N517P · Substantial damageNTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.Aug 27, 2009 · N7339Z · Substantial damageNTSB ERA09FA487Accident · 2 fatalField investigationFinal reportSocata TB20 · Pavo, GAThe pilot’s continued visual flight into instrument meteorological conditions, with embedded intense thunderstorms, heavy rain, and severe to extreme turbulence, resulting in an in-flight separation of the left wing due to overstress.Aug 27, 2009 · N654GT · Substantial damageNTSB ERA09LA476Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fairmount, GAA total loss of engine power due to fuel starvation as a result of a contaminated fuel strainer.Aug 22, 2009 · N61022 · Substantial damageNTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.Aug 20, 2009 · N4842R · Substantial damageNTSB ERA09LA460Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Acworth, GAThe loss of engine power due to the fatigue failure of the third-stage turbine wheel airfoil.Aug 12, 2009 · N527BB · Substantial damageNTSB ERA09LA412Accident · 1 fatalLimited investigationFinal reportJames O'Bert Vari-Eze · Columbus, GAThe pilots improper fuel management, which resulted in a loss of engine power due to fuel starvation.Jul 19, 2009 · N39DX · Substantial damageNTSB ERA09LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Brinson, GAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Jul 7, 2009 · N8587S · Substantial damageNTSB ERA09LA369Accident · 2 fatalLimited investigationFinal reportP&M Quikr · Cedar Town, GAA loss of aircraft control for an undetermined reason.Jun 25, 2009 · N433PM · Substantial damageNTSB ERA09CA366Accident · Minor injuriesData collectionFinal reportCessna 210-5(205) · Porterdale, GAThe loss of engine power due to fuel exhaustion as a result of the pilot's use of improper fuel caps. Contributing to the accident was the pilot’s selection of an unsuitable area for landing.Jun 24, 2009 · N8272Z · Substantial damageNTSB ERA09CA268Accident · No injuriesData collectionFinal reportDiamond DA20 · Townsend, GAThe pilot's failure to maintain directional control during a landing roll with a crosswind. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Apr 25, 2009 · N561CS · Substantial damageNTSB ERA09LA231Accident · 1 fatalLimited investigationFinal reportHoward William C KR-2 · Valdosta, GAAn in-flight fire for undetermined reasons.Apr 4, 2009 · N456CH · DestroyedNTSB ERA09LA222Accident · Serious injuriesLimited investigationFinal reportRogers Kenneth J Flaglor Scooter · Griffin, GAA total loss of engine power due to the failure of the engine-driven fuel pump. Contributing to the accident was unsuitable terrain for a forced landing and the pilot’s preexisting medical condition.Mar 30, 2009 · N3248Q · Substantial damageNTSB ERA09FA185Accident · 3 fatalField investigationFinal reportCessna 182P · Carrollton, GAThe pilot's decision to continue visual flight rules flight into an area of reduced visibility weather conditions, which resulted in disorientation and subsequent loss of aircraft control.Mar 8, 2009 · N1913M · DestroyedNTSB ERA09LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, GAA total loss of engine power for an undetermined reason.Jan 17, 2009 · N9459J · Substantial damageNTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.Jan 12, 2009 · N57N · Substantial damage