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 CEN21LA250Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · West Portsmouth, OHThe pilot’s improper use of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR21LA229Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4 · Cascade, IDThe pilot’s failure to maintain clearance from a ditch, which resulted in impact with terrain.NTSB WPR21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Carlsbad, CAThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB WPR21FA211Accident · 2 fatalClass 3 · FieldFinal reportTextron 172S · Eden, UTThe flight instructor’s improper aeronautical decision-making, which led to an encounter with a downdraft at a low altitude in mountainous terrain and resulted in the instructor’s loss of airplane control and an impact with terrain.NTSB WPR21LA218Accident · Minor injuriesClass 4 · LimitedFinal reportBeech A36 · Sulphur Creek, IDThe pilot’s inability to maintain airplane control during takeoff when the airplane encountered a tailwind and gusting winds which resulted in an aborted takeoff and forced landing to rough terrain.NTSB CEN21LA241Accident · Serious injuriesClass 3 · LimitedFinal reportPipistrel Alpha Trainer · Fort Collins, COA partial loss of engine power due to the failure of the throttle control cable, which resulted in the loss of control of the dual carburetor system. The cable failure was a result of improper soldering at the throttle cable input terminal on the splitter…NTSB WPR21LA205Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Ventura, CAThe partial loss of engine power, during cruise flight, due to the formation of carburetor ice, which resulted in a forced landing to an open field where the airplane nosed over.NTSB WPR21LA202Accident · No injuriesClass 4 · LimitedFinal reportGoodsell Lynn A Classic 4 · Richmond, UTThe pilot’s failure to maintain clearance from powerlines while maneuvering for landing, which resulted in a wire strike and impact with terrain.NTSB WPR21LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Minden, NVThe pilot’s failure to maintain airplane control while on approach in microburst or windshear conditions, which resulted in impact with a runway sign.NTSB CEN21LA225Accident · 1 fatalClass 3 · LimitedFinal reportBell OH58A · Ulysses, KSThe pilot’s failure to maintain clearance from a power line during the aerial application flight, which resulted in collision with the power line and subsequent impact with terrain.NTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.NTSB WPR21LA195Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Hillsboro, ORThe pilot’s delayed remediation following an aborted takeoff run, which resulted in a runway overrun and collision with trees.NTSB WPR21LA193Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172R · Chandler, AZThe pilot’s failure to locate the airport which resulted in an approach to a road and subsequent collision with powerlines during a go-around in low light conditions.NTSB WPR21LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Palm Springs, CAThe Kingair pilot’s failure to maintain clearance from another airplane while taxiing, which resulted in a ground collision.NTSB ANC21LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Willow, AKThe pilots over application of the brakes while landing on a wet grass runway, which resulted in a loss of control and nose-over.NTSB WPR21LA183Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Mesa, AZA tail rotor blade strike to an undetermined object while practicing approaches to unimproved terrain.NTSB ERA21LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Charleston, SCThe airplane's impact with a deer during takeoff.NTSB ERA21FA200Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Wingate, NCThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight, resulting in tail rotor impact with the power line, a loss of control, and subsequent impact with the ground.NTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.NTSB ERA21FA194Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Middleburg, FLThe pilot's decision to depart from a soft grass runway with a tailwind, which resulted in an increased takeoff distance and subsequent impact with trees during the initial climb.NTSB ERA21LA193Accident · No injuriesClass 4 · LimitedFinal reportTextron 208B · Laceyville, PAThe pilot’s improper decision to conduct a low altitude flight and his failure to see and avoid powerlines. Contributing was the operator’s lack of safety guidance or a safety policy for low-altitude operations.NTSB WPR21LA177Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182J · Sedona, AZThe pilot’s failure to maintain directional control during landing with a crosswind, which resulted in a collision with a fuel truck and a parked airplane.NTSB ANC21LA034Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Palmer, AKThe pilot’s selection of unsuitable terrain for landing and his excessive braking which resulted in a nose-over.NTSB WPR21LA173Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Santa Fe, NMA leak in the oil line that supplied the engine with oil, which resulted in oil exhaustion and the total loss of engine power. Contributing to the accident was the routing of the oil line to close to the exhaust manifold.NTSB ERA21LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · New Bedford, MAAn inadvertent collision with a bird during descent, resulting in substantial damage to the vertical stabilizer.NTSB CEN21LA214Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Gonzales, TXThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and collision with a pole.NTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe pilot's inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC21LA030Accident · No injuriesClass 4 · LimitedFinal reportBeech C-99 · Chignik Lagoon, AKThe pilot’s failure to visually inspect the runway condition before landing, which resulted in a collision with an ice chunk and main landing gear separation during landing.NTSB ERA21FA184Accident · 1 fatalClass 3 · FieldFinal reportCessna A188 · Pineview, GAThe pilot’s inadequate visual lookout, which resulted in collision with powerlines during an aerial application flight.NTSB WPR21LA174Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Silver City, NMThe pilot’s loss of situational awareness and failure to touchdown on the runway which resulted in a collision with the airport’s perimeter fence.NTSB ERA21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Troy, ALAn unanticipated encounter with a deer shortly after touchdown, resulting in a collision and substantial damage to the airframe.NTSB DCA21LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7 · Boulder, COa bird strike.NTSB CEN21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Tishomingo, OKThe pilot’s decision to abort the takeoff on encountering a wind gust and his landing beyond the end of the runway that resulted in the airplane impacting a ditch collapsing the nose landing gear.NTSB ANC21LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Lime Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a landing gear collapse.NTSB CEN21LA183Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MT7 · Jewett, TXThe pilot’s failure to maintain control of the airplane after it struck a hidden berm during the intentional off-airport landing, which resulted in a hard landing.NTSB CEN21FA177Accident · 1 fatalClass 3 · FieldFinal reportMagnus Fusion 212 · Conifer, COThe pilot’s decision to fly at low altitude toward a mountainous canyon, and his exceedance of the airplane’s critical angle of attack while maneuvering to avoid rising terrain, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN21LA182Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Denver, COThe pilot’s loss of situational awareness, and his unintended landing on a soft unimproved dirt road, which resulted in a loss of directional control into soft ground and the airplane to subsequently nose over.NTSB ERA21LA166Accident · Serious injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Fort Pierce, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB ERA21FA165Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1 · Cave Spring, GAThe pilot's inadequate visual lookout and failure to maintain clearance from a power line.NTSB CEN21LA173Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Dustin, OKThe pilot’s insufficient monitoring of the helicopter’s power while flying at low altitude and at low airspeed, which resulted in the loss of rotor rpm and impact with a tree and terrain.NTSB ANC21LA027Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Port Alsworth, AKThe pilot's misidentification of the airport’s active runway, which resulted in an off runway landing and a collision with a snow berm. Contributing to the accident was the runway’s lack of identifying markings.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB ERA21FA154Accident · 3 fatalClass 3 · FieldFinal reportBeech B36 · Pembroke Pines, FLThe pilot’s likely activation of the auxiliary fuel pump to “high” for undetermined reasons during takeoff, which resulted in total loss of engine power due to an excessively rich fuel-to-air mixture. Also causal was the pilot’s exceedance of the airplane’s…NTSB CEN21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Port Aransas, TXThe pilot’s failure to maintain proper airspeed on approach and his attempt to land on a wet runway with insufficient runway remaining, resulting in an overrun and loss of directional control.NTSB WPR21LA130Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Laton, CAThe pilot’s failure to maintain clearance from powerlines during low-altitude maneuvering.NTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.NTSB ANC21LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Chevak, AKThe pilot’s loss of directional control during the back-taxi for departure in strong crosswind conditions which resulted in a runway excursion. Contributing to the accident was the snow-and-ice-covered runway.NTSB WPR21LA129Accident · Serious injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Arlington, AZThe pilot’s failure to maintain obstacle clearance during takeoff, which resulted in a collision with a cactus and impact with terrain.NTSB CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…NTSB CEN21LA148Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Moorhead, MSThe pilot did not maintain clearance from a powerline during an aerial application flight.