NTSB investigations, 2018

208 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\") = 2018
    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 GAA19CA005Accident · No injuriesData collectionFinal reportCessna 180 · Hailey, IDThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Oct 3, 2018 · N180BG · Substantial damageNTSB ANC19CA002Accident · No injuriesData collectionFinal reportBeech 1900 · Gambell, AKThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard landing.Oct 3, 2018 · N575Q · Substantial damageNTSB GAA18CA580Accident · No injuriesData collectionFinal reportPiper PA28 · Van Nuys, CAThe pilot's failure to maintain directional control of the airplane during landing.Sep 30, 2018 · N400JW · Substantial damageNTSB GAA18CA574Accident · No injuriesData collectionFinal reportPiper PA24 · Crewe, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper fuel management, which resulted in fuel starvation…Sep 29, 2018 · N6148P · Substantial damageNTSB CEN18FA391Accident · 3 fatalField investigationFinal reportAirbus Helicopters AS350 · Gustavus, AKThe pilot's failure to maintain main rotor speed after setting the engine fuel control to idle, which resulted in a loss of helicopter control and impact with water.Sep 28, 2018 · N907PL · DestroyedNTSB GAA18CA566Accident · No injuriesData collectionFinal reportVans RV-14 · Heber City, UTThe pilot's loss of directional control during the landing roll and his subsequent attempted go-around.Sep 24, 2018 · N823HE · Substantial damageNTSB ERA18LA257Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Winter Haven, FLThe student pilot’s improper pitch attitude control during the initial climb, which resulted in a loss of airspeed, and his subsequent decision to conduct a 180° turn following the perceived anomaly, which resulted in a runway overrun.Sep 24, 2018 · N6950A · Substantial damageNTSB ERA18TA267Accident · Serious injuriesClass 3Final reportGrob G103 Twin Astir · Groveland, FLThe student pilot's failure to relinquish the flight controls during landing when the flight instructor told him to do so, and the instructor’s subsequent inability to properly control the glider, which led to a hard landing.Sep 22, 2018 · N72EJ · Minor damageNTSB GAA18CA564Accident · No injuriesData collectionFinal reportCessna 150 · Roseburg, ORThe pilot's loss of directional control during landing.Sep 21, 2018 · N8382G · Substantial damageNTSB GAA18CA565Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 · Igiugig, AKThe pilot’s selection of an empty fuel tank for takeoff, which resulted in fuel starvation and the subsequent total loss of engine power.Sep 20, 2018 · N121AK · Substantial damageNTSB GAA18CA569Accident · No injuriesData collectionFinal reportMaule M7 · Grass Valley, ORThe pilot’s failure to maintain directional control during the landing roll.Sep 16, 2018 · N760AC · Substantial damageNTSB GAA18CA556Accident · No injuriesData collectionFinal reportCessna R182 · Mount Holly, NJThe pilot’s failure to maintain lateral control of the airplane during landing, which resulted in a loss of directional control and subsequent runway excursion.Sep 15, 2018 · N7304T · Substantial damageNTSB GAA18CA553Accident · Minor injuriesData collectionFinal reportPiper PA28 · Spanish Fork, UTThe student pilot’s failure to maintain the runway heading during takeoff and the flight instructor’s decision to conduct primary flight instruction in an airplane without dual controls.Sep 13, 2018 · N7223J · Substantial damageNTSB GAA18CA549Accident · Minor injuriesData collectionFinal reportAviat A1 · Bentonville, ARThe pilot’s exceedance of the airplane’s critical angle of attack during an attempted go-around after the airplane bounced, which resulted in an aerodynamic stall.Sep 12, 2018 · N868X · Substantial damageNTSB GAA18CA559Accident · No injuriesData collectionFinal reportPiper PA34 · Miami, FLThe pilot under instruction’s failure to maintain the twin-engine airplane’s minimum control airspeed with one engine inoperative and the flight instructor’s distraction when reconfiguring the airplane following the simulated engine failure, which resulted in…Sep 11, 2018 · N88AG · Substantial damageNTSB GAA18CA548Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Carson, NVThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control in gusting, right quartering tailwind conditions.Sep 11, 2018 · N289MM · Substantial damageNTSB GAA18CA555Accident · No injuriesData collectionFinal reportHimmeroeder Hansgeorg Bearhawk · Williams, CAThe pilot’s failure to maintain directional control during the landing roll.Sep 9, 2018 · N152GH · Substantial damageNTSB GAA18CA542Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe student pilot's failure to maintain lateral control during the aborted landing.Sep 9, 2018 · N7205J · Substantial damageNTSB GAA18CA545Accident · Minor injuriesData collectionFinal reportCirrus SR22 · Mason City, IAThe pilot’s improper hand propping procedure, which resulted in a runaway airplane and subsequent impact with a hangar.Sep 8, 2018 · N669HT · Substantial damageNTSB GAA18CA546Accident · No injuriesData collectionFinal reportPiper PA28 · De Pere, WIThe pilot's improper decision not to abort the takeoff after the airplane encountered standing water on the runway, which decreased its speed and led to its subsequent inability to climb and resulted in a runway overrun.Sep 7, 2018 · N7595R · Substantial damageNTSB GAA18CA584Accident · No injuriesData collectionFinal reportCessna 305 · Groveland, CAThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and subsequent ground-loop.Sep 5, 2018 · N119PP · Substantial damageNTSB GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.Sep 4, 2018 · N230DE · Substantial damageNTSB WPR18LA252Accident · No injuriesClass 3 · LimitedFinal reportGuimbal Cabri · Santa Ana, CAThe flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.Sep 3, 2018 · N401SH · Substantial damageNTSB WPR18FA247Accident · 2 fatalClass 3 · FieldFinal reportSchempp-Hirth Duo Discus T · New Washoe City, NVThe pilot’s delayed recovery from an inadvertent spin and/or spiral dive and an exceedance of the glider’s design limit load during recovery, which resulted in an overload failure of both wings.Sep 2, 2018 · N22XC · DestroyedNTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.Sep 2, 2018 · N4077M · Substantial damageNTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.Sep 1, 2018 · N212NA · Substantial damageNTSB GAA18CA523Accident · Minor injuriesData collectionFinal reportEggleston Daniel S-18 Thorp · Porterville, CAThe pilot’s failure to maintain directional control during the takeoff roll.Sep 1, 2018 · N575DG · Substantial damageNTSB GAA18CA529Accident · No injuriesData collectionFinal reportPiper PA46 · Hartford, CTThe pilot’s unstabilized approach and hard landing, which resulted in a nose landing gear collapse.Aug 28, 2018 · N178DB · Substantial damageNTSB GAA18CA524Accident · No injuriesData collectionFinal reportLuscombe 8 · Fulton, MOThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Aug 28, 2018 · N1211B · Substantial damageNTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 27, 2018 · N1701Q · Substantial damageNTSB GAA18CA513Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's failure to maintain directional control during the takeoff roll.Aug 27, 2018 · N53051 · Substantial damageNTSB CEN18LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rushville, INLoss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.Aug 27, 2018 · N4379L · Substantial damageNTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.Aug 26, 2018 · N201BS · Substantial damageNTSB WPR18LA242Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Dardanelle, CAAn in-flight failure of the trunnion bearing and subsequent failure of the drive link and swashplate support, which resulted in the loss of helicopter control.Aug 25, 2018 · N512TA · Substantial damageNTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.Aug 25, 2018 · N7635F · Substantial damageNTSB GAA18CA509Accident · No injuriesData collectionFinal reportCessna 170 · Prineville, ORThe pilot's failure to maintain directional control during the landing roll.Aug 25, 2018 · N4569C · Substantial damageNTSB GAA18CA503Accident · Minor injuriesData collectionFinal reportChampion 8GCBC · Elberta, ALThe pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.Aug 22, 2018 · N88287 · Substantial damageNTSB GAA18CA501Accident · No injuriesData collectionFinal reportCessna A185 · McCall, IDThe disconnection of the brake cylinder actuator rod, which resulted in the pilot’s inability to maintain directional control during the landing roll.Aug 20, 2018 · N93039 · Substantial damageNTSB GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.Aug 14, 2018 · N1085U · Substantial damageNTSB GAA18CA482Accident · No injuriesData collectionFinal reportQac Quickie · helena, MTThe pilot's failure to maintain yaw control and a proper descent rate during an aborted takeoff.Aug 11, 2018 · N624JC · Substantial damageNTSB GAA18CA481Accident · No injuriesData collectionFinal reportHelio H 295 · Great Falls, MTThe pilot’s failure to maintain lateral control of the airplane during takeoff in a quartering tailwind.Aug 11, 2018 · N77TR · Substantial damageNTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.Aug 9, 2018 · N104CC · Substantial damageNTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…Aug 9, 2018 · N20JA · Substantial damageNTSB WPR18LA214Accident · Minor injuriesLimited investigationFinal reportBell 206 · Basin City, WAThe pilot's improper execution of a slowing and turning maneuver, which resulted in a loss of control at an altitude that was too low for recovery.Aug 7, 2018 · N607RA · DestroyedNTSB CEN18LA321Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Sedalia, MOA total loss of engine power during low-altitude maneuvering for reasons that could not be determined due to postimpact fire damage.Aug 6, 2018 · N4996R · DestroyedNTSB ERA18FA208Accident · 2 fatalField investigationFinal reportChampion 8GCBC · Foley, ALThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.Aug 4, 2018 · N424A · DestroyedNTSB CEN18LA313Accident · No injuriesLimited investigationFinal reportBrantly B-2 · Midland, MIThe in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.Aug 3, 2018 · N5901X · Substantial damageNTSB GAA18CA459Accident · No injuriesData collectionFinal reportHerzog CCX-2000 · Bend, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the subsequent collapse of the left main landing gear when he attempted to steer the airplane back onto the runway.Jul 31, 2018 · N116PM · Substantial damageNTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.Jul 30, 2018 · N205SK · Substantial damageNTSB GAA18CA458Accident · No injuriesData collectionFinal reportAllen W Inks Virus SW · Clayton, GAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard, bounced landing and runway overrun.Jul 30, 2018 · N608US · Substantial damage