NTSB investigations, TN
14 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 3 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2004 | 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\" = 352)
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" = 352) 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 ATL05FA032Accident · 5 fatalField investigationFinal reportCessna 421B · Apison, TNThe pilot's improper identification of a partial loss of engine power on initial takeoff climb resulting in a collision with trees and the ground. A factor was a partial failure of the left engine starter adapter due to overload.NTSB ATL00LA046Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401-B · Lawrenceburg, TNThe loss of engine power due to a stuck exhaust valve that resulted in the collision with a tree while maneuvering for the forced landing.NTSB MIA98LA130Accident · 1 fatalLimited investigationFinal reportStarck Auriga · Collegedale, TNA leak in the electric fuel boost pump caused by an improperly sized 'O' ring installation and the pilot's failure to maintain airspeed during an approach to a forced landing resulting in a stall.NTSB MIA97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Lexington, TNfailure of the pilot to abort the takeoff after encountering excessive ground roll, and failure (or inability) of the pilot to obtain/maintain adequate airspeed, which resulted in an inadvertent stall. Factors relating to the accident were: restricted…NTSB MIA95FA200Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pulaski, TNFailure of the pilot to perform the before-takeoff checklist, and his failure to abort the takeoff due to inadequate acceleration. Contributing to the accident was an inadequate annual inspection by maintenance personnel for failure to safety the carburetor…NTSB ATL90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Midway, TNTotal failure of the number four exhaust valve, resulting in engine power loss and the subsequent forced landing of the airplane.NTSB ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.NTSB ATL89LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, TNThe separation of the mixture cable from the carburetor. Contributing factor(s) was: inadequate maintenance and inspection of the airplane and the soft terrain encountered during the forced landing.NTSB ATL88LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Covington, TNThe plt reported that the engine suddenly began to run rough and backfire during a pipeline patrol flight at 300 ft AGL. The roughness worsened and the plt made a forced ldg on a dirt road. During rollout, one of the wings caught vegetation bordering the road…NTSB ATL88LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Michie, TNWitness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…NTSB ATL84FA277Accident · Serious injuriesField investigationFinal reportBell 222 · Knoxville, TNThe helicopter was in a hover when a rt pedal turn was initiated and a climb attempted. Plt stated, 'I was unable to climb, and the aircraft began to lose rotor RPM. I increased power to 100% mrtq. The acft was settling.' Unable to sustain flt, a landing was…NTSB ATL84FA251Accident · 3 fatalField investigationFinal reportDouglas DC3C-S1C3G · Memphis, TNMoments after the DC-3 took off, the twr ctlr noted the l eng was torching & asked the flt if it was 'having a problem.'the crew replied 'affirmative,' then the ctlr clrd the flt to lnd on any rwy. The acft began turning left at the end of the rwy & contd…NTSB ATL84IA246Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-30 · Nashville, TNDuring the climb-out, a 15% decrease in the right eng epr was noted by the flt crew. This was followed by a loud bang & failure of the #2 eng. The #2 eng was shut down & the acft was flown back to the departure arpt. An initial exam revealed that the right…NTSB ATL83FA312Accident · No injuriesField investigationFinal reportSikorsky S-58D · Gatlingurg, TNThe helicopter collided with terrain on a wooded mountainside after liftoff. The plt said a power loss occurred after itwas to late to abort. Takeoff was made from a lot that was 5200 ft MSL. The plt hover-checked at 2500 RPM and 39.5 inches of manifold…