NTSB investigations, 2014

671 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases, newest first

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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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 CEN15FA034Accident · 4 fatalField investigationFinal reportRaytheon B200 · Wichita, KSThe pilot's failure to maintain lateral control of the airplane after a reduction in left engine power and his application of inappropriate rudder input. Contributing to the accident was the pilot's failure to follow the emergency procedures for an engine…Oct 30, 2014 · N52SZ · DestroyedNTSB ERA15LA039Accident · No injuriesLimited investigationFinal reportCurtiss Wright P 40B · New Smyrna Beach, FLThe pilot’s failure to maintain directional control while landing with a crosswind, which resulted in a ground loop and a subsequent runway excursion.Oct 29, 2014 · N284CF · Substantial damageNTSB CEN15FA032Accident · 1 fatalField investigationFinal reportLangston, Frederick L RV 4 · Boerne, TXA total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.Oct 28, 2014 · N70PM · DestroyedNTSB CEN15FA030Accident · 1 fatalField investigationFinal reportMooney M20 · Boulder, COThe loss of airplane control for reasons that could not be determined by the postaccident examination, which was limited due to impact damage and postcrash fire.Oct 27, 2014 · N3539X · Substantial damageNTSB CEN15CA041Accident · No injuriesData collectionFinal reportCessna 510 · Faribault, MNAn inflight collision with a goose while descending to land at the destination airport.Oct 27, 2014 · N510PT · Substantial damageNTSB ERA15LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Valley Point, WVUndetermined based on a lack of available information.Oct 26, 2014 · N5601U · Substantial damageNTSB ERA15CA031Accident · Minor injuriesData collectionFinal reportSolo Wings Aquilla · Eustis, FLThe pilot's failure to maintain aircraft control during the final approach in turbulent conditions, which resulted in a collision with water.Oct 26, 2014 · N55446 · Substantial damageNTSB CEN15LA031Accident · No injuriesLimited investigationFinal reportCessna T210M · Brownsville, TXA loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight fuel planning.Oct 26, 2014 · XBNCZ · Substantial damageNTSB ERA15LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA 22-150 · Tompkins, NYA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.Oct 25, 2014 · N8064Y · Substantial damageNTSB ERA15CA045Accident · No injuriesData collectionFinal reportBeech V35B · Vicksburg, MSThe pilot's failure to maintain directional control while landing in variable wind conditions, resulting in a runway excursion and collision with an object.Oct 25, 2014 · N4212S · Substantial damageNTSB CEN15LA038Accident · Minor injuriesLimited investigationFinal reportStol UC 1 · Jacksonville, TXThe loss of right engine power while climbing due to fuel starvation for reasons that could not be determined during postaccident airplane examination and testing, which led to a forced landing on hilly terrain.Oct 25, 2014 · N950TB · 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 WPR15FA021Accident · 2 fatalField investigationFinal reportSlingsby T67M 260 · Ridgecrest, CAThe pilots' failure to recover from a spin for reasons that could not be determined based on available information. Contributing to the student's fatal injury was his delayed egress from the airplane below the specified egression altitude.Oct 24, 2014 · N456FR · Substantial damageNTSB ERA15WA026Accident · 1 fatalForeign investigationCessna 310R · Governors Harbor, BahamasOct 24, 2014 · N310WL · Substantial damageNTSB ERA15CA033Accident · No injuriesData collectionFinal reportCessna 172M · Apopka, FLThe student pilots improper landing flare which resulted in a hard landing and loss of aircraft control. Contributing to the accident was the flight instructor's delayed remedial actions.Oct 24, 2014 · N1533V · Substantial damageNTSB CEN15LA026Accident · 1 fatalLimited investigationFinal reportStephenson Stol CH 701 · Mount Vernon, INThe pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…Oct 24, 2014 · N34WS · Substantial damageNTSB CEN15FA027Accident · 1 fatalField investigationFinal reportCessna T210M · Bay City, WIThe non-instrument rated pilot’s continued visual flight into instrument flight rules conditions, which resulted in an in-flight loss of control.Oct 24, 2014 · N761SU · DestroyedNTSB CEN15CA049Accident · No injuriesData collectionFinal reportCessna 210 · Kalamazoo, MIThe pilot's failure to ensure that the landing gear was fully extended in the down and locked position prior to touchdown, which resulted in the left main landing gear collapse, runway excursion, and impact with a runway exit sign.Oct 24, 2014 · N8219M · Substantial damageNTSB CEN15CA025Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Harper, TXThe pilot's failure to maintain clearance from trees while maneuvering.Oct 24, 2014 · N7192K · Substantial damageNTSB WPR15CA018Accident · No injuriesData collectionFinal reportCessna 172 - R · Lake Havasu, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.Oct 23, 2014 · N1590W · Substantial damageNTSB ERA15LA030Accident · No injuriesLimited investigationFinal reportNorth American T 6G · Naples, FLThe total loss of engine power during the initial climb due to fuel starvation for reasons that could not be determined because postaccident examinations of the airframe and engine fuel system components revealed no evidence of a mechanical malfunction or…Oct 23, 2014 · N22NA · Substantial damageNTSB ERA15LA044Accident · Serious injuriesLimited investigationFinal reportItec Maverick · Dunnellon, FLA cell blowout in the fabric wing, which resulted in an asymmetrical loss of lift and a subsequent loss of aircraft control.Oct 21, 2014 · N356MV · DestroyedNTSB ERA15FA023Accident · 1 fatalField investigationFinal reportBeech D95 · Bahama, NCThe pilots' failure to maintain adequate airspeed during climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor's decision to conduct a…Oct 21, 2014 · N64GM · Substantial damageNTSB CEN15LA023Accident · Serious injuriesLimited investigationFinal reportTuberville Zodiac XL · Mountain Home, ARThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident engine examinations revealed no anomalies that would have precluded normal operation.Oct 21, 2014 · N601WR · Substantial damageNTSB WPR15FA016Accident · 1 fatalField investigationFinal reportSonex Sonex Trigear · Fawnskin, CAThe pilot's failure to maintain airspeed after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall/spin at low altitude. Contributing to the accident was the airplane's reduced climb…Oct 20, 2014 · N91922 · Substantial damageNTSB ANC15TA003Accident · No injuriesFinal reportCub Crafters CC18-180 · Anchorage, AKThe pilot’s failure to maintain directional control while attempting to drag an off-airport landing site.Oct 19, 2014 · N537CC · Substantial damageNTSB ERA15CA021Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Everglades City, FLThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, runway excursion, and collision with vegetation and water.Oct 18, 2014 · N254WM · Substantial damageNTSB ERA15CA020Accident · No injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Sebring, FLThe student pilot's inadvertent interference with the weight-shift capability of the airplane during the initial climb, resulting in a loss of airplane control and hard landing.Oct 18, 2014 · N29ME · Substantial damageNTSB WPR15LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Big Bear, CAA partial loss of engine power 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 16, 2014 · N612SP · Substantial damageNTSB ERA15FA017Accident · 1 fatalField investigationFinal reportAeronca 7EC · Cordele, GAAn in-flight loss of control for reasons that could not be determined based on the available evidence.Oct 16, 2014 · N946DR · Substantial damageNTSB ERA15FA016Accident · 2 fatalField investigationFinal reportRockwell International 112 · Gainesville, GAThe partial loss of engine power due to the undetected blockage of the inlet and outlet ports of the manifold valve by an organic compound of an unknown source.Oct 16, 2014 · N1148J · DestroyedNTSB CEN15CA065Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Branson, MOThe pilot's failure to maintain aircraft control when executing a landing with a tailwind, resulting in impact with a retaining wall.Oct 16, 2014 · N912AM · Substantial damageNTSB CEN15LA015Accident · No injuriesLimited investigationFinal reportCessna P210N · West Memphis, ARA catastrophic engine failure due to an oil starvation event for reasons that could not be determined based on the available evidence.Oct 15, 2014 · N731QV · Substantial damageNTSB CEN15LA012Accident · No injuriesLimited investigationFinal reportCessna 182B · Orange, TXThe pilot’s failure to maintain airplane control during a go-around to avoid another airplane that was making a nonstandard approach to the opposing runway. Contributing to the accident was the other pilot’s use of a nonstandard approach while landing on the…Oct 15, 2014 · N2437G · Substantial damageNTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.Oct 13, 2014 · N31EW · DestroyedNTSB ANC15CA002Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cordova, AKThe pilots decision to land and failure to maintain control of the airplane during landing in gusty wind conditions.Oct 9, 2014 · N82448 · Substantial damageNTSB WPR15CA007Accident · No injuriesData collectionFinal reportCessna T182T · Van Nuys, CAThe pilot's failure to monitor the distance between the left wing and blast fence while maneuvering behind another airplane.Oct 8, 2014 · N378MS · Substantial damageNTSB WPR15CA006Accident · No injuriesData collectionFinal reportMaule MX 7-235 · Big Creek, IDThe pilot's failure to maintain aircraft control while on final approach with shifting wind conditions.Oct 8, 2014 · N11ZA · Substantial damageNTSB WPR15GA005Accident · 1 fatalFinal reportMarsh S 2F3AT · El Portal, CAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.Oct 7, 2014 · N449DF · DestroyedNTSB ERA15WA050Accident · No injuriesForeign investigationCessna A188B · Rozo, ColombiaOct 6, 2014 · HK-1746 · Substantial damageNTSB ERA15CA010Accident · No injuriesData collectionFinal reportToerner Bob SEA REY · Tampa, FLThe pilot's failure to retract the landing gear after takeoff, which resulted in the landing gear contacting the water while maneuvering at low altitude.Oct 6, 2014 · N345BT · Substantial damageNTSB WPR15CA004Accident · Minor injuriesData collectionFinal reportCessna 172S · Sedona, AZThe pilot's failure to maintain airplane control during the landing roll out.Oct 5, 2014 · N2179L · Substantial damageNTSB ERA15LA006Accident · Serious injuriesLimited investigationFinal reportSocata TBM 700 · Fayetteville, GAThe pilot’s inadvertent deactivation of the yaw damper in flight, which resulted in a prolonged side-slip condition that led to fuel starvation and the eventual total loss of engine power. Contributing to the accident was the pilot’s failure to attempt to…Oct 5, 2014 · N536EM · Substantial damageNTSB WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.Oct 4, 2014 · N700PQ · Substantial damageNTSB ERA15CA012Accident · No injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesboro, VAThe glider's inadvertent encounter with low altitude wind shear.Oct 4, 2014 · N3619T · Substantial damageNTSB ERA15CA007Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Maryville, TNThe pilot/owner's failure to maintain a stabilized approach during the final leg of the traffic pattern. Contributing to the accident was both pilot's lack of aeronautical decision making.Oct 4, 2014 · N85707 · Substantial damageNTSB ERA15CA005Accident · No injuriesData collectionFinal reportHPH 304CZ · Pikeville, TNA loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.Oct 4, 2014 · N304AK · Substantial damageNTSB CEN15FA003Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L 1 · Wichita Falls, TXThe pilot’s failure to maintain yaw control when he applied power to execute a go-around at a low airspeed in dark, night conditions, which resulted in a rapid, uncommanded right yaw due to a loss of tail rotor effectiveness.Oct 4, 2014 · N335AE · DestroyedNTSB WPR15LA001Accident · 1 fatalLimited investigationFinal reportGaston Thomas D Thunder Mustang · Council, IDThe pilot's failure to maintain control while maneuvering for landing following a loss of oil pressure. Contributing to the accident was foreign material contamination of the oil system due to improper maintenance.Oct 3, 2014 · N51TG · DestroyedNTSB ERA15FA003Accident · 1 fatalField investigationFinal reportMiller Raymond A Sonex Waiex · Palm Coast, FLA total loss of engine power during cruise flight for reasons that could not be determined due to the postaccident condition of the engine and its associated fuel and ignition systems.Oct 3, 2014 · N461MM · Substantial damage