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 IAD73II008Incident · No injuriesClosedBeech 65-80 · Jackson, TNApr 26, 1973 · N143 · Minor damage NTSB IAD73FLT15Accident · Serious injuriesClosedBell 47G-4 · Humboldt, TNApr 25, 1973 · N2245W · Destroyed NTSB IAD73FKW24Accident · No injuriesClosedAmer Avco AA-1 · Chattanooga, TNApr 19, 1973 · N5621L · Substantial damage NTSB IAD73AI010Accident · 4 fatalClosedPiper PA-23 · Gatlinburg, TNApr 3, 1973 · N40233 · Destroyed NTSB IAD73FKW21Accident · No injuriesClosedMooney M20F · Alcoa, TNMar 23, 1973 · N3591N · Substantial damage NTSB IAD73DKW20Accident · No injuriesClosedFunk B85C · Rockwood, TNMar 22, 1973 · N8113H · Substantial damage NTSB MIA73FKW19Accident · No injuriesClosedAmer Avco AA1 · Murfreesboro, TNFeb 28, 1973 · N5916L · Substantial damage NTSB MIA73FKW18Accident · No injuriesClosedPiper PA-30 · Nashville, TNFeb 16, 1973 · N8513Y · Substantial damage NTSB MIA73AM082Accident · 2 fatalClosedAero Comdr 500B · Alcoa, TNFeb 8, 1973 · N6166X · Destroyed NTSB MIA73AM081Accident · 4 fatalClosedBeech D18S · Paris, TNFeb 7, 1973 · N80042 · Destroyed NTSB MIA73AM077Accident · 3 fatalClosedCessna 182B · Townsend, TNJan 27, 1973 · N7295E · Destroyed NTSB MKC73DKW15Accident · No injuriesClosedSwearingen SA226T · Chattanooga, TNJan 7, 1973 · N664MC · Substantial damage NTSB MIA73AM069Accident · 2 fatalClosedCessna 310P · Memphis, TNJan 1, 1973 · N5728M · Destroyed NTSB MIA73FKW14Accident · No injuriesClosedPiper PA-28 · Chuckey, TNDec 31, 1972 · N8032W · Substantial damage NTSB MIA73AM067Accident · 2 fatalClosedCessna 150H · Beechgrove, TNDec 25, 1972 · N22545 · Destroyed NTSB MIA73DKW13Accident · Minor injuriesClosedCessna 182B · Gainesboro, TNDec 12, 1972 · N2491G · Substantial damage NTSB MIA73DKW12Accident · No injuriesClosedCessna 172G · Waverly, TNDec 1, 1972 · N5965R · Substantial damage NTSB MIA73AM058Accident · 3 fatalClosedBeech G35 · Nashville, TNNov 27, 1972 · N4548D · Destroyed NTSB MIA73DKW11Accident · Serious injuriesClosedCessna 177 · Flagpond, TNNov 25, 1972 · N2360Y · Substantial damage NTSB MIA73FLT12Accident · Serious injuriesClosedPiper PA-30 · Memphis, TNNov 6, 1972 · N7684Y · Destroyed NTSB MIA73DLT13Accident · No injuriesClosedGrumman G-164 · Wynnburg, TNNov 6, 1972 · N493Y · Substantial damage NTSB MIA73DLT11Accident · No injuriesClosedHughes 269B · Millington, TNNov 1, 1972 · N9468F · Substantial damage NTSB MIA73DKW10Accident · No injuriesClosedPiper PA-24 · Kingston, TNOct 22, 1972 · N119Q · Substantial damage NTSB MIA73AM042Accident · 2 fatalClosedCessna 150L · Eads, TNOct 16, 1972 · N18142 · Destroyed NTSB MIA73AM040Accident · 3 fatalClosedCessna 172K · Oliver Spgs, TNOct 13, 1972 · N79433 · Destroyed NTSB MIA73FKW09Accident · No injuriesClosedCessna 337G · Knoxville, TNOct 4, 1972 · N1826M · Substantial damage NTSB MIA73DLT10Accident · No injuriesClosedCessna 172 · Stantonville, TNOct 1, 1972 · N9167B · Substantial damage NTSB MIA73FLT08Accident · 1 fatalClosedPiper PA-25 · Newbern, TNSep 27, 1972 · N6306Z · Destroyed NTSB MIA73FLT07Accident · No injuriesClosedCessna 150K · Memphis, TNSep 27, 1972 · N5772G · Substantial damage NTSB MIA73FLT05Accident · No injuriesClosedCessna 150F · Memphis, TNSep 23, 1972 · N8279S · Substantial damage NTSB MIA73DLT04Accident · No injuriesClosedPiper PA-25 · Jackson, TNSep 15, 1972 · N4747Y · Substantial damage NTSB MIA73DKW08Accident · No injuriesClosedVolmer Jnsn VJ-22 · Nashville, TNSep 7, 1972 · N2416 · Substantial damage NTSB MIA73FKW06Accident · Minor injuriesClosedCessna 172 · Morristown, TNAug 31, 1972 · N7854T · Substantial damage NTSB MIA73FKW05Accident · No injuriesClosedCessna 182N · Gatlinburg, TNAug 23, 1972 · N7265G · Substantial damage NTSB MIA73AM014Accident · 5 fatalClosedCessna 421 · Cleveland, TNAug 7, 1972 · N123QF · Destroyed NTSB MIA73AM012Accident · 1 fatalClosedPiper PA-22 · N.Johsnville, TNJul 26, 1972 · N4525Z · Destroyed NTSB CHI73AC008Accident · Serious injuriesClosedConvair 880 · Knoxville, TNJul 22, 1972 · N8810E · No damage NTSB MIA73DKW04Accident · No injuriesClosedCessna 172 · Clarksville, TNJul 16, 1972 · N1705F · Substantial damage NTSB MIA73DLT01Accident · Serious injuriesClosedCessna 150 · Milan, TNJul 14, 1972 · N2940J · Substantial damage NTSB MIA73FKW02Accident · No injuriesClosedCessna 337 · Alcoa, TNJul 11, 1972 · N86118 · Substantial damage NTSB MIA73FKW01Accident · No injuriesClosedGreat Lakes 2T-1A · Chattanooga, TNJul 9, 1972 · N828K · Substantial damage NTSB MIA73FKW03Accident · No injuriesClosedBeech 56TC · Springfield, TNJul 8, 1972 · N3792Q · Substantial damage NTSB MIA72DLT16Accident · Minor injuriesClosedPiper PA-25 · Trimble, TNJun 29, 1972 · N4837Y · Destroyed NTSB MIA72DKW31Accident · No injuriesClosedCessna 210 · Elizabethton, TNJun 26, 1972 · N6198R · Substantial damage NTSB MIA72AM140Accident · 1 fatalClosedAmer Avco AA-1 · Byrdstown, TNJun 23, 1972 · N101FT · Destroyed NTSB MIA72AM137Accident · 1 fatalClosedRyan PT-22 · Arlington, TNJun 17, 1972 · N47554 · Destroyed NTSB MIA72AM132Accident · 1 fatalClosedBeech D18S · Nashville, TNJun 10, 1972 · N7526 · Substantial damage NTSB MIA72FKW30Accident · Serious injuriesClosedCessna 172F · Pulaski, TNJun 9, 1972 · N7823U · Substantial damage NTSB MIA72DKW29Accident · No injuriesClosedChampion 7ECA · Concord, TNMay 24, 1972 · N5188X · Substantial damage NTSB MIA72FKW28Accident · No injuriesClosedPiper J3C-65 · Elizabethton, TNMay 23, 1972 · N98429 · Substantial damage