NTSB investigations
10,307 cases where NTSB found Environmental issues.
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\", '03')) 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", '03')) 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 ERA23LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Elizabethtown, KYThe pilot's decision to continue the taxi without visual reference to the surface, due to his vision being impaired by darkness and glare, which resulted in the airplane’s departure from the paved surface and impact with a ditch. Contributing was the flight…NTSB ERA23LA032Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Lawrenceburg, TNThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA23LA019Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe student pilot’s loss of directional control on landing.NTSB CEN23LA015Accident · No injuriesClass 4 · LimitedFinal reportBeech B-60 · Ardmore, OKThe pilot did not ensure adequate clearance from construction vehicles during taxi.NTSB CEN23LA286Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Holland, MIThe pilot’s failure to maintain directional control during the landing roll with gusty wind which exceeded the maximum crosswind of the airplane.NTSB CEN23LA013Accident · Serious injuriesClass 4 · LimitedFinal reportPober Pixie · Sterling, COThe pilot’s failure to maintain control during the takeoff with strong gusty surface wind.NTSB 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.NTSB WPR23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Monument Valley, UTThe pilot’s loss of airplane control during the landing flare in gusting wind and subsequent loss of directional control during the landing roll.NTSB ERA23LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Dacula, GAAn in-flight collision with a bird while on approach.NTSB ERA23LA011Accident · Serious injuriesClass 3 · LimitedFinal reportBell Textron Canada 505 · Fort Myers, FLThe pilot’s execution of a landing approach with a right, quartering tailwind, low forward airspeed, and high power demand that, when combined, resulted in a loss of tail rotor effectiveness and helicopter control.NTSB 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.NTSB ERA23FA006Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Arundel, METhe pilot’s loss of situational awareness, which resulted in an unstabilized approach, descent below published minimum altitudes, and collision with terrain.NTSB WPR23LA002Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 46-350P · Clovis, NMThe pilot’s failure to follow the go-around procedures by prematurely retracting the flaps and not establishing a proper go-around climb speed after attempting to land with a quartering tailwind, resulting in the airplane’s inability to climb.NTSB WPR23LA001Accident · 1 fatalClass 3 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel LS · Perma, MTThe pilot’s failure to maintain clearance from the powerline.NTSB ERA23FA001Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Hermantown, MNThe pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…NTSB CEN23LA002Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Danville, ILThe pilot decision to perform a precautionary landing to a field with obstacles which resulted in a ground loop. Contributing was the pilot’s inadequate fuel planning.NTSB CEN23LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Burnet, TXThe pilot’s failure to maintain directional control during the landing roll with an unexpected quartering tailwind.NTSB WPR23LA008Accident · No injuriesClass 4 · LimitedFinal reportSeabourn Scott R CCK-2000 · Clarksburg, CAThe pilot's failure to maintain directional control during the landing roll with a gusting quartering tailwind.NTSB WPR23LA006Accident · No injuriesClass 3 · LimitedFinal reportBell 47G2 · Mesa, AZA total loss of engine power due to fuel exhaustion.NTSB WPR22LA365Accident · Minor injuriesClass 4 · LimitedFinal reportMary Alexander JA30 Superstol · Groveland, CAThe pilot's excessive application of brake during an attempt to avoid wildlife while taxing resulted in a nose over.NTSB WPR22LA364Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20 · Hood River, ORThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB DCA23LA008Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COAn encounter with clear air turbulence during cruise flight.NTSB CEN22LA441Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Shell Lake, WIA collision with a deer during landing, which resulted in substantial damage to the left wing.NTSB CEN22FA436Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Allentown, PAA partial loss of engine power for undetermined reasons.NTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.NTSB WPR22LA355Accident · Minor injuriesClass 4 · LimitedFinal reportHartunian Robert Pulsar XP · Big Bear, CAThe pilot’s inability to maintain directional control after landing with an excessive ground speed due to a tailwind which, resulted in a severe shimmy which subsequently damaged a hydraulic brake line.NTSB CEN22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportHibbard Norman E Thorp T-18 · Del Norte, COThe pilot’s loss of airplane control during landing due to a wind gust.NTSB WPR22LA358Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · South Jordan, UTThe pilot’s inability to see and avoid a bird while landing in dark night conditions.NTSB ANC22LA081Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Chignik Lake, AKThe pilot’s failure to maintain airplane control during taxi in gusty conditions, which resulted in a nose-over and substantial damage to the rudder and wings.NTSB WPR22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Sisters, ORThe non-instrument-rated pilot’s flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s degraded judgement due to fatigue.NTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB ANC22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · Egegik, AKThe pilot’s loss of control during takeoff in gusting wind conditions.NTSB CEN22LA425Accident · No injuriesClass 4 · LimitedFinal reportSlipstream Revelation · Delphi, INA loss of engine power due to carburetor icing.NTSB WPR22LA352Accident · No injuriesClass 3 · LimitedFinal reportJacquneaux Glen R CGS Hawk · Lander, WYA reported severe airframe vibration and subsequent forced landing for reasons that could not be determined because the wreckage was not made available for examination.NTSB WPR22FA347Accident · 2 fatalClass 3 · FieldFinal reportSkiles Kenneth C RV-6A · Preston, IDThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB WPR22FA345Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46 · Seligman, AZThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup.NTSB ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB CEN22LA414Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Fort Collins, COThe pilot’s failure to maintain clearance from rising terrain while intentionally maneuvering the airplane at low altitudes, which resulted in substantial damage to the fuselage and both wings.NTSB DCA22LA201Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Chicago, ILSouthwest Airlines flight crew’s misjudgment of the distance required to safely pass the American Airlines airplane.NTSB WPR22LA346Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Las Vegas, NVThe pilot’s failure to maintain airplane control during landing in gusting wind conditions.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB CEN22LA423Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8 · Kingsbury, TXA total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees.NTSB WPR22LA344Accident · Minor injuriesClass 3 · LimitedFinal reportGates Lear Jet 36 · San Diego, CAThe flight crew’s fast landing on a wet runway, which resulted in the airplane hydroplaning during the landing roll and subsequently overrunning the runway.NTSB ERA22LA404Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Saint Cloud, FLThe pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.NTSB CEN22LA417Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Delta Junction, AKThe pilot’s decision to depart during high, gusty wind conditions which resulted sink and subsequent impact with terrain.NTSB WPR22LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Salt Lake City, UTThe airplane’s encounter with a microburst during initial climb that resulted in a loss of altitude and subsequent collision with a tree.NTSB WPR22LA339Accident · Minor injuriesClass 3 · LimitedFinal reportBell 205A-1 · Cougar, WAThe helicopter’s encounter with downdrafts during a low-altitude hovering maneuver while dipping for water.NTSB ERA22LA402Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206G · Millinocket, METhe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.NTSB CEN22LA422Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Galena, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.NTSB CEN22LA412Accident · Serious injuriesClass 3 · LimitedFinal reportZenith 750 · Silex, MOThe pilot’s failure to maintain clearance from the powerlines during takeoff.