NTSB investigations
10,134 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 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.
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 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA16CA210Accident · Minor injuriesData collectionFinal reportPiper PA18S · Talkeetna, AKThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose over.NTSB GAA16CA205Accident · Minor injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Marana, AZThe glider's loss of lift as a result of unfavorable wind conditions for glider operations, consequently resulting in a collision with trees.NTSB GAA16CA198Accident · No injuriesData collectionFinal reportCessna 150 · Sterling City, TXThe pilot's failure to establish a climb and maintain directional control during takeoff in quartering tailwind conditions, which resulted in a loss of directional control, aborted takeoff, collision with a wire fence, and nose over.NTSB ERA16FA168Accident · 1 fatalField investigationFinal reportRyskamp Bruce A Acroduster · Belton, SCA loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN16LA167Accident · No injuriesLimited investigationFinal reportProbst Zenair 601XL · Hempstead, TXA loose output connection from the generator voltage regulator, which resulted in a loss of power to the electronic ignition system, a total loss of engine power, and a subsequent forced landing, during which the airplane impacted a sign pole.NTSB CEN16FA169Accident · 1 fatalField investigationFinal reportCessna 182L · Carrollton, OHAn in-flight collision with trees and terrain for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were observed during the examination.NTSB GAA16LA199Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · Culver, INThe noncertificated pilot’s failure to attain a climb in the powered-parachute and its subsequent impact with a tree.NTSB GAA16CA239Accident · No injuriesData collectionFinal reportLogan Jerry L GN 1 Aircamper · Defuniak Springs, FLThe pilot's loss of directional control during the landing in gusting crosswind conditions resulting in a runway excursion, and the pilot's failure to attain a positive climb rate during the aborted landing and subsequent ground collision.NTSB GAA16CA197Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Ramona, CAThe pilot's failure to maintain directional control during takeoff in variable wind conditions.NTSB GAA16CA201Accident · Minor injuriesData collectionFinal reportHelicycle/Morrisey RR RM-1 · Denver, COThe pilot's failure to maintain control of the helicopter yaw while operating in conditions conducive to loss of tail rotor effectiveness, resulting in an uncommanded rapid right yaw and ground impact.NTSB WPR16FA095Accident · 1 fatalField investigationFinal reportMooney M20K · Woodland, WAThe pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…NTSB CEN16LA164Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sand Springs, OKA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB CEN16LA163Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Zionsville, INThe flight instructor’s improper decision to depart on a local instructional flight in rapidly deteriorating weather conditions, including thunderstorms and hail, which resulted in subsequent impact with terrain during a go-around.NTSB CEN16LA161Accident · Serious injuriesLimited investigationFinal reportBell 47G-2A · Los Fresnos, TXThe pilot's inability to see and avoid the power lines because of trees obscuring his view.NTSB CEN16FA158Accident · 2 fatalField investigationFinal reportBeech 65 A90 1 · Slidell, LAThe unstable approach in black-hole conditions, resulting in the airplane overshooting the runway extended centerline and descending well below a safe glidepath for the runway. Contributing to the accident was the lack of monitoring by the copilot allowing…NTSB GAA16CA204Accident · No injuriesData collectionFinal reportPiper PA 18 · Palmer, AKThe pilot's decision to land on unsuitable terrain and incorrect brake application during the landing roll, which resulted in a nose over.NTSB ERA16LA166Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tannersville, PAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA16FA165Accident · 2 fatalField investigationFinal reportVans RV12 · Stevensville, MDThe pilot's failure to maintain airplane control during approach for landing in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB GAA16CA195Accident · Minor injuriesData collectionFinal reportGary A Jamieson JA30 Superstol · Palmer, AKThe pilot's failure to maintain pitch control of the airplane during the landing touchdown, which resulted in a nose over.NTSB ERA16WA163Accident · 3 fatalForeign investigationRobinson R66 · Bely Island, RussiaNTSB ERA16LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Okeechobee, FLThe failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.NTSB ERA16FA161Accident · 2 fatalField investigationFinal reportCessna 172 · Westmoreland, NYThe pilot's decision to takeoff on the grass runway given the conditions at the time; his excessive aft control input during the takeoff roll, which resulted in the aft fuselage contacting the runway surface; and his failure to attain sufficient airspeed and…NTSB CEN16LA154Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Kilbourne, LAThe failure of the operator to comply with the terminating action of the airworthiness directive, which resulted in the subsequent failure and separation of the vertical stabilizer due to fatigue.NTSB WPR16LA093Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Avalon, CAThe pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…NTSB ERA16LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2008 · Burgaw, NCThe pilot’s failure to activate the airplane’s alternator, which resulted in an eventual loss of electrical power to the engine’s fuel pumps, fuel starvation, and a total loss of engine power. Contributing was the pilot’s use of an incomplete checklist.NTSB ERA16CA160Accident · No injuriesData collectionFinal reportBell 206 · Baltimore, MDThe pilot's inadequate compensation for the wind while hovering out of ground effect, which resulted in a loss of tail rotor effectiveness.NTSB GAA16CA194Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and collision with a runway distance remaining sign.NTSB CEN16LA157Accident · No injuriesLimited investigationFinal reportCzech Sport Piper Sport · Mansfield, OHThe pilot's failure to inspect the nose landing gear (NLG), which resulted in a crack going undetected and the subsequent separation of the NLG at the weld area during landing.NTSB ERA16LA156Accident · Minor injuriesLimited investigationFinal reportAtkinson Eaglet · Deland, FLA total loss of engine power during initial climb due to a separation of the ignition plug.NTSB GAA16CA192Accident · No injuriesData collectionFinal reportCessna E162 · Lee's Summit, MOThe flight instructor's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and collision with a taxiway sign.NTSB GAA16CA190Accident · No injuriesData collectionFinal reportMonocoupe 110 · Chandler, AZThe pilot's incorrect installation of the tailwheel steering bungee, which resulted in a runway excursion and airplane nose over.NTSB ERA16LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Bayport, NYMaintenance personnel’s improper installation and maintenance of the fuel selector valve, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA16CA184Accident · No injuriesData collectionFinal reportDehavilland DHC 6 Twin Otter · Fentress, TXThe pilot's failure to maintain directional control during the aborted landing in gusty crosswind conditions, which resulted in a runway excursion and a collision with a tree.NTSB GAA16CA183Accident · Minor injuriesData collectionFinal reportPiper PA22 · Pantego, NCA loss of directional control during the takeoff roll in gusting wind conditions, which resulted in a runway excursion, a nose over, and an impact with terrain. Contributing to the accident was the pilot's decision to takeoff in gusting crosswind conditions.NTSB ERA16FA150Accident · 1 fatalField investigationFinal reportMooney M20K · Ocala, FLThe pilot's failure to maintain sufficient airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's inadvertent placement of the…NTSB CEN16FA146Accident · 2 fatalField investigationFinal reportRockwell 690B · Taylor, TXA loss of control while maneuvering for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or anomalies with the airplane.NTSB GAA16LA182Accident · Serious injuriesLimited investigationFinal reportHughes 369 · Weatherford, TXThe pilot/mechanic's inadequate postmaintenance and preflight inspections, which resulted in his failure to remove the antitorque pedal lock and a subsequent loss of control during hover operations.NTSB ERA16LA151Accident · Serious injuriesLimited investigationFinal reportGranger Michael D Sonex · Jesup, GAThe pilot's improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN16FA145Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Midlothian, TXThe flight instructor's inability to move the control stick after takeoff for undetermined reasons, which resulted in an exceedance of the airplane's critical angle of attack and inadvertent aerodynamic stall. The reason for the inability to move the control…NTSB GAA16CA185Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Palmer, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a runway over-run and collision with trees.NTSB GAA16CA179Accident · Minor injuriesData collectionFinal reportBell 206 · Supai, AZThe pilot's decision to fly a normal approach and forgetting that the long line remained attached to the helicopter, which resulted in the line snagging on a ridgeline, a loss of lateral control, and a rollover.NTSB ERA16LA148Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Hilton Head Island, SCThe pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.NTSB GAA16CA177Accident · Minor injuriesData collectionFinal reportBeech A23 · Hulbert, OKThe pilot's inadequate fuel planning, which resulted in fuel exhaustion, and collision with terrain.NTSB GAA16CA186Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe pilot's failure to avoid obstacles and maintain situational awareness while taxiing.NTSB ERA16FA144Accident · 5 fatalField investigationFinal reportBell 206 · Pigeon Forge, TNAn inflight loss of engine power due to a failure of the engine fuel pump, which resulted in a collision with trees and terrain during the subsequent autorotation. The failure of the engine fuel pump resulted from the absence of adequate grease leading to…NTSB GAA16CA181Accident · No injuriesData collectionFinal reportCessna 172 · Orangeburg, SCThe pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.NTSB GAA16CA180Accident · Minor injuriesData collectionFinal reportLamb-Robin Bowers FLY Baby · Guthrie, OKThe pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall and a collision with terrain.NTSB GAA16CA175Accident · No injuriesData collectionFinal reportChampion 7ECA · Kinder, LAThe pilot's selection of an unsuitable landing area, resulting in a loss of directional control during landing, an airstrip excursion, impact with a fence and the subsequent airplane fire.NTSB WPR16FA091Accident · 1 fatalField investigationFinal reportNokes Matthew Lancair IV P · Fallbrook, CAA loss of engine power during cruise for reasons that could not be determined because examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA176Accident · No injuriesData collectionFinal reportNorth American AT6 · Yukon, OKThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in runway excursion and impact with terrain.