Fatal NTSB investigations, 2000, 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, 2000, 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\") = 2000
    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 ATL00FA082Accident · 1 fatalField investigationFinal reportBeech B60 · Austell, GAThe pilot's failure to preflight plan adequate fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.Aug 19, 2000 · N8WD · Substantial damageNTSB ATL00FA081Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Lumber City, GAPilot's failure to follow instrument procedures and descended below approach minimums and collided with trees. A factor was low clouds.Aug 15, 2000 · N801MW · DestroyedNTSB ATL00FA079Accident · 3 fatalField investigationFinal reportCessna 172H · Peachtree City, GAThe pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.Aug 12, 2000 · N1749F · Substantial damageNTSB ATL00LA078Accident · 1 fatalLimited investigationFinal reportSolo Wings Aquilla · Chatsworth, GAThe pilot's failure to maintain clearance from trees while maneuvering that resulted in the collision with trees and the ground.Aug 4, 2000 · UNREG · DestroyedNTSB ATL00FA075Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Augusta, GAImproper preflight planning/preparation by the pilot, which resulted in taking off with the airplane exceeding the weight and balance limitations. Factors to the accident were the improper loading of the airplane, taking off from a short, up sloping runway…Aug 4, 2000 · N198PM · DestroyedNTSB ATL00FA069Accident · 3 fatalField investigationFinal reportEurocopter AS350B · Sumner, GAThe pilot experienced spatial disorientation, which resulted in a loss of control of the helicopter. Contributing factors was the dark night.Jul 24, 2000 · N911AM · DestroyedNTSB MIA00LA228Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Clyo, GAThe failure of the pilot to maintain control of the aircraft due to impairment by use of drugs, and the resultant uncontrolled descent and in-flight collision with the terrain.Jul 23, 2000 · UNREG · DestroyedNTSB ATL00LA036Accident · 2 fatalLimited investigationFinal reportTrike Unknown · Dalton, GAThe pilot's failure to maintain appropriate clearance with objects during final approach to landing. A factor was the tree.Mar 7, 2000 · NONE · DestroyedNTSB ATL00FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Chamblee, GAThe S76 helicopter pilot's failure to follow ATC landing sequence clearance, which resulted in the PA-28's encounter with the helicopters wake turbulence. A factor was the air traffic controllers clearance procedure.Feb 15, 2000 · N8447Y · Substantial damageNTSB ATL00FA023Accident · 2 fatalField investigationFinal reportBeech 23 · Macon, GAThe loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.Jan 8, 2000 · N2336Z · Destroyed