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 CEN12CA030Accident · No injuriesData collectionFinal reportCessna 172N · Covington, LAThe pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.NTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR12LA013Accident · Minor injuriesLimited investigationFinal reportMiller Avid Flyer · Susanville, CAA total loss of engine power during the takeoff climb for undetermined reasons.NTSB ERA12WA041Accident · Serious injuriesForeign investigationBell 412 · Santa Rosa, VenezuelaOn October 15, 2011, at 1933 UTC, a Bell 412SP, YV0126, registered to and operated by Electrificacion del Caroni (EDELCA), as a business flight, collided with trees while on approach to Macagua Airport, Santa Rosa, Venezuela. The Venezuelan Government…NTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.NTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.NTSB CEN12WA033Accident · 2 fatalForeign investigationDiamond DA20 · Amurrio, SpainOn October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…NTSB WPR12LA009Accident · No injuriesLimited investigationFinal reportSpink Robert M Pietenpol Aircamper · San Rafael, CAA total loss of engine power during the takeoff climb due to fuel starvation, which resulted from the incorrect installation location of the fuel tank supply line screen that allowed debris to partially block the fuel supply line.NTSB WPR12FA010Accident · 1 fatalField investigationFinal reportDG Flugzeugbau DG 1000S · Cle Elum, WAThe pilot’s failure to maintain airspeed and control after takeoff, which resulted in an aerodynamic stall.NTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.NTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.NTSB ERA12FA023Accident · Minor injuriesField investigationFinal reportSocata TBM 700 · Hollywood, FLThe pilot’s failure to terminate the flight after observing multiple conflicting errors associated with the inaccurate right fuel quantity indication. Contributing to the accident were the total loss of engine power due to fuel starvation from the right tank,…NTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.NTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.NTSB CEN12LA014Accident · Serious injuriesLimited investigationFinal reportPeck Zodiac 601XL · Traverse City, MIA loss of engine power for undetermined reasons.NTSB CEN12CA011Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Englewood, COThe student pilot's improper flare, which resulted in a bounced landing from which he was unable to recover.NTSB WPR12CA006Accident · Minor injuriesData collectionFinal reportLudwig Larry E Bushman · Diamond, WAThe pilot's inadequate recovery from a bounced landing and subsequent failure to maintain aircraft control.NTSB ANC12CA003Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate clearance from a tree during an off-airport landing.NTSB ERA12LA358Accident · No injuriesLimited investigationFinal reportCessna 182C · Efland, NCThe pilot’s loss of directional control during the landing roll, which resulted in a collision with a ditch.NTSB ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.NTSB CEN12LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Wadsworth, OHThe failure of the brake system during the landing roll, which was caused by a loss of hydraulic fluid as a result of a leak in the piston seal due to brake plates worn beyond their service limits.NTSB CEN12LA012Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Easton, MODebris in the fuel system, which resulted in a loss of engine power due to fuel starvation. Also causal was the pilot not maintaining sufficient airspeed, which resulted in an aerodynamic stall.NTSB ERA12CA015Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Elizabethton, TNThe failure of the pilot to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.NTSB ERA12LA011Accident · 1 fatalLimited investigationFinal reportRivers William J KR-2 · Wytheville, VAThe pilot's failure to maintain control, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's lack of experience in the airplane make and model.NTSB ERA12CA010Accident · No injuriesData collectionFinal reportCalvin Nate H CALVIN-VELOCITY · Sebastian, FLThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB CEN12FA010Accident · 1 fatalField investigationFinal reportBrinkerhuff Gerald G Q200 · Holland, MIThe pilot failed to maintain sufficient altitude during the landing approach, which resulted in the airplane contacting an approach light. Contributing to the accident was the setting sun, which most likely obscured the pilot’s vision.NTSB ERA12LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Norfolk, VAThe pilot's inability to maintain directional control during takeoff for undetermined reasons. Contributing to the accident was the pilot's delayed decision to abort the takeoff.NTSB ERA12LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Punta Gorda, FLThe partial loss of engine power due to contamination of the fuel system that was not detected because of the pilot’s inadequate preflight inspection.NTSB ERA12FA008Accident · 1 fatalField investigationFinal reportAviat A-1 · Moyock, NCThe operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA12FA007Accident · 1 fatalField investigationFinal reportCessna 207A · Matinicus Island, METhe pilot’s failure to maintain airplane control during the approach after encountering a gusty crosswind, which resulted in an accelerated stall and uncontrolled descent.NTSB ERA12FA006Accident · 1 fatalField investigationFinal reportHarry L. Weber Arion LI · Hedgesville, WVAn aerodynamic stall at low altitude due to the pilot’s acute cardiac event.NTSB CEN12LA008Accident · Serious injuriesLimited investigationFinal reportJohnston William Alfred JR Kolb Mark III · Versailles, MOA loss of engine power due to adjustments and modifications that the pilot made to the engine and airplane.NTSB CEN12LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Centerburg, OHThe pilot's improper pre-flight planning and failure to ensure that there was an adequate fuel supply on board to complete the flight, which resulted in fuel exhaustion. Contributing to the accident was the malfunction of the fuel quantity indicator.NTSB WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…NTSB ERA12MA005Accident · 2 fatalMajor investigationFinal reportBell 206B · New York, NYThe pilot's failure to anticipate and correct for conditions (high gross weight, low indicated airspeed, and a right downwind turn) conducive to loss of tail rotor effectiveness (LTE), which resulted in LTE and an uncontrolled spin. Contributing to the…NTSB CEN12CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hibbing, MNThe private pilot's failure to maintain control of the helicopter during the landing flare.NTSB ERA12FA012Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Peru, WVThe non-instrument rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent in-flight collision with mountainous terrain.NTSB CEN12CA005Accident · No injuriesData collectionFinal reportCampbell John Mustang II · Brush, COThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.NTSB ERA12LA001Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Ridgefield, CTThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12FA001Accident · 1 fatalField investigationFinal reportRobinson Helicopter R66 · Philip, SDThe in-flight separation of the main rotor mast following a mast bumping event. The reason for the mast bumping event could not be determined due to postaccident damage.NTSB CEN12CA003Accident · Serious injuriesData collectionFinal reportSadler Terry Rans S-7 Courier · Riley, KSA total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.NTSB ERA11FA512Accident · 1 fatalField investigationFinal reportHeronimus Kevin A Glasair III · Falls of Rough, KYThe failure of the propeller power speed reduction unit, which resulted in a loss of engine power at low altitude.NTSB CEN11CA675Accident · No injuriesData collectionFinal reportCessna T210R · Lamar, MOThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.NTSB WPR11LA469Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ahwahnee, CAThe pilot’s failure to maintain adequate main rotor rpm during the landing approach, which resulted in a loss of control.NTSB ERA11CA506Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Montgomery, NYA total loss of engine power due to fuel starvation as a result of the pilots’ inadequate fuel management.NTSB CEN11LA669Accident · Serious injuriesLimited investigationFinal reportOwen Vans RV-10 · Marietta, OHThe in-flight engine fire and loss of engine power due to an improperly installed fuel injector nozzle during a recent engine overhaul.NTSB ANC11CA112Accident · No injuriesData collectionFinal reportCessna 180 · Haines, AKThe pilot's loss of directional control during takeoff in a float-equipped airplane for an undetermined reason, which resulted in the airplane colliding with trees and the shore.NTSB ANC11CA111Accident · No injuriesData collectionFinal reportCessna 180H · Chenga Bay, AKThe pilot's failure to maintain clearance from an obstruction while landing at an off-airport site, resulting in a loss of control.NTSB WPR11CA466Accident · Minor injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe pilot’s failure to maintain directional control during the landing rollout.NTSB ANC11CA113Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot’s decision to take off from an off-airport site in variable wind.