Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 ATL82FA013Accident · 2 fatalClosedHughes 269A · Elizabethton, TNNov 1, 1981 · N8833F · Destroyed NTSB ATL82FA012Accident · 1 fatalClosedPiper PA-28 · Powell, TNOct 29, 1981 · N6452W · Destroyed NTSB ATL82FA006Accident · 1 fatalClosedCessna A150L · Oak Ridge, TNOct 11, 1981 · N5957J · Destroyed NTSB ATL82DLT01Accident · No injuriesClosedCessna A188B · Kenton, TNOct 9, 1981 · N4853R · Destroyed NTSB ATL82DKW01Accident · No injuriesClosedPiper PA-28 · Jacksboro, TNOct 1, 1981 · N9778W · Destroyed NTSB ATL81FA115Accident · 1 fatalClosedPitts S-1 · Cleveland, TNSep 13, 1981 · N123JC · Destroyed NTSB ATL81FKW26Accident · Serious injuriesClosedTaylorcraft DCO-65 · Pleasant View, TNSep 6, 1981 · N48280 · Destroyed NTSB ATL81FKW25Accident · No injuriesClosedCessna 152 · Columbia, TNAug 25, 1981 · N48005 · Substantial damage NTSB ATL81FKW24Accident · Serious injuriesClosedBensen B8 · Hixson, TNAug 22, 1981 · N3815 · Destroyed NTSB ATL81FLT15Accident · No injuriesClosedAir Tractor AT-301 · Obion, TNAug 20, 1981 · N36498 · Substantial damage NTSB ATL81FKW23Accident · No injuriesClosedCessna 182G · Athens, TNAug 20, 1981 · N2495R · Substantial damage NTSB ATL81FLT13Accident · Serious injuriesClosedCessna 150 · Jackson, TNAug 15, 1981 · N9305U · Substantial damage NTSB ATL81FKW22Accident · No injuriesClosedCessna 210 · Winchester, TNJul 30, 1981 · N22527 · Destroyed NTSB ATL81DKW21Accident · No injuriesClosedTexas Hel M-47A · Rickman, TNJul 29, 1981 · N1001F · Substantial damage NTSB ATL81FKW20Accident · Minor injuriesClosedCessna 206 · Kingsport, TNJul 25, 1981 · N9407G · Substantial damage NTSB ATL81FA100Accident · 4 fatalClosedPiper PA-24 · Center Grove, TNJul 23, 1981 · N5472P · Destroyed NTSB ATL81FA099Accident · 2 fatalClosedAeronca 7AC · Rogersville, TNJul 22, 1981 · N4407E · Destroyed NTSB ATL81FA097Accident · 3 fatalClosedPiper PA-28R · Sweetwater, TNJul 17, 1981 · N8348C · Destroyed NTSB ATL81FLT12Accident · Minor injuriesClosedCessna 172 · Brownsville, TNJul 11, 1981 · N4361R · Substantial damage NTSB ATL81FLT10Accident · 1 fatalClosedPitts S1S · Savannah, TNJun 9, 1981 · N8020 · Destroyed NTSB ATL81FLT09Accident · Minor injuriesClosedCessna 150 · Bolivar, TNMay 29, 1981 · N6789G · Substantial damage NTSB ATL81FA079Accident · 3 fatalClosedCessna 182 · Elizabethton, TNMay 28, 1981 · N444SP · Destroyed NTSB ATL81FA072Accident · 1 fatalClosedPiper PA-30 · Smyrna, TNMay 12, 1981 · N7512Y · Destroyed NTSB ATL81FLT08Accident · No injuriesClosedHughes 269C · Ridgely, TNMay 3, 1981 · N7487F · Substantial damage NTSB ATL81FLT07Accident · No injuriesClosedPiper PA-25 · Pickwick Dam, TNApr 28, 1981 · N7682Z · Substantial damage NTSB ATL81DKW19Accident · No injuriesClosedCessna 152 · Collegedale, TNApr 28, 1981 · N69038 · Substantial damage NTSB ATL81FKW18Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNApr 26, 1981 · N7518D · Substantial damage NTSB ATL81DKW16Accident · No injuriesClosedHughes 369D · Ashland City, TNApr 13, 1981 · N58221 · Substantial damage NTSB ATL81FKW15Accident · No injuriesClosedEnstrom F-28A · Knoxville, TNApr 8, 1981 · N4871 · Substantial damage NTSB ATL81FLT06Accident · No injuriesClosedGrumman G-164B · Brownsville, TNApr 6, 1981 · N6773K · Substantial damage NTSB ATL81DKW14Accident · Minor injuriesClosedVolksplane 1 · Crossville, TNMar 26, 1981 · N2879 · Substantial damage NTSB ATL81FKW12Accident · No injuriesClosedCessna 150F · Lebanon, TNMar 11, 1981 · N7891F · Destroyed NTSB ATL81FA048Accident · 1 fatalClosedCessna 172P · Woodbury, TNFeb 18, 1981 · N51095 · Destroyed NTSB ATL81FKW11Accident · No injuriesClosedPiper PA-28 · Woodbury, TNFeb 15, 1981 · N2845T · Substantial damage NTSB ATL81FKW10Accident · No injuriesClosedCessna U206F · Crossville, TNFeb 14, 1981 · N50946 · Destroyed NTSB ATL81FKW09Accident · Minor injuriesClosedPiper PA-32 · Nashville, TNFeb 14, 1981 · N3932W · Destroyed NTSB ATL81IA037Incident · No injuriesClosedCessna 414 · Jackson, TNJan 26, 1981 · N1678T · Minor damage NTSB ATL81FA035Accident · 2 fatalClosedAeronca 11AC · Maryville, TNJan 24, 1981 · N3267E · Substantial damage NTSB ATL81FKW08Accident · No injuriesClosedCessna 182RG · Sevierville, TNJan 16, 1981 · N4778S · Substantial damage NTSB ATL81FKW06Accident · No injuriesClosedCessna 177RG · Nashville, TNJan 14, 1981 · N52709 · Substantial damage NTSB MKC81FA012Accident · No injuriesClosedBeech F35 · Paris, TNJan 1, 1981 · N266S · Substantial damage NTSB ATL81DLT02Accident · No injuriesClosedPiper PA-28R · Reelfoot Lake, TNDec 13, 1980 · N2141T · Substantial damage NTSB ATL81FA024Accident · 2 fatalClosedPiper PA-30 · Sunbright, TNDec 2, 1980 · N99EJ · Destroyed NTSB ATL81FA021Accident · 4 fatalClosedCessna T210N · Tazewell, TNDec 2, 1980 · N4846C · Destroyed NTSB ATL81FKW05Accident · 2 fatalClosedVarieze 1 · Signal Mt, TNNov 13, 1980 · N111EZ · Destroyed NTSB ATL81IA015Incident · Serious injuriesClosedBoeing 707 · Memphis, TNNov 12, 1980 · G-BDEA · No damage NTSB ATL81FKW04Accident · Minor injuriesClosedBeech E35 · Chattanooga, TNNov 2, 1980 · N3314C · Substantial damage NTSB ATL80DKW03Accident · No injuriesClosedGrumman G-164B · Portland, TNOct 10, 1980 · N48624 · Destroyed NTSB ATL81FKW02Accident · Minor injuriesClosedBell 47G · Clarksville, TNOct 8, 1980 · N64877 · Substantial damage NTSB ATL80FKW01Accident · No injuriesClosedCessna 172 · Nashville, TNOct 3, 1980 · N3008E · Substantial damage