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.

NTSB CEN24LA153Accident · No injuriesClass 4 · LimitedFinal reportBeech B300 · Oklahoma City, OKAn in-flight collision with a bird during the initial climb.Apr 9, 2024 · N243MH · Substantial damageNTSB WPR24LA125Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 195B · Portales, NMThe pilot’s decision to take off with a quartering tailwind and his subsequent failure to maintain directional control. Contributing to the accident was the pilot’s improper elevator control inputs during takeoff.Apr 8, 2024 · N2147C · Substantial damageNTSB ERA24LA177Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Carrabassett, METhe pilot’s failure to attain a proper touchdown point while landing in gusty wind conditions.Apr 8, 2024 · N6465P · Substantial damageNTSB DCA24LA144Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Cecil, NCAn encounter with clear air turbulence.Apr 3, 2024 · N899AT · No damageNTSB DCA24FA143Accident · Serious injuriesClass 3 · FieldFinal reportBoeing 737-7CT · Gulf of America (Gulf of Mexico)The pilot’s inadvertent encounter with convectively induced turbulence from a broken line of embedded thunderstorms moving across the region. Contributing to the accident was the failure of the air traffic controller to issue pertinent weather information…Apr 3, 2024 · N567WN · No damageNTSB CEN24LA145Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20E · Alpine, ARThe improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…Apr 2, 2024 · N86UM · Substantial damageNTSB CEN24LA144Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Muncie, INThe pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…Apr 1, 2024 · N8438B · DestroyedNTSB ERA24LA183Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Conyers, GAAn encounter with shifting wind conditions, which resulted in the airplane using more runway than anticipated, an aborted takeoff, and subsequent runway excursion. Contributing to the accident was the pilot’s failure account for the potential of variable and…Mar 31, 2024 · N3420E · Substantial damageNTSB WPR24LA120Accident · No injuriesClass 4 · LimitedFinal reportBeecraft Bonanza · Angel Fire, NMThe pilot's failure to maintain directional control of the airplane during takeoff with a gusting crosswind..Mar 30, 2024 · N9989R · Substantial damageNTSB ERA24LA164Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · North Kingstown, RIA total loss of engine power during final approach due to the pilot’s failure to recognize that the environmental conditions were susceptible to carburetor icing and apply carburetor heat, which resulted in the formation of carburetor ice. Contributing to the…Mar 30, 2024 · N7538P · Substantial damageNTSB CEN24LA142Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Ben Wheeler, TXThe pilot’s failure to maintain control while landing in a gusting wind.Mar 30, 2024 · N3322U · Substantial damageNTSB CEN24LA143Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Moran, KSAn in-flight collision with birds while in cruise flight.Mar 29, 2024 · N910GX · Substantial damageNTSB DCA24LA135Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-232 · Lakeland, GAAn inadvertent encounter with convective turbulence that resulted in a serious injury to a flight attendant.Mar 28, 2024 · N6705Y · No damageNTSB ERA24LA153Accident · Minor injuriesClass 3 · LimitedFinal reportDenzil Velarde MTO Sport · Tavernier, FLThe gyroplane’s encounter with a tailwind during the initial climb, which resulted in a loss of airspeed and subsequent forced landing.Mar 24, 2024 · N291AG · Substantial damageNTSB WPR24LA116Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Coolidge, AZThe student pilot’s improper landing flare, which resulted in a hard landing in gusty wind conditions. Contributing, was the failure of the flight instructor to intervene in a timely manner.Mar 21, 2024 · N755LA · Substantial damageNTSB CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.Mar 21, 2024 · N5236R · Substantial damageNTSB ERA24LA148Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369D · Belleville, WVThe ingestion of foreign object debris into the engine, which resulted in a sudden loss of engine power and a subsequent collision with trees and terrain during the forced landing.Mar 18, 2024 · N102SU · Substantial damageNTSB CEN24LA138Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Aitkin, MNThe student pilot’s failure to maintain directional control during the takeoff in crosswind conditions.Mar 18, 2024 · N788JN · Substantial damageNTSB ANC24LA019Accident · No injuriesClass 4 · LimitedFinal reportMichael G Darby Dard 1 · Anchorage, AKThe pilot’s loss of directional control while landing in soft snow, resulting in a nose over.Mar 18, 2024 · N696AK · Substantial damageNTSB WPR24FA112Accident · 1 fatalClass 3 · FieldFinal reportHolmes William B AIR Creation Twin · Gila Bend, AZThe pilot’s loss of control and subsequent collision with a mesquite tree on approach to land.Mar 17, 2024 · N4425L · Substantial damageNTSB WPR24LA113Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 Super Sport · Asotin, WAPilot’s failure to maintain clearance from powerlines during low altitude flying.Mar 16, 2024 · N295P · Substantial damageNTSB ERA24LA141Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Winokur, GAA total loss of engine power due to the unseating and subsequent failure of the No. 4 piston connection rod bushing.Mar 16, 2024 · N469GB · Substantial damageNTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.Mar 16, 2024 · N280WR · Substantial damageNTSB WPR24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportZenith Zodiac CH601 · Rawlins, WYThe student pilot’s failure to see and avoid powerlines during an unstabilized approach, which resulted the airplane landing short of the runway and coming to rest inverted.Mar 15, 2024 · N43373 · Substantial damageNTSB ERA24LA145Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Melbourne, FLThe student pilot’s failure to maintain directional control while landing in a crosswind.Mar 15, 2024 · N838ER · Substantial damageNTSB DCA24LA130Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-800 · Paris, TNAn encounter with convective turbulence.Mar 15, 2024 · N8520Q · No damageNTSB WPR24LA111Accident · Minor injuriesClass 4 · LimitedFinal reportPiper Aerostar 601P · Grass Valley, CAThe pilot’s failure to maintain directional control in a gusting wind condition.Mar 14, 2024 · N1SS · Substantial damageNTSB ERA24LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pembroke Pines, FLAn inflight collision with a bird while approaching the destination airport.Mar 14, 2024 · N6300Q · Substantial damageNTSB CEN24LA136Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Grind Stone City, MIThe pilot's failure to maintain directional control during the landing roll on a wet turf runway with a quartering tailwind.Mar 13, 2024 · N4159Y · Substantial damageNTSB CEN24LA134Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T182T · Lapeer, MIThe pilot’s failure to maintain aircraft control while landing in a gusting crosswind condition.Mar 12, 2024 · N1103H · Substantial damageNTSB CEN24LA133Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Falcon, COThe flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.Mar 12, 2024 · N2905H · Substantial damageNTSB WPR24FA105Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Madras, ORThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with turbulence and structural icing conditions, loss of control, and subsequent impact with terrain.Mar 10, 2024 · N3264W · DestroyedNTSB ERA24LA135Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Homestead, FLA loss of engine power due to carburetor ice as a result of the pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice.Mar 9, 2024 · N5171H · Substantial damageNTSB ERA24LA134Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Clay, KYThe pilot’s decision to attempt a VFR flight in instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s impairment due to alcohol consumption.Mar 9, 2024 · N1703Q · Substantial damageNTSB DCA24LA124Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Aylett, VAAn encounter with clear air turbulence during descent.Mar 9, 2024 · N411WN · No damageNTSB ERA24LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Greensboro, NCThe pilot’s failure to maintain directional control while landing with a crosswind.Mar 8, 2024 · N8455R · Substantial damageNTSB CEN24LA132Accident · No injuriesClass 4 · LimitedFinal reportPietenpol Aircamper · Lockhart, TXThe pilot’s failure to maintain control during after takeoff.Mar 6, 2024 · N7710J · Substantial damageNTSB CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.Mar 5, 2024 · N853MB · Substantial damageNTSB ERA24LA131Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AT · Smyrna, TNThe airplane encountered a sink hole while taxiing.Mar 4, 2024 · N563TR · Substantial damageNTSB ERA24LA129Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11 · Fort Myers, FLThe pilot’s failure to maintain directional control while landing with a crosswind.Mar 3, 2024 · N729CJ · Substantial damageNTSB ERA24LA137Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Leesburg, VAAn in-flight collision with a bird while on the downwind leg of the airport traffic pattern.Mar 1, 2024 · N1057R · Substantial damageNTSB CEN24LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Alexandria, LAThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.Feb 28, 2024 · N7770K · Substantial damageNTSB WPR24LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Casper, WYThe pilot’s failure to maintain directional control while taxiing with a crosswind.Feb 26, 2024 · N739UE · Substantial damageNTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.Feb 26, 2024 · N35719 · Substantial damageNTSB ERA24FA120Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Jackson, OHThe non-instrument-rated pilot’s decision to depart under visual flight rules into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.Feb 24, 2024 · N8963N · DestroyedNTSB WPR24LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Weippe, IDThe pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.Feb 22, 2024 · N6323B · Substantial damageNTSB CEN24LA116Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Laotto, INThe pilot’s improper decision to continue an approach with his vision obscured by sun glare, which resulted in a collision with a tree.Feb 19, 2024 · N358AK · Substantial damageNTSB ANC24LA014Accident · No injuriesClass 4 · LimitedFinal reportBenjamin Pratt Bearhawk Patrol · Galena, AKA loss of engine power as a result of carburetor ice. Contributing to the outcome was the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.Feb 19, 2024 · N406AK · Substantial damageNTSB ERA24LA114Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Brookwood, ALThe pilot’s failure to see and avoid powerlines while maneuvering at low altitude.Feb 16, 2024 · N9160H · Substantial damageNTSB WPR24LA090Accident · No injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Lewistown, MTThe pilot’s failure to maintain clearance from terrain. Contributing to the accident was the pilot’s encounter with low light conditions and snow-covered terrain.Feb 15, 2024 · N899JS · Substantial damage