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 WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…NTSB ERA13WA063Accident · Serious injuriesForeign investigationCessna 525B · Sao Paulo, BrazilOn November 11, 2012, at 1921 universal coordinated time, a Cessna Citation 525B, Brazilian registration PR-MRG, sustained substantial damage when it overran the runway during landing. One of the 2 crewmembers received serious injuries and the other received…NTSB ERA13LA053Accident · No injuriesLimited investigationFinal reportCessna 210 · Jasper, GAA loss of engine power due to fuel starvation as a result of the pilot’s prolonged sideslip maneuvers during the descent to landing. Contributing to the accident was the airplane’s lack of a required placard advising pilots to avoid lengthy sideslip maneuvers…NTSB CEN13WA061Accident · 2 fatalForeign investigationReims-Cessna F150 · Birr, Ireland, IrelandOn November 11, 2012, about 1655 Western European time, a Reims-Cessna, model F150H, single engine airplane, EI-AST, was destroyed when it impacted terrain near Birr Airfield (EIBR), Birr, Ireland. The two pilots were fatally injured. The airplane was…NTSB ANC13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Akiachak, AKThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and the pilot’s failure to maintain adequate airspeed during the subsequent forced landing, which resulted in an inadvertent stall.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB WPR13FA036Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Waterville, WAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he was unable to recover.NTSB CEN13LA054Accident · 1 fatalLimited investigationFinal reportCessna P210N · Conway, ARThe pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…NTSB WPR13LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Modesto, CAFailure of the throttle control cable during maneuvering flight, which resulted in a partial loss of engine power.NTSB CEN13FA051Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Anadarko, OKThe pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.NTSB CEN13FA049Accident · 1 fatalField investigationFinal reportCessna 208B · Wichita, KSThe total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.NTSB CEN13LA046Accident · 1 fatalLimited investigationFinal reportSorensen Sprint Mxii · Groesbeck, TXThe pilot’s failure to maintain control of the noncertificated airplane during a go-around. Contributing to the accident was the pilot’s physical and psychological impairment.NTSB CEN13FA044Accident · 2 fatalField investigationFinal reportCessna 310 · Stotts City, MOThe pilot's failure to maintain airplane control after he shut down the right engine in flight due a loss of oil pressure. Contributing to the accident was the pilot's decision to reposition the unairworthy airplane during twilight after extensive maintenance…NTSB ERA13GA046Accident · 2 fatalFinal reportHughes OH-6A · Atlanta, GAThe pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.NTSB CEN13LA055Accident · Serious injuriesLimited investigationFinal reportCentral Ohio Dragonfly Club DRAGONFLY-C · Darbyville, OHThe total loss of engine power due to a cold-seizure event that occurred at a low altitude, which precluded the pilot's recovery from an inadvertent aerodynamic stall/spin.NTSB CEN13FA045Accident · 1 fatalField investigationFinal reportCessna 150F · Gothenburg, NEThe student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.NTSB ANC13LA008Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kenai, AKThe loss of engine power due to carburetor icing and the pilot's failure to apply carburetor heat when he reduced engine power.NTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…NTSB CEN13CA042Accident · Minor injuriesData collectionFinal reportLuscombe 8E · West Bend, WIThe pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.NTSB CEN13CA040Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during landing.NTSB ERA13WA050Accident · Serious injuriesForeign investigationCessna 206 · Kiim, EcuadorOn October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…NTSB WPR13CA027Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hanapepe, HIThe pilot's selection of an unsuitable landing area. Contributing to the pilot’s decision to land in an unsuitable landing area was his lack of helicopter experience, which led him to misidentify the precursor event.NTSB CEN13LA034Accident · 2 fatalLimited investigationFinal reportUS Light Hornet · Mont Belvieu, TXThe pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.NTSB WPR13LA025Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Lake Havasu, AZThe pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.NTSB WPR13CA024Accident · No injuriesData collectionFinal reportCessna 170A · Calexico, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.NTSB CEN13CA033Accident · Serious injuriesData collectionFinal reportPorter James Grant Superior CUB · Beechgrove, INThe pilot’s failure to maintain clearance from trees during takeoff from a short field.NTSB WPR13LA023Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R-44 II · Toutle, WAThe pilot’s failure to maintain precise altitude control, which resulted in the helicopter entering a settling with power condition while hovering out of ground effect.NTSB ERA13FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Hooksett, NHThe pilot's total incapacitation in flight due to an acute heart attack.NTSB WPR13CA028Accident · No injuriesData collectionFinal reportSport Plane Dynamics Lightning · Casa Grande, AZThe pilot’s failure to follow specified procedures for an aborted landing and loss of control during the attempt.NTSB WPR13FA022Accident · 2 fatalField investigationFinal reportBehne Glasair III · Byron, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a stall and subsequent spin.NTSB CEN13LA029Accident · 1 fatalLimited investigationFinal reportQuad City Challenger · Castroville, TXThe pilot’s steep 180-degree turn to final approach for landing, which resulted in an inadvertent stall and spin at an altitude from which he could not recover.NTSB CEN13FA025Accident · Serious injuriesField investigationFinal reportAgusta AW139 · Houma, LAThe helicopter’s sudden and severe vertical vibrations during landing, which resulted in a collision with terrain. The reason for the helicopter’s sudden and severe vertical vibrations could not be determined during postaccident examinations.NTSB ANC13CA005Accident · No injuriesData collectionFinal reportCessna A185E · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a ground loop.NTSB ERA13LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Mansfield, MAThe pilots’ failure to apply carburetor heat during takeoff, which resulted in a partial loss of engine power due to the formation of carburetor ice.NTSB CEN13WA020Accident · 2 fatalForeign investigationMooney M20E · Speichersdorf, GermanyOn October 21, 2012, about 1520 coordinated universal time, a Mooney M20E, D-EMHE was destroyed following a loss of control during initial climb from Rosenthal Field Ploessen Airport (EDQP), near Speichersdorf, Germany. The pilot and passenger were fatally…NTSB ERA13LA037Accident · No injuriesLimited investigationFinal reportCessna 172D · Indian Trail, NCThe pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ERA13CA035Accident · Minor injuriesData collectionFinal reportAB Sportine Aviacija Genesis 2 · Roseland, VAThe pilot’s failure to maintain glider control during takeoff.NTSB ERA13CA033Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Newton, GAThe pilot’s failure to maintain clearance from power lines while maneuvering, which resulted in a hard forced landing.NTSB ANC13CA006Accident · No injuriesData collectionFinal reportPiper PA-18-125 · Cordova, AKThe pilot's failure to maintain clearance from terrain during takeoff.NTSB ERA13FA026Accident · 1 fatalField investigationFinal reportAerospatiale AS 355 · Erwinna, PAThe pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.NTSB CEN13CA019Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Portales, NMThe pilot’s failure to maintain clearance from power lines during an aerial application flight.NTSB ERA13LA024Accident · Serious injuriesLimited investigationFinal reportCashmer Philip M Sonex · Crossville, TNThe pilot’s failure to maintain control of the airplane, which resulted in a low-altitude aerodynamic stall/spin. Contributing to the accident was a loss of engine power for reasons that could not be determined during postaccident examination and the pilot’s…NTSB ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.NTSB WPR13LA011Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Parker, AZThe pilot's failure to perform an adequate preflight inspection, which resulted in inadequate fuel for the flight and the subsequent fuel exhaustion and a total loss of engine power. Contributing to the accident was the pilot's failure to land the airplane at…NTSB WPR13FA013Accident · 1 fatalField investigationFinal reportAeropro CZ A240 · Half Moon Bay, CAThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB CEN13FA012Accident · 1 fatalField investigationFinal reportCessna 172R · Simpson, LAThe pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.NTSB ANC13FA004Accident · 1 fatalField investigationFinal reportGrumman Aircraft ENG C-1A · Willow, AKThe pilot’s loss of control of the airplane for reasons that could not be determined because the wreckage was not recovered from the accident site.NTSB ERA13LA020Accident · 2 fatalLimited investigationFinal reportAirborne Windsports PTY XT-912 · Winter Haven, FLThe pilot’s failure to maintain aircraft control during takeoff in crosswind conditions, which resulted in collision with terrain.NTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.