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 ERA16FA023Accident · 1 fatalField investigationFinal reportMooney M20M · Worcester, MAA total loss of engine power during the initial climb due to a fatigue failure of the engine's crankshaft. Contributing to the accident was the pilot's failure to maintain control of the airplane, which resulted in an aerodynamic stall.NTSB ERA16CA024Accident · Minor injuriesData collectionFinal reportMaule M5 · Warrentown, VAThe pilot's failure to maintain clearance of a cattle-guard fence on landing. Contributing to the accident was his lack of recent flying experience.NTSB GAA16CA033Accident · No injuriesData collectionFinal reportCessna 150 · Millbrook, NYThe pilot's loss of heading control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.NTSB GAA16CA030Accident · No injuriesData collectionFinal reportMcpherson John G Pietenpol Aircamper · Placerville, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and an impact with terrain.NTSB ERA16LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bluemont, VAA total loss of engine power as a result of the separation of the No. 5 connecting rod for reasons that could not be determined based on the available information.NTSB GAA16CA026Accident · No injuriesData collectionFinal reportRans S-7 · Gerlach, NVThe pilot's failure to maintain pitch and airspeed control, in conjunction with full flaps, while maneuvering at a low altitude, resulting in a tail-stall and subsequent impact with the ground.NTSB GAA16CA055Accident · No injuriesData collectionFinal reportBell 47G · Searchlight, NVThe pilot's failure to maintain adequate clearance from a tree during hover flight.NTSB ERA16LA019Accident · No injuriesLimited investigationFinal reportBeech 23 · Humboldt, TNA partial loss of engine power due to low No. 2 cylinder compression and an inoperative right magneto.NTSB WPR16FA014Accident · 2 fatalField investigationFinal reportPiper PA 28R-180 · Morongo Valley, CAThe non-instrument rated pilot's improper inflight decision-making to attempt to outclimb clouds along his planned route rather than reverse course, which resulted in his inadvertent entry into instrument meteorological conditions, spatial disorientation, and…NTSB GAA16CA021Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Old Harbor, AKThe pilot's selection of unsuitable terrain for landing, resulting in a collision with terrain.NTSB ERA16LA016Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado · Mitchells, VAA total loss of engine power due to fatigue cracking and separation of the No. 3 cylinder exhaust valve stem.NTSB ERA16LA015Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Dickinson, ALThe improper installation by company maintenance personnel of the securing hardware of a tail rotor driveshaft section, which resulted in that section of tail rotor driveshaft disconnecting and a complete loss of tail rotor thrust.NTSB CEN16LA017Accident · Minor injuriesLimited investigationFinal reportComp Air CA8 · Ray, MIThe pilot's improper use of the trim, which created a cross-controlled situation and resulted in an aerodynamic stall during the attempted go-around.NTSB WPR16LA011Accident · No injuriesLimited investigationFinal reportChristopher Tom Kitfox 5 · Battle Ground, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR16FA012Accident · 1 fatalField investigationFinal reportBucker Jungmeister BU 133 · Missoula, MTThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while executing a return to the runway after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot’s…NTSB GAA16CA017Accident · No injuriesData collectionFinal reportCessna 195A · Aztec, NMThe pilot's failure to maintain directional control during landing, which resulted in runway excursion and collision with terrain.NTSB CEN16FA013Accident · 2 fatalField investigationFinal reportCessna 421B · Hammond, LAThe loss of right engine power on takeoff due to maintenance personnel's failure to properly tighten the crankcase through-studs during cylinder replacement, which resulted in crankshaft fracture. Also causal were the pilot's failure to feather the propeller…NTSB WPR16LA008Accident · No injuriesLimited investigationFinal reportCessna T210K · Boise, IDThe pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which…NTSB ERA16FA012Accident · 2 fatalField investigationFinal reportPiper PA 28-180 · Lake Worth, FLA loss of control for reasons that could not be determined based on the available information.NTSB ERA16CA011Accident · No injuriesData collectionFinal reportPiper PA-32RT-300T · Salisbury, NCThe pilot's inadvertent switching of the fuel selector to the "off" position on final approach, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN16FA011Accident · 2 fatalField investigationFinal reportBeech G35 · Eaton, COThe pilot's loss of airplane control in gusting wind conditions and low-level wind shear, following a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to properly monitor the fuel level inflight because of his…NTSB GAA16CA034Accident · No injuriesData collectionFinal reportCessna 182R · Abilene, TXThe pilot's diverted attention while taxiing, which resulted in a collision with a fence post.NTSB GAA16CA018Accident · No injuriesData collectionFinal reportFurgason James E Vans RV 4 · San Marcos, TXThe pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.NTSB ERA16LA010Accident · 1 fatalLimited investigationFinal reportMurray Blair L Free Bird Classic · Kylertown, PAThe pilot's failure to maintain sufficient airspeed during approach for landing, which resulted in an inadvertent aerodynamic stall/spin. Contributing to the accident was the pilot’s lack of flight experience in the accident airplane make and model.NTSB CEN16LA018Accident · No injuriesLimited investigationFinal reportDiamond DA20-C1 · Waskom, TXThe pilot's decision to operate the airplane without the owner’s permission and his lack of preflight planning, which resulted a total loss of engine power due fuel exhaustion.NTSB CEN16LA008Accident · No injuriesLimited investigationFinal reportBeechcraft A36 · Dallas, TXThe pilot’s improper navigation onto a vehicle service road while taxiing and his subsequent distraction while looking at an airport diagram, which led to the airplane impacting a fence post.NTSB WPR16FA007Accident · 2 fatalField investigationFinal reportBeech G35 · South Lake Tahoe, CAThe pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without…NTSB GAA16CA019Accident · No injuriesData collectionFinal reportMaule M 7-235C · Mankato, MNThe pilot's failure to maintain directional control during the go-around, which resulted in a collision with terrain.NTSB GAA16CA012Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Kanab, UTThe pilot's failure to monitor the airplane's movement on the ground while programming the GPS, which resulted in a collision with a pole.NTSB WPR16LA015Accident · No injuriesLimited investigationFinal reportCessna 310J · Tucson, AZThe insufficient right main landing gear (MLG) down-lock tension due to maintenance personnel's failure to perform a rigging procedure during the airplane's most recent inspection, which resulted in the right MLG collapsing during landing.NTSB ERA16LA008Accident · 1 fatalLimited investigationFinal reportCessna 172S · Seville, FLThe airplane’s encounter with a downdraft, and the pilot's decision to maneuver the airplane at a low altitude and airspeed, which provided insufficient time and altitude to recover before impacting terrain.NTSB ERA16LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Savannah, GAThe pilot's inadequate preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and a total loss of engine power during approach. Contributing to the accident were the pilot’s failure to maintain adequate airspeed and his…NTSB ERA16FA006Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Erwin, TNThe pilot's decision to fly into a known area of adverse weather, which resulted in the airplane entering a severe thunderstorm and a subsequent loss of control.NTSB CEN16LA019Accident · Serious injuriesLimited investigationFinal reportQuest Kodiak 100 · Sheridan, WYThe loss of airplane control during takeoff for reasons that could not be determined based on the available information.NTSB ERA16FA005Accident · 1 fatalField investigationFinal reportPiper PA 38-112 · Jasper, GAThe student pilot's failure to accurately determine the airplane's fuel state, subsequent fuel exhaustion, and a total loss of engine power during initial climb. Contributing to the accident was the flight instructor's inadequate oversight of the student…NTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.NTSB WPR16LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Compton, CAA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA004Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8F · Georgetown, CAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB GAA16CA005Accident · No injuriesData collectionFinal reportRaytheon A36 · Monterey, CAThe pilot's failure to see and avoid runway signage during taxi after landing, resulting in a collision and substantial damage to the left wing of the airplane.NTSB ERA16LA004Accident · No injuriesLimited investigationFinal reportBeech 58 · Albany, GAThe mechanic's inadequate inspection of the brake system during the most recent annual inspection, which resulted in the failure of both left and right main landing gear torque plates and a subsequent loss of braking action.NTSB CEN16LA012Accident · No injuriesLimited investigationFinal reportRefling RV8 · Bottineau, NDThe pilot/builder’s failure to ensure that the fuel line was properly secured, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB WPR16FA002Accident · 2 fatalField investigationFinal reportCessna 152 · Cedar City, UTThe failure of the pilots to maintain control of the airplane while maneuvering, which resulted in an aerodynamic stall from which they did not recover.NTSB GAA16CA006Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Devine, TXThe pilot's failure to maintain obstacle clearance during the takeoff, which resulted in the helicopter striking power lines.NTSB CEN16LA004Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dexter, MOThe pilot's impairment due to the ingestion of alcohol, which impaired his decision-making and resulted in his taking off and flying the airplane until the engine lost power due to fuel exhaustion.NTSB CEN16LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G · Huntsville, TXThe pilot's loss of helicopter control during an agricultural application pass for reasons that could not be determined due to the extent of damage to the flight control system.NTSB GAA16CA003Accident · Minor injuriesData collectionFinal reportBushmaster Super Bushmaster · Marble Canyon, AZThe pilot's failure to maintain descent rate durring the landing resulting in collision with terrain.NTSB WPR16LA003Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Fall City, WAThe airplane’s collision with the ground short of the runway for reasons that could not be determined based on the available evidence.NTSB GAA16LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Redding, CAThe pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing.NTSB WPR16FA001Accident · 1 fatalField investigationFinal reportJohnson Coot · Deer Park, WAThe pilot's failure to maintain sufficient airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Contributing to the accident was the pilot's diverted attention due to the rough…NTSB ERA16FA001Accident · 4 fatalField investigationFinal reportPiper PA32R · Westminster, SCThe pilot's loss of airplane control for reasons that could not be determined based on the available information.