NTSB investigations, 2010

658 cases where NTSB found Task performance.

Cases per year

20082026
NTSB investigations, 2010 per year, 2008–2026: 13,694 cases
2008642
2009857
2010658
2011761
2012843
2013717
2014840
2015809
2016857
2017848
2018852
2019825
2020689
2021701
2022722
2023681
2024667
2025494
2026231

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\", '0206'))
  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 WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.Dec 31, 2010 · N67F · Substantial damageNTSB ERA11LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Wimauma, FLThe mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…Dec 31, 2010 · N28BA · Substantial damageNTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…Dec 30, 2010 · N9103N · Substantial damageNTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…Dec 29, 2010 · N668AA · No damageNTSB CEN11CA136Accident · Minor injuriesData collectionFinal reportAero Commander 500-B · Columbus, OHThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion.Dec 28, 2010 · N888CA · Substantial damageNTSB ERA11CA170Accident · No injuriesData collectionFinal reportCessna 195 · Williamson, GAThe pilot's inadvertent application of the brakes during a bounced landing resulting in a nose over.Dec 27, 2010 · N3464V · Substantial damageNTSB ENG11IA011Incident · No injuriesIncident investigationFinal reportBoeing 737 · San Francisco, CAThe probable cause of the undercowl in-flight engine fire was the insufficient installation torque of the bolts that secure the fuel manifold cover to the fuel manifold. Engine vibrations and fuel pressure cycles caused the bolts to gradually loosen further…Dec 25, 2010 · N248WN · No damageNTSB WPR11LA080Accident · Serious injuriesLimited investigationFinal reportSchaefer Kitfox 4 · Glendale, AZThe pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…Dec 23, 2010 · N95FT · Substantial damageNTSB ERA11FA095Accident · 1 fatalField investigationFinal reportMooney M20R · Dundee, NYThe pilot's decision to operate in known moderate-to-severe icing conditions, which resulted in a loss of control during approach.Dec 23, 2010 · N968SM · Substantial damageNTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.Dec 23, 2010 · N385ME · Substantial damageNTSB ANC11CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Clear, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to water/ice in the fuel system.Dec 23, 2010 · N40283 · Substantial damageNTSB WPR11FA082Accident · 3 fatalField investigationFinal reportAero Commander 114B · Lander, WYThe non-instrument-rated pilot's decision to continue visual flight in instrument or marginal visual meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of…Dec 22, 2010 · N799RS · Substantial damageNTSB WPR11CA079Accident · No injuriesData collectionFinal reportMoyes Bailey Microlite · Newberg, ORThe pilot's improper recovery from a dive, which resulted in a loss of control.Dec 22, 2010 · N7008Z · Substantial damageNTSB CEN11FA125Accident · 1 fatalField investigationFinal reportBeech C24R · Wheeling, ILThe installation of the wrong engine-driven fuel pump, which resulted in a loss of engine power during takeoff, and the pilot's subsequent decision to turn back toward the airport at an insufficient altitude to complete the maneuver. Contributing to the…Dec 22, 2010 · N5293M · Substantial damageNTSB CEN11FA124Accident · 2 fatalField investigationFinal reportMooney M20E · Colorado Springs, COThe pilot’s decision to initiate an approach into weather conditions where the ceiling and visibility were below the minimums for the approach and where reported icing existed, in an airplane not certified for flight in icing conditions, and his failure to…Dec 22, 2010 · N79869 · Substantial damageNTSB CEN11CA128Accident · No injuriesData collectionFinal reportCessna 340A · Madison, WIThe pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…Dec 21, 2010 · N233DS · Substantial damageNTSB CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.Dec 21, 2010 · N9317G · Substantial damageNTSB CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.Dec 19, 2010 · N5437M · Substantial damageNTSB ERA11LA093Accident · Serious injuriesLimited investigationFinal reportCessna 182 · West Milford, NJThe pilot's delayed application of carburetor heat while taking off in weather conditions conducive to serious carburetor icing, which resulted in a partial loss of engine power.Dec 18, 2010 · N1462M · Substantial damageNTSB DCA11CA014Accident · No injuriesData collectionFinal reportBoeing 737-7H4 · Philadelphia, PAthe failure of the ground operations personnel to maintain awareness of the relative position of the two airplanes.Dec 18, 2010 · N913WN · 2 aircraft · Substantial damageNTSB CEN11LA148Accident · No injuriesLimited investigationFinal reportBeech H35 · Des Moines, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Dec 18, 2010 · N5537D · Substantial damageNTSB CEN11LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lake Elmo, MNThe pilot's improper fuel management which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the distraction of the cabin depressurization.Dec 18, 2010 · N92358 · Substantial damageNTSB CEN11LA109Accident · Minor injuriesLimited investigationFinal reportCessna T182T · Moline, ILThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and noseover.Dec 16, 2010 · N2187H · Substantial damageNTSB WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.Dec 13, 2010 · N36041 · Substantial damageNTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.Dec 13, 2010 · N361DS · Substantial damageNTSB WPR11CA077Accident · No injuriesData collectionFinal reportCessna 177 · Corona, CAThe pilot’s improper flare, which resulted in a hard landing.Dec 12, 2010 · N2262Y · Substantial damageNTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.Dec 11, 2010 · N4326H · Substantial damageNTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.Dec 10, 2010 · N206K · 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 CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.Dec 7, 2010 · N888VM · Substantial damageNTSB ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.Dec 4, 2010 · N271NE · Minor damageNTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.Dec 2, 2010 · N9145H · Substantial damageNTSB WPR11LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Wittmann, AZThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 1, 2010 · N4122F · Substantial damageNTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.Nov 30, 2010 · N1860P · Substantial damageNTSB ERA11CA092Accident · No injuriesData collectionFinal reportHaeussler Ray Sonex · Buffalo, NYThe pilot's failure to maintain directional control during takeoff due to his abrupt advancing of the throttle.Nov 29, 2010 · N469SA · 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 CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.Nov 27, 2010 · N4541L · Substantial damageNTSB WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.Nov 26, 2010 · N74400 · Substantial damageNTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.Nov 25, 2010 · VH-PPA · 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 WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.Nov 24, 2010 · N459CT · Substantial damageNTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.Nov 24, 2010 · N548C · Substantial damageNTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.Nov 24, 2010 · N4428Q · DestroyedNTSB 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 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 ERA11CA069Accident · No injuriesData collectionFinal reportCessna 172G · Winter Haven, FLThe pilot's inadequate preflight/inflight fuel planning resulting in fuel exhaustion and total loss of engine power.Nov 21, 2010 · N3700L · Substantial damageNTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.Nov 18, 2010 · N314DP · 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 WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…Nov 17, 2010 · N978CT · Substantial damage