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 IAD75DLT10Accident · No injuriesClosedPiper PA-25 · Montezuma, TNApr 20, 1975 · N8649L · Destroyed NTSB IAD75FKW13Accident · No injuriesClosedBell 47H · Nashville, TNApr 1, 1975 · N981B · Substantial damage NTSB IAD75DKW11Accident · No injuriesClosedCessna 140 · Knoxville, TNApr 1, 1975 · N89687 · Substantial damage NTSB IAD75DKW12Accident · Serious injuriesClosedDehavilland DHC-3 · Winchester, TNMar 17, 1975 · N22UT · Substantial damage NTSB NYC75AN093Accident · 1 fatalClosedCessna 170 · Byrdstown, TNMar 16, 1975 · N4082V · Destroyed NTSB IAD75AI052Accident · Minor injuriesClosedAero Comdr 1121 · Tullahoma, TNMar 13, 1975 · N711JT · Substantial damage NTSB IAD75DKW10Accident · Minor injuriesClosedCessna 182 · Greeneville, TNMar 1, 1975 · N9940T · Substantial damage NTSB IAD75FLT09Accident · No injuriesClosedCessna 177 · Jackson, TNFeb 14, 1975 · N34343 · Substantial damage NTSB IAD75AI047Accident · 2 fatalClosedBeech 95-B55 · Lawrenceburg, TNFeb 14, 1975 · N907T · Destroyed NTSB IAD75FLT08Accident · No injuriesClosedLake LA4200 · Dyersburg, TNJan 18, 1975 · N5027L · Substantial damage NTSB IAD75AI039Accident · 1 fatalClosedPiper PA-28 · Chattanooga, TNJan 9, 1975 · N2066R · Destroyed NTSB IAD75FKW09Accident · Serious injuriesClosedCessna 150 · Monterey, TNJan 1, 1975 · N6555T · Substantial damage NTSB IAD75FKW08Accident · No injuriesClosedBeech A35 · Tullahoma, TNDec 21, 1974 · N756B · Substantial damage NTSB IAD75FLT06Accident · No injuriesClosedCessna 150 · Brunswick, TNDec 19, 1974 · N2908V · Substantial damage NTSB IAD75FLT05Accident · Minor injuriesClosedCessna 205 · Memphis, TNDec 18, 1974 · N8377Z · Substantial damage NTSB IAD75FKW07Accident · Serious injuriesClosedCessna 172 · Livingston, TNDec 18, 1974 · N1384F · Substantial damage NTSB IAD75II033Incident · No injuriesClosedCessna 310Q · Knoxville, TNNov 30, 1974 · N7548Q · 2 aircraft · Substantial damage NTSB IAD75AI034Accident · 3 fatalClosedPiper PA-28R · Toone, TNNov 30, 1974 · N5092S · Destroyed NTSB IAD75DKW05Accident · Minor injuriesClosedCessna 172 · Cleveland, TNNov 5, 1974 · N2888Q · Substantial damage NTSB IAD75AI024Accident · 1 fatalClosedCessna 150 · Johnson City, TNOct 13, 1974 · N60125 · Destroyed NTSB IAD75AI021Accident · 1 fatalClosedBoeing 75 · Somerville, TNOct 7, 1974 · N66489 · Destroyed NTSB IAD75DLQ07Accident · Minor injuriesClosedBoeing A75-N1 · Union City, TNSep 19, 1974 · N65200 · Substantial damage NTSB IAD75FKW06Accident · 1 fatalClosedCessna 172 · Twinton, TNSep 14, 1974 · N7549T · Destroyed NTSB IAD75AI012Accident · 1 fatalClosedCessna A188B · Smyrna, TNSep 13, 1974 · N53235 · Destroyed NTSB IAD75FLT04Accident · No injuriesClosedPiper PA-25 · Germantown, TNSep 2, 1974 · N7428Z · Substantial damage NTSB IAD75FLT03Accident · Serious injuriesClosedPiper PA-25 · Germantown, TNSep 2, 1974 · N7485Z · Destroyed NTSB IAD75AI008Accident · 1 fatalClosedGlobe GC-1B · Manchester, TNAug 20, 1974 · N3716K · Substantial damage NTSB IAD75AI010Accident · 2 fatalClosedBeech A24R · Wartburg, TNAug 12, 1974 · N24667 · Destroyed NTSB IAD75FKW03Accident · No injuriesClosedPiper PA-25 · Springfield, TNJul 28, 1974 · N6032Z · Substantial damage NTSB IAD75DLT02Accident · No injuriesClosedGrumman G-164A · New Castle, TNJul 22, 1974 · N6533 · Substantial damage NTSB IAD75AI001Accident · 1 fatalClosedBeech 65-90 · Knoxville, TNJul 16, 1974 · N113TC · Destroyed NTSB IAD75FKW04Accident · Minor injuriesClosedGlobe GC-1A · Tullahoma, TNJul 14, 1974 · N2450B · Destroyed NTSB IAD75FKW01Accident · Minor injuriesClosedTennie II · Smyrna, TNJul 14, 1974 · N4XX · Substantial damage NTSB IAD75DKW02Accident · No injuriesClosedPiper PA-28 · Johnson City, TNJul 14, 1974 · N5861U · Substantial damage NTSB IAD75FLT01Accident · No injuriesClosedPiper PA-25 · Selmer, TNJul 11, 1974 · N4907Y · Destroyed NTSB IAD74FLT14Accident · No injuriesClosedCessna 182K · Dyersburg, TNApr 22, 1974 · N2890R · Substantial damage NTSB IAD74DKW34Accident · No injuriesClosedCessna 150G · Surgoinsvile, TNApr 21, 1974 · N3176X · Substantial damage NTSB IAD74DKW33Accident · Minor injuriesClosedCessna 205 · Jonesboro, TNApr 18, 1974 · N8124Z · Substantial damage NTSB IAD74II055Incident · No injuriesClosedBeech G18 · Nashville, TNApr 8, 1974 · N1291N · Minor damage NTSB IAD74FKW31Accident · Minor injuriesClosedCessna 182 · Nashville, TNMar 31, 1974 · N3149R · Substantial damage NTSB IAD74DKW32Accident · No injuriesClosedBeech 23 · Oneida, TNMar 31, 1974 · N2313Q · Substantial damage NTSB IAD74DKW29Accident · No injuriesClosedCessna 175 · Nashville, TNMar 30, 1974 · N6836E · Destroyed NTSB IAD74AI043Accident · Minor injuriesClosedBeech D18S · Tullahoma, TNFeb 14, 1974 · N313A · Destroyed NTSB NYC74AN073Accident · 1 fatalClosedCessna 172 · Woodbury, TNFeb 7, 1974 · N52170 · Destroyed NTSB IAD74AI040Accident · 4 fatalClosedPiper PA-28 · Speedwell, TNFeb 3, 1974 · N4888L · Destroyed NTSB IAD74DKW25Accident · No injuriesClosedAeronca 7AC · Dayton, TNJan 30, 1974 · N83053 · Substantial damage NTSB IAD74FLT13Accident · No injuriesClosedCessna 150H · Memphis, TNJan 27, 1974 · N23321 · Substantial damage NTSB IAD74FKW24Accident · Serious injuriesClosedHiller Acft FH1100 · Knoxville, TNJan 23, 1974 · N441FH · Minor damage NTSB IAD74FLT12Accident · Minor injuriesClosedCessna A188A · Trenton, TNJan 16, 1974 · N9983G · Substantial damage NTSB IAD74FKW23Accident · No injuriesClosedPiper PA-30 · Morristown, TNJan 16, 1974 · N8030Y · Substantial damage