• NC Software is having a Black Friday Sale Event thru December 4th on Logbook Pro, APDL - Airline Pilot Logbook, Cirrus Elite Binders, and more. Use coupon code BF2020 at checkout to redeem 15% off your purchase. Click here to shop now.
  • NC Software is proud to announce the release of APDL - Airline Pilot Logbook version 10.0. Click here to view APDL on the Apple App store and install now.

KCAS/KIAS to KTAS -- how to convert accurately?

Chr017

New member
Joined
Sep 21, 2017
Posts
1
Total Time
none
Good morning,

Someone had recommended that I use this formula to convert KCAS/KIAS to KTAS:

https://www.experimentalaircraft.info/flight-planning/aircraft-navigation-speed.php

If you scroll down to "True Airspeed, TAS," you will see this formula:

=KIAS*SQRT(SEA LEVEL AIR DENSITY/AIR DENSITY OF DESIRED ALT)

So, entered into an Excel spreadsheet cell, the formula would look like this:

--------------------------------------------------------------------------------------------------
=100*SQRT(1.225/0.905)

100 is the KIAS, 1.255 is air density at sea level, and 0.905 is air density at 10,000 feet.

This formula gives us 116 knots for KTAS.
--------------------------------------------------------------------------------------------------

This formula works for low airspeeds, but as airspeeds get higher, the KTAS that is given is not accurate. As I have learned, this formula does not take into account "compressibility," and therefore the KTAS will not be accurate at higher airspeeds.

I am interested in a formula that I can enter into my Excel spreadsheet that will give an accurate KTAS for all airspeeds up to Mach 3, and altitudes up to 100,000 feet.

Is there one particular formula that will work?

Thank you very much,

Chris
 
Top