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 WPR26LA134Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage CUB-S · Young, AZThe pilot’s failure to maintain adequate clearance from trees during landing.NTSB DCA26LA159Accident · No injuriesClass 4 · LimitedFinal reportPyka Pelican Cargo · Summit Point, WVThe inaccurate obstacle height entered into mission planning that resulted in the aircraft wing’s impact with a tree during descent, resulting resulted in a loss of control.NTSB WPR26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportBrunner Donald G Kitfox · Rock Crossing, AZAn encounter with a downdraft while maneuvering at a low altitude, which resulted in an impact with terrain.NTSB ERA26LA149Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, FLAn in-flight collision with a bird during initial climb.NTSB ERA26LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Chuluota, FLAn in-flight collision with a bird while enroute.NTSB ERA26LA141Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Charleston, WVThe pilot’s inadequate visual lookout, which resulted in a collision with a helicopter dolly during taxi.NTSB ERA26LA130Accident · No injuriesClass 4 · LimitedFinal reportTextron 680A · Miami, FLThe flight crew’s failure to maintain adequate clearance from the blast fence during taxi to the runway for departure, and their inadequate inspection of the airplane after it contacted the blast fence.NTSB WPR26LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Kneeland, CAThe pilot’s failure to maintain airplane control during landing roll on a snow-covered runway.NTSB CEN26LA119Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Graford, TXThe pilot’s failure to maintain sufficient rotor speed during a practice autorotation to soft terrain which resulted in a loss of control and roll over.NTSB CEN26LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Antigo, WIThe pilot receiving instruction’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN26LA116Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Guymon, OKThe collision with a white-tailed deer during the takeoff in night visual conditions.NTSB ERA26LA111Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Thomson, GAAn in-flight collision with a bird while maneuvering.NTSB WPR26LA099Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada BHT407 · Libby, MTThe pilot's failure to maintain clearance from a light post during landing.NTSB WPR26LA095Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Alpine, WYThe pilot’s inadvertent descent while operating in flat light conditions which resulted in controlled flight into terrain.NTSB ERA26LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Castle, DEThe pilots’ failure to properly identify the assigned runway during the landing approach, which resulted in the airplane landing on a closed, snow-covered runway. Contributing was the illumination of the closed runway’s edge lighting.NTSB CEN26LA101Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sullivan, MOThe pilot’s failure to maintain clearance from powerlines during low-level operations.NTSB ANC26LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · Anchorage, AKThe flight instructor’s unintentional selection of the wrong, snow-covered landing surface, which resulted in a nose-over.NTSB WPR26LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-23 · Newkirk, NMThe pilots inadequate preflight planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR26LA087Accident · Serious injuriesClass 4 · LimitedFinal reportKitfox Series 7 · Lemmon Valley-Golden Valley, NVThe pilot’s inability to maintain clearance from terrain during a go-around.NTSB WPR26LA083Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Parkman, WYThe pilots’ failure to maintain separation while conducting air work in a common operational area. Contributing to the accident was the pilots’ divided attention associated with the mission activity and unreliable radio communications.NTSB DCA26LA102Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Kodiak, AKThe reduced surface friction of the contaminated ramp which led to a loss of directional control during taxi.NTSB CEN26LA088Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Early, TXThe unsecured cup holder that restricted left rudder pedal movement, which resulted in a loss of directional control during landing roll.NTSB CEN26LA083Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Round Lake Park, ILThe student pilot’s failure to maintain directional control during a soft-field takeoff and the flight instructor’s delayed remedial action.NTSB CEN26LA074Accident · Minor injuriesClass 3 · LimitedFinal reportPitts S1S · Carbondale, ILA loss of engine power due to fuel starvation resulting from an uncommanded change to the fuel servo mixture position due to the improperly installed mixture cable.NTSB CEN26LA068Accident · No injuriesClass 4 · LimitedFinal reportKitfox Clasc IV-1200 · Hudson, COThe pilot’s failure to maintain control of the airplane during the landing roll.NTSB CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.NTSB ERA26LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA44 · Pembroke Pines, FLAn in-flight collision with a bird while on approach to the destination airport.NTSB WPR26LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Temecula, CAThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA075Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Hawthorne, FLThe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.NTSB CEN26LA070Accident · Serious injuriesClass 4 · LimitedFinal reportGlynn RS-3 · Crabapple, TXThe pilot's failure to maintain clearance from a fence cable guy-line during low-level maneuvering over a river.NTSB CEN26LA073Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International 114 · Stroud, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of power due to fuel exhaustion.NTSB ERA26LA068Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot’s inadequate visual lookout while taxing, which resulted in the airplane striking a light pole.NTSB CEN26LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Conroe, TXThe collision with a deer during takeoff.NTSB CEN26LA055Accident · Serious injuriesClass 4 · LimitedFinal reportJust Highlander · Brazos, TXThe pilot’s failure to maintain clearance from power lines during low-level maneuvering along a river.NTSB CEN26LA054Accident · Minor injuriesClass 4 · LimitedFinal reportLou Malinchak Titan T-51D · Bristow, OKThe collision with two deer during takeoff which resulted in a loss of control and impact with terrain.NTSB CEN26LA053Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Colorado Springs, COThe pilot’s failure to maintain directional control during the landing.NTSB ERA26LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zanesville, OHThe pilot’s failure to maintain clearance from a power line during an approach to land.NTSB ANC26LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Eek, AKThe pilot’s loss of directional control when the airplane encountered snow and ice on the runway while landing at night in gusting crosswind conditions.NTSB ERA26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lynchburg, VAAn in-flight collision with a bird.NTSB CEN26LA036Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gueydan, LAThe pilot’s failure to maintain situational awareness and clearance from terrain while maneuvering to avoid birds.NTSB CEN26LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Grantsburg, WIThe collision with a white-tail deer during the landing in dark night visual conditions.NTSB WPR26LA025Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Queen Creek, AZThe pilot’s improper runway alignment and failure to maintain clearance from powerlines. Contributing to the accident was sun glare, which obscured the pilot’s view of the runway.NTSB ERA26LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Plymouth, CTThe plot’s failure to account sufficiently for the decrease in the airplane’s takeoff performance due to the wet turf runway, which resulted in a collision with a log barrier and subsequent nose over after aborting the takeoff.NTSB CEN26LA019Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Bonilla, SDThe pilot’s inadequate flight planning and his failure to maintain aircraft control during the precautionary off-airport landing.NTSB WPR26LA018Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Imnaha, ORThe pilot’s continued application of brakes during an aborted takeoff in a tailwind on down-sloping terrain, which resulted in a nose-over.NTSB WPR26LA021Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot's failure to maintain clearance from a power line during a descent for landing.NTSB WPR26LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Lathrop, CAAn inflight collision with a bird.NTSB WPR26LA014Accident · No injuriesClass 4 · LimitedFinal reportMaye James A Just Aircraft Escapade · Flanigan, NVThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA25LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Punxsutawney, PAThe airplane’s collision with a deer on a runway during landing roll.NTSB CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.