Fatal NTSB investigations, 2002, GA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
Fatal NTSB investigations, 2002, GA per year, 1964–2026: 759 cases
19646
196512
196611
196715
196819
196920
197024
197121
197225
197318
197417
197511
197620
197721
197817
197914
198019
198114
198219
198317
198415
198512
198612
198712
19887
198916
199012
199113
199210
199315
19947
199512
199610
199711
19987
19999
200010
200112
200213
200316
200411
20056
200611
200710
20087
20099
20108
201110
201212
20136
20149
20158
20167
20177
20189
20198
20207
202111
20228
202310
20246
20253
20265

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.Dec 21, 2002 · N47420 · DestroyedNTSB ATL03FA017Accident · 1 fatalField investigationFinal reportCessna 182Q · Cornelia, GAThe pilot's failure to follow IFR approach procedures and continue below the minimum descent altitude, which resulted in an inflight collision with trees, and the ground. A factor was the pilot's impairment from a prescription drug.Nov 20, 2002 · N58GH · Substantial damageNTSB ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.Oct 24, 2002 · N73CR · DestroyedNTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.Aug 15, 2002 · N5603G · DestroyedNTSB MIA02LA115Accident · 2 fatalLimited investigationFinal reportBailey Dragon Fly · Trenton, GAthe pilot-in-command's failure to maintain airspeed while maneuvering, which resulted in the airplane stalling, spinning, and impacting with the ground.Jun 20, 2002 · UNREG · DestroyedNTSB MIA02LA110Accident · 1 fatalLimited investigationFinal reportHarrison Pietenpol Air Camper · Bainbridge, GAa loss of power due to the passenger's inadvertent deactivation and restricting the movement of the throttle, which resulted in a forced landing and subsequent impact with trees.Jun 13, 2002 · N7224X · DestroyedNTSB ATL02FA104Accident · 3 fatalField investigationFinal reportCessna 172C · Ball Ground, GAThe flight instructor's failure to maintain adequate obstacle clearance, which resulted in an inflight collision with trees.May 23, 2002 · N1479Y · DestroyedNTSB MIA02LA093Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200-Saeta · Perry, GAThe pilots failure to maintain airspeed while performing a turn at a low altitude, which resulted in a inadvertent stall, an uncontrolled descent, and an impact with trees and terrain.May 5, 2002 · N2000G · DestroyedNTSB ATL02FA072Accident · 2 fatalField investigationFinal reportNorth American T-6-AT6D · Gainesville, GAA loss of engine power following a supercharger bearing failure and subsequent collision with the ground while maneuvering for an emergency landing.Apr 1, 2002 · N7471C · Substantial damageNTSB ATL02FA062Accident · 2 fatalField investigationFinal reportEurocopter France AS355 F1 · Savannah, GAThe pilot's failure to follow operating procedures and, experienced spatial disorientation while attempting a night landing to an offshore platform. A factor was a dark night.Mar 9, 2002 · N355D · Substantial damageNTSB ATL02FA059Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Macon, GAThe pilot's failure to maintain clearance from a tree while maneuvering after takeoff.Mar 4, 2002 · N41340 · Substantial damageNTSB ATL02FA057Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hamilton, GAThe loss of engine power for undetermined reasons.Feb 28, 2002 · N33584 · Substantial damageNTSB ATL02FA043Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Atlanta, GAThe pilot experienced spatial disorientation that resulted in the loss of control.Feb 6, 2002 · N4105W · Destroyed