NTSB investigations, 2018

669 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\") = 2018
    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 GAA19CA067Accident · No injuriesData collectionFinal reportJabiru J230-SP · Center, TXThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 18, 2018 · N667J · Substantial damageNTSB GAA19CA063Accident · No injuriesData collectionFinal reportRobinson R44 · Knox City, TXThe pilot's failure to maintain adequate airspeed with a tailwind, which resulted in the helicopter settling with power, and his subsequent incorrect collective application while attempting to recover, which resulted in a loss of helicopter control due to a…Nov 18, 2018 · N4167Y · Substantial damageNTSB CEN19FA030Accident · 3 fatalClass 2 · FieldFinal reportCessna 441 · Harmon, NDThe pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.Nov 18, 2018 · N441CX · DestroyedNTSB GAA19CA069Accident · No injuriesData collectionFinal reportPiper PA32R · Versailles, OHThe pilot's improper landing flare, which resulted in landing on the landing gear first and a subsequent loss of directional control, a runway excursion, and impact with a tree and a fence during an attempted go-around.Nov 17, 2018 · N4137W · Substantial damageNTSB ERA19LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Barnesville, GAThe student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.Nov 17, 2018 · N111TA · Substantial damageNTSB ERA19FA049Accident · 1 fatalClass 2 · FieldFinal reportLancair Legacy RG · Gainesville, GAThe pilots’ failure to execute a go-around when the nighttime autopilot-coupled approach became unstable, which resulted in a loss of control and subsequent impact with terrain. Also causal was the flight instructor's inadequate supervision of the pilot and…Nov 17, 2018 · N8448J · Substantial damageNTSB ERA19FA048Accident · 1 fatalField investigationFinal reportVans RV-12 · Niceville, FLA partial loss of engine power during initial climb for undetermined reasons, and pilot's failure to maintain airspeed during a turn back to the runway, which resulted in an exceedance of the airplane's critical angle of attack, and subsequent aerodynamic…Nov 17, 2018 · N232VA · Substantial damageNTSB CEN19FA029Accident · 2 fatalField investigationFinal reportBeech 55 · Liberal, KSThe pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…Nov 17, 2018 · N4817M · Substantial damageNTSB CEN19FA028Accident · 2 fatalField investigationFinal reportNorth American P51 · Fredericksburg, TXThe pilot's decision to perform a low-level maneuver at an altitude where he was unable to recover the airplane before impacting terrain.Nov 17, 2018 · N4132A · DestroyedNTSB WPR19FA025Accident · 2 fatalClass 2 · FieldFinal reportCessna 182 · Redding, CAThe pilot's spatial disorientation and subsequent loss of control after takeoff in dark night instrument meteorological conditions.Nov 16, 2018 · N2629R · Substantial damageNTSB ERA19TA051Accident · Minor injuriesFinal reportCessna E162 · Franklin, NCThe pilot's delay in applying carburetor heat, which resulted in a total loss of engine power during descent due to carburetor icing.Nov 16, 2018 · N70252 · Substantial damageNTSB WPR19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Presidio, TXThe student pilot’s loss of control at low altitude during a forced landing, which resulted in impact with terrain and substantial damage to the right wing. A contributing factor in the accident was the loss of engine power for undetermined reasons.Nov 14, 2018 · N1715J · Substantial damageNTSB GAA19CA059Accident · No injuriesData collectionFinal reportEugene Wells Dragon Fly-B · Kailua/Kona, HIThe pilot's failure to maintain directional control during landing in a crosswind. Contributing to the accident was the pilot’s lack of experience in tailwheel airplanes for which he did not have an endorsement.Nov 13, 2018 · N5023G · Substantial damageNTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.Nov 12, 2018 · N4642J · Substantial damageNTSB GAA19CA058Accident · Minor injuriesData collectionFinal reportCessna 172 · Piseco, NYThe pilot’s loss of directional control during landing, which resulted in impact with a snow pile and necessitated a go-around, during which the airplane impacted trees.Nov 12, 2018 · N738VK · Substantial damageNTSB ERA19LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 690 · Myrtle Beach, SCAn encounter with low-level windshear and turbulence during the landing approach, which resulted in a loss of airplane control.Nov 12, 2018 · N840JC · Substantial damageNTSB ERA19LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Lake City, FLThe pilot's failure to attain adequate airspeed before attempting the takeoff with a tailwind, which resulted in the airplane being unable to sustain flight.Nov 11, 2018 · N52737 · Substantial damageNTSB WPR19LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV7A · Ramona, CAThe partial loss of engine power for reasons that could not be determined based on the available information.Nov 10, 2018 · N5433T · DestroyedNTSB ERA19TA042Accident · Serious injuriesClass 3Final reportMooney M20C · Wildwood, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation during the initial climb. Contributing to the accident was the pilot’s decision to initiate a 180° turn following the loss of power.Nov 10, 2018 · N78870 · Substantial damageNTSB WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.Nov 9, 2018 · N91770 · Substantial damageNTSB ERA19FA039Accident · 1 fatalField investigationFinal reportCessna 310 · Walton, NYAn in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.Nov 9, 2018 · N5044J · DestroyedNTSB WPR19LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Ontario, CAA partial loss of engine power during descent due to an incorrectly installed carburetor.Nov 8, 2018 · N9914M · Substantial damageNTSB GAA19CA070Accident · No injuriesData collectionFinal reportCessna T337 · Homosassa, FLThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the subsequent total loss of power in both engines.Nov 8, 2018 · N1ZR · Substantial damageNTSB GAA19CA092Accident · No injuriesData collectionFinal reportMaule MX7 · Immokalee, FLThe flight instructor's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with runway signage during the subsequent attempted aborted landing.Nov 5, 2018 · N9225G · Substantial damageNTSB GAA19CA053Accident · Minor injuriesData collectionFinal reportPiper PA24 · Texico, NMThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 5, 2018 · N3214P · Substantial damageNTSB CEN19WA037Accident · 1 fatalForeign investigationRotorway Exec · Saint Pierre, St. Pierre & MiquelonNov 5, 2018 · F-PSPM · DestroyedNTSB GAA19CA047Accident · No injuriesData collectionFinal reportPoberezny Acro Sport II · Culpeper, VAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Nov 4, 2018 · N44JS · Substantial damageNTSB ERA19LA037Accident · 1 fatalLimited investigationFinal reportCessna 150 · Woodstock, GAThe pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.Nov 4, 2018 · N3515J · Substantial damageNTSB ERA19FA036Accident · 1 fatalField investigationFinal reportTitan Tornado 1 · Louisa, VAThe pilot's failure to maintain airspeed and the airplane's exceedance of its critical angle of attack, which resulted in an aerodynamic stall and spin at a low altitude.Nov 4, 2018 · N38FD · Substantial damageNTSB WPR19TA018Accident · Serious injuriesFinal reportAudenried Kitfox S7 SuperSport · Flanigan, NVThe pilot's failure to maintain airspeed during a sharp turn at low altitude, which resulted in an aerodynamic stall.Nov 3, 2018 · N13NZ · Substantial damageNTSB ANC19LA006Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain airplane control during the landing flare, which resulted in the wing striking the runway. Contributing to the accident was a partial loss of engine power, which resulted from fuel contamination.Nov 3, 2018 · N2809L · Substantial damageNTSB WPR19LA019Accident · Serious injuriesClass 3 · LimitedFinal reportBell 47G · Wichita Falls, TXA total loss of engine power for reasons that could not be determined based on the available information.Nov 2, 2018 · N1159W · DestroyedNTSB GAA19CA061Accident · No injuriesData collectionFinal reportSocata TBM 700 · Corvallis, ORThe pilot's failure to maintain lateral control of the airplane during landing, which resulted in a wing strike.Nov 2, 2018 · N850TJ · Substantial damageNTSB CEN19FA022Accident · 2 fatalField investigationFinal reportMustang II · Broomfield, COThe pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.Nov 2, 2018 · N287BM · Substantial damageNTSB CEN19FA021Accident · 1 fatalField investigationFinal reportCessna 210 · Bradley, SDThe non-instrument-rated pilot's improper decision to conduct a flight in which instrument meteorological conditions existed along the route of flight, which resulted in spatial disorientation and a loss of airplane control.Nov 2, 2018 · N81KD · DestroyedNTSB ANC19LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Willow, AKThe loss of engine power shortly after takeoff for reasons that could not be determined based on the available information, which resulted in an emergency landing and collision with trees.Nov 2, 2018 · N3227M · Substantial damageNTSB GAA19CA048Accident · Minor injuriesData collectionFinal reportCessna 172 · Cleburne, TXThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.Nov 1, 2018 · N3984L · Substantial damageNTSB ERA19FA035Accident · 2 fatalField investigationFinal reportAerospatiale AS 355F2 · Beekmantown, NYThe pilot's failure to keep the helicopter clear of a utility pole while hovering with a tailwind, which resulted in a dynamic rollover into active power lines.Oct 30, 2018 · N372CA · DestroyedNTSB ERA19FA034Accident · 2 fatalField investigationFinal reportAutogyro Cavalon · Sebring, FLThe pilot's improper decision to operate the gyroplane in an unairworthy condition, which resulted in the cyclic pitch control disconnecting in flight. Contributing was the pilot's inability to maintain control of the helicopter utilizing the published…Oct 30, 2018 · N198LT · DestroyedNTSB CEN19FA018Accident · 1 fatalField investigationFinal reportEurocopter AS350 · Odanah, WIThe pilot's loss of helicopter control for undetermined reasons.Oct 29, 2018 · N910S · DestroyedNTSB ERA19LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Simsbury, CTMaintenance personnel's inadequate inspection of the wheel brake system during the airplane's most recent 100-hour inspection, which resulted in a loss of hydraulic fluid and the pilot's inability to control the airplane during the landing.Oct 28, 2018 · N8132X · Substantial damageNTSB ERA19LA028Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Murfreesboro, TNThe pilot's failure to maintain airplane control while maneuvering at low altitude in gusting wind conditions.Oct 28, 2018 · N5624S · Substantial damageNTSB GAA19CA045Accident · No injuriesData collectionFinal reportPiper PA18 · Denver, COThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions.Oct 27, 2018 · N4500W · Substantial damageNTSB CEN19LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXThe pilot's failure to apply carburetor heat while operating in an area conducive to carburetor icing, which resulted in a total loss of engine power on approach and subsequent forced landing into a creek.Oct 27, 2018 · N3973L · Substantial damageNTSB GAA19CA040Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe student pilot's improper landing flare, which resulted in a hard landing.Oct 26, 2018 · N15888 · Substantial damageNTSB ERA19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Parker, COA partial loss of engine power during initial climb due to carburetor icing, and the pilot's failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.Oct 26, 2018 · N5575U · Substantial damageNTSB ERA19LA024Accident · Minor injuriesLimited investigationFinal reportBeech 35 · State College, PAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.Oct 24, 2018 · N8319D · Substantial damageNTSB CEN19LA013Accident · No injuriesLimited investigationFinal reportSorrell Sorrell SNS 7 · Middletown, OHThe pilot's loss of directional control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in the right wing striking the ground.Oct 24, 2018 · N8053Q · Substantial damageNTSB GAA19CA035Accident · No injuriesData collectionFinal reportCirrus SR20 · Greenville, SCThe pilot's improper decision to land with a quartering tailwind and his improper landing flare, which resulted in a bounced landing, loss of directional control, runway excursion, and impact with a pole.Oct 23, 2018 · N782JR · Substantial damageNTSB ERA19FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Woodbine, NJThe pilot's failure to maintain the proper airspeed during takeoff, which resulted in the exceedance of the airplane’s critical angle of attack and the airplane experiencing an aerodynamic stall.Oct 23, 2018 · N9667M · Destroyed