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 CEN11LA348Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Cypress, TXThe loss of engine power due to carburetor ice.NTSB ERA11LA306Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Wurtsboro, NYThe pilot’s performance of aerobatic maneuvers at low altitude and his failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB CEN11CA351Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILThe student pilot’s failure to maintain control of the helicopter while hovering.NTSB CEN11LA345Accident · Serious injuriesLimited investigationFinal reportSocata TBM-850 · Salem, OHThe pilot's failure to maintain a stabilized glide path which resulted in the airplane touching down short of the runway.NTSB WPR11FA225Accident · 2 fatalField investigationFinal reportP&M Pegasus Quik 912S · Hanalei, HIThe pilot's continued operation of the aircraft with deteriorated wing fabric and his aggressive maneuvering at low altitude, which resulted in the right wing fabric’s failure during flight. Contributing to the accident was the pilot's loading of the aircraft…NTSB CEN11CA342Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Spicewood, TXThe pilot's failure to maintain adequate airspeed during takeoff which resulted in an aerodynamic stall.NTSB ANC11CA032Accident · No injuriesData collectionFinal reportCessna A185F · Talkeetna, AKThe pilot's failure to maintain directional control during landing.NTSB CEN11LA339Accident · No injuriesLimited investigationFinal reportMD Helicopter 369E · Victoria, TXThe pilot’s failure to ensure that the governor limit switch was properly set, which resulted in reduced engine power.NTSB ANC11TA031Accident · Minor injuriesFinal reportBeech B200 · Atqasuk, AKThe pilot did not maintain sufficient airspeed during an instrument approach in icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident were the pilot’s fatigue, the operator’s decision to initiate the flight…NTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.NTSB CEN11CA336Accident · Serious injuriesData collectionFinal reportReed Roderick KB3 Gyroplane · Scott, LAThe pilot's poor decision to takeoff with a tailwind which resulted in a runway excursion.NTSB ERA11LA300Accident · Serious injuriesLimited investigationFinal reportCarothers Zenith CH701 · Tidioute, PAThe pilot's impairment due to alcohol and failure to maintain altitude on approach to landing, resulting in an in-flight collision with a tree.NTSB ERA11LA298Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Greenwood, MSA partial loss of engine power during low-altitude maneuvering for undetermined reasons.NTSB ERA11FA299Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Benezette, PAThe pilot's loss of airplane control for reasons that could not be determined from the available evidence.NTSB CEN11CA353Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Guymon, OKThe pilot's loss of directional control while landing in gusty, crosswind conditions.NTSB WPR11CA222Accident · No injuriesData collectionFinal reportThrush S2R-T34 · Pleasant Grove, CAThe pilot's failure to maintain directional control during the landing.NTSB ERA11FA293Accident · Serious injuriesField investigationFinal reportBeech F33A · Tarentum, PAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate preflight planning and excessive loading of the airplane.NTSB CEN11CA362Accident · No injuriesData collectionFinal reportBeech B24R · Dowagiac, MIThe flight instructor's failure to maintain an appropriate glide path and airspeed during the landing approach, which resulted in an aerodynamic stall.NTSB ERA11LA292Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Troy, SCThe pilots’ failure to ensure that the airplane had enough fuel to complete the planned flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11FA340Accident · Serious injuriesField investigationFinal reportMooney M20R · Ravenna, OHThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11CA330Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Garwood, TXThe pilot's failure to maintain adequate clearance from transmission wires during a low-level maneuvering flight.NTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.NTSB WPR11CA219Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Scottsdale, AZThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN11LA332Accident · Serious injuriesLimited investigationFinal reportUnregistered Quicksilver MXL II · Crookston, MNThe pilot’s improper airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin at a low altitude.NTSB CEN11CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Golden, COThe pilot’s decision to operate the helicopter at a high density altitude near terrain, which resulted in a settling with power condition.NTSB ERA11LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…NTSB ERA11CA304Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Stevensville, MDThe student pilot's improper flare which resulted in a hard landing, and the flight instructor's lack of remedial action.NTSB ERA11CA288Accident · Minor injuriesData collectionFinal reportSchleicher ASW-27 · Athens, TNThe pilot's inadequate visual lookout resulting in a collision with power lines while making an off-airport landing.NTSB CEN11LA328Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fredenberg Township, MNThe pilot's inadequate directional control during a crosswind landing.NTSB CEN11FA324Accident · 2 fatalField investigationFinal reportWoodward Harold L Ravin 500 · Conroe, TXAn in-flight smoke event on takeoff and the pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall.NTSB ERA11FA285Accident · 2 fatalField investigationFinal reportHebert Peter J Lancair Legacy · Richlands, NCThe pilot's improper in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11CA326Accident · No injuriesData collectionFinal reportGetten Marvin T Quickie Q2 · Albuquerque, NMThe pilot's loss of elevator control, due to control stick's counter-weight binding with the airplane's header tank.NTSB CEN11CA322Accident · No injuriesData collectionFinal reportCessna 172K · Farmersville, TXA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB WPR11CA198Accident · No injuriesData collectionFinal reportGrumman G-164 · Princeton, CAThe pilot’s failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.NTSB ERA11LA282Accident · No injuriesLimited investigationFinal reportPfouts Alfred L Senior Aero SPT D260 · Palm Coast, FLA total loss of engine power for undetermined reasons.NTSB ERA11CA286Accident · No injuriesData collectionFinal reportCessna 172R · Hollywood, FLThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing.NTSB CEN11FA319Accident · 1 fatalField investigationFinal reportThomas Europa · Shreveport, LAThe loss of aircraft control and subsequent impact with terrain for undetermined reasons.NTSB ERA11CA277Accident · No injuriesData collectionFinal reportCessna A185F · Ocean City, NJThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.NTSB CEN11LA316Accident · 1 fatalLimited investigationFinal reportNorris Dominator · Blue Springs, NEThe pilot's failure to maintain clearance from power lines.NTSB ERA11FA274Accident · 1 fatalField investigationFinal reportBeech E18S · Miami Gardens, FLThe pilot’s improper response to a loss of power in the No. 2 engine and his failure to ensure that the airplane was airworthy. Contributing to the accident was the inadequate engine maintenance by the operator's maintenance personnel.NTSB CEN11CA314Accident · No injuriesData collectionFinal reportPrichard Kevin Legacy 2K · Kansas City, MOThe pilot's misjudgment of the landing area, which resulted in the airplane touching down on a grass area adjacent to the runway and between parallel taxiways.NTSB ERA11FA272Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Indiana, PAThe pilot's operation of the helicopter at a low-forward airspeed out of ground effect, which resulted in the helicopter’s loss of translational lift and tail rotor authority and the pilot’s subsequent loss of helicopter control.NTSB ERA11CA303Accident · No injuriesData collectionFinal reportChampion 7EC-703 · Moultonboro, NHThe pilot’s loss of directional control during the landing rollout, which resulted in a collision with trees.NTSB WPR11CA215Accident · No injuriesData collectionFinal reportCessna 185A · Bend, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA11CA271Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe student pilot’s failure to maintain directional control during landing and the pilot’s inadequate remedial action, which resulted in a runway excursion.NTSB CEN11FA310Accident · 1 fatalField investigationFinal reportJurmu Stol CH701 · Pulaski, WIThe pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.NTSB CEN11CA301Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Estelline, SDThe pilot's failure to maintain directional control of the airplane during takeoff.