NTSB investigations
5,692 cases where NTSB found Physical environment.
Cases per year
| 2008 | 604 |
|---|---|
| 2009 | 361 |
| 2010 | 303 |
| 2011 | 244 |
| 2012 | 265 |
| 2013 | 274 |
| 2014 | 379 |
| 2015 | 332 |
| 2016 | 421 |
| 2017 | 457 |
| 2018 | 431 |
| 2019 | 396 |
| 2020 | 251 |
| 2021 | 221 |
| 2022 | 198 |
| 2023 | 186 |
| 2024 | 172 |
| 2025 | 129 |
| 2026 | 68 |
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\", '0302')) 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", '0302')) 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 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 ERA26LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Carlisle, PAA collision with a deer during landing.NTSB CEN26LA291Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Linden, MIThe collision with a deer during touch-and-go landings.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 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 ERA26LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lakeland, FLAn in-flight collision with a bird while on approach.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 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 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 CEN26LA252Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Whiting, KSThe pilot's failure to maintain clearance from an antenna while maneuvering during a low-level aerial application flight.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 ERA26LA261Accident · No injuriesClass 4 · LimitedFinal reportKodiak Kodiak 100 · New York, NYAn inadvertent collision with a large wave during touchdown on a river, which resulted in a subsequent bounce and hard landing.NTSB WPR26LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Dixie, IDThe pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.NTSB WPR26LA230Accident · No injuriesClass 4 · LimitedFinal reportStephen Aberle Chipper CH-2A · Alva, OKThe pilot's decision to taxi the tailwheel-equipped airplane over uneven terrain while operating with limited forward visibility, which resulted in the left main landing gear entering a hole.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 WPR26LA221Accident · No injuriesClass 4 · LimitedFinal reportStoddard Hamilton Glastar · Summer Lake, ORThe pilot's selection of an unsuitable landing area, which resulted in the airplane nosing over during the landing roll.NTSB WPR26LA220Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Morgan Hill, CAAn in-flight collision with a bird.NTSB ERA26LA234Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mayesville, SCThe pilot’s failure to remain clear of a power line during an aerial application flight.NTSB ERA26LA245Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft DCO-65 · Renovo, PAThe pilot’s failure to maintain control during an off-airport landing.NTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB CEN26LA215Accident · No injuriesClass 4 · LimitedFinal reportEaa Acro Sport II · Sheridan, ARThe pilot’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB WPR26LA206Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cascade, IDThe pilot’s improper approach, which resulted in a faster than normal touchdown and subsequent runway overrun.NTSB CEN26LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Northport, MIThe pilot's decision to resume taxiing on a turf runway that was unable to adequately support the airplane's weight, which resulted in the nose landing gear sinking into the soft ground and the propeller striking the terrain.NTSB CEN26LA194Accident · No injuriesClass 4 · LimitedFinal reportLockwood AIR CAM · Hutchinson, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.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 ERA26LA207Accident · 1 fatalClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Scotts Fork, VAThe photographer’s failure to remain clear of an active taxiway.NTSB WPR26LA184Accident · No injuriesClass 4 · LimitedFinal reportVans RV-6A · Kooskia, IDThe pilot’s collision with a hole in the runway surface during the landing roll, which resulted in a nose over.NTSB WPR26LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna A150L · Superior, AZThe pilot's failure to retract the flaps during takeoff following a touch-and-go landing, which resulted in degraded climb performance and an impact with an object during an off-field landing.NTSB CEN26LA177Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · El Campo, TXThe pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.NTSB CEN26LA272Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-236 · Glenwood Springs, COThe pilot’s failure to maintain clearance from a fuel farm fence while taxiing.NTSB WPR26LA172Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Young, AZThe pilot’s failure to maintain clearance from a tree stump during landing in mountainous terrain.NTSB CEN26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportJust JA-30 · Hartville, MOThe pilot’s failure to maintain clearance from a power line after takeoff.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 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 CEN26LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Topeka, KSThe student pilot’s failure to maintain situational awareness while taxiing which resulted in a collision with fence poles on either side of a gate which was not intended for airplanes.NTSB CEN26LA165Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Peyton, COThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing to a field.NTSB ANC26LA025Accident · No injuriesClass 4 · LimitedFinal reportAvid Avid Flyer · Anchorage, AKThe pilot’s failure to maintain directional control while maneuvering onto the runway for takeoff. Contributing to the accident was the presence of heavy, wet snow adjacent to the runway.NTSB WPR26LA146Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Chimney Rock, MTThe pilot’s failure to maintain adequate clearance from the terrain while performing a low altitude circling takeoff maneuver, which resulted in a dynamic rollover.NTSB ERA26LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Fellsmere, FLAn in-flight collision with a bird while descending to land at an airport.NTSB ERA26LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Mount Pleasant, SCThe airplane’s encounter with uneven terrain during takeoff, which resulted in a runway excursion and impact with water.NTSB ANC26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportWag Aero Sportsman · Cordova, AKThe pilot’s decision to land on an unsuitable snow-covered runway and his failure to maintain directional control during the landing roll which resulted in a nose over.NTSB ERA26LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Greenville, SCAn in-flight collision with a bird during cruise flight.NTSB ANC26LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Skwentna, AKThe pilot’s loss of directional control during landing roll due to contact with wind hardened snow berm and subsequent failure of main landing gear.NTSB ERA26LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Daytona Beach, FLAn in-flight collision with a bird while enroute.NTSB WPR26LA144Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Los Angeles, CAThe pilot’s failure to maintain adequate clearance from a jet blast fence during taxi.NTSB WPR26LA134Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage CUB-S · Young, AZThe pilot’s failure to maintain adequate clearance from trees during landing.NTSB DCA26LA159Accident · No injuriesClass 4 · LimitedFinal reportPyka Pelican Cargo · Summit Point, WVThe inaccurate obstacle height entered into mission planning that resulted in the aircraft wing’s impact with a tree during descent, resulting resulted in a loss of control.NTSB WPR26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportBrunner Donald G Kitfox · Rock Crossing, AZAn encounter with a downdraft while maneuvering at a low altitude, which resulted in an impact with terrain.NTSB ERA26LA149Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, FLAn in-flight collision with a bird during initial climb.