NTSB investigations, 2017

163 cases where the sequence of events included Attempted remediation/recovery.

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 year(c.\"eventDate\") = 2017
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA17LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Suffolk, NYA loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.Jun 12, 2017 · N13306 · Substantial damageNTSB GAA17CA351Accident · No injuriesData collectionFinal reportCessna 172 · Lawrence, KSThe student pilot's incorrect control application during landing after a simulated engine failure, which resulted in a hard, bounced landing, and the flight instructor's delayed action to perform a go-around in gusting wind conditions.Jun 10, 2017 · N99HV · Substantial damageNTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.Jun 9, 2017 · N32088 · Substantial damageNTSB ANC17LA028Accident · Minor injuriesClass 2 · LimitedFinal reportCessna 172 · Chugiak, AKThe pilot's improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Jun 6, 2017 · N35700 · Substantial damageNTSB GAA17CA317Accident · No injuriesData collectionFinal reportCessna 177 · Guttenberg, IAThe pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.Jun 3, 2017 · N34462 · Substantial damageNTSB GAA17CA313Accident · No injuriesData collectionFinal reportCessna A185 · Clovis, NMThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.May 31, 2017 · N185FF · Substantial damageNTSB GAA17CA314Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Logan, UTThe pilot’s failure to maintain directional control during the landing roll due to the high placement of his feet on the rudder pedals, which led to the inadvertent application of the brakes.May 30, 2017 · N533AL · Substantial damageNTSB WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…May 27, 2017 · N6832D · Substantial damageNTSB ERA17LA194Accident · No injuriesLimited investigationFinal reportAvions Mudry Cie CAP 231 · Lebanon, PAThe partial separation of one counterweight and the subsequent seizure of the engine due to mechanical interference. Contributing to the partial separation of the counterweight was the overstress fracture of a retaining ring and the fatigue fracture of the…May 27, 2017 · N231X · Substantial damageNTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.May 24, 2017 · N708PV · Substantial damageNTSB GAA17CA304Accident · No injuriesData collectionFinal reportMaule MX7 · Sidney, METhe pilot’s delayed application of rudder and failure to maintain directional control during takeoff.May 23, 2017 · N888WF · Substantial damageNTSB GAA17CA298Accident · No injuriesData collectionFinal reportSchweizer SGS233 · Springfield, VTThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway in trees.May 20, 2017 · N1242S · Substantial damageNTSB ERA17LA188Accident · Minor injuriesLimited investigationFinal reportMaule M7 · Colton, NYThe pilots' initiation of an uncoordinated right turn with the fuel selector positioned to the right main fuel tank, which had a low quantity of fuel in it and resulted in a total loss of engine power due to the unporting of the fuel and subsequent fuel…May 20, 2017 · N126MC · Substantial damageNTSB GAA17CA281Accident · No injuriesData collectionFinal reportPiper PA22 · South Boston, VAThe pilot’s failure to maintain directional control during the landing roll.May 15, 2017 · N31JP · Substantial damageNTSB ANC17CA023Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL 104 Wilga 80 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the pilot's lack of training and experience in the accident make and model airplane.May 14, 2017 · N9726N · Substantial damageNTSB CEN17LA182Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Weatherford, TXThe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall/spin.May 13, 2017 · N616NG · Substantial damageNTSB CEN17LA181Accident · 1 fatalLimited investigationFinal reportAS+ AC 4 · Blair, NEThe pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.May 13, 2017 · N358R · Substantial damageNTSB GAA17CA263Accident · No injuriesData collectionFinal reportPiper PA28R · Frankfort, KYThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll in gusting crosswind conditions.May 7, 2017 · N33006 · Substantial damageNTSB CEN17LA176Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Gypsum, KSA total loss of engine power during a low-altitude agricultural application flight for reasons that could not be determined during detailed examinations. Contributing to the accident was the pilot’s failure to follow the airplane manufacturer's emergency…May 5, 2017 · N3045R · Substantial damageNTSB GAA17CA283Accident · No injuriesData collectionFinal reportCessna 172 · Atlanta, GAThe student’s incorrect use of the go-around procedure, which resulted in an aerodynamic stall, and the flight instructor’s delayed remedial action.May 2, 2017 · N704RB · Substantial damageNTSB GAA17CA253Accident · No injuriesData collectionFinal reportCirrus SR20 · Lakewood, NJThe student pilot’s failure to adequately compensate for crosswind conditions during a go-around and the flight instructor’s delayed remedial action.May 1, 2017 · N68VY · Substantial damageNTSB GAA17CA254Accident · No injuriesData collectionFinal reportCessna 172 · Columbia, KYThe pilot’s failure to maintain a flare during landing in variable, gusting wind conditions.Apr 28, 2017 · N64144 · Substantial damageNTSB GAA17CA211Accident · No injuriesData collectionFinal reportMooney M20J · Cedar Key, FLThe pilot’s failure to follow the manufacturer’s go-around procedure, which resulted in an aerodynamic stall.Apr 28, 2017 · N1157N · Substantial damageNTSB GAA17CA246Accident · No injuriesData collectionFinal reportThomas B Mcgrath JA30 Superstol · Chesterfield, MOThe pilot’s failure to maintain directional control of the airplane during the landing roll in crosswind conditions.Apr 24, 2017 · N614WB · Substantial damageNTSB ERA17LA166Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Ovid, NYThe mechanic's failure to inspect and clean the carburetor fuel inlet screen during the airplane’s annual inspection, which allowed undetected debris and dirt to obstruct the fuel supply and resulted in fuel starvation and the subsequent total loss of engine…Apr 23, 2017 · N9907B · Substantial damageNTSB GAA17CA240Accident · Minor injuriesData collectionFinal reportParlette Robert L Glastar · Wenatchee, WAThe pilot’s improper landing flare and subsequent failure to adequately compensate for gusting wind conditions during a go-around.Apr 21, 2017 · N661RP · Substantial damageNTSB ERA17LA160Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankeetown, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation.Apr 20, 2017 · N6013E · Substantial damageNTSB GAA17CA231Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot’s failure to maintain directional control during the landing roll with crosswind conditions.Apr 12, 2017 · N2144Z · Substantial damageNTSB GAA17CA232Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.Apr 11, 2017 · N92873 · Substantial damageNTSB GAA17CA222Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Avalon, CAThe pilot’s failure to maintain the runway heading and the improper landing flare during landing.Apr 9, 2017 · N54EB · Substantial damageNTSB GAA17CA224Accident · No injuriesData collectionFinal reportStinson 108 · Woodruff, WIThe pilot receiving instruction's incorrect brake usage and failure to maintain directional control during the landing roll.Apr 7, 2017 · N9363K · Substantial damageNTSB GAA17CA220Accident · No injuriesData collectionFinal reportShilt Jerry C F-1 Rocket · Bessimer, ALThe pilot’s failure to maintain directional control during the landing rollout in gusting crosswind conditions.Apr 7, 2017 · N3839Y · Substantial damageNTSB GAA17CA218Accident · No injuriesData collectionFinal reportBell 206 · La Verne, CAThe pilot’s early increased application of the collective during a simulated hovering autorotation, which resulted in a loss of rotor rpm and subsequent main rotor blade strike of the tailboom.Apr 6, 2017 · N206SA · Substantial damageNTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.Apr 5, 2017 · N81173 · Substantial damageNTSB GAA17CA209Accident · No injuriesData collectionFinal reportCessna 140 · St. Petersburg, FLThe pilot receiving instruction’s overcorrection with rudder during the landing roll, which resulted in a ground loop and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.Mar 28, 2017 · N7838B · Substantial damageNTSB GAA17CA210Accident · No injuriesData collectionFinal reportPiper PA22 · Soldotna, AKThe pilot’s unstabilized approach and failure to attain the proper touchdown point, which resulted in a runway overrun and collision with a snowbank.Mar 27, 2017 · N2838Z · Substantial damageNTSB GAA17CA203Accident · No injuriesData collectionFinal reportAeronca 11AC · Warroad, MNThe pilot’s improper landing flare and his subsequent failure to maintain directional control during the landing in tailwind conditions.Mar 25, 2017 · N9595E · Substantial damageNTSB GAA17CA202Accident · Minor injuriesData collectionFinal reportCessna 182 · Mackay, IDThe pilot's decision to maneuver the airplane over mountainous terrain in high-density altitude conditions, which resulted in the airplane’s inability to maintain altitude or establish a climb.Mar 25, 2017 · N52743 · Substantial damageNTSB GAA17CA193Accident · No injuriesData collectionFinal reportPiper PA 12 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff, which resulted in a ground loop.Mar 19, 2017 · N92544 · Substantial damageNTSB GAA17CA195Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Mosby, MOThe student pilot's failure to maintain directional control during an attempted go-around.Mar 17, 2017 · N423SA · Substantial damageNTSB GAA17CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 208 · Kalaupapa, HIThe pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.Mar 11, 2017 · N865MA · Substantial damageNTSB GAA17CA192Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot’s decision to land with a crosswind that exceeded the airplane’s demonstrated capability, which resulted in the airplane banking left and the wing striking the ground.Mar 7, 2017 · N703TP · Substantial damageNTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.Mar 3, 2017 · N2892Y · Substantial damageNTSB GAA17CA170Accident · No injuriesData collectionFinal reportMaule M5 · Roxbury, KSThe pilot’s failure to maintain directional control during a go-around.Mar 2, 2017 · N56552 · Substantial damageNTSB GAA17CA158Accident · No injuriesData collectionFinal reportSocata TBM700 · Bellingham, WAThe pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.Feb 27, 2017 · CGWVS · Substantial damageNTSB ERA17FA115Accident · 2 fatalField investigationFinal reportRyan Navion · Westhampton Beach, NYThe flight instructor's exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall/spin. Contributing to the accident was the flight instructor's failure to familiarize himself with the flight characteristics of the…Feb 26, 2017 · N4529K · DestroyedNTSB WPR17LA067Accident · Minor injuriesLimited investigationFinal reportGuarino Vans · Marysville, CAA partial loss of engine power for reasons that could not be determined due to the fragmentation of the electrical system.Feb 24, 2017 · N470LM · Substantial damageNTSB GAA17CA154Accident · No injuriesData collectionFinal reportCessna 180 · Bally, PAThe pilot’s failure to maintain directional control during takeoff in crosswind conditions.Feb 19, 2017 · N123GT · Substantial damageNTSB ERA17LA110Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Bayonne, NJMaintenance personnel’s incorrect installation of the No. 3 cylinder’s hydraulic valve tappet plunger, which resulted in a failure of the No. 3 cylinder’s intake valve and the subsequent partial loss of engine power.Feb 19, 2017 · N15745 · Substantial damageNTSB GAA17CA187Accident · No injuriesData collectionFinal reportPiper PA22 · Ruby, AKThe pilot’s failure to maintain directional control while landing in flat light conditions on a hard-packed snow-covered landing area.Feb 16, 2017 · N72999 · Substantial damage