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 WPR14CA293Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Marysville, CAThe pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…NTSB WPR14CA292Accident · Serious injuriesData collectionFinal reportJonker Sailplanes JS1-C · Truckee, CAThe pilot's failure to maintain aircraft control in gusting wind conditions while on final approach to the runway.NTSB CEN14CA380Accident · No injuriesData collectionFinal reportDantonio 404 · Wichita Falls, TXThe separation of a spark plug wire resulting in a loss of engine power during climb out and a subsequent forced landing on a field containing trees.NTSB ANC14LA054Accident · No injuriesLimited investigationFinal reportCessna 180H · Seward, AKThe pilot’s execution of a hard uncoordinated landing, which resulted in the overstress fracture of the right main landing gear (MLG) axle attachment bolts and the subsequent separation of the of the right MLG axle.NTSB ERA14FA339Accident · 2 fatalField investigationFinal reportAllen Steen Skybolt · Carrollton, GAAn in-flight loss of airplane control for reasons that could not be determined during postaccident examinations or based on the available evidence.NTSB CEN14LA443Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Waukesha, WIThe loss of engine power for reasons that could not be determined because no anomalies were identified during postaccident examination.NTSB CEN14LA372Accident · 1 fatalLimited investigationFinal reportJonker Sailplanes JS1-C · Wallis, TXThe pilot’s loss of glider control and its subsequent impact with terrain for reasons that could not be determined due to a lack of available information.NTSB CEN14CA368Accident · Minor injuriesData collectionFinal reportMckenzie Douglas E Stol CH750 · Dodgeville, MIThe pilot's failure to maintain control of the airplane during takeoff resulting in an impact with a tree and terrain.NTSB ERA14FA337Accident · 1 fatalField investigationFinal reportCulver LFA · Limington, METhe pilot’s failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…NTSB CEN14CA362Accident · No injuriesData collectionFinal reportAeronca 65CA · Pulaski, WIThe student pilot's improper flight control inputs resulting in a loss of control during the landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB WPR14CA290Accident · Minor injuriesData collectionFinal reportBell 47K · Kingston, WAThe pilot's failure to maintain aircraft control during the landing approach, which resulted in an excessive descent angle and settling with power.NTSB CEN14FA356Accident · 1 fatalField investigationFinal reportMooney M20M · Greenwood, INA 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. Also causal to the accident was the pilots' decision…NTSB CEN14CA366Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Cavalier, NDThe pilot's loss of control during the takeoff roll.NTSB CEN14CA360Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Englewood, COThe pilot did not maintain control of the helicopter during the takeoff resulting in low rotor rpm and impact of the fuel trailer during the running landing.NTSB ANC14CA053Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Prudhoe Bay, AKThe pilot's failure to maintain directional control during landing and attempted go-around, resulting in contact with terrain and a ground loop.NTSB ERA14LA336Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Titusville, FLThe pilot's failure to secure the fuel strainer drain during the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14CA349Accident · No injuriesData collectionFinal reportPekola James W Ridge Runner III · Andrews, NCThe pilot's failure to open the fuel tank valves during the preflight examination of the airplane, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN14LA371Accident · 1 fatalLimited investigationFinal reportAir Command 532 · Petersburg, MIThe noncertificated pilot’s failure to maintain control of the gyroplane following a total loss of engine power due to a loose spark plug.NTSB CEN14LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Mt. Vernon, TXThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN14CA353Accident · No injuriesData collectionFinal reportCessna 172N · Edgewood, NMThe pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.NTSB ANC14LA052Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Palmer, AKThe pilot’s failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.NTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA357Accident · No injuriesLimited investigationFinal reportCessna TR182 · Wichita, KSMaintenance personnel’s improper landing gear system repair, which resulted in a hydraulic leak and subsequent gear collapse during landing.NTSB CEN14LA349Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Carthage, ILThe airplane’s inability to climb out of ground effect, which resulted from the pilot using a lower power setting than needed for takeoff due to the mechanic’s installation of the wrong engine torque gauge.NTSB WPR14FA282Accident · 3 fatalField investigationFinal reportPiper PA 28R-180 · Lake Elsinore, CAThe pilot's failure to maintain airplane control when the landing gear unintentionally extended while maneuvering at low altitude and airspeed, which increased the airplane’s drag and decreased its ability to climb over the rising terrain.NTSB ERA14LA330Accident · 1 fatalLimited investigationFinal reportZubair S Khan Raven · Mattituck, NYThe pilot's failure to ensure that the airplane was loaded within its calculated center of gravity limits, which resulted in longitudinal instability and a subsequent unrecoverable stall.NTSB ERA14FA328Accident · 2 fatalField investigationFinal reportCessna 150J · Topping, VAThe pilot's failure to maintain airplane control, which resulted in an aerodynamic stall/spin.NTSB ERA14CA335Accident · No injuriesData collectionFinal reportAlexander Schleicher K 7 · Mocksville, NCThe pilot's decision to install an additional cushion to elevate his passenger and his failure to insure the cushion would not interfere with the control stick movement resulting in limited movement of the elevator in flight and collision with a fence during…NTSB ERA14LA338Accident · Serious injuriesLimited investigationFinal reportLawson Ronald S Explorer · East Bend, NCA total loss of engine power likely due to a failure of a rotary valve shaft seal and the pilot’s failure to detect and diagnose the impending failure during the preflight inspection.NTSB ERA14LA332Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Prentiss, MSA total loss of engine power for reasons that could not be determined because postaccident engine examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA14LA329Accident · 1 fatalLimited investigationFinal reportFlight Design CT-SW 2006 · Gasport, NYThe pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA14FA327Accident · 1 fatalField investigationFinal reportCessna 140 · Parma, NYThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during the landing roll. Contributing to the severity of the pilot's injuries was the failure of the aluminum center safety belt bracket.NTSB WPR14CA279Accident · Serious injuriesData collectionFinal reportWiley Kitfox IV · Sprague, WAThe pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.NTSB ERA14TA326Accident · Serious injuriesFinal reportCessna 336 · Mobile, ALThe pilot’s inadequate preflight fuel planning during which he did not ensure that there was adequate fuel in the main tanks for the flight, which resulted in a loss of engine power.NTSB ERA14LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Monroeville, ALA loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.NTSB CEN14LA345Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Las Vegas, NMThe pilot's loss of airplane control during an aborted landing. Contributing to the accident was the pilot's inadequate preflight planning, which resulted in his attempt to land on a runway closed by a notice to airmen and the loss of engine power due to fuel…NTSB CEN14LA336Accident · 1 fatalLimited investigationFinal reportNorthwing Design Apache Sport · Omro, WIThe pilot’s failure to maintain adequate airspeed to compensate for a newly installed wing, which resulted in the aircraft stalling and the subsequent loss of control.NTSB CEN14LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Granbury, TXThe partial loss of engine power due to the failure of the exhaust valve.NTSB CEN14FA337Accident · Serious injuriesField investigationFinal reportPiper PA30 · Harrison, ARThe pilot's loss of control of the airplane during initial climb because he failed to correctly compensate for the loss of power in the left engine. Contributing to the accident was water contamination in the fuel and the lack of an adequate preflight…NTSB ANC14FA050Accident · 1 fatalField investigationFinal reportPiper PA 12 · Anchorage, AKThe incorrect (reverse) rigging of the elevator control cables, and the pilot’s inadequate preflight inspection, which failed to detect the misrigging.NTSB ERA14FA322Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Clarksdale, MSThe pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.NTSB CEN14LA379Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Jonesville, LAThe noncertificated pilot's failure to maintain clearance from trees.NTSB CEN14LA333Accident · No injuriesLimited investigationFinal reportCessna 172R · Joplin, MOThe partial loss of engine power for reasons that could not be determined because an operational test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR14LA271Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Big Creek, IDThe pilot’s execution of a traffic pattern that did not put the airplane in position for a normal final approach and the pilot’s decision to continue the landing attempt instead of initiating a go-around, which resulted in the airplane exceeding its critical…NTSB ERA14LA316Accident · Serious injuriesLimited investigationFinal reportCzech Sport Piper Sport · Peachtree City, GAThe pilot's incomplete assessment of the risk presented by operating an airplane with an unresolved history of engine power losses; a partial loss of engine power during takeoff due to operation of the engine with an excessively rich fuel/air mixture; and the…NTSB ERA14CA317Accident · Minor injuriesData collectionFinal reportCessna 172S · Orlando, FLThe flight instructor's failure to maintain control while taxiing in a strong gusty wind.NTSB WPR14LA273Accident · 1 fatalLimited investigationFinal reportSkyraider Skyraider · Lewiston, IDThe pilot's failure to maintain an adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall at too low an altitude to recover.NTSB CEN14FA325Accident · 1 fatalField investigationFinal reportDoyle James E Skybolt · Midlothian, TXThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in an inverted spin and subsequent collision with terrain.NTSB WPR14CA270Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Quincy, WAThe pilot's failure to maintain clearance from a wind generator tower while drying cherries, which resulted in a loss of aircraft control and subsequent hard landing.