NTSB investigations, 2014, AZ

10 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2014, AZ per year, 2008–2026: 107 cases
20087
200912
201010
20118
20125
20136
201410
20155
20167
20176
20183
20196
20203
20211
20226
20233
20245
20254

Latest 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 year(c.\"eventDate\") = 2014
    AND c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB WPR15IA080Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Beta II · Phoenix, AZThe failure of the fanshaft due to fatigue.Dec 30, 2014 · N7041X · No damageNTSB WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.Dec 6, 2014 · N300FM · Substantial damageNTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…Oct 24, 2014 · N244SW · Substantial damageNTSB WPR15LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA28 151 · Bullhead City, AZA partial loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Oct 18, 2014 · N56873 · Substantial damageNTSB WPR14LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Tombstone, AZA partial loss of engine power during cruise flight due to loose “B” nut fittings and a bent tube as a result of maintenance personnel’s inadequate inspection of the nuts during the most recent inspection.Sep 12, 2014 · N64AW · Substantial damageNTSB WPR14LA242Accident · No injuriesLimited investigationFinal reportAdams Dragonfly · Mesa, AZA partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.Jun 12, 2014 · N85TL · Substantial damageNTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…Jun 8, 2014 · N504MP · Substantial damageNTSB WPR14CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…Jun 4, 2014 · N223G · Substantial damageNTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…May 17, 2014 · N40TC · Substantial damageNTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…Apr 21, 2014 · N7880Y · Substantial damage