NTSB investigations

138 cases where NTSB found Task performance, general.

Cases, newest first

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\", '020600'))
  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 WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.Jan 4, 2011 · N90TY · 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 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 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 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 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 CEN11CA019Accident · No injuriesData collectionFinal reportCessna 195 · Midland, TXThe private pilot’s loss of control during the landing roll and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.Oct 2, 2010 · N4666T · Substantial damageNTSB ANC10LA083Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Tuluksak, AKThe pilot's delayed application of full power during a soft/wet field takeoff, resulting in a collision with trees during takeoff.Sep 4, 2010 · N9942M · Substantial damageNTSB CEN10CA516Accident · No injuriesData collectionFinal reportChampion 7KCAB · North Fork, NEThe student pilot's loss of directional control during landing, which resulted in a ground loop.Sep 2, 2010 · N1678G · Substantial damageNTSB CEN10LA487Accident · No injuriesLimited investigationFinal reportShpakow Thomas SA 750 · Brighton, COThe radio-controlled airplane operator’s decision to maneuver his airplane outside of the designated operating area, resulting in a collision with a bi-plane. Contributing to the accident was the lack of a formally designated spotter.Aug 14, 2010 · N28KT · Substantial damageNTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.Jul 31, 2010 · N46590 · 2 aircraft · Minor damageNTSB CEN10CA454Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Petersburg, TXThe pilot's failure to maintain clearance from a signpost during an aerial application flight.Jul 29, 2010 · N57706 · Substantial damageNTSB ERA10CA381Accident · No injuriesData collectionFinal reportCessna 172N · Stonington, METhe pilot's failure to maintain directional control during a crosswind landing.Jul 27, 2010 · N6410F · Substantial damageNTSB CEN10CA270Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Belton, TXThe pilot's loss of directional control during landing.May 27, 2010 · N817P · Substantial damageNTSB CEN10LA208Accident · Serious injuriesLimited investigationFinal reportReed William A Kitfox 4 · Baraboo, WIThe pilot's failure to compensate for wind gusts and maintain sufficient airspeed, which resulted in a stall.Apr 15, 2010 · N421KF · Substantial damageNTSB OPS10IA014Incident · No injuriesIncident investigationFinal reportBoeing 737 · Worton, MDThe R10/12 controller issued an improper vector and descent clearance to the GII that put the airplane on a coverging flight path with the B737. Contributing to the incident was the failure of the FAA's training program to correct ongoing controller…Mar 25, 2010 · N27239 · 2 aircraft · No damageNTSB CEN10CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Houston, TXThe student pilot's loss of directional control during takeoff, resulting in a dynamic rollover of the helicopter.Mar 13, 2010 · N822SH · Substantial damageNTSB WPR10FA223Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D1 · Skokomish, WAThe pilot's failure to maintain clearance from trees while flying over hilly, forested terrain.Oct 11, 2009 · N44362 · Substantial damageNTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.Aug 21, 2009 · N6038D · Substantial damageNTSB ERA09LA436Accident · Minor injuriesLimited investigationFinal reportEurocopter EC130 · Deer Isle, METhe pilot's loss of directional control during an out-of-ground-effect hover.Aug 1, 2009 · M-BOAT · Substantial damageNTSB ERA09LA371Accident · 1 fatalLimited investigationFinal reportLayson Stanley B Steen SKY Bolt · High Point, NCThe pilot’s failure to maintain clearance from power lines during takeoff.Jun 27, 2009 · N233VW · Substantial damageNTSB WPR09CA276Accident · No injuriesData collectionFinal reportCessna A185F · Wenatchee, WAThe pilot's misjudged approach and failure to attain the proper touchdown point.Jun 2, 2009 · N1015F · Substantial damageNTSB CEN09LA318Accident · Serious injuriesLimited investigationFinal reportAerostar International S-60A · Albuquerque, NMThe pilot's excessive descent rate.May 25, 2009 · N120RB · No damageNTSB ERA09LA238Accident · No injuriesLimited investigationFinal reportByron J. Moore Zealot · Clermont, FLA loss of engine power due to oil starvation as a result of the previous owner's improper servicing of the engine oil.Apr 9, 2009 · N61ZT · Substantial damageNTSB ERA09FA145Accident · 6 fatalField investigationFinal reportPiper PA-34-200T · Huntington, WV(1) The pilot’s failure to perform adequate preflight planning and to use available in flight resources in a timely manner and (2) his decision to continue visual-flight-rules flight in instrument meteorological conditions despite his lack of an instrument…Jan 30, 2009 · N8047C · DestroyedNTSB CEN09LA145Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Wichita, KSThe failure of line personnel to ensure that the airplane was serviced with the proper fuel. Contributing to the accident was the Federal Aviation Administration's approval of a Supplemental Type Certificate (STC) which allowed an improper fuel filler…Jan 30, 2009 · N345JB · Substantial damageNTSB WPR09LA010Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cougar, WAThe pilot's failure to maintain clearance between his external load and trees while maneuvering. Contributing to the accident were hilly terrain and trees.Oct 10, 2008 · N206CH · Substantial damageNTSB ANC09LA004Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe failure of both pilots to maintain adequate clearance/distance from each other at the taxiway intersection to avoid a collision. Contributing to the accident was a lack of clear and concise instruction to either airplane by the ground controller to…Oct 8, 2008 · N1229C · 2 aircraft · Substantial damageNTSB SEA08LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Napavine, WAThe pilot's decision to make a low-altitude pass, and his failure to maintain clearance from all structures while maneuvering.Sep 14, 2008 · N9268D · Substantial damageNTSB DEN08LA151Accident · No injuriesLimited investigationFinal reportBeech 1900D · St. Louis, MOThe ground crew's failure to ensure airplane clearance from the building while parking the airplane. Contributing to the accident was the flight crew's unprofessional behavior and the lack of marshaling procedures for the ground crew.Sep 7, 2008 · N122UX · Substantial damageNTSB OPS08IA014Incident · No injuriesIncident investigationFinal reportBoeing B744 · Atlantic OceanThe San Juan CERAP controllers failure to ensure the two aircraft were properly separated using non-radar separation standards.Aug 28, 2008 · UKNOWN · 2 aircraft · No damageNTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.Aug 24, 2008 · N5476P · Substantial damageNTSB DFW08LA197Accident · 1 fatalLimited investigationFinal reportMarshall James J Cozy MK IV · Midlothian, TXThe pilot's failure to maintain clearance from the wall of the rock quarry.Jul 24, 2008 · N500K · Substantial damageNTSB LAX08LA235Accident · No injuriesLimited investigationFinal reportExtra Flugzeugproduktions-und EA 300/L · San Jose, CAThe pilot of the other airplane's inadequate visual lookout and failure to maintain clearance from another airplane.Jul 20, 2008 · N981KM · 2 aircraft · Minor damageNTSB SEA08LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Big Creek, IDThe pilot's delayed decision to abort the landing and failure to achieve the proper touchdown point. Contributing to the accident was a high density altitude.Jul 7, 2008 · N5652Q · Substantial damageNTSB DFW08FA153Accident · 2 fatalField investigationFinal reportCessna 310Q · Steamboat, COThe pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.May 25, 2008 · N8187Q · DestroyedNTSB DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.Apr 28, 2008 · N477SH · Substantial damageNTSB DEN08CA056Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Alamogordo, NMThe unsuitable terrain for landing. Contributing to the accident were the pilot's encounter with turbulence and the loss of visual contact with the tow plane.Feb 9, 2008 · N223WP · Substantial damage