NTSB investigations, TN
17 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 354)
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" = 354) 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 NYC07LA134Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Gallatin, TNThe pilot’s mismanagement of fuel which led to fuel starvation and loss of engine power. Contributing to the accident was the pilot’s failure to utilize the proper engine restart procedures, and the hard landing.NTSB ATL05CA028Accident · No injuriesData collectionFinal reportEnstrom F-28A · Smyrna, TNThe loss of engine power for undetermined reasons, and the pilot's improper flare during forced landing, which resulted in an inflight collision into an open field.NTSB ATL04FA051Accident · 4 fatalField investigationFinal reportCessna 414 · Greeneville, TNThe pilot's failure to maintain airspeed while maneuvering in icing conditions on a circling approach for landing resulting in an inadvertent stall and collision with trees and terrain. A factor in the accident was a partial loss of engine power due to the…NTSB MIA02LA080Accident · 1 fatalLimited investigationFinal reportGary L. Zeigler Monnett Moni · Sevierville, TNThe failure of the pilot to maintain airspeed while turning to reverse direction resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees. A factor in the accident was the failure of the pilot to tighten the spark plugs…NTSB MIA00LA100Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Dandridge, TNthe student pilot's improper preflight that resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and a forced landing in the trees and damage to the aircraft. Contributing to the accident were the student's…NTSB ATL99LA094Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Millington, TNLoss of engine power due to undetermined reasons. Factors were weather conditions favorable to carburetor ice and the terrain condition at the forced landing site.NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…NTSB ATL95LA170Accident · No injuriesLimited investigationFinal reportBeech A35 · Knoxville, TNThe pilot's failure to use the carburetor heat during the approach. The factors were: failure to obtain a weather briefing, and weather conditions favorable for the formation of carburetor icing.NTSB ATL94IA092Incident · No injuriesIncident investigationFinal reportSaab-Scania S340B · Nashville, TNEngine ice/slush ingestion that resulted in power interruptions and failure of the air data computer coupled with moisture ingestion of the static system. Factors were the failure of the manufacturer to correct a previously identified design deficiency that…NTSB ATL93FA155Accident · 2 fatalField investigationFinal reportBeech F35 · Jackson, TNThe improper use of old auto fuel for the refueling of the aircraft. Factors in the accident were the deterioration of the octane in the auto fuel being used in the aircraft and the delayed decision by the pilot to choose a suitable area and execute a forced…NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB ATL89LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Cleveland, TNFlight into known adverse weather by the pilot and his delay in diverting to an alternate airport which led to a partial power loss and an emergency landing. The weather conditions and soft terrain were contributing factors.NTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…NTSB ATL87FA136Accident · 2 fatalField investigationFinal reportPiper J4A · Collierville, TNIt was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…NTSB ATL84FLT07Accident · No injuriesFinal reportWeatherly 201C · South Fulton, TNFive miles after takeoff the acft engine began sputtering and losing power. The plt dumped his load and still could not maintain flight. The acft could not be stopped before colliding with fence and trees during a downwind landing on wet pasture grass.…NTSB ATL83LA321Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jamestown, TNThe acft crashed in trees during a forced landing after takeoff. The pilot said that during climbout the engine failed to develop full power. The pilot reported that the carburetor heat control was in the cold position. The pilot elected to land straight…