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 ERA22LA006Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Williston, FLThe pilot’s failure to maintain clearance from terrain on approach which resulted in controlled flight into trees. Contributing to the accident was the flight instructor’s inadequate supervision of the approach path, the dark night conditions and the landing…NTSB CEN22LA006Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Delta, MOThe pilot’s inadequate inflight planning and his failure to see and avoid a wire which resulted in contact with the wire and subsequent ground impact.NTSB ERA22FA001Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Andrews, NCThe pilot’s decision to fly toward rapidly rising, obscured mountainous terrain after departing under visual flight rules at night.NTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB ANC21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 180E · Kotzebue, AKThe pilot’s loss of control during takeoff due to a gusty, variable wind and the rough terrain.NTSB ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.NTSB CEN21LA456Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Patterson, LAThe pilot’s failure to maintain adequate clearance from a parked helicopter while hovering to reposition for takeoff.NTSB WPR21LA351Accident · No injuriesClass 4 · LimitedFinal reportGeorge A. Thiel Just Aircraft Highlander · Monroe, WAThe in-flight malfunction of the throttle control pivot arm, which resulted in a total loss of engine power and the subsequent collision with terrain during the forced landing.NTSB WPR21LA349Accident · No injuriesClass 4 · LimitedFinal reportBeech D17S · San Diego / El Cajon, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a crosswind, which resulted in a runway excursion and subsequent collision with runway signage.NTSB ERA21LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Unadilla, GAThe airplane's impact by a bird during the enroute portion of the flight.NTSB CEN21LA447Accident · No injuriesClass 4 · LimitedFinal reportMorgan Sport Copter Vortex · Kingsland, TXThe pilot’s diverted attention which resulted in an inadvertent descent and subsequent collision with a lake.NTSB CEN21LA421Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Reynoldsville, ILThe pilot’s failure to maintain clearance from the wire during low altitude operations in windy conditions.NTSB ERA21LA375Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Andover Township, NJThe student pilot's excessive asymmetrical application of the brakes, which resulted in a nose over.NTSB ERA21LA366Accident · No injuriesClass 4 · LimitedFinal reportSproul Keith A 83K-16 · Ryegate, VTThe pilot's failure to secure himself to the balloon seat which resulted in a loss of control of the balloon.NTSB ANC21LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and nose over.NTSB CEN21FA410Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Mentone, TXThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB ANC21LA087Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · North Pole, AKThe pilot’s failure to ensure adequate obstacle clearance while maneuvering, which resulted in a collision with a tree and a loss of control.NTSB CEN21LA417Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Olive Branch, MSThe airplane’s impact with a bird while on approach.NTSB WPR21LA338Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Tillamook, ORThe pilot's failure to maintain clearance from a powerline during a low reconnaissance, with sun glare.NTSB ANC21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKThe pilot’s inability to maintain lateral control during the takeoff, which resulted in dynamic rollover. Contributing to the accident was the pilot’s decision to utilize an unsuitable landing area for flight operations.NTSB WPR21LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Salt Lake City, UTThe airplane’s impact with birds during approach.NTSB ERA21LA393Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Delray, FLThe pilot’s inadequate preflight inspection and improper fuel planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB CEN21LA398Accident · No injuriesClass 4 · LimitedFinal reportSegarra Lucas JR Zenith Stoll 701 · Grantsburg, WIThe pilot’s improper landing flare, which resulted in abnormal runway contact and the nose landing gear collapsing.NTSB WPR21LA343Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-24-400 · Fullerton, CAThe pilot’s failure to monitor the environment and maintain a proper glidepath on approach which, resulted in a collision with the airport perimeter fence.NTSB WPR21LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wenatchee, WAThe student pilot’s inadequate inflight navigation and the flight instructors delayed remedial action which resulted in a collision with trees.NTSB WPR21LA341Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Camp Verde, AZThe pilot's inadequate preflight performance calculations which resulted in an aborted takeoff and collision with trees.NTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB ERA21LA345Accident · No injuriesClass 4 · LimitedFinal reportMaule MXT-7-180 · Troy, ALThe pilot's failure to maintain directional control while landing which resulted in a collision with terrain.NTSB WPR21LA333Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Glide, ORThe pilot’s failure to maintain clearance from a tree during an aerial application.NTSB ERA21LA353Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB-505 · Banner Elk, NCThe pilot’s failure to achieve the approach criteria for the available runway landing distances published in the POH, likely as a result of the steeper-than-normal approach and the required left turn on short final to avoid the terrain surrounding the…NTSB WPR21LA326Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Del Mar, CAThe partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.NTSB CEN21LA413Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Stow, OHThe airplane’s impact with a deer during a night landing.NTSB ANC21LA081Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Kodiak, AKThe pilot’s improper landing flare, which resulted in a hard landing and nose over.NTSB WPR21LA328Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe pilot’s inability to maintain control of the airplane during taxi after it encountered the prop wash from a larger airplane that was conducting a high-power engine run on the same taxiway.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…NTSB ANC21LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 180H · Soldotna, AKThe flight instructor's inadequate supervision of the pilot receiving instruction, which resulted in a loss of control during the landing touchdown and a left main landing gear collapse.NTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.NTSB CEN21FA368Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S2R · Strasburg, NDThe pilot’s intentional flight under power lines and his failure to maintain clearance from the lines during an aerial application flight.NTSB WPR21LA307Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170A · Metaline Falls, WAThe pilot’s failure to attain sufficient altitude during the initial climb to clear trees due to an encounter with windshear.NTSB WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.NTSB CEN21LA354Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Wooster, OHThe pilot inadvertently collided with powerline wires during an agricultural spraying flight, resulting in a loss of aircraft control and subsequent impact with the ground.NTSB CEN21LA350Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Waukon, IAThe pilot’s failure to maintain adequate clearance from a powerline during an agricultural application pass.NTSB CEN21FA355Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Starkville, MSThe pilot’s failure to maintain clearance from trees while maneuvering at low altitude.NTSB WPR21LA312Accident · Minor injuriesClass 4 · LimitedFinal reportLake LA-4 · Lake Isabell, CAThe pilot’s failure to establish a positive climb rate after takeoff, which resulted in an impact with an object.NTSB WPR21LA310Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Fort Sumner, NMThe pilot's failure to maintain adequate clearance from a windmill while maneuvering during an aerial application flight.NTSB CEN21LA348Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Merry, NEThe pilot’s failure to maintain clearance from a wire during a low-level aerial application flight.NTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.NTSB WPR21LA314Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2000 · Roseburg, ORThe pilot’s failure to maintain directional control during the landing roll which, resulted in a runway excursion and collision with a tree.NTSB ERA21LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Farmingdale, NYThe pilot’s failure to maintain clearance with a fuel truck while taxiing