NTSB investigations
5,625 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 443 |
|---|---|
| 2009 | 356 |
| 2010 | 336 |
| 2011 | 361 |
| 2012 | 348 |
| 2013 | 284 |
| 2014 | 327 |
| 2015 | 303 |
| 2016 | 345 |
| 2017 | 350 |
| 2018 | 321 |
| 2019 | 294 |
| 2020 | 243 |
| 2021 | 271 |
| 2022 | 248 |
| 2023 | 267 |
| 2024 | 271 |
| 2025 | 188 |
| 2026 | 69 |
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\", '0303')) 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", '0303')) 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 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 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 DCA26LA286Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LL · Sanford, FLAn encounter with convectively induced turbulence during cruise flight in an area of forecast thunderstorm activity.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 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 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 WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB DCA26LA285Accident · No injuriesClass 4 · LimitedFinal reportLeigh Aerosystems E100 · Douglas, AZDegraded engine and propeller performance during hot and high-density altitude operations, which resulted in a high descent rate and subsequent hard landing.NTSB WPR26LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Death Valley, CAThe pilot’s failure to maintain airspeed and encounter with a tailwind while landing on a rough runway, which resulted in a runway overrun and subsequent nose over.NTSB CEN26LA211Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Montevideo, MNA total loss of engine power on approach due to carburetor icing.NTSB CEN26LA209Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Jonesboro, ARThe student pilot's failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot’s decision to practice slow flight maneuvers at an…NTSB CEN26LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Dickinson, NDThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions which resulted in a hard landing.NTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA26LA218Accident · No injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G600 · Birmingham, ALThe flight crew’s decision to continue the landing approach into adverse weather conditions, which resulted in a loss visual reference and loss airplane control during landing.NTSB CEN26LA196Accident · No injuriesClass 4 · LimitedFinal reportGuenther Glen A Searey LSX · Briarcliff, TXThe pilot's failure to maintain sufficient altitude and aircraft control during the base to final turn, which resulted in the airplane impacting the water. Contributing to the accident was reported downdraft wind conditions.NTSB WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.NTSB WPR26LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Arco, IDThe pilot's failure to maintain directional control during the landing roll with a right crosswind.NTSB WPR26LA196Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond DA40 · Wells, NVThe pilot’s inability to maintain climb performance and clearance from mountainous terrain due to a downdraft.NTSB WPR26LA192Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Vernal, UTThe pilot's failure to maintain control during the landing flare with a gusting crosswind.NTSB WPR26LA188Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 500 · Twin Falls, IDThe pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.NTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB WPR26LA187Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sedona, AZThe pilot’s inability to maintain directional control due to a plastic foreign object jammed in the rudder pedals, while landing with a gusting left crosswind.NTSB WPR26LA182Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Jurupa Valley, CAThe pilot’s decision to land at night on a runway without illuminated runway lights. Contributing to the accident was the pilot’s failure to review NOTAMs for a nightly airport closure.NTSB WPR26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Marysvale, UTThe pilot's failure to maintain clearance from trees while maneuvering in mountainous terrain prior to encountering a downdraft.NTSB CEN26LA182Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Waco, TXThe pilot’s failure to maintain directional control during the landing with a crosswind.NTSB CEN26LA181Accident · No injuriesClass 4 · LimitedFinal reportHughes 369HS · Durango, COThe flight instructor’s inadequate supervision of the pilot receiving the instruction and the pilot’s improper recovery from a practice autorotation in shifting wind conditions, which resulted in a hard landing.NTSB WPR26LA170Accident · No injuriesClass 4 · LimitedFinal reportBalony Kubicek Spol Sro BB100Z · Elk Grove, CAThe pilot’s delayed decision to deflate the balloon during a static display in windy conditions, which resulted in a loss of control and impact with a building. Contributing to the accident was the proximity of the balloon from structures during a static…NTSB WPR26LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Carlsbad, CAThe student pilot’s failure to maintain airplane control while landing in gusting crosswind conditions.NTSB ANC26LA028Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.NTSB WPR26LA168Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Española, NMThe pilot’s loss of of directional control during landing roll following an encounter with a dust devil.NTSB ERA26LA199Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Greenwood, SCThe glider pilot’s encounter with a strong sink/loss of lift, which resulted in a forced landing to unsuitable terrain.NTSB CEN26LA169Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Meeker, COThe pilot’s inability to maintain climb performance and clearance from terrain due to the airplane’s encounter with windshear during takeoff.NTSB WPR26LA165Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7FC · Bend, ORThe pilot’s failure to maintain directional control during landing roll. Contributing to the accident was the rotor wash from a nearby helicopter.NTSB CEN26LA170Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA 31P 350 · Ardmore, OKThe pilot’s failure to maintain control of the airplane while landing on a wet runway with a tailwind.NTSB DCA26LA185Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Providence, RIThe airplane’s encounter with turbulence during descent resulting in a serious injury to a flight attendant.NTSB CEN26LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Burke, TXThe airplane’s encounter with unexpected low-level wind shear during final approach, which resulted in a hard impact with the runway.NTSB CEN26LA158Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Luverne, MNThe pilot’s failure to maintain directional control during a gusting crosswind landing, and the flight instructor’s delayed remedial action.NTSB CEN26LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.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 CEN26LA154Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28F · Oelwein, IAThe pilot's failure to maintain directional control during the hover taxi with a quartering tailwind.NTSB CEN26LA152Accident · No injuriesClass 4 · LimitedFinal reportEla ELA10 · Boulder, COThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB CEN26LA151Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCB · Colorado Springs, COThe pilot’s failure to maintain directional control of the airplane during takeoff in gusty wind conditions, which resulted in a hard landing.NTSB CEN26LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Beloit, KSThe pilot’s failure to maintain directional control during the landing with a quartering headwind. Contributing to the accident was the pilot’s runway selection based on the variable and gusting wind conditions.NTSB ERA26LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Maiden, NCThe flight instructor’s inadequate preflight planning, which resulted in a rejected takeoff from a tailwind departure and subsequent runway excursion.NTSB WPR26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.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 ERA26LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · North Canton, OHThe flight instructor’s decision to conduct a training flight in strong, gusting crosswinds, which resulted in the airplane’s right wing impacting the ground during taxi.