NTSB investigations
19,179 cases where NTSB found Aircraft.
Cases per year
| 1979 | 1 |
|---|---|
| 2008 | 1,297 |
| 2009 | 1,286 |
| 2010 | 1,161 |
| 2011 | 1,213 |
| 2012 | 1,206 |
| 2013 | 1,003 |
| 2014 | 1,047 |
| 2015 | 1,034 |
| 2016 | 1,075 |
| 2017 | 1,060 |
| 2018 | 1,065 |
| 2019 | 1,048 |
| 2020 | 921 |
| 2021 | 950 |
| 2022 | 1,010 |
| 2023 | 975 |
| 2024 | 926 |
| 2025 | 637 |
| 2026 | 264 |
Where
Open the mapLatest 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\", '01')) 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", '01')) 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 CEN26LA315Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · DeQuincy, LAThe pilot’s failure to maintain directional control during takeoff after encountering a wind gust. Contributing to the accident was nearby convective activity.NTSB ERA26LA336Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · West Kingston, RIThe pilot’s failure to bring the airplane to a stop on the available runway, which resulted in a runway excursion.NTSB ERA26LA327Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · McMinnville, TNThe flight instructor’s delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB ERA26LA323Accident · No injuriesClass 4 · LimitedFinal reportMooney M-20 · Stanfield, NCThe pilot’s failure to adequately manage the available fuel onboard the airplane, which resulted in a total loss of power due to fuel starvation and a forced landing on uneven terrain.NTSB CEN26LA304Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Hudson Oaks, TXThe pilot’s loss of directional control during the rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s decision to abort the takeoff after the airplane had accelerated above its normal rotation speed. Also…NTSB CEN26LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna Claassen 305A(0-1A) · Midland, TXThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA26LA315Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Rural Retreat, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA26LA313Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Milton, FLThe flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left.NTSB ERA26LA311Accident · No injuriesClass 4 · LimitedFinal reportHPH Glasflugel 304CZ · Xenia, OHThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB CEN26LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206H · Marble, COThe pilot's failure to maintain directional control during the final approach in variable and gusting wind conditions. Contributing to the accident were localized wind effects associated with mountainous terrain and with nearby convective activity.NTSB CEN26LA297Accident · Minor injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Searcy, ARThe flight instructor’s failure to maintain airplane control during landing in gusting wind conditions.NTSB ERA26LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miramar, FLThe flight instructor’s failure to maintain control of the helicopter during a hover, which resulted in the left skid contacting ground and a subsequent dynamic rollover.NTSB CEN26LA298Accident · Minor injuriesClass 4 · LimitedFinal reportRotor Effects M24 Plus · Waelder, TXThe pilot’s improper execution of rejected takeoff procedures, which resulted in loss of control and subsequent runway excursion.NTSB CEN26LA294Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Taurus Electro G2.5 · Hempstead, TXThe pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin.NTSB ERA26LA307Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Altoona, PAThe pilot’s descent below the glidepath and collision with trees during a missed approach.NTSB ERA26LA301Accident · Serious injuriesClass 4 · LimitedFinal reportSpirit Engineering SE-1 · Ossipee, NHThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a nose over on the grass runway.NTSB ERA26LA292Accident · No injuriesClass 4 · LimitedFinal reportExtra Flugzeugproduktions-Und EA 300/LT · Whitehouse, OHThe pilot’s failure to ensure the canopy was properly locked before flight, which resulted in the canopy opening during takeoff.NTSB CEN26LA286Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Randolph, NEThe pilot’s failure to maintain clearance from a tree during a low-level aerial application flight.NTSB CEN26LA278Accident · No injuriesClass 4 · LimitedFinal reportCessna 310 · North Little Rock, ARThe flight instructor and pilot receiving instruction’s failure to verify that the landing gear was extended before landing, which resulted in a gear-up landing.NTSB ERA26LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Weston, CTThe in-flight opening of the engine cowling, which resulted in engine baffling separating from the airplane and impacting the right elevator.NTSB ERA26LA285Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Tuscumbia, ALThe pilot’s failure to keep the tail rotor clear of an obstacle while attempting to land.NTSB CEN26LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Algona, IAThe pilot’s failure to maintain control during a turn, which resulted in an aerodynamic stall.NTSB ERA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Sanford, METhe pilot’s loss of directional control during landing and the flight instructor’s inadequate remedial action, which resulted in a ground loop.NTSB ERA26LA284Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palmetto, FLThe flight instructor’s failure to maintain clearance from obstacles during low altitude maneuvering, which resulted in a collision with a fence.NTSB ERA26LA280Accident · No injuriesClass 4 · LimitedFinal reportWaco ASO · Hamilton, OHThe separation of the right main landing gear axle, which resulted in a loss of control during the landing roll.NTSB ERA26LA279Accident · No injuriesClass 4 · LimitedFinal reportBeech A23-24 · Middlefield, OHThe flight instructor’s failure to maintain directional control during landing.NTSB ERA26LA277Accident · No injuriesClass 4 · LimitedFinal reportRans S-6-S · Morgan, VTThe pilot’s failure to maintain control of the airplane during takeoff, resulting in an aerodynamic stall and impact with water.NTSB CEN26LA260Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Emerson, IAThe failure of the pilot to verify the loading hose had been disconnected before taking off and the failure of the loader to disconnect the fuel hose from the helicopter.NTSB ERA26LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mooresville, NCThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA289Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Raven 1 · Scribner, NEThe pilot's failure to maintain clearance from power lines while maneuvering at low-level altitude during an agricultural operation.NTSB WPR26LA265Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7A · Covington, WAThe pilot’s improper pitch control during landing, which resulted in a bounced landing, nose landing gear collapse, and nose over.NTSB ERA26LA276Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries Pitts S-2 · Porter Center, NYThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN26LA256Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Coralville, IAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.NTSB ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB CEN26LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Ellsworth, KSThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.NTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN26LA246Accident · Minor injuriesClass 4 · LimitedFinal reportRotec Engineering Rally 3 · Hooker, OKThe total loss of engine power due to an engine seizure for undetermined reasons because the wreckage was disposed of before it could be examined.NTSB ERA26LA259Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Hickman, KYThe pilot’s failure to maintain a proper glide path, which resulted in a runway undershoot.NTSB WPR26LA252Accident · Serious injuriesClass 4 · LimitedFinal reportFairchild M-62A · Greenleaf, IDThe pilot’s failure to maintain proper airspeed during approach and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR26LA246Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Lake Elsinore, CAThe student pilot’s failure to maintain a proper glidepath, which resulted in a long landing and collision with a person on the ground.NTSB ERA26LA263Accident · Serious injuriesClass 4 · LimitedFinal reportRyan Navion A · Newport, NHThe pilot’s failure to attain an appropriate touchdown point, which resulted in a runway overrun.NTSB CEN26LA244Accident · Serious injuriesClass 4 · LimitedFinal reportCassutt Iiim · Odessa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…NTSB WPR26LA248Accident · No injuriesClass 4 · LimitedFinal reportDean J Irvin KFA Safari XL · Saratoga, WYThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN26LA245Accident · Serious injuriesClass 4 · LimitedFinal reportXag P150 MAX · Wolcott, INThe pilot’s failure to maintain control of the UAS during takeoff.NTSB ERA26LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lafayette, TNThe passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.NTSB CEN26LA243Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Peyton, COThe flight instructor’s inadequate supervision of the student pilot, which resulted in the loss of control during a rejected takeoff.NTSB WPR26LA240Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Santa Paula, CAThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power.NTSB WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB ERA26LA265Accident · No injuriesClass 4 · LimitedFinal reportBeech E35 · Lincoln, ALThe pilot’s failure to ensure that the landing gear were extended prior to landing.NTSB ERA26LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, NCThe flight instructor’s improper decision to leave the airplane with the engine running, which resulted in the airplane rolling forward and impacting a hangar.