NTSB investigations, TN
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC07LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sevierville, TNThe pilot misjudged his speed and distance resulting in an overrun. Contributing to the accident was the wet turf runway and the lack of any information in the pilot operating handbook regarding landing distance on a wet turf runway.NTSB NYC07CA198Accident · No injuriesData collectionFinal reportChristen Industries Pitts S-2B · Springfield, TNThe pilot's inadequate compensation for wind conditions during landing.NTSB NYC07LA134Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Gallatin, TNThe pilot’s mismanagement of fuel which led to fuel starvation and loss of engine power. Contributing to the accident was the pilot’s failure to utilize the proper engine restart procedures, and the hard landing.NTSB NYC07CA122Accident · Minor injuriesData collectionFinal reportHanson Gerald Hanson Bucker 131E · Memphis, TNThe pilot's inadequate visual lookout that resulted in a collision with a lighting structure in the grass while landing. A factor in the accident was the pilot's intentional landing in the runway safety area.NTSB MIA07CA094Accident · Serious injuriesData collectionFinal reportRotor Flight Dynamics Dominator · Mountain City, TNThe pilot's decision to attempt operation of the airplane with a known physical impairment (loss of leg control) which resulted in his loss of aircraft control during takeoff and the airplane nosing over.NTSB ATL07CA076Accident · No injuriesData collectionFinal reportBell 206-B · Sevierville, TNThe pilot's improper use of the flight controls while at a hover that resulted in the tail colliding with the ground, a subsequent hard landing, and collapse of the skids.NTSB ATL07CA071Accident · No injuriesData collectionFinal reportCessna C-150H · Dyersburg, TNThe student's pilot's misjudged distance/altitude that led to an undershoot and a failure to attain the proper touchdown point.NTSB ATL07LA067Accident · 1 fatalLimited investigationFinal reportPiper PA28-181 · New Tazewell, TNThe pilot's failure to maintain aircraft control. Contributing to the accident was the non-instrument rated pilot's continued flight from visual meteorological conditions into instrument meteorological conditions, and a low cloud ceiling.NTSB ATL07CA053Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Oliver Springs, TNThe pilot's failure to maintain adequate clearance, resulting in an in-flight collision with an airport sign.NTSB ATL07CA051Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Collinwood, TNThe pilots improper inflight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB ATL07CA050Accident · Minor injuriesData collectionFinal reportCessna 172K · Paris, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB CHI07FA046Accident · 2 fatalField investigationFinal reportRockwell International 114 · Jasper, TNThe pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…NTSB ANC07LA009Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Nashville, TNThe pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…NTSB CHI07FA045Accident · 4 fatalField investigationFinal reportBeech A36 · Chattanooga, TNThe pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.NTSB ATL07CA020Accident · No injuriesData collectionFinal reportCessna 190 · Chattanooga, TNThe pilot's failure to maintain directional control on takeoff resulting in a collapse of the left main landing gear when the airplane swerved. A factor in the accident was wake turbulence from a landing airplane.NTSB ATL07LA016Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Memphis, TNThe captain's inadequate visual look out during taxi.NTSB ATL07LA001Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Somerville, TNThe total loss of engine power for undetermined reasons.NTSB ATL06LA127Accident · No injuriesLimited investigationFinal reportStinson 108 · Holladay, TNA total loss of engine power in cruise flight due to the fatigue failure of the crankshaft gear resulting in a forced landing and subsequent nose over.NTSB DEN06CA123Accident · Serious injuriesData collectionFinal reportParsons JN4-D Jenny Replica · Crossville, TNA loss of control in flight due to a disconnected rudder control cable. Contributing to the accident was the pilot's inability to control the roll.NTSB DCA06FA058Accident · No injuriesField investigationFinal reportBoeing MD-10-10F · Memphis, TNthe failure of the left main landing gear due to fatigue cracking in the air filler valve hole on the aft side of the landing gear. The fatigue cracking occurred due to the presence of stray nickel plating in the air filler valve hole. Contributing to this…NTSB ATL06CA097Accident · No injuriesData collectionFinal reportCessna R182 · Lebanon, TNImproper maintenance by other maintenance personnel resulting in the puncture of the landing gear hydraulic down line and the failure of the main landing gear to extended on landing.NTSB ATL06LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nashville, TNImproper installation of the fuel line by maintenance personnel which resulted in the fuel line disconnecting and a loss of engine power during approach.NTSB ATL06CA084Accident · No injuriesData collectionFinal reportCessna 172L · Lexington, TNThe pilot's failure to attain the proper touchdown point during landing.NTSB ATL06CA082Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Crossville, TNInadequate maintenance inspection resulting in fuel system contamination going undetected resulting in a total loss of engine power while on final approach to land.NTSB ATL06CA081Accident · No injuriesData collectionFinal reportPiper PA28-140 · Murfreesboro, TNThe student pilot's failure to maintain directional control during landing roll.NTSB ATL06CA080Accident · No injuriesData collectionFinal reportCessna 525 · Murfreesboro, TNThe pilot's failure to maintain directional control while landing on a wet runway.NTSB ATL06CA066Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Shelbyville, TNThe pilot's inadequate in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA06FA033Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC10 · Memphis, TNThe rupture of a fatigue crack in the forward air seal tooth serration of the No. 3 engine low pressure turbine stage 1 disk that initiated due to an improper weld repair performed during original manufacture. The improper weld repair changed the material…NTSB ATL06FA045Accident · 1 fatalField investigationFinal reportSwearingen SA-226-TC · Paris, TNThe pilot's inflight loss of control following a reported fuel asymmetry condition for undetermined reasons.NTSB ATL06LA039Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Murfreesboro, TNThe pilot's failure to maintain airplane control during a precautionary landing following a reported failure (undetermined) of the elevator trim control system.NTSB ATL06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-2S2F · Memphis, TNThe improper towing of the airplane by the tug operator which resulted in the shearing of the towbar shear pin and subsequent collision of the airplane and tug.NTSB ATL06CA006Accident · Serious injuriesData collectionFinal report1200 G103 · Benton, TNThe pilot's misjudgment of distance and failure to maintain a visual look out during a forced landing resulting in an in flight collision with a guy wire and the ground.NTSB ATL06CA004Accident · No injuriesData collectionFinal reportBeech F33A · Millington, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation. A factor in the accident was the pilot's failure to maintain airspeed and misjudged distance to the forced landing area resulting in a stall and collision…NTSB ATL06LA003Accident · 1 fatalLimited investigationFinal reportGrumman F6F · Monterey, TNThe pilot's inadequate preflight planning and inadequate evaluation of the weather, inadequate visual lookout, and his failure to maintain clearance, resulted in the in-flight collision with power lines.NTSB ATL05CA165Accident · No injuriesData collectionFinal reportCessna C172F · Sparta, TNThe pilot's delay in applying carburetor heat that resulted in the loss of engine power due to carburetor ice.NTSB ATL05CA161Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Summerville, TNThe pilot's failure to maintain adequate clearance and adequate visual lookout during take-off which resulted in an in-flight collision with a tree and roll over.NTSB ATL05CA158Accident · Minor injuriesData collectionFinal reportChristen Industries S-2B · Deeherd, TNThe pilots inadequate preflight of the fuel tank resulting in a total loss of engine power in cruise flight, forced landing, and nose over on landing roll out.NTSB ATL05FA148Accident · 2 fatalField investigationFinal reportBeech A36 · Jamestown, TNThe pilot's decision to continue flight into an area of known thunderstorm activity, which resulted in loss of aircraft control and collision with trees and the ground during the result uncontrolled descent.NTSB ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.NTSB ATL05CA136Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Rogersville, TNThe flight instructor's failure to maintain directional control which resulted in a on ground collision with terrain.NTSB ATL05LA113Accident · 1 fatalLimited investigationFinal reportMize Donald Kolb MK III X · Dickson, TNThe pilot's failure to maintain adequate obstacle clearance during climb out which resulted in the in-flight collision with a tree.NTSB ATL05CA119Accident · Minor injuriesData collectionFinal reportGlobe GC-1B · Athens, TNThe pilot's improper landing flare, which resulted in a hard landing.NTSB ATL05LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Tazewell, TNLoss of engine power due to oil starvation; the reason for the oil starvation could not be determined.NTSB ATL05CA095Accident · Minor injuriesData collectionFinal reportDavid S Robbins Christavia MK 1 · Decherd, TNThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ATL05CA092Accident · Minor injuriesData collectionFinal reportCessna 172 · Crossville, TNThe pilot's continued VFR flight into IMC conditions which resulted in an in-flight collision with trees. A related factor was the clouds.NTSB ATL05FA082Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nashville, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an in flight loss of control, stall, and collision with trees and the ground. A factor was the pilot's impairment due to drugs.NTSB ATL05LA078Accident · 1 fatalLimited investigationFinal reportEarnest Jodel D-9 · Memphis, TNThe pilot's misjudgment of distance/altitude, and his failure to maintain adequate airspeed resulting in a stall and subsequent undershoot.NTSB ATL05CA059Accident · No injuriesData collectionFinal reportEcker Starduster 1 · Millington, TNThe malfunction of the left main landing gear wheel brake during landing roll on a grassy area, resulting in a nose over.NTSB ATL05CA056Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Eagleville, TNThe pilot's mismanagement of the fuel supply by his failure to switch the fuel selector position , which resulted in a loss of engine power due to fuel starvation.NTSB ATL05TA055Accident · Serious injuriesFinal reportCessna T-41B · Sparta, TNImproper installation of the timing reference plug by other maintenance personnel, which resulted in oil starvation, and the loss of engine power.