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 WPR23LA106Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing and subsequent failure to maintain clearance from a snow berm during a go around.Jan 30, 2023 · N1791P · Substantial damageNTSB WPR23LA101Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Dallesport, WAThe flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.Jan 29, 2023 · N127DT · Substantial damageNTSB CEN23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Eagle River, WIThe pilot’s decision to takeoff from an unsuitable surface which resulted in collision with an object.Jan 25, 2023 · N73034 · Substantial damageNTSB CEN23LA090Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Hyannis, NEThe pilot’s failure to maintain clearance from a snowbank during landing, which resulted in a nose-over.Jan 20, 2023 · N717DJ · Substantial damageNTSB ERA23LA116Accident · No injuriesClass 4 · LimitedFinal reportMesafox Kitfox · Orlando, FLAn inadvertent encounter with the jet blast of another airplane while taxiing, which resulted in substantial damage to the airplane’s left wing.Jan 19, 2023 · N915KF · Substantial damageNTSB WPR23LA090Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-160 · Minidoka, IDThe pilot’s failure to maintain control during landing on a contaminated runway.Jan 16, 2023 · N30737 · Substantial damageNTSB WPR23LA089Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Yelm, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway over run. Contributing to the accident was a wet runway.Jan 12, 2023 · N225V · Substantial damageNTSB ERA23FA108Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Dayton, VAThe pilot’s controlled flight into terrain while descending over mountainous terrain at night.Jan 11, 2023 · N43156 · DestroyedNTSB CEN23LA086Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Fowlerton, TXThe pilot’s failure to maintain clearance with trees, which resulted in an uncontrollable spin due to tail rotor damage.Jan 10, 2023 · N811S · Substantial damageNTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.Jan 1, 2023 · N7181A · Substantial damageNTSB CEN23FA071Accident · 4 fatalClass 3 · FieldFinal reportBell 407 · Galliano, LAThe pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…Dec 29, 2022 · N595RL · Substantial damageNTSB WPR23LA081Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-505 · Hawthorne, CAA runway overrun due to the pilot’s failure to stop the airplane as a result of diminished braking action due to a water contaminated runway surface.Dec 28, 2022 · N16DF · Substantial damageNTSB ERA23LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Franklin, VAThe pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…Dec 26, 2022 · N177D · Substantial damageNTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.Dec 26, 2022 · N51115 · Substantial damageNTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.Dec 18, 2022 · N78HJ · Substantial damageNTSB WPR23LA066Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Yuba City, CAAn in-flight collision with a bird while in cruise flight.Dec 13, 2022 · N415RX · Substantial damageNTSB WPR23LA063Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · La Sal, UTThe pilot’s failure to maintain clearance from terrain during a toe-in landing to sloping terrain which resulted in a loss of helicopter control.Dec 8, 2022 · N458HW · Substantial damageNTSB ANC23LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Wasilla, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over after the main landing gear wheels broke through deep snow on the snow-covered runway.Dec 8, 2022 · N3861P · Substantial damageNTSB CEN23LA063Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S2R-G6 · Mission, TXThe pilot's failure to maintain clearance from an electrical box.Dec 6, 2022 · N4205X · Substantial damageNTSB CEN23FA059Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Corning, IAThe pilot’s failure to maintain clearance from obstructions during a go-around, which resulted in impact with powerlines, a tree, and the ground.Dec 5, 2022 · N99345 · DestroyedNTSB WPR23LA053Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Morgan, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.Dec 3, 2022 · N60WY · Substantial damageNTSB CEN23LA058Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108-3 · Regent, NDThe pilot failed to maintain clearance from high tension wires while maneuvering at low altitude.Dec 3, 2022 · N7659X · Substantial damageNTSB ERA23FA077Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Falmouth, MAThe pilot’s failure to maintain clearance from trees during the landing approach. Contributing to the accident was the sun glare, which impaired the pilot's visibility and situational awareness.Dec 2, 2022 · N3515H · Substantial damageNTSB WPR23LA052Accident · No injuriesClass 4 · LimitedFinal reportRutan Long-EZ · Mountain Green, UTThe pilot’s flight into a valley with rising terrain that the airplane was incapable of out-climbing.Nov 27, 2022 · N379W · Substantial damageNTSB ERA23LA071Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Gaithersburg, MDThe pilot’s visual flight below published altitude minimums, which resulted in collision with a powerline tower structure.Nov 27, 2022 · N201RF · Substantial damageNTSB CEN23LA055Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Guthrie, OKThe airplane’s collision with a deer on the runway during landing.Nov 27, 2022 · N99JT · Substantial damageNTSB ANC23LA014Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane during landing.Nov 27, 2022 · N5626U · Substantial damageNTSB WPR23LA051Accident · No injuriesClass 4 · LimitedFinal reportCosmos Phase II · Lake Havasu, AZThe 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 and a subsequent landing on rough terrain.Nov 26, 2022 · N254DW · Substantial damageNTSB ERA23LA072Accident · Serious injuriesClass 4 · LimitedFinal reportDaniel Anthony Proctor M24 Orion Plus · Suches, GAThe pilot's decision to take off from the runway midpoint with a tailwind, which resulted in impact with terrain.Nov 26, 2022 · N728RJ · Substantial damageNTSB CEN23FA046Accident · 1 fatalClass 3 · FieldFinal reportExtra EA300 · Wonder Lake, ILThe pilot’s failure to maintain a proper descent path to the runway after he became disorientated by sun glare while on final approach, which resulted in a collision with trees and terrain.Nov 25, 2022 · N361LX · Substantial damageNTSB CEN23LA047Accident · Minor injuriesClass 4 · LimitedFinal reportSeace David A Gyroplane · Iredell, TXThe pilot's failure to maintain clearance from a power line during low-level maneuvering.Nov 22, 2022 · N44088 · Substantial damageNTSB DCA23LA067Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320 · Red Oak, IAMultiple bird strikes during descent.Nov 20, 2022 · N330NW · Substantial damageNTSB CEN23LA053Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Searcy, ARThe pilot’s failure to maintain clearance from the electrical box while repositioning.Nov 19, 2022 · N184SF · Substantial damageNTSB ERA23LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 402 · Mashpee, MAThe airplane’s impact with a bird while enroute.Nov 18, 2022 · N2649Z · Substantial damageNTSB WPR23LA032Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Salt Lake City, UTThe pilot’s inadvertent attempt to takeoff on a left side of runway, rather than the centerline of runway, which resulted in a collision with runway edge lights during the night time takeoff.Nov 15, 2022 · N789RJ · Substantial damageNTSB CEN23LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Olathe, KSThe inflight collision with multiple geese during initial climb.Nov 12, 2022 · N5258Y · Substantial damageNTSB WPR23LA030Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s improper decision to takeoff from an unimproved airstrip with insufficient takeoff distance which, resulted in a runway overrun and collision with vegetation.Nov 11, 2022 · N615DD · Substantial damageNTSB ANC23FA004Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18 · Chickaloon, AKThe pilot's decision to fly at low altitude, which resulted in a collision with a cable.Nov 10, 2022 · N7123K · Substantial damageNTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.Nov 7, 2022 · N809DM · DestroyedNTSB CEN23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Aguilar, COFailure of the engine cylinder assembly, which resulted in a loss of engine power during cruise flight and an impact with a fence during the forced landing.Nov 5, 2022 · N6051U · Substantial damageNTSB CEN23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Hardin, TXThe pilot’s failure to maintain clearance from the powerlines while landing.Nov 2, 2022 · N9244A · Substantial damageNTSB ERA23LA044Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Sarasota, FLAn in-flight collision with a bird, which resulted in damage to a tail rotor blade, a subsequent vibration, and the pilot’s decision to conduct a precautionary landing to unsuitable terrain.Oct 27, 2022 · N442H · Substantial damageNTSB CEN23LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Burleson, TXThe pilot’s mismanagement of the fuel supply, which led to fuel starvation and a loss of engine power.Oct 27, 2022 · N36X · Substantial damageNTSB CEN23LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Osage, ARA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Oct 26, 2022 · N8457D · Substantial damageNTSB ERA23LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Spartanburg, SCA partial separation of the crankshaft gear/bolt, which resulted in a total loss of engine power.Oct 23, 2022 · N8580N · Substantial damageNTSB WPR23LA023Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Marble Canyon, AZThe pilot’s loss of directional control during a takeoff from a rough, narrow runway, resulting in an aborted takeoff and subsequent runway excursion.Oct 15, 2022 · N6031Q · Substantial damageNTSB ERA23LA039Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Kingstree, SCThe airplane’s impact with two deer during the landing roll.Oct 15, 2022 · C-GITL · Substantial damageNTSB ERA23LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX-7-160 · Northville, NYThe pilot's decision to depart from an area of wet sand, which resulted in a nose over during the attempted takeoff.Oct 9, 2022 · N41510 · Substantial damageNTSB ERA23LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Dacula, GAAn in-flight collision with a bird while on approach.Oct 8, 2022 · N2047Q · Substantial damageNTSB CEN23LA006Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International S53A · Albuquerque, NMThe pilot’s inability to find a suitable landing area in a critical fuel situation and his decision to land on a highway, which resulted in the balloon impacting a bridge railing and terrain.Oct 7, 2022 · N9140F · Minor damage