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 ERA13LA118Accident · Minor injuriesLimited investigationFinal reportHiller-Tri-Plex Ind.Inc. UH-12B · Okeechobee, FLThe pilot's failure to monitor carburetor temperature and use carburetor heat in conditions conducive to serious carburetor icing, which resulted in partial loss of engine power.NTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.NTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.NTSB CEN13CA142Accident · No injuriesData collectionFinal reportCessna 172S · Peoria, ILThe pilot’s inadvertent activation of the electric trim to the nose-down position, which resulted in the airplane being improperly configured for takeoff, and the flight instructor’s incorrect remedial action that allowed the airplane to porpoise.NTSB ERA13LA117Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Danbury, CTThe flight instructor’s inadequate preflight inspection in which he incorrectly estimated the airplane’s fuel quantity and his improper reliance on the fuel totalizer rather than the fuel quantity indicating and warning systems to determine the fuel on board,…NTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.NTSB WPR13LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rock Springs, WYThe pilot's inadvertent movement of the fuel selector valve beyond its tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector interlock mechanism.NTSB WPR13CA103Accident · No injuriesData collectionFinal reportCessna 150J · Porterville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13LA116Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Ellington, CTThe separation of the collective push-pull tube and jackshaft assembly, which resulted in the total loss of helicopter control and collision with terrain. Contributing to the accident was the inadequate supervision of maintenance personnel by the operator…NTSB CEN13CA139Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Phillipsburg, OHThe pilot's improper operation of the airplane controls during engine start, which resulted in a collision with a hangar.NTSB ERA13FA115Accident · 1 fatalField investigationFinal reportPilatus PC-12/45 · Burlington, NCThe pilot's failure to maintain airplane control due to spatial disorientation during the initial climb after takeoff in night instrument flight rules conditions.NTSB CEN13FA135Accident · 1 fatalField investigationFinal reportCessna 208B · Pellston, MIThe pilot's inadvertent controlled descent into terrain due to spatial disorientation. Contributing to the accident was lack of visual reference due to night conditions.NTSB CEN13CA136Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Upper Sandusky, OHThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.NTSB ERA13LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Dover, DEThe pilot's failure to land the airplane at multiple airports that were equipped with adequate instrument approach procedures while operating in low instrument meteorological conditions and his delay in declaring a fuel-related emergency, which resulted in a…NTSB ERA13LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Winder, GAA total loss of engine power due to a cracked fuel pump line fitting O-ring seal at the inlet to the engine driven fuel pump. Contributing to the accident was the failure of the aircraft operator to comply with the engine manufacturer’s recommended time…NTSB ERA13FA109Accident · 2 fatalField investigationFinal reportBenton Fred D Seawind 3000 · Sarasota, FLThe pilot's inability to establish a normal climb rate after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13FA130Accident · 4 fatalField investigationFinal reportRaytheon 58 · Maxwell, NEThe pilot’s inadvertent encounter with severe icing conditions, which resulted in structural icing and the subsequent loss of airplane control.NTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.NTSB WPR13LA087Accident · Serious injuriesLimited investigationFinal reportBell OH-58C · Riverdale, CAA flight control malfunction while maneuvering for reasons that could not be determined because it was not possible to establish whether observed damage to the flight control assembly was the result of wreckage recovery efforts or a preexisting condition.NTSB ERA13CA107Accident · No injuriesData collectionFinal reportBrewer James M KR2 · Bear Branch, KYThe pilot’s improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot’s lack of knowledge about the airplane’s total fuel capacity and fuel quantity instrumentation.NTSB ANC13CA020Accident · No injuriesData collectionFinal reportCessna A185E · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a main landing gear collapse.NTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…NTSB ANC13CA019Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for an off-airport landing, which resulted in a ground-loop.NTSB WPR13FA083Accident · 1 fatalField investigationFinal reportLuscombe 8A · Oceano, CAThe pilot’s failure to maintain airplane control and his improper decision to begin a low-level maneuver at an altitude that was not sufficient for recovery before ground impact. Contributing to the accident was the pilot’s impairment from marijuana use.NTSB WPR13CA084Accident · Minor injuriesData collectionFinal reportBell 47G · Five Points, CAThe pilot’s failure to maintain clearance with a telephone pole during a low-level maneuver.NTSB CEN13FA122Accident · 3 fatalField investigationFinal reportBell Helicopter 407 · Clear Lake, IAThe pilot’s inadvertent encounter with localized icing conditions and his subsequent in-flight loss of helicopter control.NTSB WPR13FA080Accident · 1 fatalField investigationFinal reportBell 206 · Delano, CAThe pilot's failure to maintain helicopter control due to spatial disorientation while maneuvering in low visibility, dark night conditions.NTSB ERA13FA101Accident · 3 fatalField investigationFinal reportPiper PA-30 · Jasper, ALThe student pilot’s poor judgment to take a multiengine airplane for which he did not have experience or permission to operate and depart into night instrument meteorological conditions, which resulted in a loss of airplane control and impact with terrain.NTSB CEN13CA124Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Menard, TXThe helicopter landed hard during a forced landing.NTSB WPR13LA078Accident · No injuriesLimited investigationFinal reportCessna 210A · Chandler, AZA loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN13LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mc Allen, TXA loss of engine power due to carburetor icing.NTSB ERA13WA103Accident · 2 fatalForeign investigationPiper PA28 · Minas City, BrazilOn December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The…NTSB ERA13CA098Accident · Minor injuriesData collectionFinal reportMckay Gene RV-9A · Brunswick, GAThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB DCA13CA035Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD-11F · Memphis, TNthe operator's failure to provide appropriate training and documentation for ground personnel, leading the marshaller to inadvertently guide the airplane into the collision.NTSB ERA13FA096Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Leesburg, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…NTSB CEN13LA116Accident · Serious injuriesLimited investigationFinal reportSeguine Swift II · San Antonio, TXThe pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.NTSB ERA13LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Lock Haven, PAThe reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…NTSB CEN13TA113Accident · Minor injuriesFinal reportCessna 550 · Oklahoma City, OKThe flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane…NTSB ERA13LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Indian Trail, NCThe flight instructor’s failure to maintain adequate glidepath and airspeed control during short final approach and the airplane’s improper touchdown point, which resulted in a runway overrun.NTSB ERA13CA090Accident · No injuriesData collectionFinal reportAmerican AA-5 · Hot Springs, VAThe pilot’s failure to maintain airplane control while attempting to land in crosswind conditions.NTSB CEN13LA111Accident · No injuriesLimited investigationFinal reportPiper L-18C · Graham, TXThe failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.NTSB ERA13LA093Accident · 1 fatalLimited investigationFinal reportRussom Roy G Hummel H5 · Calhoun, GAThe pilot’s impairment or incapacitation due to the effects of medication, worsening cardiac disease, or cardiac arrhythmia, which resulted in his loss of control of the airplane.NTSB ERA13FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Parkton, NCThe failure of the instrument-rated pilot to maintain control of the airplane while in instrument meteorological conditions after reporting a gyro malfunction. Contributing to the accident was the loss of primary gyro flight instruments due to the failure of…NTSB ANC13FA017Accident · Serious injuriesField investigationFinal reportEurocopter AS350 B3 · Beluga, AKThe pilot's failure to stabilize the external load, which led to the synthetic long-line separating about midspan and the remaining line becoming entangled in the tail rotor gearbox output shaft and resulted in the separation of the tail rotor gearbox and…NTSB WPR13LA069Accident · Serious injuriesLimited investigationFinal reportPowerchute Airwolf 912ULS · Dell, MTThe pilot's failure to maintain aircraft control and clearance from mountainous terrain while maneuvering at a low altitude in downdraft conditions.NTSB ERA13LA087Accident · Minor injuriesLimited investigationFinal reportRotorway DB-1 · Mayland, TNThe pilot’s failure to maintain helicopter control following a high-side governor failure for reasons that could not be determined during postaccident examination.NTSB ERA13CA086Accident · Serious injuriesData collectionFinal reportCessna 172P · Murfreesboro, TNThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ERA13FA083Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Lake Park, GAThe noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB CEN13CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okaton, SDThe pilot's failure to perform an adequate preflight inspection of the airplane and obstruction of the aileron control system by snow and ice, which led to a loss of control during flight.