NTSB investigations

224 cases where NTSB found Object/animal/substance, 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\", '03022000'))
  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 GAA18CA505Accident · No injuriesData collectionFinal reportCessna 172 · Churchville, MDThe pilot's failure to maintain directional control after landing left of the runway centerline, which resulted in a runway excursion and impact with a power box.Aug 23, 2018 · N419SP · Substantial damageNTSB GAA18CA495Accident · No injuriesData collectionFinal reportCessna 140 · Hayes Center, NEThe pilot's failure to maintain directional control during landing.Aug 17, 2018 · N4102N · Substantial damageNTSB CEN18LA317Accident · No injuriesLimited investigationFinal reportCessna 120 · Pomona, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.Aug 6, 2018 · N76524 · Substantial damageNTSB GAA18CA452Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot’s failure to maintain directional control during landing.Jul 28, 2018 · N4855G · Substantial damageNTSB GAA18CA447Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Iowa, LAThe pilot's failure to maintain directional control during the landing roll.Jul 26, 2018 · N254LA · Substantial damageNTSB GAA18CA443Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Chelan Falls, WAThe pilot's improper approach over a river, which resulted in a collision with a dock.Jul 22, 2018 · N825PW · Substantial damageNTSB GAA18CA439Accident · No injuriesData collectionFinal reportWayne D. Teel Waiex · Kinsey, KSThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions.Jul 20, 2018 · N49YX · Substantial damageNTSB GAA18CA400Accident · No injuriesData collectionFinal reportChampion 8GCBC · Waunakee, WIThe pilot’s failure to maintain clearance from tall corn along the edge of the airstrip during takeoff.Jul 6, 2018 · N114JM · Substantial damageNTSB GAA18CA420Accident · No injuriesData collectionFinal reportCirrus SR22 · Hudson, NYCollision with a deer during landing.Jun 30, 2018 · N615EM · Substantial damageNTSB GAA18CA384Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Chelan, WAThe pilot's improper approach, which resulted in the airplane landing long and a subsequent runway overrun.Jun 27, 2018 · N1266C · Substantial damageNTSB GAA18CA376Accident · No injuriesData collectionFinal reportPiper PA 18 · Cantwell, AKThe pilot's failure to see and avoid a post during a go-around following a landing on unsuitable terrain.Jun 25, 2018 · N249T · Substantial damageNTSB GAA18CA370Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot’s failure to maintain directional control during landing.Jun 21, 2018 · N4427B · Substantial damageNTSB GAA18CA366Accident · No injuriesData collectionFinal reportRobinson R66 · Cordova, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in impact with brush and a loss of helicopter control.Jun 19, 2018 · N7040P · Substantial damageNTSB GAA18CA365Accident · No injuriesData collectionFinal reportCraig A Reed Starduster II · Morrilton, ARThe pilot’s loss of directional control during an aborted landing.Jun 19, 2018 · N969TM · Substantial damageNTSB GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.Jun 3, 2018 · N67WW · Substantial damageNTSB GAA18CA311Accident · Minor injuriesData collectionFinal reportMaule M5 · Lewiston, IDThe pilot’s failure to maintain the runway centerline and his subsequent decision to not perform a go-around, which resulted in the main landing gear contacting tall wheat and a subsequent loss of control.May 28, 2018 · N5634Y · Substantial damageNTSB WPR18LA145Accident · Minor injuriesLimited investigationFinal reportSportavia Putzer RF5B Sperber · Lookout Pass, MTThe pilot’s improper decision to continue flight toward rising terrain after the engine overheated, which necessitated a precautionary landing when the motorglider could not maintain altitude in downdrafts.May 22, 2018 · N66GL · Substantial damageNTSB GAA18CA299Accident · No injuriesData collectionFinal reportCessna 172 · Defuniak Springs, FLThe student pilot’s failure to maintain directional control during the aborted landing.May 19, 2018 · N12267 · Substantial damageNTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…May 8, 2018 · N377ES · Substantial damageNTSB GAA18CA245Accident · No injuriesData collectionFinal reportAyres S2R · Weipee, IDThe pilot’s failure to maintain directional control during the takeoff roll.Apr 18, 2018 · N40170 · Substantial damageNTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.Mar 14, 2018 · N1004H · Substantial damageNTSB GAA18CA184Accident · No injuriesData collectionFinal reportPiper PA32 · Camas, WAThe pilot’s inadequate inflight fuel management and his failure to switch to a fuel tank with adequate fuel, which resulted in fuel starvation.Mar 4, 2018 · N3756W · Substantial damageNTSB GAA18CA120Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Paula, CAThe pilot’s failure to maintain directional control during landing due to being distracted by another airplane and her delayed initiation of a go-around, during which the right wing struck a parked helicopter.Feb 2, 2018 · N519AC · Substantial damageNTSB ERA18LA091Accident · Serious injuriesLimited investigationFinal reportHughes 369 · San Juan, PRThe helicopter pilot's improper decision to use an open-end grapple, instead of an A-frame attachment, to lift and move a ladder with a lineman on it and the lineman's improper decision to be lifted on a ladder via an open-end grapple, which were contrary to…Jan 11, 2018 · N571HH · No damageNTSB GAA18CA012Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB BK 117 · Canton, ILThe flight instructor's incorrect cyclic control during a hover, which resulted in a hard landing.Oct 13, 2017 · N140SF · Substantial damageNTSB CEN17LA357Accident · Minor injuriesLimited investigationFinal reportBeech A36 · McAlester, OKA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.Sep 15, 2017 · N18403 · Substantial damageNTSB CEN17LA367Accident · Serious injuriesLimited investigationFinal reportMiller Steven M RV6 A · Elbert, COThe pilot’s improper landing flare in strong gusting wind conditions, which resulted in a bounced landing, and his loss of directional control during an attempted go-around, which resulted in a runway excursion and impact with objects.Sep 13, 2017 · N812SM · Substantial damageNTSB CEN17CA345Accident · No injuriesData collectionFinal reportShiner RV-4 · Ramah, NMThe pilot’s failure to maintain clearance from berms during landing in sun glare conditions.Sep 9, 2017 · N70RV · Substantial damageNTSB WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.Sep 4, 2017 · N75753 · Substantial damageNTSB ERA17LA293Accident · No injuriesLimited investigationFinal reportCessna 172 · Guntersville, ALThe pilot's failure to maintain directional control on takeoff.Aug 21, 2017 · N73929 · Substantial damageNTSB GAA17CA467Accident · Serious injuriesData collectionFinal reportJames D Riggs RV-10 · Lawrenceburg, TNThe pilot’s improper landing flare and failure to maintain yaw control during a go-around in gusting wind conditions.Jul 30, 2017 · N616JJ · Substantial damageNTSB CEN17LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA 46 350P · Tahlequah, OKThe total loss of engine power, which resulted from fatigue failure of two engine through bolts and the No. 2 cylinder attachment studs due to the lack of sufficient clamping force.Jul 30, 2017 · N786MD · Substantial damageNTSB GAA17CA441Accident · No injuriesData collectionFinal reportPiper PA18S · Sterling, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.Jul 23, 2017 · N4387A · Substantial damageNTSB ERA17CA250Accident · No injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun.Jul 20, 2017 · N4876F · Substantial damageNTSB GAA17CA424Accident · Minor injuriesData collectionFinal reportSalerno Kenneth G JR Kitfox Series 7 · Owyhee, ORThe pilot's failure to maintain directional control during takeoff from a rough, dirt airstrip.Jul 18, 2017 · N702KF · Substantial damageNTSB GAA17CA416Accident · No injuriesData collectionFinal reportPiper PA 22 · Breckenridge, MIThe pilot’s loss of situational awareness during the approach over a corn field, which resulted in collision with corn stalks.Jul 18, 2017 · N9807D · Substantial damageNTSB GAA17CA407Accident · No injuriesData collectionFinal reportGerald Donovan Rans S-16 · Los Lunas, NMThe pilot's failure to maintain directional control during takeoff.Jul 12, 2017 · N116GD · Substantial damageNTSB WPR17LA144Accident · No injuriesLimited investigationFinal reportCessna U206F · Page, AZThe failure of the throttle control cable due to fatigue and maintenance personnel’s failure to replace the cable at the last engine overhaul, which resulted in the pilots’ inability to control engine power and led to a precautionary landing during which the…Jun 23, 2017 · N71001 · Substantial damageNTSB GAA17CA340Accident · Minor injuriesData collectionFinal reportSportine Aviacija LAK 12 · Reno, NVThe glider pilot’s failure to maintain proper pitch during an aerotow takeoff.Jun 14, 2017 · N4206N · Substantial damageNTSB GAA17CA335Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot’s rudder overcorrection during the landing roll, which resulted in a loss of directional control.Jun 12, 2017 · N95821 · Substantial damageNTSB CEN17LA198Accident · No injuriesLimited investigationFinal reportMooney M20J · Lakeway, TXThe pilot's failure to attain a proper touchdown point during landing, which resulted in a runway excursion. Contributing to the accident was the pilot’s impaired vision due to his broken eyeglasses.May 28, 2017 · N211ZN · Substantial damageNTSB CEN17CA218Accident · Minor injuriesData collectionFinal reportCessna 177 · Plainwell, MIThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overrun.May 26, 2017 · N30462 · Substantial damageNTSB GAA17CA285Accident · Minor injuriesData collectionFinal reportAir Tractor AT 802 · Dumas, TXThe pilot’s failure to maintain lateral control while maneuvering at a low altitude.May 15, 2017 · N319BM · 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 GAA17CA280Accident · Minor injuriesData collectionFinal reportWeaver Stanley R/Robinson Scot Vans RV-8 · Vacaville, CAThe pilot’s failure to maintain directional control while landing in crosswind conditions.May 15, 2017 · N184ME · Substantial damageNTSB GAA17CA264Accident · No injuriesData collectionFinal reportStinson 108 · Pedro Bay, AKThe pilot’s failure to maintain directional control during the takeoff roll.May 6, 2017 · N9510K · Substantial damageNTSB GAA17CA266Accident · No injuriesData collectionFinal reportCessna T182 · Portage County Airport, OHThe student pilot’s failure to maintain directional control during a touch-and-go.May 3, 2017 · N421KR · Substantial damageNTSB GAA17CA255Accident · No injuriesData collectionFinal reportSchweizer SGS134 · Blairstown, NJThe pilot’s failure to attain a proper glidepath on approach for landing in gusting wind conditions, which resulted in an off-airport landing and impact with soccer goal posts.Apr 28, 2017 · N2682H · Substantial damageNTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 4, 2017 · N55339 · Substantial damageNTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.Mar 19, 2017 · N1915N · Substantial damage