Ongoing NTSB investigations, TN
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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.
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 12 |
| 2026 | 10 |
Where
Open the mapLatest cases
Query with SQL
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'
AND c.\"completionStatus\" = 'Ongoing'
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' AND c."completionStatus" = 'Ongoing' 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 ERA26LA357Accident · No injuriesClass 4 · LimitedInvestigation openGrumman American Avn. GA-7 · Knoxville, TNNTSB ERA26LA360Accident · No injuriesClass 4 · LimitedInvestigation openCessna 421B · Nashville, TNNTSB ANC26LA096Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna R182 · Lebanon, TNOn September 1, 2026, about 1815 eastern daylight time, a Cessna R182 airplane was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA321Accident · No injuriesClass 4 · LimitedInvestigation openCessna R182 · Clarksville, TNNTSB ERA26LA306Accident · Serious injuriesClass 4 · LimitedInvestigation openPowrachute Pegasus · Humboldt, TNNTSB ERA26LA257Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Lafayette, TNOn July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14…NTSB ERA26FA241Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 177RG · Morrison, TNOn June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…NTSB ERA26FA165Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 58 · New Market, TNOn April 13, 2026, about 1308 eastern daylight time, a Beechcraft 58 multi-engine airplane, N2063G, was destroyed when it was involved in an accident near New Market, Tennessee. The flight instructor and the commercial pilot were fatally injured. The airplane…NTSB ERA26LA127Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-151 · Arno, TNOn February 24, 2026, about 1107 central standard time, a Piper PA-28-151, N85RW, was substantially damaged when it was involved in an accident near Arno, Tennessee. The pilot was not injured. The airplane was operated as a 14 Code of Federal Regulations Part…NTSB ERA26LA093Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 177 · Ocoee, TNOn January 13, 2026, about 1530 eastern standard time, a Cessna 177B, N34959, was substantially damaged when it was involved in an accident near Ocoee, Tennessee. The pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26FA035Accident · 1 fatalClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Lebanon, TNOn November 8, 2025, at 1341 central standard time, an Airbus Helicopters EC 130 T2, N107VU, was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot and flight paramedic were seriously injured, and the flight nurse was…NTSB ERA26LA031Accident · Minor injuriesClass 3 · LimitedPreliminary reportProctor E Ray Exec 162F · Athens, TNOn November 04, 2025, at about 1400 eastern standard time, an amateur built experimental Rotorway 162F, N162RW, was destroyed when it was involved in an accident near Athens, Tennessee. The commercial pilot received minor injuries. The airplane was operated…NTSB ERA26LA024Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Somerville, TNOn October 24, 2025, about 1815 central daylight time, a Piper PA-28-140, N3905F, was substantially damaged when it was involved in an accident at Fayette County Airport (FYE), Somerville, Tennessee. The pilot sustained minor injuries. The airplane was…NTSB ERA25LA346Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-24-180 · Ashland City, TNOn September 5, 2025, at 1645 central daylight time, N5759P, a Piper Cherokee PA-24-180, sustained substantial damage when it was involved in an accident near Ashland City, Tennessee. The private pilot sustained minor injuries. The flight was conducted as a…NTSB DCA25LA291Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus A319 · Nashville, TNOn August 14, 2025, about 1724 central daylight time (CDT), Air Canada Rouge flight ROU1717, an Airbus A319 airplane, registration C-GSJB, touched down short of runway 20L while landing at the Nashville International airport (BNA), Nashville, TN. There were…NTSB ERA25LA290Accident · Serious injuriesClass 3 · LimitedPreliminary reportGary W Lewinski Sonex · Tellico Plains, TNOn August 5, 2025, about 1131 eastern daylight time, a Lewinski Sonex, N67BG, was substantially damaged when it was involved in an accident near Tellico Plains, Tennessee. The private pilot was seriously injured. The airplane was operated as a Title 14?Code…NTSB ERA25FA253Accident · 1 fatalClass 3 · FieldPreliminary reportErcoupe 415 · Gallatin, TNOn July 2, 2025, about 1300 central daylight time, an Ercoupe 415-C, N93985, was substantially damaged when it was involved in an accident near Gallatin, Tennessee. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25FA239Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dunlap, TNOn June 24, 2025, about 18:23 central daylight time, a Piper J3C-65, N28DR, was substantially damaged when it was involved in an accident near Dunlap, Tennessee. The commercial pilot was fatally injured and the passenger was seriously injured. The airplane…NTSB ERA25LA227Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Hartsville, TNOn June 12, 2025, about 1750 central daylight time, a Cirrus SR22, N312DA, was substantially damaged when it was involved in an accident near Hartsville, Tennessee. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA222Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-6 Twin Otter · Tullahoma, TNOn June 8, 2025, about 1220 central daylight time, a DeHavilland DHC-6 Twin Otter, N166DH, was involved in an accident near Tullahoma, Tennessee. The commercial pilot and five passengers were seriously injured, and 15 passengers were not injured. The flight…NTSB ERA25FA187Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20TN · Sparta, TNOn April 26, 2025, about 1147 central daylight time, a Mooney M20TN, N242RE, was substantially damaged when it was involved in an accident near Sparta, Tennessee. The private pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB WPR25FA126Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20F · Reliance, TNOn April 11, 2025, about 1402 eastern daylight time, a Mooney M20F, N7026V, sustained substantial damage when it was involved in an accident near Reliance, Tennessee. The pilot, pilot-rated passenger and passenger were fatally injured. The airplane was…NTSB DCA24FA300Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 737-9 · Nashville, TNOn September 12, 2024, about 0914 central daylight time (CDT), Alaska Airlines flight 369 (ASA369), a Boeing 737-900, N919AK, rejected their take-off on runway 13 at Nashville International Airport (BNA), Nashville, Tennessee, when Southwest Airlines flight…NTSB ERA24FA274Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT502 · Martin, TNOn June 25, 2024, about 0820 central daylight time, an Air Tractor, Inc. AT-502A, N325RA, was substantially damaged when it was involved in an accident near Martin, Tennessee. The commercial pilot was fatally injured. The airplane was operated as a Title…