Source document: https://docs-lawep.s3.us-east-2.amazonaws.com/1697630944427.pdf (Australia)
Senate Committee -­‐ Aviation Accident Investigations (Pel-­‐Air) Submission by Richard James Davies Annex D -­‐ Accident Flight Calculations.xlsx Copyright Richard James Davies, 2012.
All rights reserved Not to be used without permission of Richard Davies Note: No Performance Correction Factors used from published figures User Entered From Planning Manual Depart Destination Route Distance ZFW Fuel Load TOTAL Ramp Weight Fuel Used INITIAL SEGMENT Distance Flight Fuel Initial Climb Cruise MID SEGMENT 1 Distance Flight Fuel Altitude Change Cruise MID SEGMENT 2 Distance Flight Fuel Altitude Change Page 1 of 2 GNM lbs Litres Fuel SG lbs lbs Start Taxi Takeoff To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used NSFA YSNF 1449 14606 4164 0.78 7160 21766 0 0 0 KILAN 292 21766 0 39000 +10 -­‐20 36 1200 208 196 96 -­‐20 +10 0.72 20382 1612 417 15 390 APASI 209 20018 39000 39000 +10 -­‐35 0 0 0 0 209 -­‐35 +10 0.72 19600 1462 417 33 800 DOLSI 513 19138 39000 39000 +10 -­‐75 0 0 = US Gallons 1100 To start of next Altitude Change Cruise MZW Check TOPC End Cruise MZW Error 20446 20018 20232 -­‐150 Time Interval Elapsed Time Fuel Remaining at KILAN 51 51 5412 minutes minutes if VFR used To start of next Altitude Change Cruise MZW Check End Alt.
Change End Cruise MZW Error 20018 19138 19578 -­‐22 Time Interval Elapsed Time Fuel Remaining at APASI 33 83 4532 minutes minutes if VFR used To start of next Altitude Change Senate Committee -­‐ Aviation Accident Investigations (Pel-­‐Air) Submission by Richard James Davies Annex D -­‐ Accident Flight Calculations.xlsx Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Type EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise Start Alt Finish Alt Wind Component Time Fuel Used Distance (ANM) GNM Approach Landing Cruise MID SEGMENT 3 Distance Flight Fuel Altitude Change Cruise FINAL SEGMENT Distance Flight Fuel Altitude Change Cruise Descent to Destination Fuel Used ARRIVAL FUEL 0 0 513 -­‐75 +10 0.72 17978 1364 417 90 2045 Cruise MZW Check End Alt.
Change End Cruise MZW Error 19138 16888 18013 36 Time Interval Elapsed Time Fuel Remaining at DOLSI 90 173 2282 minutes minutes if VFR used 0 To start of next Altitude Change 16888 39000 39000 +10 -­‐65 0 0 0 0 0 -­‐65 +10 0.72 16888 1326 417 0 0 YSNF 435 16888 39000 39000 +10 -­‐65 0 0 0 0 358 -­‐65 +10 0.72 16104 1251 417 61 1272 39000 0 -­‐30 16 158 85 77 0 0 709 Cruise MZW Check End Alt.
Change End Cruise MZW Error 16888 16888 16888 0 Time Interval Elapsed Time Fuel Remaining at 0 0 173 2282 minutes minutes if VFR used Cruise MZW Check End Alt.

Change End Cruise MZW Error 16888 15489 16189 85 Time Interval Elapsed Time Fuel Remaining at YSNF 77 250 709 minutes minutes if VFR used NOTES EMZW checks use average TAS 380 & 23 lb per minute TAS = 38.975 X Mach Number X Square Root of Absolute Temperature (Where Absolute Temperature °K = SAT °C + 273.15) Page 2 of 2