NTSB investigations
10,937 cases where NTSB found Use of equip/info.
Cases per year
| 2008 | 427 |
|---|---|
| 2009 | 672 |
| 2010 | 456 |
| 2011 | 543 |
| 2012 | 657 |
| 2013 | 547 |
| 2014 | 660 |
| 2015 | 652 |
| 2016 | 732 |
| 2017 | 715 |
| 2018 | 735 |
| 2019 | 704 |
| 2020 | 561 |
| 2021 | 601 |
| 2022 | 576 |
| 2023 | 543 |
| 2024 | 533 |
| 2025 | 417 |
| 2026 | 206 |
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\", '020630')) 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", '020630')) 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 ERA26LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mount Pleasant, SCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB CEN26LA317Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Natchez, MSThe pilot’s failure to complete a preflight weight and balance calculation, which resulted in a center of gravity beyond the forward limit, and adversely affected the helicopter’s controllability during takeoff.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 ERA26LA334Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American Harvard III · Sanatoga, PAThe pilot’s failure to maintain control of the airplane while landing in a crosswind.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 CEN26LA305Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75L300 · Taylor, TXThe pilot’s failure to maintain directional control during landing.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 WPR26LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Logan, UTThe pilot’s failure to extend the airplane’s landing gear before landing.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 WPR26LA308Accident · No injuriesClass 4 · LimitedFinal reportMitsubishi MU-2B-40 · Norton Shores, MIThe pilot’s failure to extend the landing gear before landing.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 ERA26LA300Accident · Serious injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Clermont, FLThe pilot’s failure to maintain clearance from trees during the landing 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 ERA26LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 680 · Statesville, NCThe pilot’s failure to maintain directional control while landing in a strong gusting crosswind.NTSB WPR26LA286Accident · Minor injuriesClass 4 · LimitedFinal reportInterstate S-1A · Blackfoot, IDThe pilot's failure to maintain the proper glidepath during the landing approach, which resulted in a touchdown prior to the runway threshold, impact of the main landing gear with the pavement edge.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 WPR26LA280Accident · Serious injuriesClass 4 · LimitedFinal reportHarmon Rocket II · Glasgow, MTThe pilot’s inadvertent selection of the fuel selector valve to the OFF position resulted in a total loss of engine power due to fuel starvation and subsequent forced landing to a field.NTSB WPR26LA278Accident · No injuriesClass 4 · LimitedFinal reportNeuberg Bill Glastar · Wills Point, TXThe pilot’s failure to maintain directional control during landing with a right crosswind, which resulted in the airplane’s impact with terrain.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 CEN26LA262Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Janesville, WIThe pilot’s failure to extend the landing gear before landing.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 WPR26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRans S7 · Kemmerer, WYThe pilot’s decision to perform a take-off in high-density-altitude, gusting-crosswind conditions, which resulted in an aerodynamic stall, hard landing and subsequent nose-over.NTSB ERA26LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mooresville, NCThe pilot’s improper landing flare, which resulted in a hard, bounced landing.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 WPR26LA261Accident · No injuriesClass 4 · LimitedFinal reportKitfox S7 STI · Greenwater, WAThe pilot’s failure to maintain directional control during the landing roll, in variable wind conditions.NTSB DCA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-211 · New York, NYThe first officer’s excessive aft sidestick input following a bounced landing, and the line check pilot’s delayed remedial action, which resulted in an increase in the airplane’s pitch attitude and a subsequent tailstrike.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 WPR26LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Marbleton, WYThe pilot's failure to maintain directional control during the landing roll.NTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR26LA273Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Boulder, COThe pilot’s improper landing flare which resulted in a stall and a hard bounced landing.NTSB WPR26LA259Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Monte Vista, COThe pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.NTSB WPR26LA250Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Buffalo, WYThe pilot’s improper flare and subsequent failure to maintain directional control of the airplane during the aborted 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 WPR26LA243Accident · No injuriesClass 4 · LimitedFinal reportValerie Westedt Zenith Zodiac 650B · Colorado Springs, COThe pilot’s improper flare which resulted in a hard landing and their subsequent loss control of during a go-around. Contributing to the accident was the flight instructor’s inadequate remedial action.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 WPR26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportBell 47G · Springtown, TXThe pilot’s failure to maintain clearance from trees while in a low hover.NTSB CEN26LA245Accident · Serious injuriesClass 4 · LimitedFinal reportXag P150 MAX · Wolcott, INThe pilot’s failure to maintain control of the UAS during takeoff.