NTSB investigations, TN
22 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 4 |
| 1990 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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" = 310) 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 NYC07CA122Accident · Minor injuriesData collectionFinal reportHanson Gerald Hanson Bucker 131E · Memphis, TNThe pilot's inadequate visual lookout that resulted in a collision with a lighting structure in the grass while landing. A factor in the accident was the pilot's intentional landing in the runway safety area.NTSB ATL06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-2S2F · Memphis, TNThe improper towing of the airplane by the tug operator which resulted in the shearing of the towbar shear pin and subsequent collision of the airplane and tug.NTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .NTSB MIA00LA068Accident · No injuriesLimited investigationFinal reportDana A. Moore Danamite · Smyrna, TNthe pilot's excessive taxiing speed and failure to maintain adequate clearance from objects, resulting in the gyroplane's main rotor colliding with a fence and subsequent damage to the aircraft.NTSB MIA98LA124Accident · No injuriesLimited investigationFinal reportDouglas DC-10-10F · Memphis, TNThe tug operator's (maintenance representative) inadequate visual lookout during pushback.NTSB MIA97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Jackson, TNThe pilot's failure to maintain an adequate visual lookout while taxing. The reduced visibility was a factor.NTSB MIA97LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNthe student pilot's improper planning/decision, and his failure to maintain proper runway alignment during a crosswind landing. The strong crosswind was a related factor.NTSB ATL96FA101Accident · Serious injuriesField investigationFinal reportBoeing 737-200 · Nashville, TNthe captain's improper rejected takeoff, in that the takeoff was rejected after V1, and the flight attendants' improper use of the evacuation procedure, in that an evacuation was independently initiated without the captain's approval, and without assessing…NTSB MIA96LA107Accident · No injuriesLimited investigationFinal reportBoeing 727-225 · Memphis, TNfailure of the flightcrew to maintain clearance from construction equipment while taxiing after landing. Factors relating to the accident were: failure of operator personnel to supply the flightcrew with current NOTAM information, failure of ATC personnel to…NTSB ATL95LA038Accident · No injuriesLimited investigationFinal reportDouglas DC-9-32 · Memphis, TNThe ground personnel's improper handling of the aircraft while in tow, and the operator's failure to provide sufficient requirements for this situation.NTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.NTSB ATL91LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Centerville, TNThe propable cause of the accident was the runway incursion by the deer during the pilot's takeoff roll.NTSB ATL89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Union City, TNPIC made two sdf approaches. On the first approach he had difficulty seeing the rwy lights. The acft was aligned left of rwy and a missed approach was made. On the second approach the PIC said he had difficulty picking up any rwy lights. He landed with the…NTSB ATL89LA029Accident · No injuriesLimited investigationFinal reportCessna 172N · Rogersville, TNThe plt reported that he was ferrying the airplane to obtain scheduled maintenance. Upon arrival over the arpt, he found that the only rwy was closed for maintenance. He then elected to land on a taxiway. He made a short-field ldg and applied the brakes…NTSB ATL89FA020Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-31 · Memphis, TNThe acft was being taxied to the gate when its right wingtip struck a catering truck that had been driven off of the designated driving lanes & partially onto the taxiway. The flt crew rprtd that the truck was traveling in the same direction within the…NTSB ATL88LA152Accident · No injuriesLimited investigationFinal reportCessna 172F · Walland, TNThe pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft…NTSB ATL86FLT05Accident · No injuriesFinal reportPiper PA-14 · Memphis, TNThe acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started…NTSB ATL85LLT07Accident · Serious injuriesFinal reportBarnes FF-7 · Franklin, TNThe plt noticed a power line extending across the field he had selected for landing at which time air was released from the envelope for an emergency descent. As the basket touched down, the envelope drifted into the line. A passenger was seriously injuried…NTSB ATL85FA109Accident · Serious injuriesField investigationFinal reportMooney M20J · Chattanooga, TNThe plt was attempting to disengage the starter pinion gear by rocking the prop up & down by hand. The eng inadvertently started & the acft rolled across the ramp at a high rate of speed & collided with two automobiles & a chain link fence before coming to…NTSB ATL84LA257Accident · No injuriesLimited investigationFinal reportCessna 177RG · Shelbyville, TNThe acft collided with a parked truck on a taxiway en route to takeoff. The plt said he observed the parked truck on thetaxiway. There was another taxiway available but the plt continued on the congested one with the acft wing overlapping the truck by about 7…NTSB ATL82DA206Accident · No injuriesFinal reportPitts S2S · Somerville, TNShortly after touchdown during a formation landing, the wingman's aircraft struck an engine stand that had been placed over a hole in the runway. The hole was located about 900 ft from the approach end and was about 2 ft long, 1 ft wide, and 1 ft deep. It was…NTSB ATL82DKW06Accident · No injuriesFinal reportCessna 310 · Nashville, TNThe aircraft collided with a Cessna 310, N5253J at night after both planes had been cleared to the same runway. The other pilot stated that the Beech 95-55 was taxiing without lights. Reportedly, the Cessna pilot did not see the Beech 95-55 approaching from…