NTSB investigations
10,139 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 GAA19CA562Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 MK.1 · Kotzebue, AKThe pilot's delayed decision to abort the takeoff from water after the airplane impacted a submerged object, which resulted in insufficient airspeed for liftoff and led to the pilot steering the airplane toward a mud embankment to avoid rocks.NTSB WPR19FA263Accident · 2 fatalField investigationFinal reportCessna 182 · Nixon, NVA loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.NTSB CEN19TA335Accident · Minor injuriesClass 3Final reportVans RV 4 · De Soto, MSA total loss of engine power due to fuel exhaustion.NTSB CEN19FA323Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · London, OHThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering toward the final leg of the traffic pattern and facing the rising sun, which resulted in a subsequent aerodynamic stall at too low an altitude to recover.NTSB GAA19CA584Accident · No injuriesData collectionFinal reportPiper PA18 · New Meadows, IDThe pilot receiving instruction's failure to maintain directional control during takeoff with a gusting, right quartering headwind, which resulted in a noseover.NTSB ERA19LA274Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB9 · Fort Meade, MDThe failure of the carburetor intake scat tubing, which resulted in a partial loss of engine power.NTSB ERA19LA273Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sardis, GAFatigue failure of the fasteners on the engine crankshaft, which resulted in a partial loss of engine power and a subsequent forced landing.NTSB ERA19FA275Accident · 2 fatalClass 3 · FieldFinal reportVans RV 8 · Stroudsburg, PAThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB GAA19CA554Accident · No injuriesData collectionFinal reportPiper PA32R · Owasso, OKThe pilot's improper altitude and airspeed control during landing, which resulted in the airplane landing long and a subsequent runway overrun and impact with a drainage culvert.NTSB GAA19CA550Accident · No injuriesData collectionFinal reportPzl Okecie PZL104 · Reno, NVThe pilot's failure to maintain bank control during takeoff in gusting crosswind conditions, resulting in a loss of control in flight and subsequent impact with terrain.NTSB GAA19CA555Accident · Serious injuriesData collectionFinal reportCessna 175 · Toklat, AKThe pilot's loss of airplane control and his subsequent exceedance of the airplane's critical angle of attack during takeoff in variable, gusting wind conditions, which resulted in an aerodynamic stall.NTSB GAA19CA551Accident · No injuriesData collectionFinal reportPiper PA 12 · Healy, AKThe pilot's exceedance of the airplane's critical angle of attack while taking off from water in shifting wind conditions.NTSB GAA19CA546Accident · No injuriesData collectionFinal reportMooney M20M · Chandler, AZThe pilot's improper pitch control during takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's failure to take remedial action.NTSB GAA19CA545Accident · No injuriesData collectionFinal reportCessna P206 · Caldwell, IDThe pilot's improper approach, which resulted in a long landing, a runway overrun, and collision with a drainage culvert.NTSB GAA19CA544Accident · No injuriesData collectionFinal reportCessna 172F · Hemet, CAThe flight instructor's improper decision to perform a precautionary landing on unsuitable terrain, which resulted in a noseover.NTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.NTSB GAA19CA542Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's failure to maintain directional control during an aborted takeoff, which resulted in a runway excursion and impact with runway signs while attempting to maneuver back onto the runway.NTSB CEN19LA318Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Hill City, SDA total loss of engine power for undetermined reasons, which resulted in a hard landing.NTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.NTSB CEN19MA312Accident · 2 fatalClass 3 · MajorFinal reportConvair 440 · Monclova, OHThe flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.NTSB ERA19TA276Accident · No injuriesClass 3Final reportBeech 23 · Panama City, FLA total loss of engine power due to an obstructed fuel vent, and the flight instructor's failure to ensure that the student did an adequate preflight inspection, which resulted in a forced landing.NTSB WPR19FA256Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · La Grande, ORThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB GAA19CA535Accident · Minor injuriesData collectionFinal reportAir Tractor AT 602 · Turkey, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a low pass, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA19CA529Accident · No injuriesData collectionFinal reportCessna 172 · Mekoryuk, AKThe pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting wind conditions.NTSB ERA19FA266Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation, which resulted in the airplane’s descent into water.NTSB CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…NTSB GAA19CA528Accident · Minor injuriesData collectionFinal reportSiai-Marchetti SM 1019 · Lakeport, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting, variable wind conditions, which resulted in a loss of airplane control and subsequent impact with water.NTSB CEN19LA306Accident · Serious injuriesClass 3 · LimitedFinal reportPietenpol Sky Scout · Kingsbury, TXThe total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.NTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.NTSB WPR19FA251Accident · 2 fatalClass 3 · FieldFinal reportPiper PA18 · Hood River, ORThe total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time…NTSB ERA19FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Lady Lake, FLThe pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.NTSB GAA19CA536Accident · Minor injuriesData collectionFinal reportCessna 310 · Tahlequah, OKThe total loss of right engine power due to fuel starvation and the pilot's improper fuel management.NTSB GAA19CA526Accident · No injuriesData collectionFinal reportPietenpol Pietenpol Aircamper · Glendo, WYThe pilot's overapplication of brakes during the landing roll, which resulted in a noseover.NTSB GAA19CA534Accident · No injuriesData collectionFinal reportPiper PA28 · Sawyer, MIThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…NTSB CEN19LA313Accident · No injuriesClass 3 · LimitedFinal reportJackson Velocity · Mack, COA propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing.NTSB GAA19CA521Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent.NTSB GAA19CA520Accident · No injuriesData collectionFinal reportPiper PA32RT · Mackinac Island, MIThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway light.NTSB ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.NTSB CEN19LA319Accident · Minor injuriesClass 3 · LimitedFinal reportLancair LC41-550FG · Branson, MOA total loss of engine power after takeoff for undetermined reasons.NTSB CEN19CA336Accident · No injuriesData collectionFinal reportPiper PA38 · Taylor, TXThe flight instructor's inadequate supervision of the student's soft-field takeoff, which resulted in an excessive pitch attitude, settling effect, and impact with a ditch off the end of the runway.NTSB GAA19CA530Accident · No injuriesData collectionFinal reportPiper PA 18 · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing and the pilot's improper pitch control during the landing roll which resulted in a nose over.NTSB GAA19CA524Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Manchester, NHThe student pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with approach lights.NTSB ERA19LA264Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Foley, ALTotal loss of engine power due to a fatigue failure of the camshaft gear.NTSB WPR19LA247Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 510 · El Monte, CAThe pilot's failure to disengage the parking brake before takeoff, which resulted in decreased acceleration and a subsequent runway overrun following an aborted takeoff.NTSB GAA19CA527Accident · No injuriesData collectionFinal reportDiamond DA20 · Convington, TNThe student pilot's improper pitch attitude during the takeoff climb, and the flight instructor's delayed remedial action which resulted in an aerodynamic stall and ground impact.NTSB ANC19LA048Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18 · Fairbanks, AKThe inappropriate application of paint underneath the engine cylinder hold-down nuts, which resulted in inadequate torque and the subsequent in-flight separation of the No. 3 cylinder, and resulted in a total loss of engine power.NTSB ANC19CA057Accident · Minor injuriesData collectionFinal reportPiper PA22 · Arctic Village, AKThe pilot's failure to maintain adequate airspeed while maneuvering to avoid mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB CEN19LA295Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Olney, TXA loss of thrust control due to a propeller surge event, which resulted in a forced landing shortly after takeoff.NTSB WPR19TA245Accident · No injuriesClass 3Final reportBell 47G · North Las Vegas, NVThe noncertificated passenger’s loss of control during attempted hover operations.NTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.