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 WPR12CA187Accident · No injuriesData collectionFinal reportGlass Roy L RV-6 · Coolidge, AZThe pilot’s loss of directional control during landing.NTSB ERA12LA306Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Fowler's Bluff, FLThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12LA305Accident · Serious injuriesLimited investigationFinal reportAviat A-1B · Sylacauga, ALThe pilot's attempt to take off with the carburetor heat in the hot position, which limited the airplane’s performance, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA12FA303Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Anderson, SCThe pilot's failure to maintain control of the airplane during the aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA12WA353Accident · 2 fatalForeign investigationEmbraer EMB712 · Morro do Manduba Guaruja, BrazilOn April 26, 2012, about 1845 Universal Coordinated Time (UTC), an Embraer 712, Brazilian registration PT-NUH, operated by the Aeroclube de Itanhaem, crashed under unknown circumstances in a dense forest area in Morro do Manduba Guaruja Municipality, Sao…NTSB CEN12LA258Accident · Minor injuriesLimited investigationFinal reportBell 206B · Amarillo, TXThe pilot's failure to maintain helicopter control during landing in gusty wind conditions associated with a thunderstorm, which resulted in a loss of tail rotor effectiveness.NTSB WPR12FA184Accident · 3 fatalField investigationFinal reportCessna A185F · Blanding, UTThe pilot's failure to maintain airplane control during low-level maneuvering flight. Contributing to the pilot’s death was the lack of a timely emergency rescue response due to the lack of effective emergency signal transmissions from both the airplane’s…NTSB WPR12CA183Accident · No injuriesData collectionFinal reportBell 206B · Arvin, CAThe pilot did not maintain clearance from power lines during low altitude maneuvering.NTSB ERA12CA302Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Lancaster, PAThe pilot's loss of directional control during the takeoff, and her delayed remedial action in aborting the takeoff after the loss of directional control.NTSB CEN12LA260Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Bryan, TXThe pilot's diverted attention, which resulted in a loss of control while maneuvering the airplane at a low altitude.NTSB CEN12LA283Accident · No injuriesLimited investigationFinal reportBeech 58 · Sioux Falls, SDThe failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.NTSB CEN12LA257Accident · No injuriesLimited investigationFinal reportClifton Breezy · Laneville, TXA loss of engine power due to carburetor ice.NTSB WPR12LA181Accident · No injuriesLimited investigationFinal reportCub Crafters CC11-100 · Monmouth, ORA partial loss of engine power during takeoff for undetermined reasons.NTSB WPR12LA178Accident · Serious injuriesLimited investigationFinal reportBeechcraft A36TC · Pendleton, ORThe pilot's failure to maintain an adequate glidepath for landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's failure to secure the left-side fuel cap before departure. Contributing to the…NTSB CEN12LA254Accident · No injuriesLimited investigationFinal reportAlvarez Marvin R Rans S-6S · New Braunfels, TXThe non-certificated pilot's loss of airplane control during takeoff.NTSB CEN12LA253Accident · Serious injuriesLimited investigationFinal reportBumford-Royer Christen Eagle II · Pearland, TXA loose B nut on the fuel inlet line due to maintenance personnel’s application of insufficient torque on the nut at an unknown time, which resulted in a fuel leak and a subsequent total loss of engine power during initial climb.NTSB CEN12LA252Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Englewood, COThe pilot’s failure to abort the takeoff after the airplane failed to gain adequate airspeed.NTSB ANC12LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.NTSB CEN12LA259Accident · No injuriesLimited investigationFinal reportMoody-Siple A · Stuttgart, ARThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC12CA032Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Alpha · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a tailrotor strike.NTSB WPR12CA177Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Sierraville, CAThe pilot did not maintain directional control during the landing roll.NTSB ERA12LA295Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Yorktown, NYThe pilot's improper placement of the fuel selector, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to perform the published emergency procedure by the checklist.NTSB ERA12LA294Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, KYA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s failure to supervise the student’s preflight inspection, his inadequate fuel management and preflight and in-flight fuel planning, and the operator’s…NTSB ERA12LA292Accident · Serious injuriesLimited investigationFinal reportMooney M20F · McKinnon, TNThe pilot's delayed decision to go-around after failing to recognize that he was attempting to land with a tailwind, and his failure to retract the landing gear and wing flaps for the go-around, which resulted in a collision with trees and terrain near the…NTSB ERA12LA290Accident · 1 fatalLimited investigationFinal reportCessna 421CPilot incapacitation, which resulted in the pilot’s inability to maintain airplane control and the airplane’s subsequent ocean impact.NTSB WPR12CA169Accident · No injuriesData collectionFinal reportCessna 182G · Georgetown, CAThe pilot’s failure to maintain control of the airplane while landing with a gusting wind.NTSB ERA12CA288Accident · No injuriesData collectionFinal reportCessna 180J · Abingdon, VAThe passenger’s inadvertent blockage of the rudder pedals, which resulted in the pilot’s inability to maintain directional control during the landing roll.NTSB ERA12LA293Accident · No injuriesLimited investigationFinal reportPrendergast John/Vans RV-7A · Gerrardstown, WVThe pilot/builder's misjudgment of the required spacer width needed after engine housing lap grinding, which resulted in bearing oil hole misalignment and insufficient internal engine lubrication.NTSB WPR12CA166Accident · Minor injuriesData collectionFinal reportMooney M20B · Rosamond, CAA loss of engine power during takeoff due to fuel starvation as a result of the pilot’s selection of an empty fuel tank prior to departure.NTSB ERA12LA285Accident · Serious injuriesLimited investigationFinal reportWilloughby Pete A Streak Shadow · Salem, WVA total loss of engine power due to a piston seizure that resulted from a fuel system restriction and poorly secured fuel lines. Contributing to the accident were the pilot/builder’s failure to follow the engine manufacturer procedures and his use of…NTSB ERA12CA284Accident · No injuriesData collectionFinal reportTiger AG-5B · Lincoln Park, NJThe pilot's failure to maintain directional control during a go-around in a crosswind.NTSB ERA12LA282Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Farmington, CTThe pilot's inadequate compensation for wind during a high-power, low-speed downwind turn, which resulted in a loss of control due to loss of tail rotor effectiveness and settling with power. Contributing to the accident was the pilot’s decision to land…NTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.NTSB CEN12LA244Accident · Serious injuriesLimited investigationFinal reportT Bird Golden Circle Air II · Clara City, MNThe airplane's loss of engine power for reasons that could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have precluded normal operation.NTSB WPR12LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · San Manuel, AZThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.NTSB ERA12LA279Accident · Minor injuriesLimited investigationFinal reportStanley B E Murphy Rebel · Falmouth, MAThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power.NTSB ERA12CA281Accident · No injuriesData collectionFinal reportPiper J3C-65 · Plantation Key, FLThe pilot’s failure to maintain adequate control of the airplane and ensure clearance from trees.NTSB CEN12LA248Accident · Minor injuriesLimited investigationFinal reportAerostar International Raven S49A · Janesville, WIThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB WPR12FA164Accident · 1 fatalField investigationFinal reportCessna 320D · Green River, WYThe pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.NTSB WPR12CA171Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's inadequate compensation for a crosswind during takeoff, which resulted in a loss of directional control.NTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.NTSB ERA12CA276Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Iuka, MSThe pilot's improper preflight planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLA total loss of engine power due to a catastrophic engine failure, the origin of which could not be determined during postaccident examination.NTSB ERA12CA275Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Ruleville, MSThe pilot's inadequate preflight planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12LA236Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T15 · Lakin, KSThe pilot did not maintain sufficient airspeed while maneuvering, which resulted in an aerodynamic stall at a low altitude.NTSB WPR12LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Casper, WYA total loss of engine power during cruise flight due to a failed piston pin plug, which resulted in engine oil contamination and subsequent oil starvation. Contributing to the loss of power was the failure of maintenance personnel to identify contaminants…NTSB WPR12FA155Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA-300 · Salinas, CAA loose portable XM-GPS antenna that migrated to the tail section of the airplane and jammed the elevator bell crank. Contributing to the accident was the pilot’s failure to account for the cockpit portable GPS antenna during preflight or postflight…NTSB WPR12LA160Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kent, WAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern, which resulted in a collision with trees.NTSB WPR12FA154Accident · 1 fatalField investigationFinal reportCessna T182 · Ludlow, CAThe in-flight loss of control due to the pilot’s impairment as a result of hypoxia. Contributing to the accident was the pilot’s operation of the airplane above 12,500 feet without the aid of supplemental oxygen.NTSB ERA12FA271Accident · 1 fatalField investigationFinal reportWejebe Jose CA8 -SF · Everglades City, FLThe pilot’s failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of airplane control.