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 IAD78FA063Accident · No injuriesClosedBell 47J-2A · Memphis, TNMay 16, 1978 · N1155W · Substantial damage NTSB IAD78DKW05Accident · No injuriesClosedCessna 150 · Philadelphia, TNMay 11, 1978 · N66560 · Substantial damage NTSB IAD78FLT05Accident · No injuriesClosedHiller UH12E · Paris, TNApr 28, 1978 · N87600 · Substantial damage NTSB IAD78FA059Accident · No injuriesClosedCessna 402B · Knoxville, TNApr 11, 1978 · N6367X · Substantial damage NTSB IAD78FLT03Accident · No injuriesClosedPiper PA-18 · Tigrett, TNMar 22, 1978 · N3486Z · Destroyed NTSB IAD78FA049Accident · 4 fatalClosedCessna 177 · Maryville, TNMar 17, 1978 · N3379T · Destroyed NTSB IAD78FA043Accident · 2 fatalClosedPiper PA-22 · Camden, TNFeb 18, 1978 · N1693P · Destroyed NTSB IAD78FLT02Accident · No injuriesClosedPiper PA-28 · Tiptonville, TNJan 29, 1978 · N3666R · Substantial damage NTSB IAD78FKW04Accident · Serious injuriesClosedPiper PA-28 · Benton, TNJan 28, 1978 · N5733W · Substantial damage NTSB IAD78FA028Accident · 5 fatalClosedCessna 421B · Knoxville, TNJan 3, 1978 · N41037 · Destroyed NTSB IAD78FA024Accident · Minor injuriesClosedCessna 150 · Arlington, TNDec 22, 1977 · N6431K · 2 aircraft · Substantial damage NTSB IAD78FA018Accident · 2 fatalClosedCessna 172H · Dickson, TNDec 4, 1977 · N75923 · Destroyed NTSB IAD78FA017Accident · 2 fatalClosedCessna 172H · Cades Cove, TNDec 1, 1977 · N8821Z · Destroyed NTSB IAD78DKW03Accident · No injuriesClosedCessna 150 · Johnson City, TNOct 31, 1977 · N63074 · Substantial damage NTSB IAD78DKW02Accident · No injuriesClosedCessna 414 · Oneida, TNOct 28, 1977 · N1603T · Substantial damage NTSB IAD78FA006Accident · 1 fatalClosedPiper J-3 · Pulaski, TNOct 22, 1977 · N98067 · Destroyed NTSB IAD78FLT01Accident · Minor injuriesClosedCessna 172 · Covington, TNOct 13, 1977 · N79322 · Substantial damage NTSB IAD78FA003Accident · 1 fatalClosedBellanca 7GCBC · Sparta, TNOct 10, 1977 · N10988 · Destroyed NTSB IAD78FKW01Accident · Minor injuriesClosedCessna 150 · Spring Hill, TNOct 2, 1977 · N5848E · Destroyed NTSB IAD77FA068Accident · 2 fatalClosedCessna 210L · Smithville, TNSep 25, 1977 · N2199S · Destroyed NTSB IAD77FKW29Accident · Serious injuriesClosedAero Comdr 100 · Clifton, TNSep 6, 1977 · N3681X · Destroyed NTSB IAD77FA064Accident · 2 fatalClosedPiper PA-28 · Harriman, TNSep 5, 1977 · N32044 · Destroyed NTSB IAD77DKW30Accident · No injuriesClosedSchleicher KA6CR · Benton, TNSep 4, 1977 · N201V · Minor damage NTSB IAD77DKW28Accident · No injuriesClosedCessna 188 · Charlotte, TNAug 30, 1977 · N5525S · Substantial damage NTSB IAD77FLT06Accident · Serious injuriesClosedCessna 150H · Millington, TNAug 24, 1977 · N23321 · Destroyed NTSB IAD77DLT05Accident · No injuriesClosedPiper PA-25 · Trimble, TNAug 23, 1977 · N8945L · Substantial damage NTSB IAD77FKW27Accident · Serious injuriesClosedBell 47G2A · Jamestown, TNAug 15, 1977 · N2880B · Substantial damage NTSB IAD77DKW26Accident · No injuriesClosedCessna 172 · Beersheba Spgs, TNAug 13, 1977 · N4295F · Substantial damage NTSB IAD77DKW25Accident · No injuriesClosedBell 206L · Knoxville, TNAug 4, 1977 · N970CR · Substantial damage NTSB IAD77FA055Accident · 1 fatalClosedBoeing A75N-1 · Union City, TNAug 2, 1977 · N46998 · Destroyed NTSB IAD77FKW24Accident · Minor injuriesClosedPiper PA-22 · Pulaski, TNJul 29, 1977 · N3159Z · Destroyed NTSB IAD78FA010Accident · 1 fatalClosedStinson 108-3 · Knoxville, TNJul 27, 1977 · N6734M · Destroyed NTSB IAD77DKW23Accident · No injuriesClosedCessna 150 · Celina, TNJul 27, 1977 · N3155V · Substantial damage NTSB IAD77IA052Incident · No injuriesClosedBoeing 727 · Memphis, TNJul 13, 1977 · N9278 · Minor damage NTSB IAD78FA079Accident · Serious injuriesClosedCessna 421 · Nashville, TNJul 8, 1977 · N1504G · Destroyed NTSB IAD77FKW21Accident · No injuriesClosedGrumman G-164B · Dunlap, TNJun 25, 1977 · N48668 · Substantial damage NTSB IAD77FKW20Accident · 2 fatalClosedCessna 172 · Midtown Commun, TNJun 18, 1977 · N7129A · Destroyed NTSB IAD77DKW19Accident · Minor injuriesClosedCessna 150 · Center Hill Lk, TNJun 11, 1977 · N6098K · Destroyed NTSB IAD77DLT04Accident · No injuriesClosedCessna 180 · Centennial Isl, TNJun 6, 1977 · N25NW · Substantial damage NTSB IAD77FKW18Accident · Serious injuriesClosedBeech 58P · Knoxville, TNMay 2, 1977 · N6039S · Substantial damage NTSB IAD77FA035Accident · 1 fatalClosedBeech C23 · Knoxville, TNApr 19, 1977 · N9224S · Destroyed NTSB IAD77DKW17Accident · No injuriesClosedBeech 35 · Sewanee, TNApr 11, 1977 · N3195V · Substantial damage NTSB IAD77DLT03Accident · No injuriesClosedRaven RX6 · Huntingdon, TNApr 10, 1977 · N1035R · Substantial damage NTSB IAD77FA032Accident · 4 fatalClosedPiper PA-28 · Powell, TNMar 26, 1977 · N8690W · Destroyed NTSB IAD77FLT02Accident · No injuriesClosedBellanca 14-13 · Parsons, TNFeb 25, 1977 · N86841 · Substantial damage NTSB IAD77DKW16Accident · No injuriesClosedPiper PA-24 · Greenville, TNFeb 25, 1977 · N5349P · Substantial damage NTSB IAD77FKW15Accident · No injuriesClosedCessna 150 · Gallatin, TNFeb 21, 1977 · N10858 · Substantial damage NTSB IAD77FLT01Accident · Serious injuriesClosedPiper PA-28 · Tiptonville, TNFeb 20, 1977 · N5305W · Substantial damage NTSB IAD77DKW14Accident · Minor injuriesClosedCessna 177 · Lafayette, TNFeb 16, 1977 · N43980 · Destroyed NTSB IAD77FKW13Accident · No injuriesClosedCessna 172 · Jamestown, TNFeb 11, 1977 · N4028F · Substantial damage