NTSB investigations, 2010

303 cases where NTSB found Physical environment.

Cases per year

20082026
NTSB investigations, 2010 per year, 2008–2026: 5,697 cases
2008604
2009361
2010303
2011244
2012265
2013274
2014379
2015332
2016421
2017457
2018431
2019396
2020251
2021221
2022198
2023186
2024172
2025129
202673

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.

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.Dec 31, 2010 · N702FW · Substantial damageNTSB CEN11CA139Accident · No injuriesData collectionFinal reportCessna 305A · Spooner, WIThe pilot's selection of unsuitable terrain for landing on a snow-covered lake.Dec 25, 2010 · N6897 · Substantial damageNTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.Dec 8, 2010 · N418PA · Substantial damageNTSB 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.Dec 5, 2010 · N9742Z · Substantial damageNTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.Nov 28, 2010 · N55HU · Substantial damageNTSB 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…Nov 24, 2010 · N614SK · Substantial damageNTSB WPR11LA056Accident · No injuriesLimited investigationFinal reportBell 407 · Riverdale, UTThe pilot's failure to maintain clearance from a highway marker sign while maneuvering.Nov 22, 2010 · N408UH · Substantial damageNTSB 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.Nov 22, 2010 · N718QS · No damageNTSB 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.Nov 22, 2010 · N6064N · Substantial damageNTSB ERA11LA071Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bluffton, SCAn in-flight upset of undetermined origin resulting in a forced landing.Nov 21, 2010 · N882AV · Substantial damageNTSB 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.Nov 18, 2010 · N273MA · Substantial damageNTSB CEN11LA076Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Roanoke, TXA loss of engine power for undetermined reasons.Nov 18, 2010 · N5481 · Substantial damageNTSB 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…Nov 17, 2010 · N25PJ · Substantial damageNTSB 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.Nov 15, 2010 · N155PH · Substantial damageNTSB CEN11LA072Accident · No injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Minneapolis, MNThe in-flight collision with a flock of birds during climb.Nov 15, 2010 · N604CZ · Substantial damageNTSB 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.Nov 14, 2010 · N747MT · Substantial damageNTSB ERA11CA072Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Andover, NJAn inadvertent collision with a deer on the runway during a night landing.Nov 13, 2010 · N15499 · Substantial damageNTSB 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.Nov 10, 2010 · N44956 · DestroyedNTSB WPR11LA042Accident · No injuriesLimited investigationFinal reportBombardier DHC-8-402 · Los Angeles, CAAn in-flight collision with a bird.Nov 8, 2010 · N422QX · Substantial damageNTSB 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.Nov 6, 2010 · N3215S · Substantial damageNTSB 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.Nov 6, 2010 · N6179Y · Substantial damageNTSB 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.Nov 6, 2010 · N178WW · Substantial damageNTSB 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.Nov 4, 2010 · N14511 · Substantial damageNTSB CEN11FA053Accident · 1 fatalField investigationFinal reportBell 206 · Meeker, COThe pilot's failure to maintain clearance from electrical power lines during the low-altitude flight.Nov 3, 2010 · N8533F · Substantial damageNTSB 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.Nov 2, 2010 · N3488L · Substantial damageNTSB 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…Nov 2, 2010 · N709BR · Substantial damageNTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.Nov 1, 2010 · N3542V · Substantial damageNTSB 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…Oct 30, 2010 · N765WH · Substantial damageNTSB WPR11CA033Accident · No injuriesData collectionFinal reportMedway Raven · Benson, AZThe pilot's inadequate evaluation of the runway condition and failure to maintain directional control during takeoff.Oct 27, 2010 · N75784 · Substantial damageNTSB 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.Oct 23, 2010 · N228KK · Substantial damageNTSB 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.Oct 23, 2010 · N2814D · Substantial damageNTSB 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.Oct 21, 2010 · N4247U · Substantial damageNTSB ERA11CA027Accident · No injuriesData collectionFinal reportPiper PA28 · Titusville, FLAn inadvertent collision with a deer during a night takeoff.Oct 19, 2010 · N9247V · Substantial damageNTSB CEN11TA027Accident · No injuriesFinal reportBeech A100 · Palestine, TXAn in-flight collision with a flock of birds while the airplane was descending through a cloud layer.Oct 18, 2010 · N1TR · Substantial damageNTSB 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.Oct 16, 2010 · N807PW · Substantial damageNTSB WPR11LA016Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, CAThe pilot's failure to maintain clearance from a transmission line during flight.Oct 14, 2010 · N2763M · Substantial damageNTSB ERA11LA015Accident · No injuriesLimited investigationFinal reportCessna 172SP · Boynton Beach, FLThe loss of engine power for undetermined reasons.Oct 10, 2010 · N423FT · Substantial damageNTSB 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.Oct 10, 2010 · N157SB · DestroyedNTSB 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.Oct 8, 2010 · N8437A · Substantial damageNTSB CEN11CA011Accident · Minor injuriesData collectionFinal reportCessna 175C · Humphrey, ARThe pilot’s failure to maintain clearance from a static wire while maneuvering at a low altitude.Oct 8, 2010 · N8323T · Substantial damageNTSB ERA11CA012Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLAn inadvertent in-flight collision with a bird.Oct 6, 2010 · N2074B · Substantial damageNTSB 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.Oct 4, 2010 · N85888 · Substantial damageNTSB ANC11CA002Accident · No injuriesData collectionFinal reportCessna 170B · Minto Flats, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control.Oct 3, 2010 · N2792C · Substantial damageNTSB WPR11CA008Accident · No injuriesData collectionFinal reportCessna 172N · Salem, ORThe pilot's failure to maintain directional control during the landing roll.Oct 2, 2010 · N545DS · Substantial damageNTSB CEN11CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Sparta, MIAn inadvertent collision with a deer during a night takeoff.Oct 2, 2010 · N759BJ · Substantial damageNTSB 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.Oct 2, 2010 · N4166M · Substantial damageNTSB 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.Oct 1, 2010 · N822MH · Substantial damageNTSB 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…Oct 1, 2010 · N262Y · Substantial damageNTSB 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.Sep 30, 2010 · N90SE · Substantial damageNTSB 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.Sep 29, 2010 · N6819L · Substantial damage