Major NTSB investigations, GA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 2 |
| 2000 | 1 |
| 2006 | 1 |
| 2013 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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.
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB 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…NTSB CHI06MA115Accident · 1 fatalMajor investigationFinal reportCessna 210A · Ludville, GAThe pilot's failure to obtain updated en route weather information, which resulted in his continued instrument flight into a widespread area of severe convective activity, and the air traffic controller's failure to provide adverse weather avoidance…NTSB DCA01MA005Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9 · Atlanta, GAthe leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…NTSB DCA99MA007Accident · Minor injuriesMajor investigationFinal reportBoeing 737-200 · Atlanta, GA(1) the capping of the incorrect hydraulic line by mechanics, which led to the failure of hydraulic system A; (2) the mechanics' lack of experience working with the Boeing 737 hydraulic system; and (3) the maintenance controller's failure to ascertain more…NTSB DCA98MA045Accident · Serious injuriesMajor investigationFinal reportDouglas DC-9-32 · Calhoun, GAThe failure of the flight crew to maintain adequate separation from hazardous meteorological conditions. Factors contributing to the accident were: (1) the failure of AirTran Airlines to provide adequate crewmember training and guidance regarding hazardous…NTSB DCA95MA054Accident · 8 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Carrollton, GAthe in-flight fatigue fracture and separation of a propeller blade resulting in distortion of the left engine nacelle, causing excessive drag, loss of wing lift, and reduced directional control of the airplane. The fracture was caused by a fatigue crack from…NTSB ATL95MA106Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-9-32 · Atlanta, GAfailure of Turk Hava Yollari maintenance and inspection personnel to perform a proper inspection of a 7th stage high compressor disc, thus allowing the detectable crack to grow to a length at which the disc ruptured, under normal operating conditions,…NTSB ATL93MA055Accident · 7 fatalMajor investigationFinal reportLockheed L382E-44K-20 · Marietta, GADisengagement of the rudder fly-by-wire flight control system resulting in a total loss of rudder control capability while conducting ground minimum control speed tests. The disengagement was a result of the inadequate design of the rudder's integrated…NTSB DCA92MA011Accident · 9 fatalMajor investigationFinal reportBeech 400 · Rome, GAThe captain's decision to initiate visual flight into an area of known mountainous terrain and low ceilings and the failure of the flightcrew to maintain awareness of their proximity to the terrain.NTSB DCA91MA033Accident · 23 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Brunswick, GAThe loss of control in flight as a result of a malfunction of the left engine propeller control unit which allowed the propeller blade angles to go below the flight idle position. Contributing to the accident was the deficient design of the propeller control…NTSB DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBeech A100 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…NTSB ATL86MA011Accident · 2 fatalMajor investigationFinal reportBeech 58P · Forsyth, GAThe flt was normal until the plt was tracking inbnd on the atlanta (atl) 128 deg radial twd the husky intxn & was told to make a 360 deg turn for spacing. After aprx 270 deg of turn, the plt was clrd to turn back inbnd, join the atl 128 deg radial & cont to…NTSB ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…NTSB ATL85MA083Accident · No injuriesMajor investigationFinal reportLockheed 188C · Dobbins Afb, GADuring gear retraction after takeoff, the right main gear became jammed in a partially retracted psn & the respective in-transit gear light would not extinguish. Attempts to recycle the gear were unsuccessful. The flt crew diverted to atlanta, GA; then…NTSB ATL84MA296Accident · Serious injuriesMajor investigationFinal reportPiper PA-31T3 · Atlanta, GAThe normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to…NTSB ATL84MA208Accident · 5 fatalMajor investigationFinal reportPiper PA-32-300 · Canton, GAThe acft with a student plt at the controls had an in-flt breakup during a night x-country flt. During a preflt wx briefing, he was advised that VFR flt was not recommended. The plt terminated the conversation before the briefing was completed. While in flt,…NTSB ATL84MA148Accident · 6 fatalMajor investigationFinal reportPiper PA-34-220T · Mt Airy, GADrg arrival, the plt reqd & rcvd clnc to fly drct to the unctld arpt, altho the arpt had no terminal nav fac & the acft had no RNAV type equip. Nrby at athens, the 0745 spl wx OBS was in part: indef cig, sky obscd, vsby 1/4 mi with fog. At 0801, atl ctr clrd…NTSB DCA83AA022Accident · 4 fatalFinal reportMitsubishi MU-2B-60 · Jeffersonville, GAThe acft was on the return portion of a round trip flt, hauling canceled bank checks. When they boarded before takeoff, the plt's wife, who was not a plt, occupied the r front seat & his 2 daughter's, ages 4 & 6, were in the passenger seats. Previous legs of…NTSB DCA82AA020Accident · 4 fatalFinal reportGates Learjet 23 · Near Savannah, GAThe flt was cleared to descend from FL410 to FL390. The flightcrew acknowledged the clearance & ATC observed the radar target descend. The acft suddenly pitched up when within 600 ft of FL390 & climbed. The pitchup was followed by two pitch oscillations which…NTSB DCA77AA015Accident · 62 fatalClosedDouglas DC-9 · New Hope, GANTSB MIA73AM087Accident · 7 fatalClosedGates Lear 24 · Atlanta, GANTSB MIA72IM055Incident · No injuriesClosedBoeing 727 · Atlanta, GANTSB MIA70AM093Accident · 1 fatalClosedMartin 404 · Atlanta, GANTSB DCA70A0001Accident · 14 fatalClosedBeech B99 · Monroe, GA