NTSB investigations, 2023
437 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 933 |
|---|---|
| 2009 | 669 |
| 2010 | 591 |
| 2011 | 564 |
| 2012 | 566 |
| 2013 | 507 |
| 2014 | 612 |
| 2015 | 568 |
| 2016 | 665 |
| 2017 | 700 |
| 2018 | 663 |
| 2019 | 613 |
| 2020 | 441 |
| 2021 | 463 |
| 2022 | 428 |
| 2023 | 437 |
| 2024 | 426 |
| 2025 | 312 |
| 2026 | 149 |
Where
Latest cases
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 year(c.\"eventDate\") = 2023
AND 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 year(c."eventDate") = 2023 AND 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 ERA24FA077Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Marienville, PAThe pilot’s decision to continue visual flight into deteriorating visibility conditions at night, which resulted in spatial disorientation and subsequent descent that continued to ground contact.NTSB CEN24LA081Accident · No injuriesClass 4 · LimitedFinal reportMaule M-6-235 · Beaumont, TXThe pilot’s failure to maintain directional control during landing in crosswind conditions, which resulted in a ground loop on the runway.NTSB CEN24LA076Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Vermillion, SDThe pilot’s encounter with carburetor icing during landing final approach which resulted in fuel starvation, a total loss of engine power, and impact with terrain.NTSB CEN24FA073Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Canton, TXThe pilot’s failure to attain the runway while landing at night, which resulted in an impact with trees.NTSB CEN24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Ponca City, OKThe pilot’s loss of directional control during landing in gusty crosswind conditions.NTSB ANC24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain during the landing approach in flat light conditions.NTSB WPR24LA069Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Whitefish, MTThe failure of the airport authorities to renew the airport closure NOTAM for the airport. Contributing to the accident, was the pilot’s inability to see the runway closure sign.NTSB CEN24LA078Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 210M · Gulfport, MSThe pilot’s failure to maintain directional control during the go-around with a crosswind.NTSB DCA24LA330IncidentClass 2 · LimitedFinal reportBoeing 737-8 · Kenner, LAA partial loss of engine power due to bird ingestion in the No. 1 (left) engine, which resulted in the activation of the load reduction device to prevent vibration. The load reduction device activation resulted in smoke and fumes entering the cockpit.NTSB DCA24LA051Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · St. Louis, MOA bird strike during climbout.NTSB CEN24LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Red Lake, MNThe pilot’s inadequate landing surface evaluation and failure to stop the airplane on the frozen lake, which resulted the airplane continuing into a crack in the ice.NTSB ERA24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Pahokee, FLThe flight instructor’s failure to maintain control of the airplane after encountering a wind gust during landing.NTSB CEN24LA069Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 100 · Texarkana, ARThe pilot’s improper decision to attempt a go-around with full flaps extended, which resulted in decreased climb performance and led to a collision with trees.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.