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 ATL80FKW23Accident · No injuriesClosedCessna 152 · Murfreesboro, TNSep 23, 1980 · N5396M · Substantial damage NTSB ATL80FKW22Accident · No injuriesClosedQuickie 01 · Collegedale, TNSep 20, 1980 · N45BT · Substantial damage NTSB ATL80DKW21Accident · No injuriesClosedChampion 7ECA · Lawrenceburg, TNSep 14, 1980 · N1633G · Substantial damage NTSB ATL80DKW20Accident · No injuriesClosedPiper PA-12 · Crossville, TNSep 7, 1980 · N3467M · Substantial damage NTSB ATL80DLT12Accident · No injuriesClosedPiper PA-28 · Union City, TNSep 1, 1980 · N2152Z · Substantial damage NTSB ATL80FKW19Accident · 1 fatalClosedErco 415-C · Nashville, TNAug 18, 1980 · N99446 · Destroyed NTSB ATL80FLT11Accident · Minor injuriesClosedPiper PA-23 · Jackson, TNAug 1, 1980 · N7AD · Destroyed NTSB ATL80FKW18Accident · Minor injuriesClosedCessna 150L · Jonesboro, TNJul 29, 1980 · N16087 · Destroyed NTSB ATL80DKW17Accident · No injuriesClosedCessna 170 · Tazewell, TNJul 18, 1980 · N170HC · Substantial damage NTSB ATL80FA074Accident · 2 fatalClosedPiper PA-28R · Reliance, TNJul 14, 1980 · N32036 · Destroyed NTSB ATL80FKW16Accident · Serious injuriesClosedPiper PA-32 · Sparta, TNJul 8, 1980 · N3157D · Substantial damage NTSB ATL80DKW15Accident · No injuriesClosedBell 47G-3B · Livingston, TNJul 6, 1980 · N8463E · Destroyed NTSB ATL80FA065Accident · 5 fatalClosedPiper PA-23 · Rockford, TNJul 3, 1980 · N6087Y · Destroyed NTSB ATL80DKW14Accident · No injuriesClosedCessna 152 · Greenville, TNJun 19, 1980 · N24298 · Substantial damage NTSB ATL80FLT08Accident · Serious injuriesClosedPitts S1A · Oakland, TNMay 26, 1980 · N99MS · Destroyed NTSB ATL80FLT07Accident · No injuriesClosedHughes 269C · Martin, TNMay 3, 1980 · N9665F · Substantial damage NTSB IAD80DKW13Accident · Serious injuriesClosedCallair A9 · Centerville, TNApr 21, 1980 · N8251H · Destroyed NTSB ATL80FKW12Accident · Minor injuriesClosedCessna 206 · Mcminnville, TNApr 19, 1980 · N3856G · Destroyed NTSB IAD80FLT06Accident · No injuriesClosedGrumman G-164A · Montezuma, TNApr 16, 1980 · N48408 · Substantial damage NTSB IAD80FKW11Accident · No injuriesClosedCessna 152 · Murfreesboro, TNMar 28, 1980 · N4848B · Substantial damage NTSB IAD80FA034Accident · 2 fatalClosedCessna 152 · Apison, TNMar 26, 1980 · N4896H · Destroyed NTSB IAD80FLT05Accident · Serious injuriesClosedCessna 152 · Memphis, TNMar 25, 1980 · N49867 · Destroyed NTSB IAD80FA032Accident · 1 fatalClosedPiper PA-28R · Alcoa, TNMar 24, 1980 · N3059T · Destroyed NTSB IAD80FKW10Accident · Serious injuriesClosedPiper PA-32 · Gatlinburg, TNMar 20, 1980 · N649TP · Destroyed NTSB IAD80FA029Accident · 1 fatalClosedCessna 182K · Hartsville, TNMar 3, 1980 · N48G · Destroyed NTSB IAD80FKW09Accident · 1 fatalClosedDer Jagger Wilson · Loudon, TNFeb 24, 1980 · N75BW · Destroyed NTSB IAD80FKW08Accident · Serious injuriesClosedCessna 172 · Tn Ridge, TNFeb 2, 1980 · N6248E · Substantial damage NTSB IAD80DKW07Accident · No injuriesClosedCessna A150L · Oliver Spgs, TNJan 27, 1980 · N5957J · Substantial damage NTSB IAD80FLT04Accident · Minor injuriesClosedCessna 150 · Jackson, TNJan 26, 1980 · N6364K · Substantial damage NTSB IAD80FKW06Accident · No injuriesClosedSchweizer 1-26E · Benton, TNJan 19, 1980 · N2994H · Substantial damage NTSB IAD80FKW05Accident · No injuriesClosedPiper PA-28 · Carryville, TNJan 15, 1980 · N9216W · Substantial damage NTSB IAD80FKW04Accident · Serious injuriesClosedRaven S55A · Knoxville, TNJan 3, 1980 · N8542L · No damage NTSB IAD80DKW03Accident · No injuriesClosedPiper PA-28 · Rockwood, TNDec 18, 1979 · N29218 · Substantial damage NTSB IAD80FA016Accident · 1 fatalClosedPiper PA-23 · Knoxville, TNDec 14, 1979 · N3242P · Destroyed NTSB IAD80FLT03Accident · No injuriesClosedCessna 172 · Collierville, TNDec 11, 1979 · N1184U · Substantial damage NTSB IAD80DKW02Accident · No injuriesClosedCallair A-9 · Greeneville, TNNov 6, 1979 · N8267H · Substantial damage NTSB IAD80FA007Accident · 5 fatalClosedMitsubishi MU-2F · Nashville, TNNov 1, 1979 · N873Q · Destroyed NTSB IAD80FKW01Accident · No injuriesClosedCessna 150 · Collegedale, TNOct 25, 1979 · N714BM · Substantial damage NTSB IAD80FLT01Accident · 2 fatalClosedBayles Spec 1 · Jackson, TNOct 13, 1979 · N8237E · Destroyed NTSB IAD80FA002Accident · 2 fatalClosedMooney M20J · Pikeville, TNOct 4, 1979 · N201YY · Destroyed NTSB IAD79FKW21Accident · Minor injuriesClosedMooney M-20K · Benton, TNSep 30, 1979 · N231C · Substantial damage NTSB IAD79FKW20Accident · Minor injuriesClosedLake 4-200 · Nashville, TNAug 30, 1979 · N6175V · Destroyed NTSB IAD79FA067Accident · 1 fatalClosedBenson R8M · Fayetteville, TNAug 19, 1979 · N86531 · Destroyed NTSB IAD79DLT06Accident · No injuriesClosedPiper PA-24 · Mckenzie, TNAug 4, 1979 · N5345P · Destroyed NTSB IAD79DKW19Accident · No injuriesClosedChampion 7FC · Whitebluff, TNJul 28, 1979 · N7580E · Substantial damage NTSB IAD79DKW18Accident · Minor injuriesClosedBeech A35 · Greeneville, TNJul 19, 1979 · N534B · Substantial damage NTSB IAD79FKW17Accident · Minor injuriesClosedGrumman G-164 · Crossville, TNJul 16, 1979 · N740Y · Destroyed NTSB IAD79FA062Accident · No injuriesClosedCessna 402 · Clarksville, TNJul 15, 1979 · N4009Q · 2 aircraft · Substantial damage NTSB IAD79DKW16Accident · No injuriesClosedCessna A185 · Elizabethton, TNJul 5, 1979 · N70083 · Substantial damage NTSB IAD79DLT05Accident · No injuriesClosedPiper PA-25 · Covington, TNJun 21, 1979 · N7260Z · Substantial damage