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 IAD77FA019Accident · 3 fatalClosedPiper PA30 · Dyersburg, TNJan 29, 1977 · N8719Y · Destroyed NTSB IAD77FA018Accident · 2 fatalClosedCessna 177RG · Chattanooga, TNJan 29, 1977 · N7506V · Destroyed NTSB IAD77FKW12Accident · No injuriesClosedPiper PA28 · Crossville, TNJan 13, 1977 · N5884W · Substantial damage NTSB IAD77DKW11Accident · No injuriesClosedBrantly B2B · Fayetteville, TNDec 31, 1976 · N2271U · Destroyed NTSB IAD77DKW10Accident · Minor injuriesClosedErco 415CD · Rockwood, TNDec 22, 1976 · N94706 · Substantial damage NTSB IAD77FKW08Accident · Serious injuriesClosedPiper PA-28 · Athens, TNNov 21, 1976 · N8033N · Substantial damage NTSB IAD77FKW09Accident · No injuriesClosedPiper PA-28 · Chattanooga, TNNov 19, 1976 · N4799F · Substantial damage NTSB IAD77DKW07Accident · No injuriesClosedFairchild 24 · Rockwood, TNNov 12, 1976 · N81365 · Destroyed NTSB IAD77DA011Accident · 1 fatalClosedBell 47G-2 · Pigeon Forge, TNNov 6, 1976 · N6755D · Destroyed NTSB IAD77FKW06Accident · Minor injuriesClosedCessna 182 · Elizabethton, TNOct 31, 1976 · N71757 · Destroyed NTSB IAD77FKW05Accident · No injuriesClosedCessna 402 · Erin, TNOct 22, 1976 · N4532Q · Substantial damage NTSB IAD77DKW03Accident · Minor injuriesClosedAeronca 7AC · Cross Plains, TNOct 17, 1976 · N83389 · Substantial damage NTSB IAD77DKW04Accident · No injuriesClosedMooney M20E · Jasper, TNOct 15, 1976 · N6993U · Substantial damage NTSB IAD77FA003Accident · Minor injuriesClosedBeech E18S · Blountville, TNOct 8, 1976 · N633DN · Substantial damage NTSB IAD77FA002Accident · 4 fatalClosedCessna 177RG · Centerville, TNOct 6, 1976 · N1865Q · Destroyed NTSB IAD77DKW01Accident · No injuriesClosedCurtis JN4C · Tullahoma, TNOct 2, 1976 · N49289 · Substantial damage NTSB IAD76FLT20Accident · No injuriesClosedHughes 269B · Millington, TNSep 28, 1976 · N9428F · Substantial damage NTSB IAD76DKW39Accident · No injuriesClosedGrumman G-164 · Livingston, TNSep 13, 1976 · N465Y · Substantial damage NTSB IAD76FKW38Accident · No injuriesClosedCessna 170B · Powell, TNSep 11, 1976 · N2434D · Substantial damage NTSB IAD76FKW37Accident · No injuriesClosedPiper PA-28 · Blountville, TNSep 7, 1976 · N56405 · Substantial damage NTSB IAD76FLT19Accident · No injuriesClosedCessna 182A · Covington, TNSep 5, 1976 · N2141G · Substantial damage NTSB IAD76AI097Accident · 2 fatalClosedCessna 210 · Athens, TNSep 5, 1976 · N6111F · Destroyed NTSB IAD76AI096Accident · 2 fatalClosedBeech E18S · Covington, TNSep 1, 1976 · N1052N · Destroyed NTSB IAD76DLT18Accident · No injuriesClosedBoeing A75 · Somerville, TNAug 9, 1976 · N60601 · Substantial damage NTSB IAD76AI090Accident · 1 fatalClosedPiper J-3 · Ooltewah, TNAug 8, 1976 · N1360M · Substantial damage NTSB IAD76FLT17Accident · Minor injuriesClosedPiper PA-25 · Henderson, TNAug 4, 1976 · N4869Y · Destroyed NTSB IAD76DKW36Accident · No injuriesClosedCessna 150 · Lawrenceburg, TNJul 18, 1976 · N5747G · Substantial damage NTSB IAD76DLT15Accident · No injuriesClosedPiper PA-36 · Memphis, TNJul 13, 1976 · N9934P · Substantial damage NTSB IAD76DKW35Accident · Minor injuriesClosedPiper PA-28 · Bluff City, TNJul 11, 1976 · N7402W · Destroyed NTSB IAD76FLT14Accident · Serious injuriesClosedPiper PA-28 · Memphis, TNJul 3, 1976 · N43229 · Destroyed NTSB IAD76AI079Accident · 1 fatalClosedPiper PA-28 · Jamestown, TNJul 3, 1976 · N55494 · Destroyed NTSB IAD76FLT13Accident · No injuriesClosedGrumman G-164A · Covington, TNJun 21, 1976 · N7951 · Substantial damage NTSB IAD76FKW34Accident · Serious injuriesClosedCessna 150 · Murfreesboro, TNJun 17, 1976 · N50196 · Destroyed NTSB IAD76FLT12Accident · Serious injuriesClosedPiper PA-32 · Dyersburg, TNJun 15, 1976 · N222GE · Substantial damage NTSB IAD76FLT16Accident · No injuriesClosedPiper PA-20 · Memphis, TNJun 10, 1976 · N6896K · Substantial damage NTSB IAD76DLT11Accident · No injuriesClosedCessna 180 · Covington, TNJun 5, 1976 · N9377T · Substantial damage NTSB IAD76FKW33Accident · No injuriesClosedPiper PA-28 · Powells Xroads, TNMay 27, 1976 · N5053T · Substantial damage NTSB IAD76DKW32Accident · Minor injuriesClosedCessna 140 · Jasper, TNMay 21, 1976 · N89178 · Substantial damage NTSB IAD76FKW30Accident · No injuriesClosedBellanca 17-30A · Lebanon, TNMay 2, 1976 · N39845 · Destroyed NTSB IAD76DLT10Accident · No injuriesClosedBeech B19 · Covington, TNApr 29, 1976 · N2167W · Substantial damage NTSB IAD76FKW27Accident · No injuriesClosedPiper PA-31T · Cleveland, TNApr 12, 1976 · N82002 · Substantial damage NTSB IAD76FLT08Accident · No injuriesClosedCessna 150 · Covington, TNApr 11, 1976 · N3400V · Substantial damage NTSB IAD76AI065Accident · 6 fatalClosedCessna 210L · Allardt, TNApr 11, 1976 · N1649X · Destroyed NTSB IAD76FKW28Accident · No injuriesClosedPiper PA-25 · Springfield, TNApr 10, 1976 · N8523L · Substantial damage NTSB IAD76FLT09Accident · No injuriesClosedCessna T337G · Memphis, TNApr 8, 1976 · N5CP · Substantial damage NTSB IAD76FKW26Accident · No injuriesClosedCessna 172 · Spencer, TNApr 4, 1976 · N5063H · Substantial damage NTSB IAD76DKW25Accident · No injuriesClosedCessna 182 · Madisonville, TNMar 28, 1976 · N3941D · Substantial damage NTSB IAD76FKW24Accident · Minor injuriesClosedPiper PA-28 · Murfreesboro, TNMar 19, 1976 · N5270L · Substantial damage NTSB IAD76FLT07Accident · No injuriesClosedBeech A65 · Parsons, TNFeb 27, 1976 · N465AA · Substantial damage NTSB IAD76FKW23Accident · No injuriesClosedCessna 210 · Fayetteville, TNFeb 14, 1976 · N9435T · Substantial damage