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 WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.NTSB WPR23LA212Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colusa, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight. Contributing to the accident was the pilot’s fatigue.NTSB ERA23LA257Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 402 · Charlotte Amalie, CBAn in-flight collision with a bird while entering the traffic pattern.NTSB 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.NTSB ERA23LA268Accident · Minor injuriesClass 3 · LimitedFinal reportJabiru J250 · Louisville, GAThe pilot’s decision to take off in wind conditions that exceeded his ability to maintain directional control, resulting in a runway excursion and substantial damage to the airplane.NTSB CEN23LA233Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Carrington, NDA total loss of engine power as a result of carburetor ice that formed while the engine was operating at a low power setting for an extended period of time before departure.NTSB CEN23LA230Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Rutherfordton, NCThe disengagement of the tailwheel locking mechanism during the landing roll which resulted in a loss of directional control during landing with a crosswind.NTSB CEN23LA226Accident · Serious injuriesClass 3 · LimitedFinal reportTemco GC-1B · Bristow, OKThe loss of engine power due to carburetor ice due to the pilot’s delayed application of carburetor heat.NTSB CEN23FA220Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Gibbon, NEThe pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.NTSB DCA23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Chicago, ILAn encounter with convectively-induced turbulence (CIT).NTSB DCA23LA304Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Houston, TXAn encounter with convectively-induced turbulence (CIT).NTSB CEN23LA228Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Saffell, ARThe airplane’s encounter with a dust devil after takeoff, which resulted in a loss of lift, and a subsequent loss of control. Contributing to the accident was the presence of a dust devil in the airplane’s flight path.NTSB CEN23LA219Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Pontiac, MIThe flight crew’s inadequate compensation for gusting wind, and the flight instructor’s delayed remedial action, which resulted in impact with the ground.NTSB WPR23LA209Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Doo Ajdovscina Virus SW · Santa Fe, NMAn encounter with a downdraft during landing that resulted in a hard landing and the pilot’s loss of control.NTSB CEN23LA210Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St. Anthony, NDThe pilot’s failure to maintain clearance from terrain while maneuvering at low attitude.NTSB WPR23LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Santa Teresa, NMThe pilot’s loss of control after encountering a dust devil during landing.NTSB 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.NTSB CEN23LA209Accident · No injuriesClass 4 · LimitedFinal reportKolb Firestar SS · Lodi, WIThe pilot’s failure to maintain control during takeoff.NTSB ANC23LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a water loop and impact with terrain.NTSB WPR23LA204Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Enterprise, UTThe pilot’s inability to maintain altitude during an initial climbout in mountainous terrain after encountering a suspected downdraft.NTSB ERA23FA249Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Plymouth, NYA total loss of engine power for reasons that could not be determined.NTSB CEN23LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Grand Forks, NDThe student pilot’s failure to attain a proper takeoff attitude while demonstrating a soft field takeoff and his improper control inputs resulting in a dragged wing. Contributing to the accident were the gusting wind conditions.NTSB WPR23LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Minden, NVThe pilot’s failure to maintain directional control during the landing roll with a quartering headwind.NTSB CEN23LA303Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Ulysses, KSThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.NTSB WPR23LA202Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M-18C 55 · Napa, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB ERA23LA243Accident · No injuriesClass 4 · LimitedFinal reportThompson Edward LM-5X-W · Limington, METhe pilot’s inadequate compensation for the gusty crosswind conditions, which resulted in a collision with a tree during landing.NTSB CEN23LA203Accident · No injuriesClass 4 · LimitedFinal reportNanchang CJ6 · Windsor, COAn inflight collision with a bird while on initial climb.NTSB CEN23LA202Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Wright, LAThe pilot's decision to takeoff with the airplane overloaded which resulted in the airplane settling and subsequently impacting terrain.NTSB WPR23LA200Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · San Diego, CAThe pilot’s failure to maintain altitude during a hover taxi due to distraction resulting from the unanticipated activation of strobing lights while using night vision googles.NTSB ERA23LA244Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Reidsville, NCThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB CEN23LA207Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Fort Worth, TXAn in-flight collision with a bird.NTSB CEN23LA200Accident · No injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Gregory, MIThe pilot’s improper landing flare that resulted in a hard, bounced landing and subsequent overstress failure of the nose landing gear.NTSB 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.NTSB CEN23LA213Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ray, MIThe flight instructor’s failure to maintain airplane control during simulated engine-out procedures. Contributing to the accident was the flight instructor’s decision to land with a tailwind.NTSB ANC23LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Hunter Creek, AKThe pilot’s loss of directional control during takeoff roll in gusting wind conditions.NTSB CEN23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · DeKalb, ILThe pilot’s failure to maintain aircraft control during a go-around in gusting winds. Contributing was the presence of windshear.NTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.NTSB WPR23LA300Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tracy, CAThe pilot’s failure to maintain directional control during the landing roll after encountering a wind gust.NTSB 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.NTSB ANC23LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Anchorage, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB CEN23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185f · Grand Junction, COThe pilot’s failure to maintain directional control during the landing roll with gusting wind.NTSB 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.NTSB CEN23FA187Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Chambers, NEThe pilot’s continued VFR flight into instrument meteorological conditions at night and his failure to maintain adequate altitude, which resulted in controlled flight into terrain.NTSB WPR23FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna T182T · Albany, WYThe pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…NTSB WPR23LA190Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Elko, NVThe pilot’s loss of directional control during landing with a quartering tailwind.NTSB ERA23LA229Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · South Bethlehem, NYThe pilot’s improper decision to attempt an intersection takeoff in a tailwind when the full runway in the opposite, headwind direction was available.NTSB 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.NTSB ANC23LA033Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235 · Soldotna, AKThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB 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.