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 ERA18FA200Accident · 2 fatalField investigationFinal reportPiper PA24 · Palatka, FLThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and a loss of control.NTSB CEN18LA301Accident · Serious injuriesLimited investigationFinal reportFlightstar SC II · Painesville, OHThe student pilot’s failure to maintain an airspeed below flight speed during a practice taxi run, which resulted in the airplane inadvertently becoming airborne. Once airborne, the reduced engine power due to an improper propeller pitch setting and…NTSB CEN18LA300Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Le Sueur, MNThe pilot's inadequate preflight and in-flight fuel planning, during which he did not visually check the fuel quantity in the fuel tanks and instead relied on the fuel gauges that were showing erroneous fuel quantity indications, which resulted in fuel…NTSB GAA18CA447Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Iowa, LAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA18TA203Accident · No injuriesFinal reportBeech C90 · Lecanto, FLThe pilot's failure to turn on the fuel transfer pumps in accordance with the published checklists, which resulted in a dual loss of engine power due to fuel starvation.NTSB CEN18TA296Accident · No injuriesFinal reportFisher Dakato Hawk · Oshkosh, WIThe failure of the left main landing gear for reasons that could not be determined, which resulted in a loss of directional control during the ground roll.NTSB WPR18LA203Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Avalon, CAThe pilot's delayed decision to conduct a go-around following an unstable landing approach and long landing.NTSB ERA18LA213Accident · No injuriesLimited investigationFinal reportPiper PA46 · West Columbia, SCThe pilot’s inadvertent navigation onto a service road instead of a taxiway, which resulted in a collision with a stop sign.NTSB WPR18LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell UH 1H · Oakdale, CAThe pilot's loss of control during a precautionary landing following an abnormal noise in-flight, the source of which could not be determined.NTSB ERA18FA197Accident · 2 fatalField investigationFinal reportPiper PA32R · Lincolnton, NCThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing the accident was the pilot's self-induced pressure to complete…NTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.NTSB CEN18CA293Accident · Minor injuriesData collectionFinal reportJust JA30 Superstol · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during the initial climb and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18CA291Accident · No injuriesData collectionFinal reportQuad City Challenger · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed during the base to final turn and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ANC18LA057Accident · 1 fatalLimited investigationFinal reportAeros Venture 2000 · Bad Axe, MIThe pilot's loss of aircraft control for reasons that could not be determined based on the available information.NTSB GAA18CA443Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Chelan Falls, WAThe pilot's improper approach over a river, which resulted in a collision with a dock.NTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB CEN18LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Milford, IAThe pilot's loss of airplane control during takeoff for reasons that could not be determined because no anomalies consistent with a flight control system malfunction were observed.NTSB WPR18FA201Accident · Serious injuriesClass 2 · FieldFinal reportDouglas DC3 · Burnet, TXThe copilot's failure to maintain directional control during the initial takeoff roll and the pilot's failure to adequately monitor the copilot during the takeoff and his delayed remedial action, which resulted in the airplane briefly becoming airborne and…NTSB GAA18CA444Accident · No injuriesData collectionFinal reportCessna 195 · Hood River, ORThe pilot’s failure to maintain directional control during landing.NTSB CEN18LA287Accident · No injuriesLimited investigationFinal reportCessna 210C · Blum, TXThe pilot's excessive leaning of the fuel mixture, which resulted in a loss of engine power, and the pilot's failure to extend the landing gear in accordance with the airplane emergency checklist, which resulted in a gear-up landing.NTSB WPR18FA200Accident · 1 fatalField investigationFinal reportDe Havilland DH112 Venom · Sheboygan, WIThe airplane's encounter with wake turbulence from the lead airplane in the formation flight, which resulted in a compressor stall and the airplane's subsequent inability to climb.NTSB GAA18CA439Accident · No injuriesData collectionFinal reportWayne D. Teel Waiex · Kinsey, KSThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB WPR18LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMicrolites Ptyltd Dragonfly B · Buckley, WAA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18LA199Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC19 · Hyrum, UTThe pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…NTSB GAA18CA432Accident · No injuriesData collectionFinal reportPiper PA28 · Oregon, WIThe pilot's improper decision to take off with a known brake malfunction, which resulted in a collision with a barn during landing on a wet runway.NTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18FA282Accident · 1 fatalField investigationFinal reportFisher Celebrity · Patriot, INAn in-flight separation of the right wing due to upward and rearward bending that led to an overstress fracture. The reason for the upward and rearward bending could not be determined based on the available information.NTSB ANC18FA055Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland DHC-2 · Willow, AKThe pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…NTSB ERA18LA195Accident · No injuriesLimited investigationFinal reportEagle DW1 · Ider, ALFatigue failure of the No. 2 cylinder studs/through bolts and the fracture of the crankcase, which resulted in a total loss of engine power.NTSB CEN18WA279Accident · 1 fatalForeign investigationCessna 150 · Tortola, British Virgin IslandsNTSB WPR18FA198Accident · 2 fatalField investigationFinal reportRyan Navion · Truckee, CAA loss of engine power for reasons that could not be determined.NTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.NTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…NTSB GAA18CA424Accident · No injuriesData collectionFinal reportBell 206 · New Castle, INThe pilot's failure to ensure that the fill hose was disconnected from the helicopter before takeoff, which resulted in the fill hose striking the tail rotor and the subsequent loss of tail rotor effectiveness. Contributing to the accident was inadequate…NTSB GAA18CA423Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Lowville, NYThe pilot’s failure to maintain a proper airspeed during the approach to land, which resulted in an aerodynamic stall.NTSB CEN18FA267Accident · 2 fatalField investigationFinal reportKolb Twinstar · La Porte, TXThe pilot's failure to maintain airspeed during a visual approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall at an altitude too low for recovery.NTSB WPR18LA196Accident · Minor injuriesClass 3 · LimitedFinal reportCassutt Iiim · Rosamond, CAThe pilot's failure to maintain adequate airspeed during a low-altitude maneuver after a partial loss of engine power, which resulted in exceedance of the airplane’s critical angle of attack and a subsequent accelerated stall. Contributing to the accident was…NTSB ERA18TA193Accident · Serious injuriesFinal reportQuicksilver MXL II · Arecibo, PRThe noncertificated pilot's improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA18LA192Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269D · Stewartstown, PAThe pilot's inability to maintain yaw control while transitioning to an out of ground effect hover due to a loss of tail rotor effectiveness.NTSB ERA18LA191Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Geneseo, NYThe pilot's failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane's critical angle of attack during takeoff and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s failure to follow…NTSB ERA18FA189Accident · 1 fatalField investigationFinal reportRutan Defiant · Plainville, CTThe pilot's loss of airplane control during climb for reasons that could not be determined based on the available information.NTSB CEN18LA275Accident · No injuriesLimited investigationFinal reportWhittman Tailwind · Orient, OHThe pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…NTSB CEN18LA274Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lakeview, ARThe student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and…NTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.NTSB CEN18FA265Accident · 1 fatalField investigationFinal reportRose Parrakeet A-1 · Rhome, TXThe pilot's exceedance of the airplane's critical angle of attack after takeoff, which resulted in an aerodynamic stall.NTSB WPR18TA192Accident · Serious injuriesFinal reportSchempp Hirth Discus CS · Goldfield, NVThe glider’s encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing on uneven terrain.NTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.NTSB GAA18CA408Accident · No injuriesData collectionFinal reportRobinson R44 · Rulo, NEThe pilot's improper collective application, which resulted in low rotor rpm during the takeoff climb and a subsequent ground collision. Contributing to the accident was the pilot’s self-induced pressure to complete the operation.NTSB CEN18FA262Accident · 1 fatalField investigationFinal reportSchempp-Hirth Flugzeugbau Ventus 3F · Moriarty, NMThe pilot's exceedance of the glider's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall and subsequent impact with terrain.