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 CEN24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Forney, TXThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR24FA057Accident · 3 fatalClass 3 · FieldFinal reportCessna 172G · Independence, ORThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.NTSB ERA24LA083Accident · No injuriesClass 4 · LimitedFinal reportRabe Richard Exec 162F · Tuscumbia, ALThe pilot’s failure to maintain control of the helicopter, which resulted in the right skid contacting the ground and a subsequent rollover.NTSB ANC24LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kapolei, HIThe first pilot’s failure to maintain a stabilized approach, in gusty crosswind conditions, in an environment favoring wake turbulence.NTSB ERA24LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Newport News, VAAn inflight collision with a bird during initial climb.NTSB WPR24FA054Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Topock, AZThe failure of the No. 4 connecting rod due to oil starvation, which resulted in a loss of engine power, inflight fire, and a subsequent off-airport emergency landing on rough desert terrain. Contributing to the accident was the pilot’s decision to attempt a…NTSB ERA24LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lajas, PRThe pilot’s failure to maintain adequate clearance from bushes alongside the runway, which resulted in a loss of directional control during the takeoff.NTSB CEN24LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Ann Arbor, MIThe airplane’s encounter with unexpected wind shear during final approach, which resulted in a hard landing short of the runway.NTSB CEN24LA103Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Bremen, INThe collapse of the nose landing gear after it contacted soft terrain during the landing roll.NTSB ANC24FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Anchor Point, AKAn impact to the left wing, at an undetermined time, for reasons that could not be determined, which partially separated the left wing and rendered the airplane uncontrollable.NTSB WPR24LA092Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calexico, CAThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB WPR24FA052Accident · Serious injuriesClass 3 · FieldFinal reportRemos Remos GX · Taylor, AZThe pilot’s decision to attempt takeoff with frost covering the airplane’s wings, which led to an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA24LA057Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Social Circle, GAAn encounter with a downdraft while maneuvering at low altitude, which resulted in a collision with a fence.NTSB ERA24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Midland, VAThe pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…NTSB ERA24LA052Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Martinsville, VAThe pilot’s failure to maintain directional control during a wheel landing in crosswind conditions and the flight instructor’s delayed remedial action, which resulted in a ground loop on the runway.NTSB DCA24LA034Incident · Minor injuriesClass 3 · LimitedFinal reportBoeing 717 · Kahului, HIThe captain did not verify that the tow tractor had exited the area in front of the airplane before taxiing for departure. Contributing factors were the dark conditions and the absence of an illuminated hazard beacon on the tow tractor, which reduced its…NTSB WPR24LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Watsonville, CAAn in-flight collision with a bird while in the initial climb.NTSB WPR24LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Modesto, CAThe failure of the pilot to maintain directional control of the airplane during landing, which resulted in a nose over.NTSB ERA24LA061Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Manassas, VAAn in-flight collision with a bird during initial climb.NTSB CEN24LA051Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Glencoe, MNThe collision with deer during the landing rollout.NTSB CEN24FA049Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 600 · Sterling City, TXThe pilot’s failure to maintain clearance from a power line pole’s static arm during forecasted gusting wind conditions, un-forecasted light turbulence, and un-forecasted low-level wind shear conditions, resulting in main rotor blade contact with the static…NTSB WPR24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Las Cruces, NMAn encounter with a downdraft during an approach to land, which resulted in a hard landing.NTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…NTSB CEN24LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Council Bluffs, IAAn in-flight collision with a bird during decent.NTSB CEN24FA046Accident · 2 fatalClass 3 · FieldFinal reportSocata TBM 700 · Ludington, MIThe pilot’s decision to take off with ice/snow contamination on the airplane’s wings, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24LA053Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters Deutschland EC135T3 · Dodge Center, MNAn in-flight collision with a flock of birds.NTSB ANC24LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · McCarthy, AKThe pilot’s loss of directional control after touchdown which resulted in substantial damage to the right wing.NTSB ERA24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 112 · Saluda, SCThe pilot’s failure to maintain directional control of the airplane during an aborted landing in crosswind conditions. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB WPR24LA048Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Hungry Horse, MTThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA047Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Barataria, LAA recreational boat crossed in front of the airplane’s path during landing on the water which resulted in the airplane colliding with the boat.NTSB WPR24LA044Accident · No injuriesClass 4 · LimitedFinal reportTheodore C Kalman ELA Eclipse 10 · Yuma, AZThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.NTSB WPR24FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna P210N · San Diego, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot’s inadequate flight and fuel planning and his decision to fly in night instrument meteorological conditions despite his lack of recent instrument flight.NTSB WPR24FA035Accident · 2 fatalClass 3 · FieldFinal reportCessna 172G · Provo, UTThe pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…NTSB ERA24FA036Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Micanopy, FLThe non-instrument-rated pilot’s improper inflight decision making and his flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident were the pilot’s…NTSB ERA24LA032Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-65 · Columbia, TNA partial loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB WPR24LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Baker City, ORThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA032Accident · Minor injuriesClass 4 · LimitedFinal reportTom Hodgson 29 · Kokomo, INThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR24LA027Accident · No injuriesClass 4 · LimitedFinal reportKitfox S5 · Ririe, IDThe pilot’s inadvertent excessive use of brakes which resulted in a nose-over.NTSB ERA24LA030Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Pembroke Pines, FLThe pilot’s loss of airplane control and descent into terrain due to spatial disorientation during a solo night cross country flight. Contributing to the accident was the pilot’s self-reported fatigue.NTSB CEN24LA030Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Lamar, COThe pilot's inadequate fuel planning and improper in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA24LA025Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 305 · Williamston, NCLoss of directional control to avoid a deer during landing, which resulted in a runway excursion and collision with a culvert.NTSB CEN24LA029Accident · No injuriesClass 4 · LimitedFinal reportAg-Cat G-164B · Abbeville, LAThe pilot’s failure to maintain clearance from a power line during an aerial application flight.NTSB WPR24FA024Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Orangeville, UTThe pilot's controlled flight into mountainous terrain for reasons that could not be determined.NTSB ERA24LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Rangeley, METhe pilot’s failure to maintain directional control during the landing roll with a crosswind, after the right tailwheel spring separated.NTSB CEN24LA027Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Rowlett, TXA malfunction of the helicopter’s Engine Monitoring Unit (EMU)/Governor Controller for undetermined reasons. Contributing to the accident was the flight instructor’s failure to turn off the EMU/Governor Controller per the emergency checklist when the…NTSB CEN24FA024Accident · 1 fatalClass 3 · FieldFinal reportLancair 320 · Manitowoc, WIThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from trees and terrain during an unapproved instrument approach. Contributing to the accident was the pilot’s…NTSB DCA24FA017Accident · No injuriesClass 2 · FieldFinal reportTextron 510 · Houston, TXThe takeoff by the flight crew of N269AA, without a takeoff clearance, which resulted in a collision with N510HM that was landing on an intersecting runway. Contributing to the accident was the N269AA crew’s expectation bias and distraction.NTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…NTSB ERA24LA014Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Ottawa, OHA total loss of engine power due to the formation of carburetor ice..