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 LAX08LA181Accident · 1 fatalLimited investigationFinal reportAirborne Edge · Dunn, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB CHI08CA165Accident · No injuriesData collectionFinal reportFetherolf CH-701 · Newton Falls, OHThe loss of engine power during the landing approach due to fuel starvation resulting from an obstructed fuel tank vent. Factors contributing to the accident were the lack of suitable terrain for a forced landing, and the airplane's low altitude at the time…NTSB LAX08LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wilder, IDThe loss of engine power as a result of failure of the supercharger. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX08LA179Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Beaver, UTThe pilot's failure to attain and maintain an adequate airspeed during the initial climb as a result of his inadequate preflight planning and improper use of the mixture control. Contributing to the accident were the tailwind and high density altitude.NTSB DEN08LA103Accident · No injuriesLimited investigationFinal reportCessna A188B · Lyons, KSthe loss of engine power for undetermined reasons. A contributing factor was the dirt embankment.NTSB MIA08CA117Accident · No injuriesData collectionFinal reportPiper J3C-65 · Fayetteville, GAThe pilot's failure to maintain control of the airplane during climbout. Contributing to the accident was the pilot's relinquish of control to a non-certificated pilot.NTSB LAX08CA180Accident · No injuriesData collectionFinal reportCessna 207 · Page, AZThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the crosswind weather conditions and the high density altitude conditions.NTSB LAX08CA176Accident · No injuriesData collectionFinal reportClarke Colin Glastar · Wenatchee, WAThe pilot's failure to initiate a timely go-around after the first bounce.NTSB DFW08CA163Accident · No injuriesData collectionFinal reportCessna CE-152 · Foss, OKA total loss of engine power for undetermined reasons.NTSB DEN08LA102Accident · No injuriesLimited investigationFinal reportCessna 150G · Brenham, TXThe sudden windshift (crosswind gust), rendering directional control impossible. Contributing factors in this accident were the high speed during the aborted takeoff and trees.NTSB NYC08FA211Accident · Serious injuriesField investigationFinal reportAvid Mark IV Aerobat · Niceville, FLThe pilot's loss of control during landing for undetermined reasons.NTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.NTSB CHI08CA159Accident · No injuriesData collectionFinal reportCessna 172P · Athens, OHThe student pilot's failure to maintain directional control during landing. A factor contributing to the accident was a nose wheel vibration.NTSB NYC08CA210Accident · No injuriesData collectionFinal reportBell 206L-4 · Philadelphia, PAThe pilot's failure to maintain aircraft control during hover, which resulted in an inadvertent impact with the ground.NTSB LAX08CA172Accident · No injuriesData collectionFinal reportCessna T337G · GreatBarrington, MAThe pilot's misjudgment of distance and altitude, and failure to attain the proper touchdown point. The pilot's delayed remedial action was also causal.NTSB CHI08FA156Accident · 6 fatalField investigationFinal reportCessna U206C · Fremont, OHThe pilot’s failure to maintain airplane control for an undetermined reason, which resulted in an inadvertent stall. Contributing to the accident was the pilot's poor judgment in continuing to fly with his severe visual deficiency. Also contributing to the…NTSB LAX08CA166Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Kykotsmovi, AZFuel exhaustion due to the pilot's inadequate preflight planning and failure to ensure that adequate fuel was onboard to complete the flight.NTSB DFW08LA161Accident · 1 fatalLimited investigationFinal reportCessna 150M · Forrest City, ARThe failure of the pilot to maintain adequate airspeed while maneuvering in the traffic pattern, resulting in an inadvertent aerodynamic stall.NTSB CHI08CA186Accident · No injuriesData collectionFinal reportNaval Aircraft Factory N3N-3 · Luckey, OHThe pilot not maintaining clearance from the high vegetation during the off airport landing. Contributing to the accident was the high vegetation.NTSB CHI08CA170Accident · No injuriesData collectionFinal reportKindig Sonex · Metropolis, ILThe loss of engine power for undermined reasons and the low altitude at the time of engine power loss while turning. An additional cause was the proper touchdown point not attained by the pilot, A contributing factor was the runway lights.NTSB ANC08FA072Accident · 1 fatalField investigationFinal reportPiper PA-18 · Quinhagak, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude in high winds, resulting in an aerodynamic stall and uncontrolled descent to the ground. Contributing to the accident were the high winds.NTSB LAX08CA164Accident · Minor injuriesData collectionFinal reportCessna 172 · Santa Rosa, CAThe pilot's improper in-flight decision making and inadequate fuel consumption calculations that resulted in fuel exhaustion.NTSB CHI08LA158Accident · 1 fatalLimited investigationFinal reportMaggs Lancair 4P · Alhambra, ILThe pilot's decision to continue the flight into an area of known thunderstorm activity and the in-flight structural failure of the airplane.NTSB DEN08FA100Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Gothenburg, NEThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…NTSB NYC08LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Palatka, FLA partial loss of engine power due to a blockage of the engine exhaust system as a result of an internal failure of the muffler.NTSB NYC08CA205Accident · No injuriesData collectionFinal reportLuscombe 8A · Indiantown, FLAn inadequate annual inspection that failed to detect a damaged rudder cable which resulted in the cable's subsequent failure during takeoff.NTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.NTSB LAX08CA138Accident · Serious injuriesData collectionFinal reportSchweizer 300C · Ogden, UTThe pilot under instruction's encounter with a settling with power condition, and the flight instructor's failure to maintain adequate rotor rpm during the subsequent go-around. Also causal was the instructor pilot's delayed remedial action during the…NTSB DEN08LA098Accident · 2 fatalLimited investigationFinal reportHarms Robert M KIT FOX SE · La Porte, TXThe pilot's failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and uncontrolled descent.NTSB CHI08CA147Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dixon, ILThe student pilot improperly raised the flaps during the go-around, did not maintain airspeed, and stalled the airplane. The trees were a factor.NTSB SEA08LA149Accident · 1 fatalLimited investigationFinal reportVan Heeswyk Lightning · Marana, AZThe insufficient clamping force resulting in a fatigue fracture of the propeller extension attachment bolts and subsequent separation of the propeller assembly in flight. Contributing to the accident was the pilot's failure to maintain sufficient airspeed to…NTSB NYC08CA200Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Wildwood, NJThe pilot's failure to maintain clearance from trees during approach. Contributing to the accident were the dark night conditions.NTSB DFW08CA159Accident · No injuriesData collectionFinal reportBeech E-18 · Guymon, OKThe pilot's failure to maintain directional control during landing roll out. Contributing to the accident was the crosswind.NTSB DFW08CA158Accident · No injuriesData collectionFinal reportAeros Venture · Baldwin City, KSthe pilot's failure to maintain proper runway alignment and the instructor's delayed remedial action to abort the landing, which resulted in a collision with a mailbox and hangar. A factor was the crosswind.NTSB SEA08CA148Accident · No injuriesData collectionFinal reportAviat A-1B · Ogden, UTThe pilot's failure to maintain directional control during landing. A contributing factor was the variable wind condition.NTSB NYC08LA201Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCA loss of engine power due to thermally-induced failure of a piston. Contributing to the accident was the sustained engine exposure to abnormally high operating temperatures and detonation, and the exceedance of the engine manufacturer's recommended overhaul…NTSB NYC08FA198Accident · Minor injuriesField investigationFinal reportEurocopter Deutschland EC 135 P2+ · Pottsville, PAThe pilot’s failure to ensure that both engine switches were in the FLIGHT position for takeoff.NTSB SEA08LA145Accident · 2 fatalLimited investigationFinal reportPoulin L/Cullen D Lancair Legacy · Murrieta, CAThe pilot's inadequate preflight planning, which resulted in the loss of engine power due to fuel exhaustion, and the pilot's failure to maintain flying speed, which resulted in an inadvertent stall/spin and the subsequent collision with terrain.NTSB SEA08FA146Accident · 2 fatalField investigationFinal reportCessna 172R · Monticello, UTThe in-flight collision with mountainous terrain for undetermined reasons. *This report was modified on December 10, 2009.NTSB CHI08FA146Accident · 2 fatalField investigationFinal reportPiper PA28 · Hillsboro, OHThe pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…NTSB CHI08CA145Accident · No injuriesData collectionFinal reportCessna 150 · New Berlin, WIThe loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.NTSB SEA08CA144Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Reno, NVThe student pilot's failure to maintain translational lift airspeed while approaching the pinnacle and the certificated flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB CHI08CA142Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's failure to maintained directional control during the aborted landing. Contributing to the accident was the student pilot's total lack of experience in the type of airplane.NTSB SEA08LA142Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed while on approach to landing that resulted in a stall/mush. Contributing to the accident was the wind shear and the high density altitude condition.NTSB ANC08CA070Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was a gust of wind.NTSB CHI08CA149Accident · Serious injuriesData collectionFinal reportMischanko Buckeye Breeze · Walkerton, INThe directional control of the parachute not obtained/maintained by the pilot during the takeoff roll. A contributing factor was separation of the nose landing gear.NTSB SEA08LA140Accident · Minor injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA loss of engine power due to the pilot's modification of the induction system, and the pilot's failure to maintain an adequate airspeed while maneuvering to a landing area following the power loss.NTSB LAX08CA155Accident · No injuriesData collectionFinal reportCessna 172N · Sells, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain proper runway alignment.NTSB DEN08FA092Accident · 1 fatalField investigationFinal reportMcDonnell Douglas Helicopter C MD 500E · Sunrise Beach, MOThe loss of tail rotor effectiveness and the pilot's failure to regain aircraft control. Contributing to the accident was the pilot's decision to fly in known adverse weather conditions and the gusty winds generated from convective outflow. Contributing to…NTSB SEA08LA139Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Chehalis, WAA loss of engine power due to fuel exhaustion caused by a missing fuel tank cap that allowed the fuel to be siphoned out. Also causal was the pilot's inadequate preflight inspection at the last airport.