NTSB investigations, 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, newest first
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\" = '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 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 ATL89FA081Accident · 2 fatalField investigationFinal reportCessna 172 · Hartsville, TNThe pilot allowing the aircraft to lift-off prematurly at a slow airspeed and his failure to maintain directional control before inadvertently entering a stall. Contributing to the accident was the pilot's experience level and lack of qualifications.NTSB ATL89FA054Accident · 2 fatalField investigationFinal reportAero Commander 720 · Alcoa, TNAfter encountering icing conditions in flight and experiencing problems maintaining altitudes and headings, the pilot elected to divert from his planned destination of dayton, oh to knoxville, TN. While on final approach after descending 1300 ft below minimum…NTSB ATL89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Union City, TNPIC made two sdf approaches. On the first approach he had difficulty seeing the rwy lights. The acft was aligned left of rwy and a missed approach was made. On the second approach the PIC said he had difficulty picking up any rwy lights. He landed with the…NTSB ATL89FA035Accident · 2 fatalField investigationFinal reportHughes 269C · Mohawk, TNThe helicopter had landed at a private airstrip and the instructor deplaned. The dual student remained in the helicopter with the engine running. The CFI reboarded and the student made the takeoff. Later, on downwind in traffic pattern, a witness reported a…NTSB ATL89LA029Accident · No injuriesLimited investigationFinal reportCessna 172N · Rogersville, TNThe plt reported that he was ferrying the airplane to obtain scheduled maintenance. Upon arrival over the arpt, he found that the only rwy was closed for maintenance. He then elected to land on a taxiway. He made a short-field ldg and applied the brakes…NTSB ATL89MA023Accident · 1 fatalMajor investigationFinal reportCessna 210D · Nashville, TNDrg west arr at ngt, plt was vctrd for a VFR, straight-in apch to rwy 2R & adzd of Boeing 727 off his rgt front, passingfm rgt to left. He was cautioned abt wake turbc (w/t) & replied, 'okay I see him.' Ctlr then told plt to turn inbnd & maint 'visual' with…NTSB ATL89FA020Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-31 · Memphis, TNThe acft was being taxied to the gate when its right wingtip struck a catering truck that had been driven off of the designated driving lanes & partially onto the taxiway. The flt crew rprtd that the truck was traveling in the same direction within the…NTSB ATL89LA016Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DISCUS-B · Whitwell, TNThe plt rprtd that thermal lift deteriorated drg the return leg of a x-country flt & he elected to make an off aprt lndg in a hay field. As he was on final apch on a westerly hdg, he saw a previously undetected power line across the field, which reqd a rapid…NTSB ATL89FA015Accident · 3 fatalField investigationFinal reportCessna 177A · La Follette, TNThe plt departed knoxville in VFR conds. There was an area of IFR wx to the north & northwest of knoxville. The wx was forecast to be marginal along his route of flt. The plt rprtd he wanted to depart knoxville on a heading of 360 deg & would be at 2500'. The…NTSB ATL89DLT02Accident · No injuriesFinal reportSchweizer SGU-2-22E · Benton, TNAs the student pilot was attempting a dual aerial tow flight at 100 feet AGL, he experienced difficulty in staying behind the tow plane. The instructor took over the controls and while applying full right aileron noted no aileron movement. At 300 feet AGL the…NTSB ATL89DLT01Accident · 1 fatalFinal reportCameron AIR Command · Hixson, TNWitnesses observed the gyrocopter oscillating in the pitch axis as it passed overhead in cruise flight. A 'white or shiny' object departed the gyrocopter. The aircraft then rolled right, descended and collided with the trees and ground, inverted. One…NTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…NTSB ATL89FA004Accident · 1 fatalField investigationFinal reportPiper PA-30 · La Follette, TNThe pilot reported an autopilot problem and was not able to maintain control of the airplane. The airframe components were scattered in a circular pattern. All fractures displayed overload failures. The wreckage examination failed to disclose any system or…NTSB ATL88LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Covington, TNThe plt reported that the engine suddenly began to run rough and backfire during a pipeline patrol flight at 300 ft AGL. The roughness worsened and the plt made a forced ldg on a dirt road. During rollout, one of the wings caught vegetation bordering the road…NTSB ATL88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, TNThe pilot reported that while in cruise flight he had a partial then total electrical failure. During the off- airport emergency landing on a wet, grassy field, the pilot was unable to stop before sliding into a culvert. Examination of the airplane revealed…NTSB ATL88LA243Accident · No injuriesLimited investigationFinal reportSchempp-Hirth 2 · Whitwell, TNThe pilot was completing a 130 mile cross country flight. Just prior to touchdown, the left wing collided with a water sprinkler pipe along the edge of the runway. The pilot lost directional control. The grass was taller along the runway edge. The pilot did…NTSB ATL88DLT02Accident · No injuriesFinal reportGrumman G-164B · Dancyville, TNNTSB ATL88DLT01Accident · 1 fatalFinal reportVan RV-4 · Ashland City, TNNTSB ATL88LA222Accident · No injuriesLimited investigationFinal reportBeech V35B · Parson, TNThe pilot reported that shortly after a heavy weather system passed over, he attempted a takeoff from a wet runway. During the takeoff roll he did not allow the airspeed to accelerate to the lift off speed. As he prematurely lifted off he lost directional…NTSB ATL88LA218Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Somerville, TNThe CFI was attempting a demonstration of a forced landing following a simulated loss of engine power. Just as he started to recover and climb back to altitude, the student plt spotted wires and yelled. Company policy required a recovery at 500 ft. the…NTSB ATL88LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Michie, TNWitness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…NTSB ATL88LA209Accident · No injuriesLimited investigationFinal reportCessna 195A · Memphis, TNThe plt reported that the left wheel separated from the airplane during ldg rollout on rwy 27, allowing the left gear to drag on the rwy. The airplane then bounced, veered to the right, and skidded to a stop. The left ldg gear collapsed as the acft stopped.…NTSB ATL88FA254Accident · 1 fatalField investigationFinal reportCessna T207 · Petros, TNNTSB ATL88LA204Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Collierville, TNA multiple balloon flight was being conducted to obtain publicity for the local balloon club. Television exposure of balloon flights had been shot and the balloons were in the process of landing. The reporter/passenger in the accident balloon had been through…NTSB ATL88FA191Accident · 1 fatalField investigationFinal reportCessna 421B · Knoxville, TNNTSB ATL88LA170Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNThe flt was being accomplished to refamiliarize the commercial plt with the airplane prior to completing the remainder of the training curriculum. One takeoff and ldg had been completed without incident. During the second approach to landing, it was related…NTSB ATL88FA155Accident · Serious injuriesField investigationFinal reportCessna 150L · Knoxville, TNNTSB ATL88LA153Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Memphis, TNThe pilot reported that the engine lost pwr in-flt due to fuel exhaustion. A forced ldg was made in a plowed field. The airplane nosed over during the ldg. The plt noted after the accident that he should have topped off the fuel tanks prior to departure. The…NTSB ATL88LA152Accident · No injuriesLimited investigationFinal reportCessna 172F · Walland, TNThe pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft…NTSB ATL88LA135Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Briceville, TNThe plt stated that he had departed coffeyville, KS on apr 5 for an airplane delivery ferry flt to lincolnton, NC he landed at cape girardeau and remained overnight due to enroute weather. He deptd cgi the following morning following a wx brief that indicated…NTSB ATL88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Nashville, TNThe pilot aborted a takeoff after he felt that the aircraft was not performing properly. The pilot had four passengers on board which put the aircraft near its gross weight. The runway was 4300 feet long and the pilot needed about 1100 feet of runway for the…NTSB ATL88FA123Accident · 4 fatalField investigationFinal reportBeech C23 · Sevierville, TNThe aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover.NTSB ATL88LA120Accident · Serious injuriesLimited investigationFinal reportSlingsby Dart T-51 · Whitwell, TNThe glider was observed to make a normal release. While still in a turn it encountered a wind shear and rolled into a vertical bank. It sideslipped for a few seconds then the nose dropped into a vertical dive. The pilot stated that when he attempted to pull…NTSB ATL88IA113Incident · No injuriesIncident investigationFinal reportCessna 172B · Elizabethton, TNDue to a low charge in the battery, the plt elected to start the eng by hand propping, so he could program the loran for a later flt. He began hand propping with the tail & left wing tied down. After the eng started, the tiedown for the tail pulled loose &…NTSB ATL88FA106Accident · 2 fatalField investigationFinal reportCessna 150 · Knoxville, TNThe Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…NTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…NTSB DCA88MZ002Incident · Minor injuriesFinal reportMcdonnell Douglas DC-9-83 · Nashville, TNAmerican flt 132 was loaded with undeclared & improperly marked haz mtrl (hm) packed in a fiber drum. It contained 5 galof 50% hydrogen peroxide solution (oxidizer) & 25 lbs of textreat s-w (corrosive agent; sodium orthosilicate-based mix),shipped by textile…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…