NTSB investigations, TN
22 cases where the first occurrence was “Overrun”.
Cases per year
| 1983 | 2 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1997 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340)
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" = 340) 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 MIA08CA018Accident · No injuriesData collectionFinal reportCessna 172 · McKinnon, TNThe pilot's failure to perform a go around.NTSB NYC07LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sevierville, TNThe pilot misjudged his speed and distance resulting in an overrun. Contributing to the accident was the wet turf runway and the lack of any information in the pilot operating handbook regarding landing distance on a wet turf runway.NTSB ATL06CA084Accident · No injuriesData collectionFinal reportCessna 172L · Lexington, TNThe pilot's failure to attain the proper touchdown point during landing.NTSB ATL04LA022Accident · No injuriesLimited investigationFinal reportDiamond DA 20-C1 · Murfreesboro, TNThe pilot's failure to attain adequate airspeed, which resulted in a stall mush and collision with a taxiway sign. A factor was the pilot's delay in aborting the landing.NTSB ATL01LA055Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Dunlap, TNThe pilot's failure to obtain liftoff airspeed for undetermined reasons. A factor was tree stumps on the departure end of the takeoff area.NTSB ATL97LA130Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Murfreesboro, TNThe pilot's excessive airspeed, and improper touch down point during landing, that resulted in the runway end overun. Factors were the wet runway surface, and the embankment at the end of the runway.NTSB ATL97LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Athens, TNthe pilot's failure to initiate a go-around. The pilot's misjudged approach was a factor.NTSB MIA96LA031Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Cleveland, TNThe pilot's inaccurate weight and balance calculations which resulted in an over maximum allowable gross weight takeoff. Contributing to the accident was the wet, downsloping condition of the runway.NTSB ATL95LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Brownsville, TNThe pilot's improper in-flight decision to land on the wet, sod runway, and his failure to use all of the available runway for landing.NTSB ATL95LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-60 · Linden, TNThe pilot's failure to attain a proper touchdown point resulting in the aircraft overrunning the runway. Gusty weather conditions and the wet runway were also contributing factors.NTSB ATL94LA044Accident · No injuriesLimited investigationFinal reportCessna 310A · Dyersburg, TNThe failure of the pilot to attain a proper touchdown point, which resulted in a long landing and an overrun of the runway. Factors were the weather conditions (sky obscuration, low ceiling, fog and drizzle) at the time of the accident, and the wet runway…NTSB ATL93LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · Blountville, TNThe intentional operation of the aircraft with a partial failure of the brake system and the failure of the pilot to attain the proper touchdown point. Factors in the accident were the sunglare and the partial loss of the aircraft brake system.NTSB ATL92LA093Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Benton, TNThe pilot's misjudged approach to the open field, which resulted in the forced landing on the obstacle lined road.NTSB ATL91LA156Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Camden, TNThe student pilot's delayed decision to abort the takeoff, resulting in his inability to stop the airplane in the remaining runway. Factors were the pilot's lack of total flying experience, and the high outside air temperature at the time of the accident.NTSB ATL90LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to properly judge the stopping distance of the airplane and his subsequent failure to perform a go around. Factors in the accident were the tailwind condition at the airport.NTSB ATL90LA052Accident · Serious injuriesLimited investigationFinal reportAero Commander 680E · Knoxville, TNThe pilot's excessive airspeed and delay in initiating a go-around during the landing. Factors related to the accident were: the wet runway condition, the pilot's failure to attain the proper touchdown point for the landing, and his lack of flying experience…NTSB ATL88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Nashville, TNThe pilot aborted a takeoff after he felt that the aircraft was not performing properly. The pilot had four passengers on board which put the aircraft near its gross weight. The runway was 4300 feet long and the pilot needed about 1100 feet of runway for the…NTSB ATL86LLT08Incident · No injuriesFinal reportPiper PA-34 · Smithville, TNThe acft ran off the departure end of the rwy during landing. The acft reportedly landed 1/2 way down the 3400 ft rwy. The plt stated in a post acc interview that he was 'too high too fast and too long.'NTSB ATL86FA020Accident · Serious injuriesField investigationFinal reportHawker Siddeley DH 125-400A · Sparta, TNTen minutes prior to landing heavy rain fell on airport. Acft mad normal touchdown,spoilers & lift dump activated.PIC delayed brake application as usual and did not get thrust levers in idle. After acft passed mid-field taxiway PIC reported brakes became…NTSB ATL85FLT05Accident · Minor injuriesFinal reportPiper PA-28-180 · Arlington, TNThe acft overran the rwy during landing and contacted a ditch. A left quartering tailwind was present at the time of the landing.NTSB DCA83AA032Accident · Minor injuriesFinal reportGrumman G-159 · Blountville, TNThe coplt stated that when he began the apch to the destination arpt, the weather condition was hazy & he delayed his descent slightly until he located the arpt. When he saw the rwy, he believed that they were a little too close, so he indicated to the…NTSB ATL83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · St. Joseph, TNThe aircraft overran the end of the runway during a night landing in IMC weather. The runway was a private dirt strip. Flight purpose is not known but it is suspected it was a drug smuggling flight. The aircraft landed long on the 2400 foot strip and went off…