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 IAD79FKW13Accident · No injuriesClosedCessna 177RG · Nashville, TNJun 10, 1979 · N35647 · Substantial damage NTSB IAD79FKW15Accident · Minor injuriesClosedPiper PA-22 · Dunlap, TNJun 6, 1979 · N8619C · Destroyed NTSB IAD79FKW12Accident · Serious injuriesClosedMooney M-20E · Oak Ridge, TNMay 28, 1979 · N1254X · Substantial damage NTSB IAD79FKW14Accident · No injuriesClosedSchleicher KA8B · Benton, TNMay 26, 1979 · N170DR · Destroyed NTSB IAD79DKW11Accident · No injuriesClosedCessna 172 · Cleveland, TNMay 25, 1979 · N5052H · Substantial damage NTSB IAD79FKW10Accident · Minor injuriesClosedTaylorcraft F-19 · Elk Valley, TNMay 24, 1979 · N3679T · Substantial damage NTSB IAD79FA046Accident · No injuriesClosedCessna 421 · Sevierville, TNMay 4, 1979 · N123SM · Substantial damage NTSB IAD79FKW09Accident · No injuriesClosedCessna 172 · Murfreesboro, TNApr 26, 1979 · N20388 · Substantial damage NTSB IAF79FLT04Accident · No injuriesClosedCessna 150 · Memphis, TNApr 17, 1979 · N6099G · Substantial damage NTSB IAD79FLT03Accident · No injuriesClosedGrumman G-164 · Newbern, TNApr 10, 1979 · N6604 · Substantial damage NTSB IAD79FA042Accident · 2 fatalClosedCessna 175 · Livingston, TNApr 1, 1979 · N6734E · Destroyed NTSB IAD79FKW08Accident · Serious injuriesClosedPiper PA-28 · Mcdonald, TNMar 17, 1979 · N8517F · Substantial damage NTSB IAD79FLT02Accident · No injuriesClosedPiper PA-25 · Ridgely, TNMar 9, 1979 · N4381Y · Substantial damage NTSB IAD79FKW07Accident · No injuriesClosedPiper PA-25 · Sparta, TNMar 6, 1979 · N4390Y · Destroyed NTSB IAD79AA034Accident · Minor injuriesClosedBeech 3NM · Memphis, TNFeb 24, 1979 · N12VT · 2 aircraft · Destroyed NTSB IAD79FKW06Accident · 2 fatalClosedCessna 150F · Bristol, TNFeb 20, 1979 · N8555G · Substantial damage NTSB IAD79FKW05Accident · Minor injuriesClosedPiper PA-22 · Gatlinburg, TNFeb 12, 1979 · N3649Z · Destroyed NTSB IAD79FKW04Accident · No injuriesClosedCessna 310Q · Sevierville, TNFeb 6, 1979 · N377WB · Substantial damage NTSB IAD79FA028Accident · Serious injuriesClosedPiper PA-32 · Paris, TNJan 15, 1979 · N4815S · Destroyed NTSB IAD79FKW03Accident · Minor injuriesClosedCessna 210 · Crossville, TNJan 6, 1979 · N6911R · Destroyed NTSB IAD79FA023Accident · 1 fatalClosedPiper PA-34 · Blountville, TNDec 16, 1978 · N3024R · Destroyed NTSB IAD79FA021Accident · 1 fatalClosedCessna 150L · Bolivar, TNDec 4, 1978 · N1540Q · Substantial damage NTSB IAD79FKW02Accident · Serious injuriesClosedBeech A23 · Knoxville, TNDec 3, 1978 · N2308Q · Destroyed NTSB IAD79FLT01Accident · No injuriesClosedCessna 150 · Covington, TNNov 29, 1978 · N5585G · Substantial damage NTSB IAD79FA017Accident · 1 fatalClosedSwearingen SA26-T · Memphis, TNNov 22, 1978 · N2301N · Destroyed NTSB IAD79FA008Accident · 2 fatalClosedCessna 310I · Portland, TNNov 7, 1978 · N8037M · Destroyed NTSB IAD79FKW01Accident · 2 fatalClosedCessna 150G · Evensville, TNOct 28, 1978 · N3637J · Destroyed NTSB IAD79FA006Accident · 1 fatalClosedCessna 120 · Covington, TNOct 28, 1978 · N1811V · Substantial damage NTSB IAD78IA002Incident · No injuriesClosedPiper PA-30 · Selmer, TNOct 4, 1978 · N7020Y · Minor damage NTSB IAD79FA018Accident · 1 fatalClosedCessna 152 · Linden, TNOct 1, 1978 · N25955 · Destroyed NTSB IAD78FA111Accident · No injuriesClosedPiper PA-31 · Blountville, TNSep 19, 1978 · N7700L · Substantial damage NTSB IAD78FKW11Accident · Minor injuriesClosedHughes 269A · Columbia, TNSep 10, 1978 · N8808F · Substantial damage NTSB IAD78FA108Accident · 1 fatalClosedGrum Amer AA-5 · Jackson, TNSep 10, 1978 · N1375R · Destroyed NTSB IAD78DKW12Accident · No injuriesClosedMooney M20E · Coryton, TNSep 9, 1978 · N5962Q · Substantial damage NTSB IAD78FLT11Accident · No injuriesClosedCessna U206 · Memphis, TNSep 8, 1978 · N60768 · Substantial damage NTSB IAD78IA107Incident · No injuriesClosedBeech E18S · Blountville, TNSep 5, 1978 · N2070A · Minor damage NTSB IAD78FLT10Accident · Serious injuriesClosedRockwell 680F · Memphis, TNAug 22, 1978 · N680RG · Destroyed NTSB IAD78FKW10Accident · No injuriesClosedCessna 182 · Westmoreland, TNAug 9, 1978 · N735RT · Substantial damage NTSB IAD78FKW09Accident · Minor injuriesClosedLet-Np-K L-13 · Benton, TNAug 2, 1978 · N96AS · Substantial damage NTSB IAD78FLT08Accident · Minor injuriesClosedCessna 152 · Memphis, TNJul 31, 1978 · N49915 · Substantial damage NTSB IAD78FA084Accident · 1 fatalClosedCessna 172B · Selmer, TNJul 22, 1978 · N7684X · Destroyed NTSB IAD78FLT07Accident · No injuriesClosedAir Tractor AT301 · Ridgely, TNJul 18, 1978 · N4422S · Substantial damage NTSB IAD78FA087Accident · Minor injuriesClosedBell 47G2 · Pigeon Forge, TNJul 16, 1978 · N47WJ · Substantial damage NTSB IAD78FKW08Accident · No injuriesClosedCessna 172 · S.Pittsburg, TNJun 8, 1978 · N12982 · Substantial damage NTSB IAD78DA070Accident · No injuriesClosedDouglas DC-3 · Nashville, TNJun 8, 1978 · N51D · Substantial damage NTSB IAD78IA071Incident · No injuriesClosedPiper PA-32R · Chattanooga, TNJun 4, 1978 · N8929C · Minor damage NTSB IAD78FKW06Accident · Minor injuriesClosedCessna 210 · Powell, TNJun 4, 1978 · N2397F · Destroyed NTSB IAD78DLT06Accident · Serious injuriesClosedStitts SA3B · Camden, TNMay 27, 1978 · N5771 · Substantial damage NTSB IAD78FKW07Accident · Minor injuriesClosedRyan ST-3KR · Columbia, TNMay 21, 1978 · N54008 · Substantial damage NTSB DCA78AA013Accident · 6 fatalClosedSud Avtn DA-20 · Memphis, TNMay 18, 1978 · N121GW · 2 aircraft · Destroyed