NTSB investigations
175 cases where NTSB found Knowledge.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 8 |
| 2010 | 8 |
| 2011 | 10 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 8 |
| 2015 | 13 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 12 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 7 |
| 2022 | 16 |
| 2023 | 16 |
| 2024 | 14 |
| 2025 | 11 |
| 2026 | 5 |
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020320')) 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", '020320')) 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 WPR26LA176Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US C-80 · Rio Rancho, NMThe passenger’s improper hand placement on the basket upright during landing, which resulted in injury when the upright fractured during the basket’s bounce and drag sequence.NTSB DCA26LA167Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean (Pacific Ocean)An unanticipated encounter with clear air turbulence while in cruise flight.NTSB DCA26LA164Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Dulles, VAThe tug drivers improper positioning of the airplane during pushback, which resulted in the airplane’s jet blast impacting an active gate area during taxi and the subsequent injury to a maintenance technician. Contributing to the accident was the captain’s…NTSB DCA26LA165Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Atlantic Ocean (Atlantic Ocean)The airplane’s encounter with turbulence resulted in serious injuries to a flight attendant who was not seated due to completion of arrival compliance checks.NTSB CEN26LA117Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · De Smet, SDThe pilot’s failure to maintain directional control during landing.NTSB WPR25LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon pilot’s improper landing, which resulted in serious injury to a passenger. Contributing to the accident was the pilot’s failure to brief the proper landing procedure.NTSB CEN25LA377Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Lancaster, TXThe pilot’s inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA337Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Caseville, MIThe front seat passenger’s inadvertent movement of the cyclic control resulting in a dynamic rollover after landing. Contributing to the accident was the pilot’s decision to leave the dual flight controls installed with a non-pilot passenger in the front seat.NTSB DCA25LA267Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing 787 · North Charleston, SCThe ground crews improper parking of N247BZ, which left its tail protruding into the taxiway, and the JA986A flight crew’s failure to maintain adequate clearance while taxiing.NTSB DCA25LA272Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · Germantown, KYAn inadvertent encounter with severe turbulence during descent.NTSB CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…NTSB ERA25LA199Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182A · Ocala, FLThe pilot’s decision to depart on the flight with known electrical issues and his subsequent loss of situational awareness (geographic position), which resulted in his eventual decision to perform an off-airport landing.NTSB CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB DCA25LA173Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Claveria, PhilippinesAn encounter with convective turbulence during cruise that was not detected in advance by cockpit weather radar or weather information services.NTSB DCA25LA085Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAEncounter with windshear during landing which resulted in a tailstrike.NTSB WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.NTSB CEN25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 340 · Muskogee, OKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB ERA25LA064Accident · Serious injuriesClass 3 · LimitedFinal reportAMS Flight D O O Carat A · Centralhatchee, GAMaintenance personnel’s failure to comply with the engine manufacturer’s guidance, which resulted in improper valvetrain clearances, unseating of the intake valve keepers, and a total loss of engine power.NTSB ANC25LA008Accident · Serious injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Anchorage, AKThe incorrect installation of the rear flight control stick, resulting in the pilot’s inability to control the pitch attitude, coupled with the pilot’s inadequate control system check before departure, all which resulted in an aerodynamic stall during takeoff.NTSB ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB ANC24LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fairbanks, AKThe pilot's failure to maintain directional control while landing at a short remote airstrip.NTSB CEN24LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Dalhart, TXThe pilot’s improper decision to take off with the airplane over its maximum allowable gross weight at a high density altitude, which degraded its climb performance and led an off airport landing.NTSB ANC24LA039Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor’s failure to implement the correct action for low rotor RPM recovery.NTSB ERA24LA225Accident · Minor injuriesClass 4 · LimitedFinal reportNickle C R Acro II · Milford, NJThe pilot’s lack of familiarity with the airplane’s fuel system, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Midland, TXThe pilot’s failure to maintain airplane control during a go-around in a gusting crosswind, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot’s lack of system knowledge regarding the operation of the…NTSB 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…NTSB ERA24LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Dunnellon, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB DCA24LA097Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 777-222ER · Kelsey, NYThe airplane’s encounter with an unanticipated localized region of moderate-to-severe turbulence while in instrument meteorological conditions (IMC) associated with strong upper-level wind shear and convective cells. Contributing to the severity of the…NTSB CEN24FA095Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Little Rock, ARThe pilot’s failure to maintain airplane control after a partial loss of engine power during initial climb. Contributing to the accident was the pilot’s failure to follow airplane flight manual procedures and limitations for the turbocharged engine, which…NTSB CEN24LA085Accident · No injuriesClass 3 · LimitedFinal reportLearjet 35 · San Marcos, TXThe captain’s failure to perform a go-around following an unstable approach while landing with a gusty tailwind, which resulted in the airplane touching down long on the wet runway with insufficient distance to stop. Contributing to the accident was the…NTSB ERA24LA079Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Daytona Beach, FLThe UAS operator’s failure to operate within the limitations of the COA that he was using to operate inside class C airspace, which resulted in a collision between the UAS and the helicopter.NTSB ANC23LA078Accident · No injuriesClass 3 · LimitedFinal reportRhodes Steven D SR3500 · Nenana, AKA total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance.NTSB ERA23LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Cortland, NYThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a noseover. Contributing was the pilot’s lack of familiarity with the airplane.NTSB DCA23LA445Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Hebron, KYAn inadvertent encounter with convectively induced turbulence (CIT) during descent.NTSB ANC23LA065Accident · 2 fatalClass 3 · LimitedFinal reportBeech B36TC · Cape Yakataga, AKThe pilot’s continued flight into moderate to severe icing conditions, including supercooled large droplets, over mountainous terrain, which resulted in a loss of control and impact with terrain. Contributing to the accident was the National Weather Service…NTSB DCA23LA421Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-222 · Over the (Atlantic Ocean)An inadvertent encounter with clear air turbulence during cruise flight.NTSB ANC23LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Iliamna, AKThe passenger’s inadvertent application of brakes during landing that resulted in a nose over.NTSB CEN23FA333Accident · 2 fatalClass 3 · FieldFinal reportRotorway 162F · Oshkosh, WIThe failure of the gyroplane pilot to see and avoid the helicopter while maneuvering in the traffic pattern. Contributing to the accident was the gyroplane pilot’s performance of a prohibited maneuver in the traffic pattern.NTSB DCA23LA382Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Myrtle Beach (Atlantic Ocean)An encounter with convectively induced turbulence (CIT) while in cruise flight.NTSB DCA23LA383Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · East Palestine, OHAn inadvertent encounter with convectively induced turbulence (CIT) during descent.NTSB WPR23LA255Accident · Serious injuriesClass 3 · LimitedFinal reportAvia Stroitel AC-5M · North Plains, ORThe pilot’s failure to maintain control of the motor glider, which resulted in an inflight overstress separation of the right wing during a high-speed, high-wing-load spiral dive recovery. Contributing to the accident was the inadequately manufactured wing…NTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB ERA23LA262Accident · No injuriesClass 3 · LimitedFinal reportBurton Searey · Sherrills Ford, NCThe pilot’s failure to configure the amphibious airplane’s landing gear before conducting a forced landing to a lake after a loss of engine power. Also causal was the occluded gascolator and the pilot’s lack of knowledge about the airplane’s fuel system,…NTSB WPR23LA145Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Elko, NVThe pilot’s failure to maintain sufficient altitude and airspeed in gusting tailwind conditions that resulted in an unrecoverable descent and impact with terrain.NTSB ERA23LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCanton Paul A RV-6 · Milton, FLThe incorrect installation of the fuel pickups, which resulted in a total loss of engine power due to fuel starvation. Contributing was the lack of documentation of the airplane’s unusable fuel.NTSB WPR23LA086Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Kent, WAThe pilot’s inflight loss of airplane control. Contributing to the accident was the pilot’s decision to fly the airplane without receiving training in its operation and flight characteristics.NTSB DCA23LA093Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Newark, NJAn inadvertent encounter with clear air turbulence during descent.NTSB DCA23LA060Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319 · New Orleans, LAThe captain’s pitch up input to avoid an overspeed condition, which resulted in a flight attendant falling and fracturing her ankle. Contributing was the airplane’s excessive airspeed during the transition to the automation-managed descent profile.NTSB CEN22FA433Accident · 1 fatalClass 3 · FieldFinal reportAirgyro AG915 · Yankton, SDA loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.NTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…