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 GAA16CA191Accident · No injuriesData collectionFinal reportBeech C23 · Frenchville, METhe pilot's failure to maintain directional control during the takeoff roll on a runway contaminated with ice and snow, which resulted in a runway excursion and an impact with a snowbank.NTSB GAA16CA173Accident · Minor injuriesData collectionFinal reportBeech F35 · Long Island, NCThe pilot's decision to maneuver at low altitude, which resulted in a collision with power lines and substantial damage to the vertical stabilizer.NTSB GAA16CA167Accident · No injuriesData collectionFinal reportSewell William K Zodiac 601 · Clarksville, VAThe pilot's failure to maintain directional control during takeoff, which resulted in the airplane drifting to the left of the runway and impacting trees.NTSB CEN16LA139Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402 · Beyersville, TXThe pilot's failure to maintain visual separation from the power line due to a lack of identifiable and contrasting features, which led to an inflight collision with the line while maneuvering in gray, hazy conditions.NTSB ERA16LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-250 · Danville, VAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA16FA143Accident · 1 fatalField investigationFinal reportRobinson R44 · Canadensis, PAThe pilot's loss of control due to spatial disorientation, which occurred after ascending in order to clear rising terrain and inadvertently entering the clouds.NTSB GAA16CA171Accident · No injuriesData collectionFinal reportRockwell International 114 · Addison, TXThe private pilot's failure to maintain directional control during the landing roll and the flight instructor's delayed remedial action, which resulted in a runway excursion, collision with an airport sign, and a nose gear collapse.NTSB GAA16CA165Accident · Minor injuriesData collectionFinal reportBell 206B · Hanford, CAThe pilot's decision to release the collective while flying at 10 feet above ground level, resulting in the rapid helicopter descent and impact with terrain.NTSB ERA16FA141Accident · 1 fatalField investigationFinal reportCessna 172N · Charleston, WVThe flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.NTSB ERA16FA140Accident · 4 fatalField investigationFinal reportEurocopter AS 350 B2 · Enterprise, ALThe pilot's decision to perform visual flight rules flight into night instrument meteorological conditions, which resulted in loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete the…NTSB CEN16LA134Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Stephenville, TXThe loss of engine power during cruise flight due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning and in-flight fuel management.NTSB CEN16LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Del Rio, TXThe pilot’s loss of directional control while departing with a gusting tailwind.NTSB GAA16CA166Accident · Minor injuriesData collectionFinal reportPiper J5A · Lake Harbor, FLThe pilot's exceedance of the critical angle of attack while maneuvering at low altitude, which resulted in an accelerated aerodynamic stall, spin, and impact with terrain.NTSB CEN16LA135Accident · Serious injuriesLimited investigationFinal reportBrantly B 2B · Galena, MOThe pilot’s loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA169Accident · Minor injuriesData collectionFinal reportAmerican Legend AL3 · Monticello, GAThe pilot's decision to land with a quartering tail wind, and failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with a tree.NTSB WPR16FA087Accident · 2 fatalField investigationFinal reportNorth American AT 6A · Astoria, ORThe pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.NTSB GAA16CA160Accident · Minor injuriesData collectionFinal reportRobinson R44 · Oak Island, NCThe student pilot's failure to maintain a stabilized hover, resulting in a loss of control and an impact with terrain.NTSB CEN16LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Alexandria, LAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA156Accident · No injuriesData collectionFinal reportRolladen-Schneider LS8 · Pine Grove, PAThe pilot's inability to maintain the glider's descent rate and glide path after encountering a downdraft, resulting in a collision with trees during an off airport landing.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB CEN16FA130Accident · 1 fatalField investigationFinal reportAeronca 7AC · Ellsworth, NEThe pilot's impairment due to carbon monoxide poisoning from a known cracked engine exhaust muffler, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to continue flying the airplane without properly repairing…NTSB GAA16CA153Accident · Serious injuriesData collectionFinal reportBarnes Thomas A Vans · Bolingbrook, ILThe pilot's failure to maintain direction control during the takeoff roll, which resulted in runway excursion, collision with terrain, and nose over.NTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN16LA129Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wichita, KSThe total loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel management.NTSB CEN16LA128Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Longview, TXThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB GAA16CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Riverside, CAThe student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.NTSB WPR16LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, UTThe pilot's failure to abort the takeoff from the soft runway surface, which precluded optimal acceleration during the takeoff sequence.NTSB GAA16CA152Accident · No injuriesData collectionFinal reportCessna 140 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a ground loop, and a collision with an airport sign.NTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…NTSB CEN16LA123Accident · Serious injuriesLimited investigationFinal reportBrockman William A Challenger II · Neshkoro, WIA total loss of engine power for reasons that could not be determined, as postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the non-certificated pilot's decision to maneuver at low…NTSB GAA16CA146Accident · Minor injuriesData collectionFinal reportBeech D17 · Brighton, COThe pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.NTSB CEN16FA122Accident · 2 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Española, NMThe pilot's failure to maintain adequate airspeed while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low altitude.NTSB WPR16LA088Accident · No injuriesLimited investigationFinal reportThomas D. Parkes Lancair ES · Prescott, AZA partial loss of engine power due to an over-temperature event, which thermally damaged the blade tips of the turbocharger wheel and resulted in a slowing or stoppage in the rotation of the turbocharger.NTSB GAA16CA148Accident · No injuriesData collectionFinal reportRemos G 3/600 · Chesapeake, OHThe pilot's unstable approach, which resulted in excessive airspeed during the touchdown, subsequent bounced landing, collapsed nose landing gear, and a runway excursion.NTSB ERA16LA126Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20 · Pottstown, PAThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination and a subsequent off-airport landing.NTSB WPR16LA080Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache · Queen Creek, AZA loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the noncertificated pilot’s lack of experience in the…NTSB GAA16CA145Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Canton, TXThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a collision with trees.NTSB ERA16LA123Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BL · St. Petersburg, FLA partial loss of engine power due to the fatigue fracture of the No. 3 cylinder head stud.NTSB CEN16LA121Accident · Serious injuriesLimited investigationFinal reportAriosto James J Ariosto Mustang II · Normangee, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector positioning procedures during the flight.NTSB GAA16CA144Accident · No injuriesData collectionFinal reportCessna 195 · Clinton, ARThe pilot's failure to maintain direction control during the landing roll, which resulted in runway excursion, and collision with a fence.NTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.NTSB GAA16CA142Accident · No injuriesData collectionFinal reportMaule M5 · Wasilla, AKThe student pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, and an impact with terrain.NTSB CEN16FA114Accident · 2 fatalField investigationFinal reportOhlgren RV 6A · Abilene, TXThe pilot's failure to maintain airplane control during takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's impairment due to his combined use of central…NTSB CEN16LA112Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Laguna Pueblo, NMA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate oversight of the airplane's refueling and her subsequent failure to verify and monitor the fuel quantity before and during the flight.NTSB ERA16LA114Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Gainesville, FLThe failure of the engine crankshaft near the Nos. 4 and 5 crankshaft journals due to oil starvation. The reason for the oil starvation could not be determined during postaccident examination.NTSB CEN16FA111Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Navasota, TXThe flight instructor's delayed remedial action to prevent a stall at an altitude that was too low to recover. Contributing to the accident was the owner/non-certificated pilot's failure to maintain control of the airplane, which resulted in an accelerated…NTSB ERA16LA116Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAA partial loss of engine power during initial climb for undetermined reasons because examination of the engine and a successful test-run did not reveal any anomalies that would preclude normal operation.NTSB ERA16LA115Accident · Serious injuriesLimited investigationFinal reportBeech 95 C55 · Plymouth, MAThe pilot's failure to maintain control of the airplane during an aborted takeoff in gusting wind conditions.NTSB CEN16LA115Accident · No injuriesLimited investigationFinal reportBeech V35 · Seymour, INThe pilot's improper placement of the fuel selector handle between two tank positions, which resulted in a restricted fuel flow to the engine and the initial loss of engine power, and his improper decision to use the high-boost auxiliary fuel pump for an…