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.

NTSB ANC21LA023Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s selection of unsuitable terrain for taxi, which resulted in the airplane encountering a crevasse.Mar 4, 2021 · N43300 · Substantial damageNTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.Feb 28, 2021 · N6962S · Substantial damageNTSB ERA21LA145Accident · No injuriesClass 4 · LimitedFinal reportGeorge Matthew Wagoner Zenith 601 HD · Englewood, FLThe pilot’s inadequate compensation for gusty wind conditions, which resulted in a hard landing. The rough terrain of the runway also contributed to the outcome.Feb 27, 2021 · N2614 · Substantial damageNTSB CEN21LA139Accident · No injuriesClass 4 · LimitedFinal reportHughes 369 · Kaufman, TXThe pilot’s failure to maintain clearance from a power line during low-level maneuvering.Feb 26, 2021 · N58431 · Substantial damageNTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.Feb 25, 2021 · N601AX · Substantial damageNTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.Feb 25, 2021 · UNREG · Substantial damageNTSB CEN21LA136Accident · No injuriesClass 3 · LimitedFinal reportLearjet 55 · Jeffersonville, INThe flight crew’s failure to verify the correct runway for landing, which resulted in a landing on a snow contaminated runway and resulting damage to the airplane. The illumination of the lights associated with the closed runway contributed to the accident.Feb 19, 2021 · N559RA · Substantial damageNTSB WPR21LA113Accident · No injuriesClass 4 · LimitedFinal reportCubcrafter CCK-1865 · Quartzite, AZThe pilot’s failure to maintain airplane control during takeoff while operating in gusting wind conditions, which resulted in a collision with a cactus and the subsequent impact with terrain.Feb 16, 2021 · N53KK · Substantial damageNTSB CEN21LA128Accident · No injuriesClass 4 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Alexandria, MNThe helicopter’s impact with an object on departure that could not be determined.Feb 13, 2021 · N352LL · Substantial damageNTSB ANC21LA017Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-6-235 · Tyonek, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the airplane encountering deep snow and coming to rest inverted.Feb 13, 2021 · N56517 · Substantial damageNTSB CEN21LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Prairie du Sac, WIThe student pilot’s loss of directional control during takeoff, which resulted in the collision with a snowbank. Contributing to the accident was the compacted snow conditions on the runway surface.Feb 12, 2021 · N3477E · Substantial damageNTSB CEN21LA133Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Alamo, TXThe partial loss of engine power due to water-contaminated fuel.Feb 9, 2021 · N5679X · Substantial damageNTSB CEN21FA125Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Galt, MOThe pilot’s decision to takeoff into instrument meteorological conditions consisting of low ceilings and icing and his failure to remain clear of terrain while attempting to remain below the clouds, which resulted in impact with terrain.Feb 8, 2021 · N8080G · DestroyedNTSB CEN21LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Urbana, OHThe student pilot’s loss of directional control during landing which resulted in an impact with a snowbank. The slippery runway condition contributed to the accident.Feb 7, 2021 · N348RM · Substantial damageNTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.Feb 5, 2021 · N6639R · Substantial damageNTSB WPR21LA104Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Riverside, CAFuel starvation due to the pilot’s inadequate weather and fuel planning, which resulted in a total loss of engine power.Feb 4, 2021 · N8107S · Substantial damageNTSB CEN21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-50 · Weidman, MIThe pilot’s failure to maintain clearance from terrain during a low approach over a snow-covered runway. Contributing to the accident was the loss of depth perception due to the bright sunlight and snow.Feb 3, 2021 · N26811 · Substantial damageNTSB CEN21LA119Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Silt, COThe pilot’s failure to avoid powerlines while flying at low altitude.Jan 31, 2021 · N4376Q · DestroyedNTSB CEN21LA118Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Davenport, IAThe pilot’s failure to maintain directional control of the airplane, and the flight instructor’s inadequate oversight during a simulated engine out takeoff that resulted in a runway excursion and impact with a snowbank.Jan 28, 2021 · N217US · Substantial damageNTSB ANC21LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-14 · Anchorage, AKThe instructor pilot’s selection of an unsuitable snow-covered runway for landing practice, and the pilot under instruction’s failure to maintain directional control during a landing roll, which resulted in a loss of control in unpacked snow and a subsequent…Jan 25, 2021 · N4265H · Substantial damageNTSB WPR21LA096Accident · No injuriesClass 4 · LimitedFinal reportHeckel Super Sportsman · Spotted Bear, MTThe pilot’s failure to maintain aircraft control during the landing roll on an unimproved snow-covered runway which resulted in a nose-over.Jan 24, 2021 · N55BT · Substantial damageNTSB WPR21LA158Accident · 1 fatalClass 3 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and fatal passenger injury when the passenger fell out of the basket.Jan 23, 2021 · N477LB · No damageNTSB CEN21LA116Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Mankato, MNThe pilot’s loss of situational awareness while landing, resulting in an impact with power lines.Jan 22, 2021 · N60BK · Substantial damageNTSB WPR21LA094Accident · Minor injuriesClass 3 · LimitedFinal reportRandy Wayne Maloney M1 · Eagle Point, ORA partial loss of engine power for reasons that could not be determined based on available evidence.Jan 21, 2021 · N322TR · DestroyedNTSB CEN21LA189Accident · No injuriesClass 4 · LimitedFinal reportBeech P35 · Poplar Grove, ILThe pilot's distraction and his failure to maintain a proper glidepath on the approach, which resulted in him landing short of the runway and impacting a snowbank.Jan 12, 2021 · N436T · Substantial damageNTSB WPR21LA084Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Winthrop, WAThe pilot’s failure to adequately monitor the environment which resulted in a collision with a snowbank and subsequent loss of control.Jan 9, 2021 · N8612F · Substantial damageNTSB CEN21LA110Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Cushing, OKThe pilot’s decision to takeoff from unsuitable terrain which resulted in an aerodynamic stall and subsequent impact with terrain.Jan 9, 2021 · N4540C · Substantial damageNTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.Jan 8, 2021 · N4344B · Substantial damageNTSB WPR21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Riverside, UTA failure of the throttle control during a landing roll, which resulted in a loss of control and collision with a fence.Jan 1, 2021 · N1571A · Substantial damageNTSB ANC21LA010Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172R · Hope, AKThe pilot’s selection of unsuitable terrain for landing. A factor was the certified flight instructor’s selection of unsuitable terrain for landing.Dec 31, 2020 · N949AF · Substantial damageNTSB ERA21LA089Accident · Serious injuriesClass 4 · LimitedFinal reportGlasflugel Club Libelle 205 · Bunn, NCThe pilot's failure to maintain adequate clearance from trees during an off-airport landing.Dec 27, 2020 · N205HL · Substantial damageNTSB WPR21LA074Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S-60A · Peoria, AZThe pilot’s encounter with an updraft which resulted in a loss of aircraft control and subsequent collision with powerlines.Dec 26, 2020 · N6534A · Substantial damageNTSB CEN21LA086Accident · No injuriesClass 4 · LimitedFinal reportEclipse EA 500 · Leadville, COThe pilot’s failure to maintain proper control of the airplane, which led to an unstabilized approach and a long landing on a runway contaminated with ice and patchy packed snow resulting in a runway excursion.Dec 14, 2020 · N686TM · Substantial damageNTSB ERA21LA074Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Dexter, METhe pilot’s loss of directional control while landing, which resulted in an encounter with snow and subsequent nose over.Dec 11, 2020 · N19801 · Substantial damageNTSB CEN21LA085Accident · Serious injuriesClass 4 · LimitedFinal reportLuscombe 8 · Manvel, TXThe pilot’s failure to maintain clearance from power lines during his attempted landing and his loss of situational awareness that led to him to misidentify a pipeline field for the landing airpark.Dec 10, 2020 · N2238K · Substantial damageNTSB WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.Dec 8, 2020 · N46017 · Substantial damageNTSB CEN21LA077Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marietta, TXThe pilot’s failure to see and avoid a transmission wire during takeoff.Dec 5, 2020 · N371MP · Substantial damageNTSB CEN21LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna 551 · Lufkin, TXThe pilot’s decision to land on a runway that did not provide enough length to stop the airplane given the wet surface conditions, resulting in a runway excursion.Dec 2, 2020 · N48DK · Substantial damageNTSB CEN21LA079Accident · No injuriesClass 4 · LimitedFinal reportHutson Star-Lite · San Antonio, TXThe pilot’s decision to land on a soft terrain which resulted in the failure of the nose landing gear.Dec 1, 2020 · N322SL · Substantial damageNTSB CEN21LA072Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Elton, LAThe loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined based on available evidence.Dec 1, 2020 · N48594 · Substantial damageNTSB ERA21LA060Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Northhampton, NYThe pilot’s loss of airplane control during an off-airport landing on soft sand, which resulted in a nose over.Nov 29, 2020 · N9721N · Substantial damageNTSB CEN21LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · French Lick, INThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel starvation.Nov 28, 2020 · N5242W · Substantial damageNTSB ERA21LA053Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35 · Deltaville, VAAn uncontrolled descent and impact with terrain following an in-flight collision with seagulls.Nov 24, 2020 · N35AW · DestroyedNTSB ERA21LA047Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Greenville, NCThe airplane’s collision with a bird during initial climb, which resulted in a forced landing.Nov 16, 2020 · N30BX · Substantial damageNTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.Nov 15, 2020 · N9111 · Substantial damageNTSB WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.Nov 14, 2020 · N8278B · Substantial damageNTSB WPR21LA051Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7 · Moab, UTThe pilot's failure to maintain airplane control during takeoff from an unimproved airstrip, which resulted in a nose-over.Nov 12, 2020 · N721P · Substantial damageNTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.Nov 12, 2020 · N939CP · DestroyedNTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.Nov 12, 2020 · N3535A · Substantial damageNTSB CEN21LA055Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182R · Rockwall, TXThe pilot’s decision to continue an unstabilized approach and his delayed go-around decision, which resulted in the airplane’s impact with power lines and the ground. Contributing to the accident was the inaccurate wind direction reporting as a result of a…Nov 12, 2020 · N7306H · Substantial damage