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 ERA10LA484Accident · No injuriesLimited investigationFinal reportBell OH-58A · Covington, TNA loss of engine power due to contamination of the helicopter's fuel supply.NTSB CEN10LA571Accident · Serious injuriesLimited investigationFinal reportCa Tecnam P2004 Bravo · Mason, MIA total loss of engine power for undetermined reasons, which resulted in a forced landing to a bean field.NTSB CEN10CA582Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Atkins, ARA partial loss of engine power during low-altitude flight for undetermined reasons.NTSB CEN10CA541Accident · Minor injuriesData collectionFinal reportAerolite Bearcat · Mineola, TXFailure of the oil injection pump resulting in a total loss of engine power.NTSB CEN10CA539Accident · No injuriesData collectionFinal reportCessna A185F · Rushville, NEThe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the loss of visual reference due to the sun glare.NTSB WPR10LA456Accident · Serious injuriesLimited investigationFinal reportSavage Savage-Cozy · Aurora, ORThe pilot’s failure to maintain control of the airplane following a loss of engine power in the traffic pattern; the cause of the loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not…NTSB CEN10CA543Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Ft. Wayne, INThe pilot's selection of unsuitable terrain for the landing.NTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.NTSB ANC10LA087Accident · Serious injuriesLimited investigationFinal reportCessna 185A · Paxson, AKThe pilot's decision to make a climbing turn close to the ground in gusting wind at a low airspeed, resulting in a loss of control and collision with terrain.NTSB WPR10LA464Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Majuro (Pacific Ocean)A loss of helicopter control for undetermined reasons.NTSB WPR10LA454Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Sierra Vista, AZA loss of engine power due to metal debris contamination of the inverted oil system shuttle valve, which resulted in a disruption of oil flow and subsequent oil starvation.NTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.NTSB ANC10LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South Naknek, AKThe loss of engine power during cruise flight for an undetermined reason, resulting in an emergency landing and collision with terrain.NTSB ANC10CA086Accident · No injuriesData collectionFinal reportRoberts Alan W Kitfox II · Fairbanks, AKThe pilot's failure to maintain proper aircraft control during landing and the subsequent go-around, resulting in a hard landing, and a collision with a signpost.NTSB ERA10LA475Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fayetteville, WVA loss of engine power due to the failure of the left magneto system’s distributor gear as a result of the improper maintenance of the magnetos by maintenance personnel.NTSB ERA10LA474Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Doerun, GAA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site and his excess speed during the landing.NTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB CEN10LA531Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Buchanan, MIA failure of the engine's No. 3 and No. 4 cylinder valve lifters for undetermined reasons, which resulted in a total loss of engine power.NTSB CEN10LA526Accident · 1 fatalLimited investigationFinal reportThompson Kolb Twinstar Mark · Elkhart, INThe pilot's failure to maintain control of the airplane during the landing approach.NTSB CEN10CA527Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-34R · Hampshire, ILThe pilot’s failure to attain the proper touchdown point, resulting in a runway overrun.NTSB CEN10FA520Accident · 2 fatalField investigationFinal reportCessna T210 · Mountain Home, ARThe pilot’s decision to continue flight into a known area of heavy rain and his subsequent failure to maintain aircraft control.NTSB WPR10FA449Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Las Vegas, NVThe pilot's inability to maintain a positive rate of climb after takeoff for undetermined reasons.NTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10LA446Accident · Serious injuriesLimited investigationFinal reportBell 47G · Salinas, CAThe pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control.NTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.NTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.NTSB CEN10CA565Accident · No injuriesData collectionFinal reportNorth American AT-6 · Blakesburg, IAThe pilot's excessive airspeed during the landing, which resulted in his decision to perform an intentional ground loop to avoid a runway overrun.NTSB WPR10FA448Accident · 3 fatalField investigationFinal reportBeech 65 · Redwood City, CAA loss of power in the right engine for undetermined reasons and the pilot’s subsequent failure to maintain adequate airspeed, which resulted in a loss of control. Contributing to the loss of control was the regulatory certification basis of the airplane that…NTSB WPR10CA444Accident · Minor injuriesData collectionFinal reportSchweizer 164B · Murtaugh, IDThe pilot’s inadequate compensation for the wind and failure to maintain directional control during the takeoff roll.NTSB ERA10LA463Accident · Minor injuriesLimited investigationFinal reportQuicksilver MX-2 · Lake City, FLA partial loss of engine power for undetermined reasons.NTSB ERA10CA461Accident · No injuriesData collectionFinal reportYeager Lancair · McMinnville, TNThe pilot’s failure to properly latch the cockpit canopy prior to takeoff, resulting in his diverted attention and failure to maintain aircraft control.NTSB ANC10CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Akhiok, AKThe pilot's failure to maintain directional control while maneuvering at a low altitude.NTSB ERA10CA467Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Churchville, MDThe pilot’s failure to ensure that the fuel valve was in the "ON" position during his preflight inspection, resulting in the loss of engine power during takeoff.NTSB ERA10CA462Accident · Serious injuriesData collectionFinal reportHead Balloons AX9 118 · Hanover, NHThe balloon's encounter with an updraft, resulting in an immediate landing and an intentional collision with a tree.NTSB WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…NTSB ERA10LA458Accident · No injuriesLimited investigationFinal reportBird CK · Eagles Mere, PAThe loss of engine power due to fuel starvation as a result of degradation of the fuel tank coating which blocked the fuel supply.NTSB ERA10LA457Accident · No injuriesLimited investigationFinal reportAero Commander 560E · Jacksonville, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of power in both engines during climb due to fuel contamination.NTSB WPR10FA438Accident · 1 fatalField investigationFinal reportCessna 182C · Belgrade, MTThe non-instrument rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of airplane control.NTSB ERA10WA456Accident · 1 fatalForeign investigationCessna A188 · Pista El Limon, EcuadorOn August 29, 2010, about 1300 universal coordinated time (UTC), a Cessna A188B, Ecuadorian registration HC-BCF, operated by a private owner on an agricultural spraying flight, collided with power lines and subsequently the ground near Pista El Limon,…NTSB ERA10LA454Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Acworth, GAThe pilots improper in-flight fuel management resulting in a total loss of engine power during a descent due to fuel starvation.NTSB ERA10LA453Accident · No injuriesLimited investigationFinal reportCessna 120 · Rockland, METhe loss of engine power for undetermined reasons.NTSB WPR10LA432Accident · Minor injuriesLimited investigationFinal reportStinson JR. S · Lake Stevens, WAA total loss of engine power during cruise flight, which resulted from a magneto switch failure.NTSB WPR10FA435Accident · 1 fatalField investigationFinal reportRemos Remos G-3/600 · Tucson, AZThe pilot's failure to maintain airplane control while maneuvering at a low altitude.NTSB WPR10CA434Accident · Minor injuriesData collectionFinal reportPiper PA-15 · Duvall, WAAn in-flight collision with a bird while maneuvering.NTSB ERA10LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT402 · Pompano Beach, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun and a subsequent collision with obstacles and terrain. Contributing to the accident was the airplane's high gross weight.NTSB ERA10CA451Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Montauk, NYThe pilot's delay in aborting the landing, which resulted in a collision with a fence.NTSB CEN10CA513Accident · No injuriesData collectionFinal reportCessna 172P · Bartlesville, OKThe student pilot's loss of directional control during takeoff due to an improper flap setting.NTSB ERA10LA449Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7HC · Louisville, KYA loss of engine power due to fuel system contamination resulting in damage to the carburetor float.