NTSB investigations, 2010
303 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 | 73 |
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 year(c.\"eventDate\") = 2010
AND 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 year(c."eventDate") = 2010 AND 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 WPR11TA083Accident · No injuriesFinal reportQuest Kodiak 100 · Reedsport, ORThe pilot's failure to maintain clearance from power lines during a low-level aerial observation flight. Contributing to the accident was pilot's failure to review a route hazards map prior to initiating the flight.NTSB CEN11CA139Accident · No injuriesData collectionFinal reportCessna 305A · Spooner, WIThe pilot's selection of unsuitable terrain for landing on a snow-covered lake.NTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.NTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.NTSB WPR11LA058Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Salt Lake City, UTThe tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…NTSB WPR11LA056Accident · No injuriesLimited investigationFinal reportBell 407 · Riverdale, UTThe pilot's failure to maintain clearance from a highway marker sign while maneuvering.NTSB WPR11IA055Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Jackson, WYThe flight crew's inability to stop the airplane during landing roll on a snow- and ice-contaminated runway. Contributing to the runway overrun were the deteriorating runway conditions.NTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11LA071Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bluffton, SCAn in-flight upset of undetermined origin resulting in a forced landing.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB CEN11LA076Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Roanoke, TXA loss of engine power for undetermined reasons.NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…NTSB WPR11LA048Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369D · Salem, ORThe pilot’s failure to maintain clearance between the longline and trees, which resulted in the longline snagging a tree and then recoiling into the main rotor blades and a subsequent loss of helicopter control.NTSB CEN11LA072Accident · No injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Minneapolis, MNThe in-flight collision with a flock of birds during climb.NTSB WPR11FA047Accident · 1 fatalField investigationFinal reportBeech C35 · Enterprise, ORThe noninstrumented pilot’s inadequate weather planning, which resulted in his failure to maintain visual flight while maneuvering under low ceilings in rainy and foggy conditions and his subsequent failure to maintain clearance from mountainous terrain.NTSB ERA11CA072Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Andover, NJAn inadvertent collision with a deer on the runway during a night landing.NTSB CEN11TA064Accident · Minor injuriesFinal reportPartenavia P.68 · Anthony, NMThe pilot's decision to conduct a low-level flight in mountainous terrain in an area where downdrafts were prevalent, resulting in the inadvertent loss of control and the collision with the terrain.NTSB WPR11LA042Accident · No injuriesLimited investigationFinal reportBombardier DHC-8-402 · Los Angeles, CAAn in-flight collision with a bird.NTSB WPR11LA039Accident · Serious injuriesLimited investigationFinal reportLansdorf Qualt · Sonoma, CAA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR11LA038Accident · No injuriesLimited investigationFinal reportCessna T210N · Baggs, WYThe failure of a connecting rod cap retaining bolt during cruise flight, which resulted in a loss of engine power.NTSB WPR11CA041Accident · No injuriesData collectionFinal reportAviat A-1B · Heber City, UTThe pilot's failure to maintain clearance from the ground during low-level maneuvering in mountainous/hilly terrain.NTSB WPR11CA037Accident · No injuriesData collectionFinal reportCessna 172S · Port Townsend, WAThe pilot's improper flare/touchdown while landing, resulting in a loss of directional control and a runway excursion.NTSB CEN11FA053Accident · 1 fatalField investigationFinal reportBell 206 · Meeker, COThe pilot's failure to maintain clearance from electrical power lines during the low-altitude flight.NTSB WPR11CA034Accident · No injuriesData collectionFinal reportCessna U206B · Cascade, IDThe pilot's failure to maintain clearance from terrain during a turn onto the final approach leg of the traffic pattern.NTSB CEN11LA051Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe pickup truck driver’s failure to follow airport and company policies regarding ground vehicle operations, which allowed for the unattended truck to collide with the airplane. Contributing to the accident were the truck's misadjusted shift lever and…NTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.NTSB ERA11FA042Accident · 1 fatalField investigationFinal reportMD Helicopters 369E · Thomas, WVThe pilot's failure to clear the helicopter and its external load from surrounding structures and his failure to execute a timely release of the external load, which resulted in an inadvertent entanglement and collision with wires and terrain. Contributing to…NTSB WPR11CA033Accident · No injuriesData collectionFinal reportMedway Raven · Benson, AZThe pilot's inadequate evaluation of the runway condition and failure to maintain directional control during takeoff.NTSB WPR11LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Dorrington, CAThe pilot’s failure to use carburetor heat while cruising in carburetor icing conditions, which resulted in a loss of engine power.NTSB CEN11CA036Accident · Minor injuriesData collectionFinal reportFrederick R Goenne Glastar · Recklaw, TXThe pilot's failure to maintain directional control during the landing roll on a rough runway surface.NTSB WPR11CA023Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Fort Hunter Liggett, CAThe pilot's misjudged glide path, which resulted in a runway undershoot and collision with terrain during landing.NTSB ERA11CA027Accident · No injuriesData collectionFinal reportPiper PA28 · Titusville, FLAn inadvertent collision with a deer during a night takeoff.NTSB CEN11TA027Accident · No injuriesFinal reportBeech A100 · Palestine, TXAn in-flight collision with a flock of birds while the airplane was descending through a cloud layer.NTSB WPR11LA017Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 90A · Cottonwood, AZThe paraglider pilot's failure to see and avoid the hot air balloon, which resulted in a midair collision.NTSB WPR11LA016Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, CAThe pilot's failure to maintain clearance from a transmission line during flight.NTSB ERA11LA015Accident · No injuriesLimited investigationFinal reportCessna 172SP · Boynton Beach, FLThe loss of engine power for undetermined reasons.NTSB CEN11CA010Accident · Minor injuriesData collectionFinal reportMartin Curtis Zenair CH701 SP · Lonsdale, MNThe pilot's failure to maintain clearance from a power line while on approach to land.NTSB WPR11FA005Accident · 2 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's decision to conduct a low-level flight into a canyon in windy conditions at a high density altitude, which resulted in a collision with trees and terrain.NTSB CEN11CA011Accident · Minor injuriesData collectionFinal reportCessna 175C · Humphrey, ARThe pilot’s failure to maintain clearance from a static wire while maneuvering at a low altitude.NTSB ERA11CA012Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLAn inadvertent in-flight collision with a bird.NTSB ERA11CA007Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Taylorsville, KYThe pilot’s failure to maintain clearance from an unmarked power line during the final approach to land.NTSB ANC11CA002Accident · No injuriesData collectionFinal reportCessna 170B · Minto Flats, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control.NTSB WPR11CA008Accident · No injuriesData collectionFinal reportCessna 172N · Salem, ORThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Sparta, MIAn inadvertent collision with a deer during a night takeoff.NTSB ANC11CA001Accident · No injuriesData collectionFinal reportPiper PA-12 · Chena Hot Springs, AKThe pilot's inadequate compensation for the wind conditions during landing, which resulted in a loss of directional control and collision with trees.NTSB WPR10LA481Accident · No injuriesLimited investigationFinal reportEurocopter EC130 · Meadview, AZThe pilot's distraction with another departing helicopter while maneuvering in a hover for departure, which resulted in his failure to maintain clearance between the tail rotor and an umbrella.NTSB ERA11FA001Accident · Minor injuriesField investigationFinal reportCessna 550 · Manteo, NCThe pilot-in-command's failure to maintain proper airspeed and his failure to initiate a go-around, which resulted in the airplane touching down too fast on a short, wet runway and a subsequent runway overrun. Contributing to the accident was the copilot's…NTSB WPR10LA479Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Spokane, WAThe failure of a manufacturing splice of the right main landing gear tire’s inner tube, which resulted in a deflated tire and a consequent loss of directional control on landing.NTSB ANC10CA103Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe student pilot's selection of unsuitable terrain for an off-airport landing, resulting in the airplane nosing over.