NTSB investigations

204 cases where NTSB found Airport facilities/design.

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\", '030170'))
  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 WPR17LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-260 · Mukilteo, WAThe improper maintenance of the carburetor, which resulted in a stuck float and a partial loss of engine power during takeoff.May 2, 2017 · N3457W · Substantial damageNTSB GAA17CA185Accident · No injuriesData collectionFinal reportPipistrel Doo Ajdovscina Virus · Okmulgee, OKThe pilot’s failure to review the Federal Aviation Administration chart supplement before landing, which resulted in his landing on a closed runway and collision with a fence. Contributing to the accident was the airport’s failure to adequately mark the…Mar 11, 2017 · N345M · Substantial damageNTSB WPR17LA019Accident · Serious injuriesLimited investigationFinal reportBell 206B · Yuma, AZThe pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.Nov 11, 2016 · N914HH · Substantial damageNTSB GAA17CA063Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Flugzeugbau DUO Discus · Port Matilda, PAThe bystander's decision to walk onto the runway, which resulted in him being struck by the glider's left wing.Nov 5, 2016 · N484KS · No damageNTSB GAA16CA396Accident · Minor injuriesData collectionFinal reportCessna 150 · Williamsburg, VAAn evasive maneuver during the landing flare to avoid deer on the runway, which resulted in a collision with trees and terrain during a go-around. Contributing to the accident was the lack of an airport perimeter fence.Jul 27, 2016 · N18228 · Substantial damageNTSB GAA16CA389Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Hyannis, MAThe pilot's failure to maintain an appropriate descent rate during landing, which resulted in a hard landing, followed by a loss of directional control, runway excursion, and an impact with a security fence and vehicles during the subsequent attempt to abort…Jul 24, 2016 · N799MR · Substantial damageNTSB GAA16CA304Accident · No injuriesData collectionFinal reportCessna 120 · Climax, NCAn evasive maneuver during the landing roll to avoid deer on the runway, which resulted in a runway excursion and a nose over. Contributing to the accident was the lack of an airport perimeter fence.Jun 10, 2016 · N77216 · Substantial damageNTSB GAA16CA280Accident · No injuriesData collectionFinal reportStaudacher S 300 · Prospect Heights, ILThe pilot's incorrect pitch control during the landing, which resulted in a hard bounced landing, and subsequent left main landing gear collapse, a runway excursion, and a collision with a runway sign.Jun 3, 2016 · N126RG · Substantial damageNTSB CEN16LA182Accident · 1 fatalLimited investigationFinal reportBell 47G 3B 1 · Portia, ARThe pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…May 13, 2016 · N48316 · Substantial damageNTSB GAA16CA251Accident · No injuriesData collectionFinal reportCirrus SR22 · Church Hill, MDThe pilot's decision to land on an unlighted grass airstrip at night, resulting in landing long, a loss of directional control, and collapsed landing gear producing substantial damage to the landing gear attachment point and left wing.Apr 21, 2016 · N27ML · Substantial damageNTSB GAA16CA109Accident · Minor injuriesData collectionFinal reportCessna CE-208 · Hooper Bay, AKThe pilot's failure to identify the runway, resulting in the airplane touching down a few feet to the right of the runway.Jan 15, 2016 · N104AN · Substantial damageNTSB GAA16CA097Accident · No injuriesData collectionFinal reportCessna 175 · Seeley Lake, MTThe pilot' failure to identify the plowed runway width in dusk and flat light conditions, which resulted in a touchdown left of the runway center, an impact with a snow berm, and a ground loop.Jan 5, 2016 · N9493B · Substantial damageNTSB DCA16LA032Accident · No injuriesLimited investigationFinal reportBoeing 737 3H4 · Nashville, TNthe flight crew's early turn towards the assigned gate because taxiway lighting had been inadvertently turned off by the controller-in-charge which resulted in the airplane leaving the paved surface. Contributing to the accident was the operation of the…Dec 15, 2015 · N649SW · Substantial damageNTSB GAA16LA056Accident · No injuriesLimited investigationFinal reportAirbus EC135 · Apple Valley, CAThe ingestion of a towel from an unsecured storage container at the landing site into the helicopter's fenestron during the landing.Nov 19, 2015 · N36RX · Substantial damageNTSB GAA16CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Ketchikan, AKThe pilot's failure to maintain directional control during the engine start sequence, which resulted in the helicopter sliding on a steel deck and impacting a crane. Contributing to the accident was the absence of traction material on the helicopter…Oct 6, 2015 · N779DZ · Substantial damageNTSB GAA16CA005Accident · No injuriesData collectionFinal reportRaytheon A36 · Monterey, CAThe pilot's failure to see and avoid runway signage during taxi after landing, resulting in a collision and substantial damage to the left wing of the airplane.Oct 6, 2015 · N53WW · Substantial damageNTSB CEN15LA418Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Platteville, WIThe partial loss of right engine power for undetermined reasons with insufficient runway remaining for the aborted takeoff.Sep 21, 2015 · N813CA · Substantial damageNTSB GAA15CA263Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Doylestown, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane. Contributing to the accident was the pilot's fatigue during the flight.Sep 7, 2015 · N1125X · Substantial damageNTSB CEN15LA417Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Pekin, INThe pilot's loss of directional control during the landing roll due to contact with a corn crop that extended into the runway area. Contributing to the accident were the lack of accurate available information to the pilot regarding the runway condition, the…Sep 5, 2015 · N67296 · Substantial damageNTSB GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.Jul 19, 2015 · N45508 · Substantial damageNTSB GAA15CA173Accident · No injuriesData collectionFinal reportCessna 182 · Athens, TNThe failure of the taxiway surface due to a sink hole, which resulted in the right main landing gear sinking into terrain causing substantial damage to the fuselage.Jul 6, 2015 · N234CF · Substantial damageNTSB GAA15CA163Accident · No injuriesData collectionFinal reportGates Learjet 35A · Grosse Ile, MIThe airplane's collision with a deer on the unfenced runway during the takeoff roll. Contributing to the accident is the airport's failure to establish a continuous fence between the runway and the nature conservancy.Jun 22, 2015 · N640BA · Substantial damageNTSB CEN15LA229Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Chesterfield, MOThe collision of the helicopter's skid shoe with the runway centerline light during landing, which abruptly stopped the helicopter and resulted in damage to the fuselage.May 7, 2015 · N127AE · Substantial damageNTSB GAA15CA013Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Lake Hamilton, ARThe pilot's overcorrection to the landing pad shifting, which resulted in the helicopter impacting trees. A factor contributing to the accident was the collapse of the landing pad.Mar 21, 2015 · N701CT · Substantial damageNTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.Mar 10, 2015 · N42667 · Substantial damageNTSB CEN14LA493Accident · No injuriesLimited investigationFinal reportDavis Benny Christen Eagle II · Vinton, IAThe pilot's loss of directional control during landing after the airplane encountered uneven pavement at the intersection with a crossing runway.Sep 3, 2014 · N229HP · Substantial damageNTSB CEN14FA462Accident · 4 fatalField investigationFinal reportCessna 421C · Las Cruces, NMThe misfueling of the airplane with jet fuel instead of the required aviation fuel, and the resultant detonation and a total loss of engine power during initial climb. Contributing to the accident were the line service technician's inadvertent misfueling of…Aug 28, 2014 · N51RX · DestroyedNTSB CEN14FA396Accident · Serious injuriesField investigationFinal reportRender RV 9A · Oshkosh, WIThe pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.Jul 30, 2014 · N82PR · Substantial damageNTSB WPR14CA314Accident · No injuriesData collectionFinal reportCessna 182Q · Warren, IDThe pilot's attempt to depart on an unpaved road, which he mistook for the unpaved runway. Contributing to the accident was the fact that the road and the runway were conjoined for the first few hundred feet of the runway.Jul 26, 2014 · N624M · Substantial damageNTSB CEN14LA390Accident · No injuriesLimited investigationFinal reportBell 206B · Bennet, NEA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.Jul 26, 2014 · N240SJ · Substantial damageNTSB ANC14CA037Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe airplane's encounter with a tailwind during takeoff from a short, narrow airstrip, which resulted in a loss of lift and collision with brush and small trees.Jun 4, 2014 · N3442D · Substantial damageNTSB CEN14LA251Accident · Serious injuriesLimited investigationFinal reportSmythe Donald F Kitfox Classic IV · Slaughter, LAThe pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.May 24, 2014 · N998DS · Substantial damageNTSB CEN14CA330Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8E · Douglass, KSThe pilot's excessive use of wheel brakes during landing, which resulted in a nose-over. Contributing to the accident were high winds and a short, downhill sloped runway.May 19, 2014 · N2649K · Substantial damageNTSB CEN14CA238Accident · No injuriesData collectionFinal reportAmerican Legend AL-3 · Osage, ARThe pilot's repeated attempts to take off from an unimproved field with tall grass.May 10, 2014 · N907DC · Substantial damageNTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…May 4, 2014 · N68828 · DestroyedNTSB ERA14CA039Accident · No injuriesData collectionFinal reportTaylorcraft BC 65 · Fallston, MDThe pilot's failure to maintain directional control during landing resulting in collision with equipment off the side of the runway. Contributing to the accident was the pilot's intentional landing on a closed runway with a tailwind.Nov 4, 2013 · N52CW · Substantial damageNTSB ERA14CA037Accident · No injuriesData collectionFinal reportPiper PA 28-150 · Newport, NHThe pilot's incorrect glide path, which resulted in a landing area overshoot and a runway excursion.Oct 14, 2013 · N5873W · Substantial damageNTSB CEN13LA570Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Algona, IAFuel exhaustion as a result of the pilot's failure to ensure he had sufficient fuel on board to complete the planned flight. Contributing to the accident was the incomplete information provided by the airport's AWOS.Sep 30, 2013 · N31688 · Substantial damageNTSB CEN13CA545Accident · No injuriesData collectionFinal reportSwedener Rans S-6ES · Mullen, NEThe gopher holes and soft terrain the airplane encountered, which resulted in the airplane nosing over.Sep 10, 2013 · N611WE · Substantial damageNTSB ERA13CA394Accident · No injuriesData collectionFinal reportHoskins Samuel R Quickie Q2 · Zelienople, PAThe pilot's loss of directional control during takeoff due to right main landing gear contact with a pool of standing water on the runway which resulted in a runway excursion.Aug 30, 2013 · N202SH · Substantial damageNTSB ERA13CA317Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Bronston, KYThe pilot’s failure to maintain airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s reduced climb performance due to density altitude, as well as the pilot’s decision to initiate the takeoff from…Jul 8, 2013 · N44293 · Substantial damageNTSB ERA13LA311Accident · No injuriesLimited investigationFinal reportCessna 172M · Burlington, VTThe pilot's improper turn down an airport access road while attempting to taxi to a runway. Contributing to the accident was the airport management's failure to install proper signage indicating that an airport access road was prohibited to aircraft.Jun 19, 2013 · N61947 · Substantial damageNTSB CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.Apr 22, 2013 · N6369V · DestroyedNTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.Feb 17, 2013 · N4426C · Substantial damageNTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…Nov 21, 2012 · N40781 · Substantial damageNTSB WPR13GA044Accident · Minor injuriesFinal reportBell OH-58 · Altadena, CAThe landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…Nov 17, 2012 · N911FA · 2 aircraft · Substantial damageNTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…Nov 3, 2012 · N985GE · Substantial damageNTSB WPR12CA375Accident · No injuriesData collectionFinal reportCessna 172 · Sand Point, IDA deer strike during the landing flare. Contributing to the accident was the airport’s lack of any deer incursion prevention measures, such as an airport perimeter fence.Aug 28, 2012 · N3082E · Substantial damageNTSB CEN12LA565Accident · No injuriesLimited investigationFinal reportKolb MK-3 · Onondaga, MIThe noncertificated pilot's inadequate preflight planning, which resulted in landing on a runway of inadequate length and subsequent runway excursion.Aug 19, 2012 · N520SK · Substantial damageNTSB CEN12CA568Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Bogata, TXThe pilot’s inadequate preflight planning, which resulted in the airplane’s loading beyond its maximum gross weight.Aug 17, 2012 · N6047G · Substantial damage