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 CEN17LA118Accident · No injuriesLimited investigationFinal reportThunder & Colt Airborne Amer AX10 180 · Albuquerque, NMThe pilot’s delayed reaction to the balloon’s increased rate of descent during an attempted landing, which resulted in impact with a power line.NTSB GAA17CA165Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Spofford, TXThe pilot's decision to hover-taxi out of the hangar and his subsequent failure to maintain clearance from the hangar.NTSB GAA17CA154Accident · No injuriesData collectionFinal reportCessna 180 · Bally, PAThe pilot’s failure to maintain directional control during takeoff in crosswind conditions.NTSB GAA17CA147Accident · No injuriesData collectionFinal reportCessna A185 · Fairbanks, AKThe pilot's failure to maintain an appropriate glidepath to the runway and to use the vertical guidance system.NTSB ERA17LA110Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Bayonne, NJMaintenance personnel’s incorrect installation of the No. 3 cylinder’s hydraulic valve tappet plunger, which resulted in a failure of the No. 3 cylinder’s intake valve and the subsequent partial loss of engine power.NTSB CEN17FA108Accident · 1 fatalField investigationFinal reportMacleod Homebuilt · Springfield, OHThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.NTSB WPR17LA068Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Holbrook, AZThe pilot’s failure to compensate for a loss of effective translational lift while turning from an upwind to a downwind condition at a low altitude and low airspeed, which resulted in a loss of helicopter control.NTSB GAA17CA144Accident · No injuriesData collectionFinal reportPitts Special S 1C · Borger, TXThe pilot’s failure to maintain directional control of the biplane during takeoff.NTSB CEN17LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Centennial, COThe loss of airplane control during takeoff for reasons that could not be determined based on the available information, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR17LA070Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Pomona, CAThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA17CA187Accident · No injuriesData collectionFinal reportPiper PA22 · Ruby, AKThe pilot’s failure to maintain directional control while landing in flat light conditions on a hard-packed snow-covered landing area.NTSB GAA17CA140Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, NCThe pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.NTSB ERA17FA107Accident · 1 fatalField investigationFinal reportBeech A45 · Climax, GAThe failure of maintenance personnel to ensure that the throttle and fuel metering unit AN "B" nut was secured, which resulted in a total loss of engine power in flight and a subsequent collision with trees while attempting to land after sunset.NTSB ERA17FA106Accident · 2 fatalField investigationFinal reportBeech C23 · Winder, GAThe flight instructor's inadequate preflight planning and operation of the airplane outside its center of gravity envelope, which resulted in a loss of control while maneuvering.NTSB GAA17CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Holtville, CAThe pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.NTSB GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.NTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.NTSB GAA17CA136Accident · Minor injuriesData collectionFinal reportNielsen Martin M Challenger II · Punta Gorda, FLThe pilot’s failure to maintain directional control during landing.NTSB CEN17LA113Accident · Serious injuriesLimited investigationFinal reportBell-Transworld Helicopters 47D1 · Archer City, TXThe total loss of engine power due to fuel starvation, which resulted from the pilot’s inadvertent positioning of the mixture control to the “fuel cutoff” position.NTSB ANC17LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA18 · Sterling, AKThe pilot’s loss of control while maneuvering for reasons that could not be determined based on the available information.NTSB ERA17LA102Accident · Serious injuriesClass 3 · LimitedFinal reportShell John Super SIX · Morganton, NCA loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.NTSB ERA17LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Friendly, MDA total loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17CA101Accident · No injuriesData collectionFinal reportRobinson R22 · West Palm Beach, FLThe flight instructor’s failure to maintain helicopter control while demonstrating low rotor rpm operations from a hover.NTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB ERA17CA099Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Fallston, MDThe student pilot's failure to relinquish the flight controls to the flight instructor, which resulted in a collision with terrain.NTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.NTSB CEN17LA101Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Ellendale, MNThe pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.NTSB WPR17LA059Accident · Minor injuriesLimited investigationFinal reportBeech E 55 · Bakersfield, CAThe pilot’s failure to select the proper fuel boost pump setting for the left auxiliary fuel pump, which allowed for an excessive fuel flow to the left engine, which resulted in a total loss of engine power and airplane control during an attempted go-around.NTSB CEN17LA096Accident · Serious injuriesLimited investigationFinal reportCook Smith Aviation Repli · Justin, TXA total loss of engine power due to fuel starvation as the result of a disruption in fuel flow.NTSB CEN17FA095Accident · 1 fatalField investigationFinal reportCessna 177 · Price, TXThe pilot's failure to maintain clearance from a communications tower guy-wire. Contributing to the accident was the pilot's decision to conduct a long distance transition flight at a low altitude.NTSB ERA17LA098Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Pottsville, PAA total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN17LA093Accident · No injuriesLimited investigationFinal reportPiper J3C · Brenham, TXThe reciprocating engine's exhaust valve being stuck in the “open” position, which resulted in a partial loss of engine power during initial climb.NTSB GAA17CA127Accident · No injuriesData collectionFinal reportVaughan Gerald R Side Winder TD · McCook, NEThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN17LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Butterfield, TXA malfunction of the fuel transfer system for reasons that could not be determined based on the available information, a stuck float in the header tank sight gauge that resulted in an inaccurate fuel quantity indication, and the pilot’s inadequate monitoring…NTSB GAA17CA126Accident · No injuriesData collectionFinal reportPiper PA32R · Fort Mohave, AZThe pilot's failure to extend the landing gear for landing.NTSB CEN17FA085Accident · 1 fatalField investigationFinal reportCessna 172 · Jay, OKThe pilot's negligent maintenance of the airplane, which resulted in improper fuel management, fuel starvation, and a loss of engine power during takeoff due to a missing securing pin in the fuel selector handle, and a subsequent forced landing on unsuitable…NTSB CEN17FA084Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · San Antonio, TXThe pilot's uncoordinated flight control inputs and subsequent inadvertent cross-control aerodynamic stall in the airport traffic pattern that resulted in a loss of control and uncontrolled descent with insufficient altitude for recovery.NTSB GAA17CA123Accident · No injuriesData collectionFinal reportPiper PA 28R · Wichita, KSThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.NTSB WPR17FA057Accident · 2 fatalField investigationFinal reportBeech 300 · Tucson, AZThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.NTSB GAA17CA121Accident · No injuriesData collectionFinal reportCessna 150 · Denton, TXThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA17CA133Accident · No injuriesData collectionFinal reportCessna 182 · Sebring, OHThe pilot’s failure to maintain the proper glidepath during landing, which resulted in the airplane landing short of the runway, the nose landing gear separating, and the airplane nosing over during a second landing.NTSB ERA17LA092Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Beechcraft G36 · West Caldwell, NJThe pilot’s failure to maintain airplane control after takeoff, which resulted in an aerodynamic stall.NTSB CEN17LA081Accident · No injuriesLimited investigationFinal reportBellanca 17 30 · Kidron, OHMaintenance personnel’s failure to properly secure the vacuum pump, which resulted in a loss of engine oil and the subsequent total loss of engine power due to oil starvation.NTSB CEN17FA080Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Wellington, TXThe pilot's improper decision to perform a steep turn at low altitude, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB ANC17TA015Accident · Serious injuriesFinal reportPiper PA-32 · Pilot Point, AKThe pilot's continued flight into known icing conditions, which resulted in structural icing and a forced landing on icy, snow-covered terrain.NTSB GAA17CA115Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Bainbridge, GAThe student pilot's exceedance of the airplane’s critical angle of attack during final approach, which resulted in an aerodynamic stall, and his subsequent loss of directional control after touchdown.NTSB CEN17LA078Accident · Serious injuriesLimited investigationFinal reportTextron 525C · Howell, MIThe pilot's attempted landing on the ice-covered runway, which resulted in a runway excursion and impact with terrain. Contributing to the accident was airport personnel's lack of training regarding issuance of NOTAMsNTSB GAA17CA116Accident · No injuriesData collectionFinal reportCessna 170 · Coeur D'Alene, IDThe pilot’s failure to maintain an appropriate descent rate during approach, which resulted in landing short of the runway threshold.NTSB GAA17CA114Accident · No injuriesData collectionFinal reportBeech B200 · Coalinga, CAThe pilot’s failure to maintain directional control during takeoff.