NTSB investigations, 1987, TN
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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
| 1962 | 1 |
|---|---|
| 1963 | 2 |
| 1964 | 74 |
| 1965 | 56 |
| 1966 | 58 |
| 1967 | 58 |
| 1968 | 51 |
| 1969 | 57 |
| 1970 | 56 |
| 1971 | 58 |
| 1972 | 56 |
| 1973 | 62 |
| 1974 | 39 |
| 1975 | 56 |
| 1976 | 53 |
| 1977 | 43 |
| 1978 | 40 |
| 1979 | 38 |
| 1980 | 41 |
| 1981 | 43 |
| 1982 | 28 |
| 1983 | 41 |
| 1984 | 35 |
| 1985 | 34 |
| 1986 | 36 |
| 1987 | 37 |
| 1988 | 36 |
| 1989 | 26 |
| 1990 | 29 |
| 1991 | 26 |
| 1992 | 25 |
| 1993 | 26 |
| 1994 | 27 |
| 1995 | 38 |
| 1996 | 33 |
| 1997 | 34 |
| 1998 | 21 |
| 1999 | 28 |
| 2000 | 26 |
| 2001 | 25 |
| 2002 | 23 |
| 2003 | 35 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 19 |
| 2007 | 23 |
| 2008 | 24 |
| 2009 | 21 |
| 2010 | 25 |
| 2011 | 23 |
| 2012 | 29 |
| 2013 | 17 |
| 2014 | 24 |
| 2015 | 24 |
| 2016 | 25 |
| 2017 | 20 |
| 2018 | 13 |
| 2019 | 24 |
| 2020 | 24 |
| 2021 | 20 |
| 2022 | 26 |
| 2023 | 26 |
| 2024 | 29 |
| 2025 | 29 |
| 2026 | 15 |
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 year(c.\"eventDate\") = 1987
AND c.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 1987 AND c."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA' 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 ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…NTSB ATL88LA063Accident · No injuriesLimited investigationFinal reportCessna 150K · Portland, TNThe student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,…NTSB ATL88LA054Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Sewanee, TNThe plt rprtd that he obtained a wx briefing before takeoff & that the wx at his intended destination was rprtd as marginal. While en route, he encountered wx and climbed above it. Aprx 4 hrs after departure, he became concerned about the remaining fuel…NTSB ATL88FA046Accident · 1 fatalField investigationFinal reportCessna 152 · Oliver Springs, TNThe plt had deptd from a small airport nr kingston, TN mid afternoon and had landed at another about 30 nmi to the NE. He remained on the ground 30-45 min departing between 1530-1545. According to info gathered, the aircraft was observed to fly over the oak…NTSB ATL88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Murfreesboro, TNThe rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using…NTSB ATL88LA050Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Union City, TNThe plt rprtd the acft started to veer off the rwy after a 'rough' lndg. He atmtd to steer the plane with the steering control, but it would not respond. Subsequently, the acft veered off the rwy. About 50' to the side of the rwy, the nose gear hit a hole &…NTSB ATL88LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Wartburg, TNThe aircraft touched down hard on the 1300 foot grass strip and began to porpoise. The pilot attempted to go-around but was unable to gain sufficient altitude to avoid striking a power line. The plt did not file an acc report.NTSB ATL88LA018Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Whitwell, TNThe glider plt made an off-arpt ldg after realizing that he didn't have enough altitude to return to his departure point. During ldg rollout on uneven terrain, one of the wingtips contacted the terrain and the glider ground-looped.NTSB ATL88FA007Accident · 1 fatalField investigationFinal reportBeech HA-1 · Memphis, TNAfter t/o PIC was told by twr that tail stand, used to prevent acft from tipping on tail when loaded, was still attached to acft. PIC req teardrop turn back to departure rwy. Approach controller stated he saw mode c indication of 700'. A/p elev. Is 332'. Acft…NTSB ATL88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Collegedale, TNThe airplane touched down while the ldg gear were extending. A witness reported that the acft began the ldg flare with the gear completely retracted, and that the gear began to extend when the airplane was 3-4 ft above the rwy. The main ldg gear contacted the…NTSB ATL87LA266Accident · No injuriesLimited investigationFinal reportCessna 172H · Chuckey, TNThe plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the…NTSB ATL87LA265Accident · No injuriesLimited investigationFinal reportCessna 172 · Murfreesboro, TNDuring a practice landing the aircraft bounced three times which resulted in the failure of the nose gear structural support. The pilot said that he experienced gusty wind conditions prior to touchdown. The pilot did not properly compensate for or anticipate…NTSB ATL87LA256Accident · No injuriesLimited investigationFinal reportHughes 269A · Morristown, TNOne CFI was demonstrating his procedures for autorotations with power recovery to his employer who was also a CFI. This was to insure standardization within the helicopter pilot school. The autorotation was entered from about 700 feet AGL to the departure…NTSB ATL87DLT04Accident · No injuriesFinal reportNord SV4C · Lebanon, TNThe pilot stated while on final approach he allowed the aircraft to get too low and slow. He realized it was too late to recover and the aircraft collided with a tree.NTSB ATL87LA242Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Joseph, TNThe plt took off from an arpt that was aprx 27 mi west of his destn. After takeoff, he rcvd an inflt wx briefing & flew north of a line of thunderstorms (tstms). Before lndg at the destn, he noted tstm activity south of the arpt, but contd the apch & lndd.…NTSB ATL87LA231Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Knoxville, TNThe plt rprtd that drg takeoff, the acft clbd normally for about 100 to 150 ft, then the eng lost pwr w/o warning. He switched fuel tanks & tried to restart the eng, but was unable. The acft was lndd & sank in a river, short of an open fld. When the acft was…NTSB ATL87LA219Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-36A · Winchester, TNThe pilot stated he circled over the airport to check for traffic then made a turn to base. He was too near the runway and too high for a normal approach. The pilot used full flaps and decreased power; however, the aircraft began to descend rapidly. The…NTSB ATL87DLT03Accident · 1 fatalFinal reportBurkhart Grob G102-111B · Memphis, TNGlider tow rope released at about 200FT following t/o. glider made rt turn followed by stall/spiral which continued until ground impact. Tow pilot saw glider pilot's hat falling to ground just after tow rope was released by glider pilot. Glider canopy was…NTSB ATL87DLT02Accident · Minor injuriesFinal reportGulfstream-Schweizer G164B-600 · Union City, TNThe ag-acft lost power while turning, shortly after departure from a field. During the subsequent forced ldg, the acft struck a fence and nosed over. The engine was torn from the acft during the impact sequence. Post-crash examination of the acft engine by an…NTSB ATL87IA191Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Nashville, TNThere was hvy traffic at the Nashville metro arpt when air midwest flt 4530 (Swearingen SA-226TC, N256AM) arrived drg a morning flt. The flt crew made an ILS apch to rwy 31 as another acft (American flt 130) was on an apch to rwy 2L. The 2 rwys intersected nr…NTSB ATL87LA190Accident · No injuriesLimited investigationFinal reportCessna A188B · Dyersburg, TNDrg a spraying opn, the plt returned to land on an asphalt hiway & reload with chemicals. As he flared to lnd, the eng accelerated to aprx '2/3 throttle' with no throttle movement. He believed the throttle was in the off psn when this occurred. A nose hi…NTSB ATL87IA179Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Nashville, TNAt aprx 2211 CDT, delta flt 314 (Boeing 727, N482DA) was clrd to taxi to rwy 31 with info india. Info india indcd rwy 31WAS active. Soon thereafter, southwest flt 715 (Boeing 737, N50SW) reqd & recd taxi clnc to rwy 13 for tkof. To accommo-date incoming…NTSB ATL87FA160Accident · 1 fatalField investigationFinal reportGlobe Globe GC-1A · Pleasant View, TNUpon returning from a short local area flight the aircraft was observed as it buzzed the owners private airstrip, where the passenger waved to his family. The plt pulled up sharply and made another low pass. This pullup was straight ahead. The climb peaked…NTSB ATL87LA154Accident · No injuriesLimited investigationFinal reportCessna T210N · Murfreesboro, TNWhile climbing thru 6,000 ft, the plt heard & felt a 'thud' & then realized the eng had failed. Drg a subsequent emerg landing in a muddy corn field, the nose gear mired in soft terrain & the acft nosed over. A teardown of the eng revealed the crankshaft was…NTSB ATL87FA136Accident · 2 fatalField investigationFinal reportPiper J4A · Collierville, TNIt was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…NTSB ATL87LA119Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Clarksville, TNThe pilot lost tail rotor control in cruise flight after the tail rotor drive shaft separated. The tail rotor system had sustained previous damage about 4 years prior to this accident when, while being operated as a public use aircraft, the helicopter skidded…NTSB ATL87LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Waverly, TNThe plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…NTSB ATL87DLT01Accident · No injuriesFinal reportSchleicher ASK-21 · Eagleville, TNDuring a landing attempt, N174KS collided with a treeline on final approach to the airport. The instructor reported that the flight was normal until the student encountered a downdraft on final approach. The instructor took control of the controls, but was…NTSB ATL87LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lebanon, TNThe plt reported that he made a VFR pattern for landing on rwy 18 at his destination. The wind was 'hard' and 'straight down the rwy.' He reported that, 'all of a sudden it seemed as though the wind quit and the airplane started to fall.' The acft hit hard…NTSB ATL87LA103Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Oliver Springs, TNThe plt reported that the acft encountered heavy turbulence and a strong gusty x-wind close to the ground while on short final to his private airstrip. The plt attempted a go-around and encountered 'extremely heavy turbulence' during a turning climbout…NTSB ATL87LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shelbyville, TNThe acft was being operated from a dirt road that was reportedly only slightly wider than the acft. The plt reported that he had just completed a spraying operation and was about to put out some fertilizer. He stated that he installed the spreader, but left…NTSB ATL87LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that…NTSB ATL87FA087Accident · 1 fatalField investigationFinal reportCessna 150H · Oneida, TNThe pilot contacted the fss several times during the morning for weather along his proposed route of flight. Shortly after lunch he departed without a flight plan. He reported to one fss that he was VFR only but continued although VFR was not recommended for…NTSB ATL87LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hixson, TNDuring ldg roll on solo instructional flt, stu plt stated that he applied hand brakes and acft swerved to the left. Skid marks found at the site led from near the rwy centerline to a parked C-172 struck during the sequence. Subsequent inspection of the brake…NTSB ATL87FA074Accident · 2 fatalField investigationFinal reportCessna 182P · Crossville, TNThe rental acft collided with the top of a mountain at substantial airspeed in level flt. VFR flt was not recommended by fss due to low ceilings, rain and fog. No flt plan was filed. The plt had not logged a flt for a five month period prior to the accident.…NTSB ATL87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Nashville, TNThe plt reported that he conducted an ILS appch behind mixed jet and turboprop traffic; the acft encountered an 'extreme downdraft' while on appch and the acft vertical speed went from about 500 fpm to about 1200 fpm. He attempted to recover by adding full…NTSB ATL87FA064Accident · 2 fatalField investigationFinal reportCessna 310P · Memphis, TNThe plt reported an engine problem inside the outer marker to runway 31. The acft impacted the ground in a nose low attitude. The wreckage examination failed to disclose any system malfunction or failure. The acft was destroyed by impact forces, and a post…