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 GAA18CA352Accident · No injuriesData collectionFinal reportBell 206 · Orondo, WAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.NTSB GAA18CA378Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369 · Yabucoa, PRThe pilot's failure to maintain main rotor clearance from a fiber line while picking up a lineman.NTSB ERA18LA169Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172D · Quinton, VAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18LA228Accident · Minor injuriesLimited investigationFinal reportRGJ Johnson AIR CAM · Greenwood, ILThe pilot's decision to take off with insufficient runway available and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR18FA171Accident · 2 fatalClass 2 · FieldFinal reportBeech A35 · Hesperia, CAThe pilot's failure to maintain airplane control during an attempted return to the airport following the separation of the spinner bulkhead during takeoff as a result of fatigue cracking. Contributing to the accident was the pilot's improper decision to fly…NTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.NTSB ANC18LA046Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Ambler, AKThe pilot's selection of an unsuitable takeoff area with unfavorable wind conditions, which resulted in the airplane’s inability to maintain a climb.NTSB ERA18LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 34-200 · Umatilla, FLMaintenance personnel ‘s failure to complete and verify the proper installation of the main landing gear (MLG) torque links’ attachment hardware, which resulted in the right MLG torque link disconnecting and the pilot’s subsequent inability to maintain…NTSB CEN18LA223Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7BCM · Eureka Springs, ARThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB ERA18FA167Accident · 2 fatalField investigationFinal reportRaytheon 58 · Springfield Township, NJA loss of control due to spatial disorientation while climbing after departure in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument experience.NTSB ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.NTSB WPR18LA166Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Plant City, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun. Contributing to the accident was an engine anomaly for reasons that could not be determined based on the available information, and the pilot's failure to activate the…NTSB GAA18CA344Accident · No injuriesData collectionFinal reportBeech A36 · Arcadia, FLThe pilot’s loss of directional control during landing due to a flat tire.NTSB CEN18LA219Accident · No injuriesLimited investigationFinal reportAston Kinsey Tercel · Cokeville, WYThe loss of gyrocopter control for reasons that could not be determined because postaccident examination of the gyrocopter revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA165Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Arecibo, PRMaintenance personnel's failure to properly apply torque to the engine through bolts, which ultimately resulted in the crankshaft failure and the total loss of engine power.NTSB CEN18FA216Accident · 4 fatalField investigationFinal reportCessna T182T · Monroe, WISpatial disorientation resulting in a loss of control during the missed approach conducted in instrument meteorological conditions. Contributing to the accident was the pilot's decision to execute an instrument approach in weather conditions that were below…NTSB ERA18LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 44 · Daytona Beach, FLThe pilots’ improper in-flight weather evaluation and decision to continue the approach, which resulted in an encounter with a thunderstorm, a loss of airplane control, and collision with terrain. Contributing to the accident was the flight instructor’s…NTSB CEN18FA217Accident · 2 fatalField investigationFinal reportLet L 23 Super Blanik · Moose, WYThe pilot's encounter with atmospheric conditions that resulted in a loss of lift and a subsequent loss of control near terrain that precluded recovery. Contributing to the accident was the pilot's failure to follow the operator's published tour flight…NTSB CEN18FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 · Oshkosh, WIThe pilot's decision to fly over the river at a low altitude and his failure to maintain clearance with wires during low-level flight.NTSB ANC18FA044Accident · 2 fatalClass 2 · FieldFinal reportPiper PA18 · Sitka, AKThe pilot's exceedance of the airplane's critical angle of attack for unknown reason, which resulted in an aerodynamic stall and a loss of control.NTSB WPR18WA187Accident · 1 fatalForeign investigationCessna 172 · Moorabbin, AustraliaNTSB ERA18LA163Accident · Minor injuriesLimited investigationFinal reportVans RV4 · Butler, PAThe pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.NTSB ERA18LA162Accident · No injuriesLimited investigationFinal reportBryan C L/Labrash R D Searey · Englewood, FLThe partial loss of engine power due to carburetor icing.NTSB ERA18WA159Accident · 3 fatalForeign investigationCessna 421B · Rock Sound, BahamasNTSB ANC18LA042Accident · Minor injuriesLimited investigationFinal reportGippsaero PTY GA10 · Mojave, CAThe flight crew's inappropriate decision, without authorization or consultation from the manufacturer's chief design engineer, to introduce flaps in the landing configuration into the entry spin testing, which resulted in an unrecoverable spin and impact with…NTSB ANC18FA041Accident · 1 fatalField investigationFinal reportMason Hal J Kitfox Model 1 · Salem, ORThe student pilot's improper decision to operate an airplane for which he was not endorsed to fly solo and in which he had limited experience or training, and his subsequent loss of airplane control after takeoff.NTSB GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…NTSB GAA18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Fuquay Varina, NCThe flight instructor’s failure to maintain adequate clearance from overgrown brush during taxi, which resulted in entanglement with the brush and a subsequent impact with a tree.NTSB ERA18LA157Accident · 4 fatalLimited investigationFinal reportPiper PA 31 · Amagansett, NYThe pilot's decision to fly under a thunderstorm and a subsequent encounter with turbulence and restricted visibility in heavy rain, which resulted in a loss of control.NTSB ANC18LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Wasilla, AKA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18LA209Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Longview, TXThe pilot's failure to use carburetor heat for takeoff, which resulted in an interruption of continuous fuel flow to the engine and a loss of engine power during climb. Also causal was the lack of required placarding warning of the need to use full carburetor…NTSB CEN18FA204Accident · 2 fatalField investigationFinal reportCirrus SR22 · Midland, TXAn inadvertent stall, resulting in an uncontrollable descent and impact with terrain. Contributing to the accident was the high density altitude.NTSB GAA18CA330Accident · No injuriesData collectionFinal reportSorensen Danny S BF9 2 · Evanston, WYThe pilot’s failure to fuel the biplane’s main fuel tank before the flight and his inadequate preflight inspection, during which he did not verify the fuel quantity, which resulted in fuel exhaustionNTSB CEN18LA211Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Parkin, ARThe improper operation of the rudder pedal adjustment mechanism for an undetermined period of time, which led to the failure of the rudder pedal adjustment track, the detachment of the rudder pedal, and the pilot’s subsequent inability to maintain directional…NTSB WPR18WA208Incident · No injuriesForeign investigationPiper PA28 · Pretoria, South AfricaNTSB GAA18CA312Accident · No injuriesData collectionFinal reportPiper PA 46 · Prescott, AZThe pilot’s improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB CEN18FA201Accident · 1 fatalField investigationFinal reportAyres S2R · El Reno, OKThe pilot's failure to maintain clearance from tower guy wires while maneuvering during an aerial application flight.NTSB GAA18CA308Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Cedar Key, FLThe airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.NTSB CEN18LA199Accident · Serious injuriesLimited investigationFinal reportAeronca 58B · Tekamah, NEThe partial loss of engine power due to the formation of carburetor ice. Contributing to the accident was the pilot's failure to use carburetor heat and his decision to continue flight with reduced engine power rather than landing the airplane on suitable…NTSB CEN18LA197Accident · Minor injuriesLimited investigationFinal reportFairchild M 62C(PT-23A) · Wichita, KSA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s miscalculation of the fuel consumption rate during preflight planning.NTSB WPR18FA150Accident · 2 fatalField investigationFinal reportMorrison Marvin E JR RV 6A · Petaluma, CAA partial loss of engine power during initial climb after takeoff due to a loose left magneto, and the pilot's decision to turn back to the airport and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and…NTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.NTSB GAA18CA306Accident · No injuriesData collectionFinal reportLite Flight Dragonfly · Mint Hill, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a turn, which resulted in an aerodynamic stall/spin.NTSB GAA18CA305Accident · Minor injuriesData collectionFinal reportZS Delta-Bielsko Wroclaw SZD 36 A Cobra 15 · Hammond, ILThe pilot’s loss of directional control during an off-airport landing and his subsequent failure to maintain clearance from power pole guy wires.NTSB CEN18LA205Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Union, ILThe pilot’s medical impairment at the time of the accident, which resulted in a collision with power lines off the end of the runway.NTSB CEN18FA193Accident · 2 fatalField investigationFinal reportBeech P35 · Omaha, NEThe pilot's loss of directional control and his failure to abort the takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA18LA155Accident · No injuriesClass 3 · LimitedFinal reportDevries WM H Kitfox Sport · Taghkanic, NYA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18LA147Accident · Serious injuriesClass 3 · LimitedFinal reportBell UH 1H · Olympia, WAA loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…