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 WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.NTSB ERA17LA057Accident · No injuriesLimited investigationFinal reportPiper PA28 · Columbus, GAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of any anomalies that would have precluded normal operation.NTSB CEN17LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bridgeport, TXThe pilot's failure to properly position the fuel selector before takeoff, which resulted a total loss of engine power due to fuel starvation.NTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.NTSB GAA17CA085Accident · No injuriesData collectionFinal reportHundley Michael J Vans RV8 · Roopville, GAThe pilot’s overcorrection with the right rudder during the landing roll, which resulted in a loss of directional control and a runway excursion.NTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA17LA063Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bluefield, WVThe pilot's failure to maintain directional control during the aborted takeoff.NTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.NTSB ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.NTSB CEN17LA042Accident · Serious injuriesLimited investigationFinal reportNorthwing Navajo · Daingerfield, TXThe noncertificated pilot’s unfamiliarity with the aircraft, which resulted in a loss of control during an unintentional takeoff.NTSB WPR17FA023Accident · 1 fatalField investigationFinal reportCessna 172N · Moss Beach, CAThe pilot's loss of airplane control following an encounter with low level wind shear and turbulence during final approach for landing. Contributing to the loss of control was the pilot's decision to retract the wing flaps on final approach, which resulted in…NTSB GAA17CA081Accident · No injuriesData collectionFinal reportCessna 172 · Destin, FLThe student pilot’s overcorrection with right rudder, which resulted in a loss of directional control, and the flight instructor’s delayed remedial action.NTSB ERA17FA050Accident · 2 fatalField investigationFinal reportCurtiss JN4 · Williamson, GAThe in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…NTSB WPR17FA021Accident · 2 fatalField investigationFinal reportHughes 369 · Pukoo, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions at night in rain, which resulted in his geographic disorientation and controlled flight into terrain.NTSB GAA17CA061Accident · No injuriesData collectionFinal reportBeech 95B55 · Plattsburgh, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle-of-attack during a single-engine approach, which resulted in an aerodynamic stall at an altitude too low for the flight instructor to recover.NTSB CEN17LA039Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Pleasanton, TXMaintenance personnel's improper installation of the throttle linkage attachment hardware, which resulted in a partial loss of engine power when the hardware separated in flight.NTSB WPR17LA020Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Taylor, AZA total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB GAA17CA070Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Stone Lake, WIThe pilot’s failure to maintain lateral control while in a hover and the helicopter’s subsequent impact with a tree.NTSB ANC17LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA32R · Bethel, AKA total loss of engine power due to oil starvation, which resulted from an oil cooler leak at a fractured brazed seam.NTSB ANC17LA005Accident · No injuriesLimited investigationFinal reportCessna A185 · Ninilchik, AKA loss of brake system fluid due to leaks in the o-rings, which resulted in asymmetrical braking and a subsequent loss of directional control during the landing roll.NTSB WPR17LA019Accident · Serious injuriesLimited investigationFinal reportBell 206B · Yuma, AZThe pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.NTSB GAA17CA072Accident · No injuriesData collectionFinal reportPiper PA 28R · Payallup, WAThe airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.NTSB GAA17CA073Accident · No injuriesData collectionFinal reportCarter Richard L Buddy Baby Lakes · Hurricane, UTThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ERA17LA042Accident · 1 fatalLimited investigationFinal reportNorth American Navion · Blairstown, NJThe pilot's improper engine start procedure, which resulted in a loss of control on the ground and collision with a tree.NTSB ERA17LA041Accident · Serious injuriesLimited investigationFinal reportBeech 36 · Ormond Beach, FLA loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures of the flight controls that would have precluded normal operation.NTSB ERA17FA038Accident · 2 fatalField investigationFinal reportQuad City Challenger · Crescent City, FLAn abrupt pitch-up maneuver following a descent, which resulted in the in-flight separation of the right wing due to the overload failure of both the forward and aft right wing attachment brackets.NTSB GAA17CA062Accident · No injuriesData collectionFinal reportAeronca L 3B · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Hopkinton, RIThe pilot's failure to accurately determine the airplane's fuel quantity before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA17CA057Accident · No injuriesData collectionFinal reportPiper PA18 · Mouth of The Big Susitna River, AKThe pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.NTSB CEN17LA037Accident · Minor injuriesLimited investigationFinal reportJohnson Kenneth R Stol CH 801 · Royalton, WIThe loss of control during approach for reasons that could not be determined due to postimpact fire damage.NTSB GAA17LA090Accident · No injuriesLimited investigationFinal reportPiper PA28R · Watertown, WIThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination…NTSB GAA17CA058Accident · No injuriesData collectionFinal reportBeech 58TC · Valdosta, GAThe pilot’s failure to ensure that adequate fuel was onboard for the flight, which resulted in fuel exhaustion and the loss of engine power.NTSB CEN17FA035Accident · 1 fatalField investigationFinal reportStamper RV-10 · Dubois, WYThe pilot's failure to maintain adequate airspeed after becoming distracted by the opening of the gull-wing cabin door during takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low…NTSB GAA17CA059Accident · Minor injuriesData collectionFinal reportHaring Clay RV6 · Eureka, KSThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA17LA037Accident · No injuriesLimited investigationFinal reportAviat A 1B · Geneva, FLA partial loss of engine power due to debris in the No. 1 cylinder that damaged the spark plugs.NTSB ERA17LA032Accident · Minor injuriesLimited investigationFinal reportBell OH 58C · Cameron, NCAn in-flight failure of a main rotor blade due to fatigue cracks. Contributing to the failure of the main rotor blade was the absence of guidance to the operator to inspect an area of the main rotor blade known to be susceptible to fatigue cracks and the…NTSB GAA17CA055Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Bristow, VAThe pilot’s loss of directional control during a landing attempt at night, which resulted in a delayed go-around procedure and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB ERA17LA034Accident · No injuriesLimited investigationFinal reportPiper PA32 · Bartow, FLA total loss of engine power during approach for reasons that could not be determined because engine examinations did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…NTSB GAA17CA198Accident · Serious injuriesData collectionFinal reportAeros 2 · Blountstown, FLThe noncertificated pilot's decision to fly the weight-shift-controlled aircraft without having received training in the aircraft type, which resulted in his loss of aircraft control shortly after takeoff.NTSB ERA17LA031Accident · Minor injuriesLimited investigationFinal reportHaddow William H Pitts Special S 1 · New Bern, NCA loss of biplane control during aerobatic maneuvers for reasons that could not be determined because a portion of the biplane's flight control system was not recovered and could not be tested.NTSB ANC17FA003Accident · 1 fatalField investigationFinal reportCessna 172 · Palmer, AKThe student pilot's exceedance of the airplane's critical angle of attack during a steep climbing turn following a touch-and-go landing, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB ERA17CA030Accident · Minor injuriesData collectionFinal reportKolb Fire FLY · West Middlesex, PAThe noncertificated pilot’s loss of airplane control while maneuvering at a low altitude.NTSB CEN17LA030Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bloomfield, NMMaintenance personnel’s failure to fully torque the fuel port cap, which allowed the cap to back off in flight and interrupted fuel flow to the engine, which resulted in a total loss of engine power.NTSB CEN17FA028Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Clarksville, TXThe pilot's failure to maintain sufficient airspeed during the landing approach, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB CEN17LA031Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Lexington, MOA total loss of engine power during takeoff for reasons that could not be determined based on available information.NTSB CEN17LA027Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Hereford, TXThe pilot's failure to maintain clearance from a cotton crop while maneuvering during agricultural application operations, which resulted in a loss of airplane control.NTSB GAA17CA048Accident · No injuriesData collectionFinal reportCessna 182 · Palo Alto, CAThe pilot's failure to perform a go-around when he recognized that the airplane was high and fast during the final approach, which resulted in an improper landing flare and a hard landing.NTSB WPR17FA013Accident · 2 fatalField investigationFinal reportBeech A36 · Pittsburg, CAA loss of airplane control for reasons that could not be determined due to the extensive impact and fire damage to the airplane.NTSB GAA17CA074Accident · No injuriesData collectionFinal reportRaytheon 58 · Lancaster, PAA collision with deer on the runway during the takeoff roll.