NTSB investigations, TN
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ERA14FA027Accident · 1 fatalField investigationFinal reportCessna 172R · Nashville, TNThe noninstrument-rated pilot’s continued visual flight into night instrument flight rules conditions, which resulted in a collision with the runway during an attempted approach to land. Contributing to the accident was the pilot’s mental state, his…NTSB ERA14FA010Accident · 3 fatalField investigationFinal reportEurocopter AS 350 B3 · Somerville, TNThe pilot’s inadvertent encounter with night, instrument meteorological conditions while responding to an obstacle alert, resulting in an in-flight loss of helicopter control.NTSB ERA13CA400Accident · Minor injuriesData collectionFinal reportMaxair Drifter Drifter II · Lafayette, TNThe pilot's failure to maintain aircraft control during the initial climb after takeoff in gusty wind conditions, which resulted in a hard off-airport landing.NTSB ERA13CA404Accident · No injuriesData collectionFinal reportCessna 172N · Knoxville, TNThe student pilot's improper flare and improper recovery from a bounced landing.NTSB ERA13LA347Accident · Serious injuriesLimited investigationFinal reportDurfee Fred Quicksilver MXL · Lexington, TNThe student pilot/builder’s failure to maintain airspeed following a loss of engine power, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the student pilot/builder’s…NTSB ERA13CA345Accident · Serious injuriesData collectionFinal reportJim Braddock Just Aircraft Highla · Limestone, TNThe pilot’s improper recovery from a bounced landing.NTSB ERA13LA323Accident · Minor injuriesLimited investigationFinal reportJohnson Garret W Merlin GT · Collierville, TNThe total loss of engine power during takeoff for reasons that could not be determined during postaccident examination due to postcrash fire damage.NTSB ERA13LA320Accident · 1 fatalLimited investigationFinal reportThompson Bruce D Sonerai II · Pulaski, TNThe pilot's failure to maintain airspeed during a near-vertical climb after takeoff, which resulted in an aerodynamic stall and subsequent collision with terrain.NTSB ERA13LA312Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Jackson, TNA failure of the right main landing gear wheel rim during the landing roll, resulting in a loss of control and a subsequent collapse of the right main landing gear.NTSB DCA13CA106Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD-88 · Nashville, TNThe flight crews failure to maintain clearance from the light pole while taxiing.NTSB ERA13LA214Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Knoxville, TNThe loss of engine power during takeoff for a reasons that could not be determined because postaccident examinations and testing revealed no anomalies that would have precluded normal operation.NTSB ERA13CA310Accident · No injuriesData collectionFinal reportSchleicher Alexander ASH 26 E · Tullahoma, TNThe pilot's improper use of wing spoilers during approach resulting in an altitude loss and collision with a tree.NTSB ERA13LA183Accident · 1 fatalLimited investigationFinal reportAndrews Zodiac · Collegedale, TNThe pilot's failure to ensure that his seatbelt was fastened and the pilots' failure to ensure that the canopy was latched properly, which resulted in the pilot's ejection from the cockpit following the opening of the canopy and the subsequent in-flight upset.NTSB ERA13CA172Accident · No injuriesData collectionFinal reportMooney M20J · Springfield, TNThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB ERA13CA140Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TNThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA13CA132Accident · No injuriesData collectionFinal reportTriad International Technology RV6A · Lewisburg, TNThe pilot’s improper landing flare and failure to maintain directional control during the landing.NTSB DCA13CA035Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD-11F · Memphis, TNthe operator's failure to provide appropriate training and documentation for ground personnel, leading the marshaller to inadvertently guide the airplane into the collision.NTSB ERA13LA087Accident · Minor injuriesLimited investigationFinal reportRotorway DB-1 · Mayland, TNThe pilot’s failure to maintain helicopter control following a high-side governor failure for reasons that could not be determined during postaccident examination.NTSB ERA13CA086Accident · Serious injuriesData collectionFinal reportCessna 172P · Murfreesboro, TNThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ERA13CA081Accident · No injuriesData collectionFinal reportBeech F90 · Knoxville, TNThe pilots’ decision to maneuver the airplane in close proximity to a hangar.NTSB ERA13LA076Accident · 1 fatalLimited investigationFinal reportCassutt Sport Racer · Collegedale, TNImpact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot.NTSB ERA13LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Sevierville, TNThe air traffic controller’s failure to comply with the required vectoring and safety alert procedures, which resulted in the airplane’s flight into rising terrain. Contributing to the accident was the Federal Aviation Administration’s continued practice of…NTSB ERA13LA024Accident · Serious injuriesLimited investigationFinal reportCashmer Philip M Sonex · Crossville, TNThe pilot’s failure to maintain control of the airplane, which resulted in a low-altitude aerodynamic stall/spin. Contributing to the accident was a loss of engine power for reasons that could not be determined during postaccident examination and the pilot’s…NTSB ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.NTSB ERA13TA021Accident · Minor injuriesFinal reportBell OH-58A · Jackson, TNA loss of engine power for undetermined reasons because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13FA017Accident · Serious injuriesField investigationFinal reportArion Lightning · Chuckey, TNThe pilot’s inadequate preflight planning, which resulted in an attempted takeoff at a high gross weight, near the limit of its aft center of gravity, and with the airplane incorrectly configured with fully extended flaps. Contributing to the accident was the…NTSB ERA12CA585Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Maryville, TNThe pilot’s failure to plan and execute a takeoff that assured obstacle clearance at the departure end of the runway, which resulted in a collision with trees.NTSB ERA12CA551Accident · Minor injuriesData collectionFinal reportHolloman L B/Holloman E M Sonex · Chapmansboro, TNThe pilot’s failure to maintain directional control during the takeoff initial climb.NTSB ERA12FA438Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Moscow, TNThe non-instrument rated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation, a loss of airplane control, and subsequent impact with trees and terrain.NTSB ERA12CA430Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Camden, TNThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.NTSB ERA12LA422Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Mc Kinnon, TNThe separation of the piston connecting rod from the crankshaft due to inadequate installation from a mechanic, resulting in a total loss of engine power.NTSB ERA12CA454Accident · Minor injuriesData collectionFinal reportLet L-23 Super Blanik · Benton, TNThe pilot's inadvertent extension of the wing airbrakes, which resulted in a loss of lift and subsequent landing prior to the runway.NTSB ERA12CA420Accident · No injuriesData collectionFinal reportCessna 172M · Smyrna, TNThe pilot’s inadequate flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA12CA408Accident · Minor injuriesData collectionFinal reportCessna 195B · Millington, TNThe pilot's failure to maintain directional control during the landing roll.NTSB ERA12CA415Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Smyrna, TNThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB ERA12LA368Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Piney Flats, TNThe mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.NTSB ERA12CA347Accident · No injuriesData collectionFinal reportCessna 172R · Crossville, TNThe pilot's attempt to avoid a deer on the runway, which resulted in a runway excursion.NTSB ERA12CA321Accident · Serious injuriesData collectionFinal reportEiriavion PIK 20D · Eagleville, TNThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in an aerodynamic stall.NTSB ERA12LA318Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Dayton, TNA partial loss of engine power during low-altitude maneuvers for reasons that could not be determined because the engine examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation; however the carburetor was…NTSB ERA12LA299Accident · No injuriesLimited investigationFinal reportCessna 210 · Gatlinburg, TNFailure of the nose landing gear down pressure hose, which resulted in the main landing gear being unable to lock and collapse of the main landing gear during the landing roll.NTSB ERA12LA292Accident · Serious injuriesLimited investigationFinal reportMooney M20F · McKinnon, TNThe pilot's delayed decision to go-around after failing to recognize that he was attempting to land with a tailwind, and his failure to retract the landing gear and wing flaps for the go-around, which resulted in a collision with trees and terrain near the…NTSB ERA12CA232Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Dover, TNThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a collision with an object and a landing gear collapse during the subsequent landing.NTSB ERA12LA226Accident · Serious injuriesLimited investigationFinal reportMichael S/Michael K Safari · Middle Valley, TNA partial loss of engine power for reasons that could not be determined due to the postaccident condition of the airframe and engine.NTSB ERA12CA209Accident · No injuriesData collectionFinal reportCessna 172S · Lafayette, TNThe pilot’s inadequate compensation for gusting crosswind conditions during landing, which resulted in a hard landing.NTSB ERA12LA148Accident · No injuriesLimited investigationFinal reportCessna 172I · Springfield, TNThe pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA12CA125Accident · Serious injuriesData collectionFinal reportCessna 150H · Knoxville, TNThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12CA119Accident · No injuriesData collectionFinal reportHughes 369D · Fall Branch, TNThe pilot's improper decision to continue a visual flight into instrument meteorological conditions, which resulted in a wire strike.NTSB ERA12FA107Accident · 1 fatalField investigationFinal reportShaw Douglas Wayne Rans S 7 · Somerville, TNThe pilot's incapacitation due to a ruptured berry aneurysm during takeoff.NTSB ERA12CA047Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Dyersburg, TNThe pilot's inadvertent excessive braking during the landing roll.NTSB ERA12CA027Accident · No injuriesData collectionFinal reportIca Brasov IS-29D2 · Benton, TNThe pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.