Skip to content

NTSB investigations, TN

23 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) 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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
  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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200)
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 ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.Aug 6, 2005 · N42923 · Substantial damage NTSB ATL05CA119Accident · Minor injuriesData collectionFinal reportGlobe GC-1B · Athens, TNThe pilot's improper landing flare, which resulted in a hard landing.Jun 19, 2005 · N10KS · Substantial damage NTSB DCA04MA082Accident · No injuriesMajor investigationFinal reportBoeing MD-11 · Memphis, TNThe pilot's over-rotation during a go-around maneuver initiated because of a bounced landing. The go-around maneuver was initiated at a low speed and high pitch angle, and after reverse thrust was selected, contrary to Boeing and FedEx training guidance.Sep 19, 2004 · N601FE · Substantial damage NTSB ATL04LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe pilot's improper landing flare and his inadequate recovery from a bounced landing resulting in a hard landing and propeller strike of the runway.Mar 7, 2004 · N325LA · Substantial damage NTSB ATL04LA080Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Nashville, TNThe pilot's inadequate compensation for wind and his failure to maintain aircraft control which resulted in a hard landing. The pilot's decision to land in wind conditions that exceeded the demonstrated crosswind component, wind gusts, and a crosswind were…Mar 7, 2004 · N5655P · Substantial damage NTSB ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…Feb 29, 2004 · N9660T · Substantial damage NTSB DCA04MA011Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-10-10F · Memphis, TN1) the first officer's failure to properly apply crosswind landing techniques to align the airplane with the runway centerline and to properly arrest the airplane's descent rate (flare) before the airplane touched down; and 2) the captain's failure to…Dec 18, 2003 · N364FE · Destroyed NTSB ATL04LA068Accident · No injuriesLimited investigationFinal reportCessna 182L · Knoxville, TNThe pilot's improper flare and his inadequate compensation for wind conditions. Wind gust was a factorDec 16, 2003 · N3191R · Substantial damage NTSB ATL03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rogersville, TNThe pilot's improper landing flare which resulted in a hard landing.Mar 4, 2003 · N4135Q · Substantial damage NTSB MIA02LA129Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F21B · Somerville, TNThe pilot's improper landing flare resulting in a hard landing and damage to the airplane.Jul 6, 2002 · N4418F · Substantial damage NTSB MIA99IA249Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-31 · Nashville, TNA preexisting crack on the left main landing gear outer cylinder housing and the first officer's failure to maintain the proper rate of descent resulting in a hard landing on touchdown, and subsequent total failure and separation of the left main landing gear…Sep 9, 1999 · N993Z · Minor damage NTSB ATL99LA036Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Murfreesboro, TNThe pilot's inadequate flare and his diverted attention, which resulted in a hard landing.Dec 30, 1998 · N123NM · Substantial damage NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.Aug 15, 1998 · N9721D · Substantial damage NTSB MIA98LA132Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesboro, TNThe student pilot's improper flare during landing.Apr 14, 1998 · N704HL · Substantial damage NTSB ATL93LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Smyrna, TNThe improper flare and the improper go around procedures used by the pilotJun 22, 1993 · N63255 · Substantial damage NTSB ATL92LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNThe improper level off by the student pilot because of misjudging the airplane's altitude above the runway. A factor was her diverted attention by an aircraft behind her in the traffic pattern.Feb 2, 1992 · N6299Q · Substantial damage NTSB ATL88LA050Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Union City, TNThe plt rprtd the acft started to veer off the rwy after a 'rough' lndg. He atmtd to steer the plane with the steering control, but it would not respond. Subsequently, the acft veered off the rwy. About 50' to the side of the rwy, the nose gear hit a hole &…Nov 8, 1987 · N3849H · Substantial damage NTSB ATL88LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Wartburg, TNThe aircraft touched down hard on the 1300 foot grass strip and began to porpoise. The pilot attempted to go-around but was unable to gain sufficient altitude to avoid striking a power line. The plt did not file an acc report.Oct 23, 1987 · N3585J · Substantial damage NTSB ATL87LA265Accident · No injuriesLimited investigationFinal reportCessna 172 · Murfreesboro, TNDuring a practice landing the aircraft bounced three times which resulted in the failure of the nose gear structural support. The pilot said that he experienced gusty wind conditions prior to touchdown. The pilot did not properly compensate for or anticipate…Sep 23, 1987 · N733JZ · Substantial damage NTSB ATL87LA256Accident · No injuriesLimited investigationFinal reportHughes 269A · Morristown, TNOne CFI was demonstrating his procedures for autorotations with power recovery to his employer who was also a CFI. This was to insure standardization within the helicopter pilot school. The autorotation was entered from about 700 feet AGL to the departure…Sep 11, 1987 · N8709F · Substantial damage NTSB ATL84LA233Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Morrison, TNThe plt was giving free rides to his friends. He was attempting to land on rwy 27 when the 'aircraft lost lift at 15 feet above the rwy.' The acft dropped to the rwy in a three point attitude, the plt added power to regain control. The left wing tip and the…Jul 22, 1984 · N7912N · Substantial damage NTSB ATL83IA018Incident · No injuriesIncident investigationFinal reportBeech B99 · Clarksville, TNAs there were no passengers on the flight, the copilot was flying the leg from the left seat. On arrival over Clarksville, the captain instructed the first officer to execute a short field landing. The approach was normal until the aircraft was flared high…Oct 28, 1982 · N4099A · Minor damage NTSB ATL82FKW07Accident · Serious injuriesFinal reportPiper PA-28 · Hohenwald, TNOriginally, the pilot departed on a flight from olive branch, ms to lawrenceburg, TN. While en route, he became disoriented and landed at lafayette, TN. From there he proceeded to lawrenceburg via lebanon, TN. After departing lebanon, he became disoriented…Jun 2, 1982 · N1298T · Substantial damage