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 CEN22LA114Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Cook, MNThe pilot’s failure to ensure the snow-covered takeoff area was safe, which resulted in a collision with ice and subsequent landing gear damage.Jan 29, 2022 · N2923E · Substantial damageNTSB CEN22LA112Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Hortonville, WIThe loss of direction control while maneuvering off the plowed surface to avoid a collision with a vehicle.Jan 29, 2022 · N544WM · Substantial damageNTSB ANC22LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Skwenta, AKThe pilot’s failure to maintain adequate clearance from a tree while landing.Jan 28, 2022 · N189BH · Substantial damageNTSB CEN22LA106Accident · Minor injuriesClass 3 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Lampasas, TXThe failure of a bolt in the engine valve system which resulted in malfunction of the engine exhaust valve system and a partial loss of engine power. The rough terrain encountered during the forced landing contributed to the outcome.Jan 23, 2022 · N5300 · Substantial damageNTSB ERA22LA110Accident · Serious injuriesClass 4 · LimitedFinal reportMiller Roger Thatcher CX4 · Angier, NCThe pilot’s encounter with a flock of birds on final approach, which resulted in a loss of control, an aerodynamic stall and spin, and impact with trees and terrain.Jan 18, 2022 · N254RM · Substantial damageNTSB ERA22LA101Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Lebanon, TNThe failure of the certified flight instructor to attain the proper glidepath which resulted in a collision with a fence and terrain.Jan 4, 2022 · N24605 · Substantial damageNTSB CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.Jan 3, 2022 · N4209Q · Substantial damageNTSB WPR22LA074Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Jordan Valley, ORThe pilot’s decision to takeoff on remote snow covered terrain which, resulted in a nose-over.Jan 1, 2022 · N58BH · Substantial damageNTSB WPR22LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150C · Johnsondale, CAThe pilot’s failure to maintain directional control of the airplane while landing on a snow-covered unimproved runway.Dec 30, 2021 · N7801Z · Substantial damageNTSB ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.Dec 29, 2021 · N6295E · Substantial damageNTSB WPR22LA078Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Strawberry, AZThe pilot’s failure to maintain clearance from a static wire during approach.Dec 21, 2021 · N111AD · Substantial damageNTSB CEN22LA084Accident · No injuriesClass 4 · LimitedFinal reportTextron 525 · Dubuque, IAAn inflight collision with a flock of geese that resulted in substantial damage to the vertical stabilizer.Dec 21, 2021 · N287CB · Substantial damageNTSB ERA22LA090Accident · 2 fatalClass 3 · LimitedFinal reportAerofab Lake LA-4-250 · Auburndale, FLA bird strike, which resulted in a loss of control while flying at low altitude over a lake.Dec 17, 2021 · N1402C · DestroyedNTSB ERA22LA091Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Manhattan, NYThe pilots overapplication of flight controls during landing, which resulted in the rotor blades contacting the wire strike protection system and subsequent hard landing.Dec 13, 2021 · N920PD · Substantial damageNTSB CEN22LA074Accident · No injuriesClass 4 · LimitedFinal reportMini-MAX 1600R Sport · South Bend, INThe pilot’s low-level flight and poor visual lookout which resulted in collision with a light pole on final approach and the pilot’s improper decision to operate an airplane under the influence of alcohol.Dec 13, 2021 · UNREG · Substantial damageNTSB CEN22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Rockwall, TXThe pilot’s failure to go-around during the unstable visual approach, which resulted in a bounced touchdown near the end of the runway and the subsequent runway excursion.Dec 9, 2021 · N7157W · Substantial damageNTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.Dec 4, 2021 · N7824S · Substantial damageNTSB WPR22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Hachita, NMThe pilot’s failure to adequately monitor the environment during a low level operation, which resulted in collision with vegetation.Dec 3, 2021 · N7116L · Substantial damageNTSB ERA22LA084Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, VACollision with a bird in flight, which resulted in damage to the right-wing leading-edge spar.Dec 3, 2021 · N2100S · Substantial damageNTSB CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.Dec 1, 2021 · N444DT · Substantial damageNTSB ERA22LA074Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Perry, GAThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a parked airplane.Nov 23, 2021 · N2033D · Substantial damageNTSB CEN22LA057Accident · No injuriesClass 4 · LimitedFinal reportLeonardo AW169 · Austin, TXThe helicopter’s impact with a bird during cruise flight.Nov 22, 2021 · N307TC · Substantial damageNTSB CEN22LA052Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Marshall, MIThe airplane’s collision with a deer during takeoff.Nov 20, 2021 · N22WU · Substantial damageNTSB WPR22FA043Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Carlsbad, NMThe pilot's failure to maintain separation from an FM tower guy wire while on an aerial survey flight.Nov 19, 2021 · N91AZ · Substantial damageNTSB WPR22LA042Accident · No injuriesClass 4 · LimitedFinal reportPhoenix Air U-15 Phoenix · Carlsbad, CAThe pilot’s failure to maintain distance with an airport sign while taxiing.Nov 18, 2021 · N44DY · Substantial damageNTSB ERA22LA072Accident · No injuriesClass 4 · LimitedFinal reportAeronca O58B · Jonestown, PAThe pilot’s incorrect glide path and landing flare, which resulted in a collision with obstacles on final approach and a hard landing.Nov 18, 2021 · N47523 · Substantial damageNTSB WPR22LA036Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Mackay, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in the airplane veering into a ditch and nosing over.Nov 17, 2021 · N2YQ · Substantial damageNTSB ERA22LA061Accident · No injuriesClass 4 · LimitedFinal reportEric A Munzer Dornier D027-B2 · Martinsville, VAThe pilot’s failure to maintain directional control during landing rollout, which resulted in a runway excursion and an impact with a ditch.Nov 12, 2021 · N27TQ · Substantial damageNTSB ANC22LA006Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC-18-180 · Yukon Charlie River, AKThe pilot’s selection of an unsuitable landing site, which resulted in a nose-over.Nov 9, 2021 · N413CC · Substantial damageNTSB ERA22LA044Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stevensville, MDAn in-flight collision with a bird during initial climb.Oct 31, 2021 · N3HQ · Substantial damageNTSB ERA22LA043Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-236 · Orleans, MAThe pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.Oct 31, 2021 · N2186U · DestroyedNTSB CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.Oct 31, 2021 · N29615 · Substantial damageNTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.Oct 31, 2021 · N46370 · Substantial damageNTSB CEN22LA027Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · La Porte, TXA total loss of engine power due to the failure of the carburetor float assembly.Oct 30, 2021 · N86612 · Substantial damageNTSB WPR22LA031Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Covelo, CAA passenger’s unsecured object departed the cabin resulted in a collision with the tail rotor drive shaft.Oct 28, 2021 · N27TK · Substantial damageNTSB ERA22LA031Accident · 1 fatalClass 3 · LimitedFinal reportVans RV-12 · Folkston, GAThe pilot’s low altitude maneuvering, which resulted in a collision with a utility pole.Oct 26, 2021 · N525AT · DestroyedNTSB ERA22LA032Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Pickens, SCThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and collision with rocky terrain.Oct 24, 2021 · N3771M · Substantial damageNTSB CEN22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe student pilot’s failure to maintain aircraft control during the final approach resulting in a bounced landing.Oct 23, 2021 · N94400 · Substantial damageNTSB WPR22FA021Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Dunsmuir, CAThe non-certificated pilot’s improper decision to continue the flight under visual flight rules into instrument meteorological conditions which resulted in controlled flight into terrain.Oct 20, 2021 · N5268Q · Substantial damageNTSB ERA22LA019Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Mount Pleasant, SCThe pilot’s failure to maintain clearance with the parked fuel truck while taxiing for takeoff. Contributing to the outcome was the pilot’s decision to park the airplane in the congested ramp area and his excessive taxi speed.Oct 18, 2021 · N996LM · Substantial damageNTSB CEN22FA016Accident · 1 fatalClass 3 · FieldFinal reportAutoGyro Cavalon · Stroud, OKThe pilot’s lack of experience in the gyroplane and his decision to takeoff with a tailwind. As a result, the gyroplane did not generate enough lift to takeoff before it struck a barbed wire fence. Contributing to the accident was the pilot’s failure to wear…Oct 18, 2021 · N419LB · Substantial damageNTSB WPR22LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Laurier, WAThe flight instructor’s delayed remedial action to prevent the airplane from landing long which, resulted in a runway overrun and collision with terrain.Oct 17, 2021 · N832DC · Substantial damageNTSB WPR22LA018Accident · No injuriesClass 4 · LimitedFinal reportAirbus A350 · Tucson, AZThe pilot's failure to maintain clearance from ground equipment during landing.Oct 16, 2021 · N544AM · Substantial damageNTSB ERA22LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Wheeler Heights, GAThe airplane’s impact with a bird while in the traffic pattern.Oct 11, 2021 · N263MG · Substantial damageNTSB WPR22LA006Accident · No injuriesClass 4 · LimitedFinal reportBevilacqua Jeffrey L Dragonfly Mkiih · Camarillo, CAThe pilot’s failure to maintain airplane control during takeoffOct 10, 2021 · N186JB · Substantial damageNTSB WPR22LA007Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-32 · San Juan Baptista, CAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which necessitated a forced landing.Oct 9, 2021 · N87R · Substantial damageNTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.Oct 9, 2021 · N8592B · Substantial damageNTSB CEN22LA015Accident · No injuriesClass 4 · LimitedFinal reportZuber Thomas P Zuber Super Drifter · Horseshoe Bay, TXThe pilot’s failure to adequately monitor airspeed during a low-level turn, which resulted in an aerodynamic stall and impact with the water.Oct 9, 2021 · N70TZ · Substantial damageNTSB WPR22LA009Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Albany, ORThe pilot's failure to maintain directional control during takeoff.Oct 7, 2021 · N98241 · Substantial damageNTSB CEN22LA010Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24 · Loveland, COThe pilot’s failure to recognize the degraded engine power and abort the takeoff in a timely manner.Oct 7, 2021 · N5585P · Substantial damage