NTSB investigations, TN
60 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 4 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 3 |
| 2001 | 3 |
| 2003 | 4 |
| 2004 | 5 |
| 2006 | 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\" = 130)
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" = 130) 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 ANC07LA009Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Nashville, TNThe pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…NTSB ATL06CA097Accident · No injuriesData collectionFinal reportCessna R182 · Lebanon, TNImproper maintenance by other maintenance personnel resulting in the puncture of the landing gear hydraulic down line and the failure of the main landing gear to extended on landing.NTSB ATL04CA189Accident · No injuriesData collectionFinal reportBeech D18S · Tullahoma, TNRight tire burst during an attempted takeoff that resulted in loss of directional control and the on ground collision with the ground.NTSB ATL04LA171Accident · Minor injuriesLimited investigationFinal reportHawkins William Searey · Dayton, TNThe delamination of the fiberglass hull of the airplane.NTSB ATL04CA154Accident · No injuriesData collectionFinal reportGlassic Composites SQ-2000 XL · Dayton, TNThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop and the subsequent collapse of the landing gear.NTSB ATL04LA128Accident · 1 fatalLimited investigationFinal reportGrover J3 Kitten · Mohawk, TNThe pilot's decision to perform aerobatic flight in an airplane with known deficiencies that resulted in the in-flight separation of the airframe and the uncontrolled collision with the ground.NTSB ATL04IA119Incident · No injuriesIncident investigationFinal reportBeech 200 · Millington, TNThe pilots failure to follow the checklist for emergency landing gear extension resulting in the collapse of the main landing gear on touchdown.NTSB ATL04LA035Accident · No injuriesLimited investigationFinal reportCessna 210D · Millington, TNThe malfunction of the main hydraulic landing gear system actuator resulting in an emergency gear up landing.NTSB ATL03LA151Accident · Serious injuriesLimited investigationFinal reportSheppard S-2 · Obion, TNThe failure of the elevator control pushrod, that resulted in an uncontrolled descent and subsequent in-flight collision with ground.NTSB ATL03IA090Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Chattanooga, TNExcessive wear on the bushings and the right aileron inboard and outboard power control unit output link resulting in the upward movement of the right aileron during cruise climb, uncommanded right roll. A factor in the accident was inadequate maintenance…NTSB ATL03FA065Accident · 1 fatalField investigationFinal reportSikorsky S-61A · Kimble, TNThe interruption of rotor system drive power due to the input free wheeling unit malfunctioning , and the pilot's operation of the helicopter in the critical area of the height-velocity curve.NTSB ATL01LA091Accident · Serious injuriesLimited investigationFinal reportMitchell T-10 · Ashland City, TNThe restricted movement of the rudder cable, resulting in a loss of control and collision with trees.NTSB MIA01FA152Accident · 5 fatalField investigationFinal reportPiper PA-31-T2 · Jackson, TNThe pilot's shutting down the left engine following loss of control of the left propeller resulting in an in-flight loss of control of the airplane due to the windmilling propeller. Factors in the accident were the failure of the propeller control bracket…NTSB MIA01IA129Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Nashville, TNThe failure of company maintenance personnel to install the correct hydraulic landing gear extension component, and the failure of company maintenance inspection personnel to comply with proper post maintenance test procedures, resulting in the impossibility…NTSB MIA99LA220Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-10F · Memphis, TNThe inadequate design by the airplane manufacturer for using bolts to secure the inboard trailing edge flap that are susceptible to stress corrosion cracking. Also, the stress corrosion cracking failure of the four H-11 bolts that secure the left inboard…NTSB ATL99LA115Accident · No injuriesLimited investigationFinal reportBeech 55 · Nashville, TNThe total failure of the nose gear extension and retraction assembly that resulted in the collapse of the nose gear during landing.NTSB MIA99LA181Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Sevierville, TNThe induced fatigue fracture of a component in the engine-to-transmission rotor drive system resulting in a disconnection of the drive system during cruise flight caused by inadequate inspection processes by the manufacturer and the subsequent autorotative…NTSB MIA98LA096Accident · Serious injuriesLimited investigationFinal reportDouglas DC-10-30F · Memphis, TNground personnel (an equipment loader) failed to follow established written procedures (ramp safety policy), resulting in a pressurized entry door being opened before it was fully depressurized, subsequently injurying the equipment loader. The malfunctioning…NTSB MIA98LA084Accident · 1 fatalLimited investigationFinal reportWalter J Collie Cumulus · Hillsboro, TNDebonding of the leading edge to spar cap joint, which resulted in inflight separation.NTSB CHI98IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-212 · Memphis, TNthe inadequate (bronze) material used by the fuel pump's manufacturer, which wore and ultimately blocked the fuel filter bypass and partially blocked the fuel nozzles, causing the fuel spray to burn through the low pressure turbine case.NTSB ATL97LA100Accident · No injuriesLimited investigationFinal reportBeech 55 · Murfreesboro, TNThe failure of the aircraft braking system due to low brake pressure resulting from the undetermined loss of brake fluid from the brake reservoir.NTSB MIA97TA139Accident · No injuriesFinal reportBell 204-B · Calderwood, TNThe inadequate maintenance inspection of the helicopter resulting in loss of lubrication from the main drive shaft going undetected until failure of the drive shaft.NTSB ATL96LA118Accident · No injuriesLimited investigationFinal reportCessna 172N · Nashville, TNinadequate annual inspection by other maintenance personnel and inadequate pre-flight inspection by the pilot.NTSB ATL96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32-RT-300 · Blountville, TNInadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.NTSB ATL96FA043Accident · No injuriesField investigationFinal reportDouglas DC-9-32 · Nashville, TNthe failure of the right main landing gear shock strut cylinder due to preexisting fractures. Contributing to the accident was: the failure of the operator to inspect the shock strut cylinder for fractures following a previous failure of the torque links, and…NTSB MIA96FA059Accident · Minor injuriesClass 1 · FieldFinal reportDouglas DC-9-32 · Nashville, TNthe flight crew's improper procedures and actions (failing to contact system operations/dispatch, failing to use all available aircraft and company manuals, and prematurely resetting the ground control relay circuit breakers) in response to an in-flight…NTSB ATL95FA078Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Covington, TNThe pilot exceeded the design stress limits of the aircraft and subsequent overload failures of the stabilator and wing spars.NTSB ATL95LA011Accident · No injuriesLimited investigationFinal reportCessna 185 · Elizabethton, TNThe flexing of the rudder pedal control locking assembly which resulted in the collapse of the co-pilot's left pedal during heavy braking.NTSB ATL94LA050Accident · Serious injuriesLimited investigationFinal reportArgo Minimax · Franklin, TNThe pilot's failure to secure cargo in the cockpit.NTSB ATL93LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Grandview, TNFailure of the aircraft battery.NTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…NTSB ATL92IA169Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Chattanooga, TNThe failure and subsequent seizure of the reduction gear box, and the failure of the propeller control unit as a result of contaminated oil supply which is shared with the gear box.NTSB ATL92LA110Accident · 1 fatalLimited investigationFinal reportWicks Bobcat · White House, TNThe pilot/owner's improper design change of the wing spar which resulted in the overload failure of the left wing. A factor was the pilot/owner's failure to perform a periodic inspection.NTSB ATL91FA013Accident · Serious injuriesField investigationFinal reportBell 47J-2 · Gatlinburg, TNThe accident was inadequate maintenance of the helicopter, allowing a tail rotor drive shaft bearing to exceed wear limits. This resulted in high loads on the tail rotor drive shaft, and the resulting fatigue failure of the drive shaft.NTSB ATL91FA006Accident · 1 fatalField investigationFinal reportOlsen-Gordon Veri EZE · Hohenwald, TNThe failure of the left rudder control cable which rendered the airplane uncontrollable.NTSB ATL90FA089Accident · 1 fatalField investigationFinal reportHiller UH-12D · Soddy-Daisy, TNFatigue induced failure of the collective pitch push rod (adjustable) during flight, and the failure of the pilot to provide routine maintenance. The pilot's lack of expereince and his failure to obtain required training and certification were factors in the…NTSB ATL90LA088Accident · No injuriesLimited investigationFinal reportMooney M20F · Murfreesboro, TNFatigue failure of the propeller blade which resulted in a forced off-airport landing.NTSB ATL89DLT03Accident · No injuriesFinal reportBell 47 · Shelbyville, TNFailure in the rotor drive system for unknown reasons. Contributing to the accident was the pilot's inability to perform an autorotation.NTSB ATL89DLT02Accident · No injuriesFinal reportSchweizer SGU-2-22E · Benton, TNAs the student pilot was attempting a dual aerial tow flight at 100 feet AGL, he experienced difficulty in staying behind the tow plane. The instructor took over the controls and while applying full right aileron noted no aileron movement. At 300 feet AGL the…NTSB ATL88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, TNThe pilot reported that while in cruise flight he had a partial then total electrical failure. During the off- airport emergency landing on a wet, grassy field, the pilot was unable to stop before sliding into a culvert. Examination of the airplane revealed…NTSB ATL88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Murfreesboro, TNThe rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using…NTSB ATL87LA119Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Clarksville, TNThe pilot lost tail rotor control in cruise flight after the tail rotor drive shaft separated. The tail rotor system had sustained previous damage about 4 years prior to this accident when, while being operated as a public use aircraft, the helicopter skidded…NTSB ATL87LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Waverly, TNThe plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…NTSB ATL87IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Livingston, TNThe braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control…NTSB ATL86IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-295 · Nashville, TNThe flight experienced a fire warning light descending through 10500 feet for landing at Nashville. The aircraft landed without incident. The passengers evacuated the aircraft using evacuation slides. Examination of the aircraft disclosed that the detection…NTSB ATL86LA073Accident · No injuriesLimited investigationFinal reportCessna U206B · Columbia, TNSoon after departure the plt experienced a severe vibration throughout the acft. Eng pwr was retarded and the vibration subsided. The plt then noticed aileron control problems and noticed the left wing tip was moving up and down. An emergency landing was made…NTSB ATL86LLT06Accident · Serious injuriesFinal reportPiper PA-22 · Jasper, TNThe acft crashed into a house before striking the ground in an uncontrolled descent. The acft was approaching marion arpt for a landing when the plt lost control. The plt said that the stabilizer adjustment 'stripped'. The pilot was using the trim tab when…NTSB ATL85LA184Accident · No injuriesLimited investigationFinal reportCessna T337G · Knoxville, TNThe acft made an emergency gear up landing when both the normal and emergency extension systems failed to function properly. A mechanic was later able to extend the gear with the acft on jacks by repeatedly cycling the selector switch. It was determined that…NTSB ATL85FA068Accident · 1 fatalField investigationFinal reportGyrocopter B-8M · Madisonville, TNStudent pilot attempting flight in Gyrocopter loss control cusing main rotor system to contact the rudder system. Pilot was not qualified to conduct this flight. A/c was not assigned an identification number.NTSB ATL85LA036Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Eads, TNThe plt stated that he was taking off with full pwr. The acft accelerated to about 60 when it went over a small rise in the rwy, the left wheel assembly seperated from the acft at the pt where it attaches to the landing gear strut. The strut dug into the gnd…