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 ERA23LA257Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 402 · Charlotte Amalie, CBAn in-flight collision with a bird while entering the traffic pattern.Jun 4, 2023 · N7037E · Minor damageNTSB ANC23LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's excessive braking during landing on a sand bar, which resulted in a nose over.Jun 4, 2023 · N83330 · Substantial damageNTSB CEN23LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Light, ARThe pilot exceeding the climb capability of the airplane during takeoff which led to it settling into the ground.May 29, 2023 · N6678Q · Substantial damageNTSB CEN23LA303Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Ulysses, KSThe pilot’s failure to maintain clearance from a cable during spray operations.May 27, 2023 · N4182G · Substantial damageNTSB CEN23LA203Accident · No injuriesClass 4 · LimitedFinal reportNanchang CJ6 · Windsor, COAn inflight collision with a bird while on initial climb.May 25, 2023 · N443LM · Substantial damageNTSB CEN23LA207Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Fort Worth, TXAn in-flight collision with a bird.May 23, 2023 · N1972G · Substantial damageNTSB WPR23LA194Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2300 · Spanish Fork, UTThe pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.May 21, 2023 · N668LD · Substantial damageNTSB ANC23LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Point Thomson, AKThe pilot’s inadvertent descent below the published minimum descent altitude, while operating in flat light conditions, which resulted in controlled flight into terrain.May 17, 2023 · N34WM · Substantial damageNTSB DCA23LA290AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 Block 1 · Elgin, AZThe pilot’s loss of situational awareness, resulting in the UAS’s controlled flight into terrain.May 15, 2023 · N31EJ · DestroyedNTSB ERA23LA228Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Bradenton, FLThe pilot’s failure to maintain adequate rotor rpm during landing which resulted in a premature landing on uneven ground and a subsequent rollover.May 11, 2023 · N62HT · Substantial damageNTSB WPR23LA186Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1C-180 Husky · Lakewood, WAAn erroneous landing gear warning that led to the pilot’s decision to abort the landing, which resulted in a collision with trees during a go-around.May 9, 2023 · N416AG · DestroyedNTSB WPR23LA180Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Ariel, WAThe pilot’s failure to maintain aircraft control during the landing roll, resulting in a nose over.May 8, 2023 · N6058D · Substantial damageNTSB ERA23LA222Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150M · Hernando, FLThe pilot’s failure to maintain adequate clearance from obstacles during takeoff at night.May 8, 2023 · N150VL · Substantial damageNTSB CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.May 3, 2023 · N750TK · Substantial damageNTSB WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.Apr 30, 2023 · N575ND · Substantial damageNTSB ERA23LA215Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Good Hope, ALThe pilot’s decision to land on a runway where there was insufficient clearance from obstructions (wheat crop) to operate safely.Apr 24, 2023 · N623LA · Substantial damageNTSB ANC23LA030Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Soldotna, AKThe pilot’s selection of an unsuitable landing site, which resulted in the main landing gear wheels breaking through the snow and the airplane nosing over.Apr 22, 2023 · N454FU · Substantial damageNTSB WPR23LA159Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Upland, CAThe pilot's improper selection of the mixture control, which resulted in a total loss of engine power and a collision with the airport boundary fence during a forced landing.Apr 18, 2023 · N349VR · Substantial damageNTSB WPR23LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · North Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with taxiway sign.Apr 15, 2023 · N734NJ · Substantial damageNTSB ERA23FA188Accident · 1 fatalClass 3 · FieldFinal reportMiller Glenn F RV-12 · Climax, NCThe airplane owner/builder’s inappropriate use of a lower grade fuel than that required by the airplane and engine operations manual, which resulted in engine detonation and the degradation and eventual obliteration of the Nos. 1 and 2 cylinder spark plug…Apr 11, 2023 · N543GM · DestroyedNTSB ERA23LA211Accident · Minor injuriesClass 4 · LimitedFinal reportAeropilot S R O Legend 600 · Vero Beach, FLThe pilot's improper recovery from a bounced landing, which resulted in a nose landing gear collapse and subsequent noseover. Contributing was the rough condition of the runway, as described by the pilot, and his decision to operate from it.Apr 8, 2023 · N600LD · Substantial damageNTSB WPR23LA151Accident · No injuriesClass 4 · LimitedFinal reportLowe Bruce Skystr Ktfx IV-1200 · Susanville, CAThe pilot’s braking technique during an off airport precautionary landing on unforeseen soft terrain, which resulted in a nose over.Apr 5, 2023 · N1641E · Substantial damageNTSB CEN23FA144Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Oxford, MSAn in-flight collision with trees and terrain for undetermined reasons.Mar 29, 2023 · N43414 · DestroyedNTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…Mar 27, 2023 · N550DW · Substantial damageNTSB ERA23FA163Accident · 1 fatalClass 3 · FieldFinal reportLarry F Preiss AR-1 · Gainesville, GAThe pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.Mar 25, 2023 · N47AR · Substantial damageNTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.Mar 25, 2023 · N43272 · Substantial damageNTSB ANC23FA031Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron 407 · Nuevo, CAThe pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.Mar 24, 2023 · N14Z · DestroyedNTSB ERA23LA198Accident · No injuriesClass 3 · LimitedFinal reportS C Aerostar S A YAK-52 · Toughkenamon, PAThe pilot’s failure to see and avoid powerlines while on approach to land.Mar 22, 2023 · N669YK · Substantial damageNTSB CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.Mar 19, 2023 · N9088D · Substantial damageNTSB CEN23LA132Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Hotchkiss, COThe pilot’s loss of control during landing rollout on a snow-covered, turf airstrip.Mar 13, 2023 · N235TT · Substantial damageNTSB WPR23LA139Accident · No injuriesClass 4 · LimitedFinal reportFiedler Mark R PA-18 Replica · Sandy Valley, NVThe pilot’s failure to maintain airplane control during an off airport precautionary landing on soft soil, which resulted in a nose over.Mar 12, 2023 · N127MF · Substantial damageNTSB WPR23LA126Accident · Minor injuriesClass 4 · LimitedFinal reportTrendak Taurus · Strawberry Reservoir, UTThe pilot’s failure to maintain clearance from the snow-covered lake while flying at a low altitude.Mar 11, 2023 · N553AT · Substantial damageNTSB ERA23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC 135 P2+ · Franklin, NCThe pilot’s improper decision to review an aircraft logbook while enroute, which resulted in controlled flight into terrain.Mar 9, 2023 · N558MT · Substantial damageNTSB WPR23FA122Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S-2R · Willows, CAThe pilot’s failure to maintain clearance from powerlines while flying under multiple conductors during a low-altitude aerial application flight, which resulted in propeller contact with a powerline and a subsequent loss of control.Mar 8, 2023 · N8424V · Substantial damageNTSB WPR23LA125Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International AC 690A · Bullhead City, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion, a total loss of engine power and subsequent impact with terrain.Mar 7, 2023 · N4PZ · Substantial damageNTSB WPR23LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, ORThe student pilot’s failure to see and avoid another airplane during taxi.Mar 7, 2023 · N25233 · 2 aircraft · Substantial damageNTSB CEN23LA131Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Tomball, TXAn inflight collision with a bird.Mar 6, 2023 · N101BM · Substantial damageNTSB ERA23LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kinston, NCThe airplane’s impact with two deer while performing a takeoff at night.Mar 5, 2023 · N2527L · Substantial damageNTSB WPR23LA120Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Vernalis, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.Mar 3, 2023 · N48492 · Substantial damageNTSB DCA23LA192IncidentClass 4 · LimitedFinal reportLearjet 60 · Boston, MAThe Hop-a-Jet flight crew taking off without a takeoff clearance which resulted in a conflict with a JetBlue flight that had been cleared to land on an intersecting runway.Feb 27, 2023 · N280LJ · 2 aircraft · No damageNTSB CEN23LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Princeton, MNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident, was the runway condition combined with a right crosswind.Feb 25, 2023 · N208SP · Substantial damageNTSB CEN23LA121Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Oklahoma City, OKThe pilot’s failure to maintain directional control during the landing, that resulted in a runway excursion, and an impact with an obstacle.Feb 20, 2023 · N303SB · Substantial damageNTSB WPR23LA111Accident · Serious injuriesClass 4 · LimitedFinal reportGlasair Sportsman · Cal-Nev-Ari, NVThe pilot’s improper decision to takeoff with known damage to the wing and his failure to maintain directional control during takeoff on rough terrain.Feb 19, 2023 · N2847H · Substantial damageNTSB CEN23LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Moline, ILThe student pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 19, 2023 · N84688 · Substantial damageNTSB ANC23LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chugiak, AKThe pilot’s failure to maintain directional control during takeoff in flat light conditions which resulted in a loss of control and impact with a snow berm.Feb 14, 2023 · N9572G · Substantial damageNTSB WPR23LA108Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Lander, WYThe pilot’s failure to maintain directional control during landing.Feb 7, 2023 · N4045R · Substantial damageNTSB WPR23LA105Accident · No injuriesClass 4 · LimitedFinal reportHughes 269C · Yakima, WAThe pilot's failure to see and avoid a powerline while flying at low altitude over a river.Feb 6, 2023 · N7452F · Substantial damageNTSB CEN23LA103Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 425 · Bismarck, NDA loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.Feb 6, 2023 · N425Z · Substantial damageNTSB CEN23LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe student pilot’s failure to maintain directional control during a touch-and-go landing.Feb 5, 2023 · N5442B · Substantial damageNTSB ANC23LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 207 · Newtok, AKThe pilot’s failure to maintain directional control while landing with a crosswind on an ice-covered runway, resulting in a loss of control and subsequent impact with a snowbank. A factor was the check airman’s inadequate supervision.Feb 2, 2023 · N9996M · Substantial damage