NTSB investigations
5,697 cases where NTSB found Physical environment.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0302')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0302')) 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 WPR23LA312Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Dixon, CAThe pilot’s loss of directional control after striking an unidentified object during landing on an unimproved runway, and his subsequent use of excessive braking that resulted in a nose-over.NTSB CEN23LA357Accident · No injuriesClass 4 · LimitedFinal reportPiper PA25 · Hartington, NEThe pilot’s misperception of the rising terrain resulting in a collision with crops and terrain.NTSB CEN23LA350Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Carthage, ILA collision with a fence during landing due to the crew’s reduced distance estimation and depth perception while using night vision goggles. Contributing to the accident was the low moon angle, which made viewing the fence more challenging.NTSB WPR23LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Indian Creek, IDThe pilot's improper fuel management, which resulted in fuel starvation, and gear up landing on a dirt airstrip.NTSB WPR23FA301Accident · 1 fatalClass 3 · FieldFinal reportGlasair Glastar · Idaho City, IDThe pilot’s loss of airplane control during takeoff for reasons that could not be determined.NTSB WPR23LA303Accident · Minor injuriesClass 3 · LimitedFinal reportAldinger Albert John Cozy Mark III · McDermitt, ORThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN23LA347Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Jamestown, NDThe pilot’s failure to maintain proper airspeed after liftoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB WPR23LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Long Beach, CAThe flight instructor’s inattention during ground operations, which resulted in unintentional movement of the airplane and ground collision with another airplane.NTSB CEN23LA341Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Arthur, ILThe pilot’s failure to maintain clearance from trees during a low-level aerial application flight.NTSB WPR23FA296Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Yellow Pine, IDThe pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.NTSB CEN23LA342Accident · 1 fatalClass 4 · LimitedFinal reportBell 206B · Denison, IAThe pilot’s inflight distraction, which resulted in his failure to see and avoid wires.NTSB WPR23FA289Accident · Serious injuriesClass 3 · FieldFinal reportCessna 177 · Gillette, WYThe pilot's decision to depart the high-density-altitude airport with the airplane at the maximum gross weight limit.NTSB ERA23FA317Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Springfield, OHThe pilot’s failure to remain clear of powerlines during an agricultural spraying operation.NTSB CEN23LA329Accident · Minor injuriesClass 3 · LimitedFinal reportVarga 2150A · Green Lake, WIA loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.NTSB CEN23LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Hanlontown, IAThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.NTSB WPR23LA284Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Red Lodge, MTThe pilot’s loss of directional control during landing with wind gusts, which resulted in a ground loop and collision with a fence.NTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.NTSB ANC23FA056Accident · 4 fatalClass 3 · FieldFinal reportBell 206-L4 · Wainwright, AKThe pilot's decision to fly at a low altitude over a large body of water toward featureless terrain, which resulted in a loss of visual clues and controlled flight into terrain.NTSB CEN23LA309Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Princeton, TXThe student pilot’s decision to attempt a takeoff from an unimproved field which resulted in an impact with an obstacle.NTSB ERA23LA368Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Culpeper, VAThe airplane’s impact with a deer while performing a takeoff at night.NTSB CEN23LA308Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Atchison, KSThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline.NTSB CEN23LA300Accident · No injuriesClass 4 · LimitedFinal reportAcrosport II · Hertford, NCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with vegetation.NTSB ERA23LA305Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Gray, GAAn in-flight collision with a bird.NTSB WPR23LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Judith Gap, MTThe pilot's decision to take off on a soft field that exceeded the performance capabilities of the airplane, which resulted in an impact with a pole and terrain.NTSB WPR23LA261Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6G · La Grande, ORThe pilot's failure to maintain clearance from trees during an airstrip overfly, which resulted in impact damage to the left wing.NTSB CEN23LA287Accident · No injuriesClass 4 · LimitedFinal reportAerofab LA-4 · Big Prairie, MIThe airplane’s collision with a submerged log during a water landing.NTSB CEN23LA290Accident · No injuriesClass 4 · LimitedFinal reportGood James AIR CAM · Caswell Beach, NCThe pilot’s failure to properly evaluate the sea state during an open sea landing and subsequent takeoff attempt resulting in an inadvertent impact with the water.NTSB CEN23LA280Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Amity, MOThe pilot’s failure to see and avoid wires while conducting a low-level aerial application flight.NTSB CEN23LA279Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Chapman, KSThe pilot’s failure to maintain clearance from the power line during an agricultural application pass.NTSB ANC23LA047Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Kusatan, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a bounced landing and an encounter with soft terrain, and a nose over.NTSB CEN23LA272Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter SR7 XL · Chetek, WIThe pilot’s failure to maintain aircraft control during initial climb which resulted in an impact with a pole, trees, and terrain.NTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.NTSB ANC23LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Beluga, AKThe pilot's selection of an unsuitable takeoff site, resulting in a collision with brush-covered terrain.NTSB CEN23LA271Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Siloam Springs, ARThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB WPR23LA246Accident · No injuriesClass 4 · LimitedFinal reportBlack Sheep CCX-1865 · Big Creek Ranger Station, IDThe pilot’s failure to identify the wet landing surface and his subsequent inability to maintain directional control and stop during landing on the unimproved grass runway, which resulted in a runway excursion and unintentional ground loop.NTSB WPR23LA245Accident · No injuriesClass 4 · LimitedFinal reportSchleicher Alexander ASH 26 E · Williams, CAThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a collision with terrain.NTSB ERA23LA295Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Sandersville, GAThe pilot’s failure to maintain clearance from trees during landing, which resulted in a tail rotor contact with tree limbs and a subsequent loss of control.NTSB CEN23LA265Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Model 5 · Livingston, TXThe pilot’s failure to maintain directional control during the rollout, which resulted in a runway excursion, and a collision with a building. Contributing to the accident were the obstacles at the airstrip that prevented the pilot from performing a go-around.NTSB WPR23LA259Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A-1B · Las Vegas, NVThe pilot’s unsafe inflight operation of the airplane and failure to maintain clearance from a person on the ground, which resulted in a serious injury.NTSB ERA23LA303Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · Macon, GAAn inflight collision with a bird.NTSB CEN23LA266Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Howell, MIA loss of engine power due to the formation of carburetor ice that resulted from the pilot’s delayed use of carburetor heat during the landing approach.NTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.NTSB ANC23FA042Accident · 2 fatalClass 3 · FieldFinal reportCessna 180 · Shaktoolik, AKThe pilot’s encounter with gusting tailwind conditions during takeoff, which resulted in impact with a tree, a loss of control, and subsequent impact with terrain.NTSB WPR23LA231Accident · Minor injuriesClass 4 · LimitedFinal reportJohnson Gary L Fisher Horizon 1 · Chelan, WAThe pilot’s improper selection of a touchdown point and delayed recognition, which resulted in an impact with an obstacle.NTSB WPR23FA225Accident · 1 fatalClass 3 · FieldFinal reportCessna R182 · McCall, IDMaintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.NTSB WPR23FA223Accident · 2 fatalClass 3 · FieldFinal reportCompagnie Daher TB 30 Epsilon · Apache Junction, AZThe pilot’s controlled flight into the mountainous terrain due to diminished depth perception as a result of the shadowing effect from the sun’s position. Contributing to the accident was the decision by all three pilots to fly low altitude around the…NTSB WPR23LA218Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Chillicothe, MOA partial loss of engine power due to a tear in the fuel manifold diaphragm, which prevented sufficient fuel flow to the engine.NTSB WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.NTSB WPR23LA212Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colusa, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight. Contributing to the accident was the pilot’s fatigue.