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 CEN14LA148Accident · 1 fatalLimited investigationFinal reportVans RV-9A · Tribune, KSThe pilot’s failure to maintain airplane control while conducting high-g turns, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to initiate the flight with a severe progressive neurological disorder that…NTSB WPR14LA117Accident · Serious injuriesLimited investigationFinal reportBeech A45 · Hollister, CAThe total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.NTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…NTSB ERA14LA137Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Macon, GAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow…NTSB CEN14LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Church Point, LAThe pilot’s improper preflight inspection and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14FA145Accident · 1 fatalField investigationFinal reportBeech B100 · Pearland, TXThe noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.NTSB WPR14CA115Accident · No injuriesData collectionFinal reportBell 47G 5A · Greenfield, CAThe pilot's failure to maintain clearance from a power pole during low-altitude maneuvering flight.NTSB ERA14CA126Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2B · Burnsville, NCThe pilot's improper use of the spoilers, which resulted in an uncontrolled descent and subsequent impact with trees.NTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.NTSB ERA14FA123Accident · 1 fatalField investigationFinal reportWilliams Christopher T Sonex · Wellington, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the…NTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.NTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.NTSB CEN14FA140Accident · 1 fatalField investigationFinal reportHillam Scott L Rans S 10 · Shepherd, TXThe noncertificated pilot’s improper decision to attempt aerobatic maneuvers that exceeded the airplane’s design limitations, which resulted in the subsequent in-flight breakup of the airplane. Contributing to the accident was the pilot’s lack of aerobatic…NTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.NTSB ERA14WA131Accident · 2 fatalForeign investigationRobinson R44 · Braganca, BrazilOn February 15, 2014, about 2200 coordinated universal time (UTC), a Robinson, R 44 helicopter, Brazilian registration PT-YMF, was destroyed when it impacted the ground in a dense forest in the Bragança Municipality, in the State of Pará, Brazil. The…NTSB ERA14FA120Accident · 2 fatalField investigationFinal reportCessna 210L · Clay, ALThe pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…NTSB ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.NTSB CEN14CA142Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Bonham, TXThe pilot's inadequate recovery from a loss of tail rotor effectiveness during a low altitude downwind hover in a gusty wind condition resulting in the helicopter contacting the ground and rolling over.NTSB ERA14CA119Accident · No injuriesData collectionFinal reportPiper PA 38-112 · West Milford, NJThe failure of the pilot-in-command to maintain directional control during landing.NTSB CEN14LA138Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Marion, IAThe pilot’s failure to attain a touchdown on the runway’s hard surface, which resulted in a loss of directional control.NTSB CEN14LA136Accident · Serious injuriesLimited investigationFinal reportMahon Paul D Capella XS · Houston, TXThe loss of engine power due to carburetor icing.NTSB CEN14LA133Accident · No injuriesLimited investigationFinal reportCessna 182A · Lexington, TXThe pilot’s improper use of the carburetor heat, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA14LA117Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLThe noninstrument-rated pilot’s continued flight into dark night, instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation and subsequent impact with water.NTSB CEN14CA132Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Hartford, WIThe pilot's inadequate preflight planning and failure to inspect the runway before departure.NTSB WPR14FA111Accident · Serious injuriesField investigationFinal reportPiper PA 28-181 · Phoenix, AZThe student pilot’s inadvertent positioning of the fuel selector in an intermediate position, which resulted in a loss of engine power due to fuel starvation.NTSB ERA14FA112Accident · 4 fatalField investigationFinal reportGulfstream AM Corp Comm Div 690 · Bellevue, TNThe pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…NTSB WPR14CA110Accident · Minor injuriesData collectionFinal reportBeech V35A · Globe, AZThe pilot's inadequate glide path and failure to maintain adequate airspeed during final approach, which resulted in an aerodynamic stall.NTSB CEN14GA135Accident · 1 fatalFinal reportCessna 210E · Oden, ARThe pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.NTSB ERA14WA114Accident · 2 fatalForeign investigationCessna 140 · Cachoeira do Sul, BrazilOn January 29, 2014, about 1340 universal coordinated time, a Cessna 140, Brazilian registration PP-DFW, was substantially damaged during impact with terrain, following a loss of control on approach to Cachoeira do Sul Airport (SSKS), Cachoeira do Sul, Rio…NTSB CEN14TA126Accident · Minor injuriesFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe flight instructor's loss of control after takeoff following a wake turbulence encounter from a preceding helicopter. Contributing to the accident were the flight instructor's misidentification of the helicopter type and a lack of Federal Aviation…NTSB WPR14LA112Accident · No injuriesLimited investigationFinal reportWeinzierl Searey · Stanwood, WAThe noncertificated pilot’s failure to maintain clearance from water while maneuvering at a low altitude over glassy water conditions, which adversely affected his depth perception.NTSB CEN14FA122Accident · 3 fatalField investigationFinal reportBell 206L 3 · Silt, COThe pilot’s inadequate preflight planning for a low-level aerial surveillance flight of power transmission lines, which led to his being unaware of the crossing power line while flying toward the sun and his subsequent failure to maintain sufficient clearance…NTSB WPR14CA109Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Willcox, AZThe pilot's decision to land off airport on unsuitable terrain that resulted in a collision with hidden objects.NTSB WPR14CA107Accident · No injuriesData collectionFinal reportCessna 170 · Wikieup, AZThe pilot's failure to maintain clearance from terrain during takeoff.NTSB ERA14LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Millen, GAThe pilot's failure to fully seat the fuel selector in the left tank position before takeoff, which resulted in fuel starvation and a subsequent loss of engine power.NTSB ERA14CA104Accident · No injuriesData collectionFinal reportMooney M20C · Rutherfordton, NCThe pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA134Accident · No injuriesLimited investigationFinal reportCessna 172K · Milan, ILThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during a short final approach.NTSB CEN14LA131Accident · No injuriesLimited investigationFinal reportCessna R182 · Eustis, NEA catastrophic engine failure, which was initiated by the failure of the No. 5 connecting rod cap.NTSB WPR14LA104Accident · No injuriesLimited investigationFinal reportSimpson Amphibeous Trike/No · Chehalis, WAThe failure of the left wing prong.NTSB CEN14CA123Accident · Minor injuriesData collectionFinal reportCessna 172N · Boulder, COThe pilot's failure to maintain airplane control during final approach with known turbulence present.NTSB CEN14CA119Accident · No injuriesData collectionFinal reportPiper PA46 500TP · Tulsa, OKThe loss of directional control while landing due to the failure of the inner tube in the left tire.NTSB CEN14LA118Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5B · Willow Park, TXThe improper reinstallation of the propeller assembly, which resulted in the subsequent in-flight separation of the propeller.NTSB WPR14LA100Accident · 1 fatalLimited investigationFinal reportErcoupe 415 C · Poulsbo, WAThe pilot's failure to confirm that the engine oil filler cap was secured before flight, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.NTSB CEN14WA117Accident · 7 fatalForeign investigationBritten Norman BN-2A-27 · Horea, RomaniaOn January 20, 2014, about 1400 coordinated universal time, a Britten-Norman BN-2A-27 airplane, YR-BNP, impacted mountainous terrain near Horea, Cluj, Romania. The two pilots, and five passengers were all fatally injured. The airplane was destroyed. The…NTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.NTSB WPR14LA099Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · San Jose, CAThe pilot’s failure to sump the fuel tanks, which resulted in water contamination, a partial loss of engine power during takeoff, and collision with a taxiing airplane during the subsequent forced landing.NTSB WPR14LA096Accident · 2 fatalLimited investigationFinal reportMorrisey 2150 · Pismo Beach, CAThe in-flight separation of a wing for reasons that could not be determined because the wreckage was not recovered from the ocean.NTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.NTSB CEN14FA102Accident · 2 fatalField investigationFinal reportMooney M20R · Boyne City, MIThe pilot’s failure to maintain control of the airplane as he attempted to return to the airport after encountering dark night conditions and heavy snow showers.NTSB CEN14LA103Accident · No injuriesLimited investigationFinal reportBell 430 · West Delta 109The pilot’s failure to maintain tail rotor clearance from a handrail on a crane davit on an oil platform during landing.