NTSB investigations, TN
38 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 4 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 4 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 1 |
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA26LA327Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · McMinnville, TNThe flight instructor’s delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB ERA26LA048Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Cookeville, TNThe pilot’s failure to maintain an appropriate decent rate during approach, resulting in a hard landing.NTSB ERA25LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Clarksville, TNThe flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.NTSB ERA24LA253Accident · No injuriesClass 4 · LimitedFinal reportDavis Lightning · Jamestown, TNThe non-certificated pilot’s failure to maintain control of the airplane during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB CEN23LA358Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor’s improper flight control inputs during the practice hovering autorotation that resulted in a loss of control and impact with terrain.NTSB ERA23LA205Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Springfield, TNA partial loss of engine power for undetermined reasons.NTSB ERA22LA311Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Livingston, TNThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA22LA101Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Lebanon, TNThe failure of the certified flight instructor to attain the proper glidepath which resulted in a collision with a fence and terrain.NTSB ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.NTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.NTSB ERA21LA070Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Nashville, TNThe pilot’s failure to use carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.NTSB ERA20CA090Accident · No injuriesClass 4 · Data collectionFinal reportPitts A · Hickory Valley, TNThe pilot’s improper fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA20CA043Accident · No injuriesData collectionFinal reportZenair Zenith 801 · Knoxville, TNThe pilot's failure to maintain a proper descent rate during the approach and his improper landing flare, which resulted in a hard landing.NTSB ERA19FA248Accident · Minor injuriesField investigationFinal reportTextron 680A · Elizabethton, TNThe pilot's continuation of an unstabilized approach despite recognizing associated cues and the flight crew's decision not to initiate a go-around before touchdown, which resulted in a bounced landing, a loss of airplane control, a landing gear collapse, and…NTSB ERA19LA228Accident · No injuriesClass 3 · LimitedFinal reportPietenpol BIG Piet · Gainesboro, TNSeparation of the spinner cap for reasons that could not be determined based on available evidence, which resulted in contact and subsequent separation of the wooden propeller blade tip.NTSB ERA18IA078Incident · No injuriesClass 3 · IncidentFinal reportAirbus Helicopters EC 130 · Memphis, TNThe pilot’s failure to lock the collective pitch control after landing, and the mechanic’s failure to properly balance the collective pitch control after converting the helicopter to a single-pilot configuration, which resulted in an uncommanded collective…NTSB GAA17CA467Accident · Serious injuriesData collectionFinal reportJames D Riggs RV-10 · Lawrenceburg, TNThe pilot’s improper landing flare and failure to maintain yaw control during a go-around in gusting wind conditions.NTSB GAA17CA300Accident · No injuriesData collectionFinal reportCessna 172 · Clarksville, TNThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard, porpoised landing.NTSB ERA16LA320Accident · No injuriesLimited investigationFinal reportBeech B100 · Jackson, TNThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA16CA479Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Benton, TNThe glider pilot's descent below the glidepath and the subsequent hard, off-airport landing.NTSB ERA16LA202Accident · Minor injuriesLimited investigationFinal reportBell 407 · Mountain City, TNAn incorrect and unapproved repair of the engine compressor diffuser performed by a machinist at a repair facility, which resulted in failure of the compressor diffuser aft plate and a partial loss of engine power.NTSB ERA14LA311Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Nashville, TNThe pilot’s failure to maintain rotor rpm during an autorotation after a perceived partial loss of power, which resulted in a hard landing. Contributing to the accident was radio frequency interference with the governor controller, which resulted in an…NTSB ERA14CA215Accident · Serious injuriesData collectionFinal reportSchleicher Alexander K 7 · Benton, TNThe pilot's distraction with traffic on the runway, and his subsequent failure to retract the air brakes prior to touchdown, which resulted in a hard landing.NTSB ERA14LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pinson, TNThe noninstrument-rated pilot’s decision to continue flight into deteriorating weather conditions at night and his failure to divert in a timely manner, which resulted in an off-airport precautionary landing and subsequent substantial damage to the airplane.NTSB DCA14FA058Accident · No injuriesClass 3 · FieldFinal reportEmbraer EMB145 - EP · Memphis, TNthe failure of the flight crew to adequately monitor the system for proper operation and manually activate the system during the flight in icing conditions. Contributing to the accident was the crew's limited training on the manual operation of the anti-ice…NTSB ERA13CA400Accident · Minor injuriesData collectionFinal reportMaxair Drifter Drifter II · Lafayette, TNThe pilot's failure to maintain aircraft control during the initial climb after takeoff in gusty wind conditions, which resulted in a hard off-airport landing.NTSB ERA13CA404Accident · No injuriesData collectionFinal reportCessna 172N · Knoxville, TNThe student pilot's improper flare and improper recovery from a bounced landing.NTSB ERA13CA345Accident · Serious injuriesData collectionFinal reportJim Braddock Just Aircraft Highla · Limestone, TNThe pilot’s improper recovery from a bounced landing.NTSB ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.NTSB ERA12CA420Accident · No injuriesData collectionFinal reportCessna 172M · Smyrna, TNThe pilot’s inadequate flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA12CA415Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Smyrna, TNThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB ERA12LA368Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Piney Flats, TNThe mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.NTSB ERA12CA209Accident · No injuriesData collectionFinal reportCessna 172S · Lafayette, TNThe pilot’s inadequate compensation for gusting crosswind conditions during landing, which resulted in a hard landing.NTSB ERA10LA484Accident · No injuriesLimited investigationFinal reportBell OH-58A · Covington, TNA loss of engine power due to contamination of the helicopter's fuel supply.NTSB ERA10CA372Accident · No injuriesData collectionFinal reportCessna 150M · Knoxville, TNThe student pilot's improper recovery from a bounced landing.NTSB ERA10LA325Accident · Minor injuriesLimited investigationFinal reportSchleicher ASH26 · Shelbyville, TNA complete loss of electrical and engine power over unsuitable terrain due to a cannon plug that became disconnected for undetermined reasons.NTSB ERA10TA292Accident · No injuriesFinal reportBell 206B · Memphis, TNThe pilot’s failure to maintain adequate rotor rpm and the certificated flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB NYC08CA120Accident · No injuriesData collectionFinal reportCessna 140 · Dayton, TNThe pilot's improper flare, which resulted in a hard landing.