NTSB investigations

214 cases where NTSB found Sign/marker.

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\", '03022015'))
  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 GAA17CA127Accident · No injuriesData collectionFinal reportVaughan Gerald R Side Winder TD · McCook, NEThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Jan 28, 2017 · N60JV · Substantial damageNTSB GAA17CA123Accident · No injuriesData collectionFinal reportPiper PA 28R · Wichita, KSThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.Jan 24, 2017 · N4792T · Substantial damageNTSB GAA17CA105Accident · No injuriesData collectionFinal reportPiper PA 46 · Nashville, TNThe pilot’s loss of directional control during the aborted landing in gusting crosswind conditions, which resulted in a runway excursion.Dec 29, 2016 · N301BK · Substantial damageNTSB CEN17LA090Accident · No injuriesLimited investigationFinal reportCessna 172B · Prairie Du Sac, WIThe pilot's decision to taxi the airplane from the roadway and his subsequent failure to maintain clearance from signs and a fence after a successful emergency landing following a total loss of engine power.Dec 28, 2016 · N6941X · Substantial damageNTSB CEN17LA058Accident · No injuriesLimited investigationFinal reportBellanca 17 30A · Blaine, MNA total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.Dec 18, 2016 · N4204B · Substantial damageNTSB GAA17CA149Accident · No injuriesData collectionFinal reportPiper PA28 · Palm Coast, FLThe pilot’s failure to maintain clearance from the taxiway sign.Dec 13, 2016 · N3563K · Substantial damageNTSB GAA17CA043Accident · No injuriesData collectionFinal reportAeronca 11AC · Winter Haven, FLThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion.Oct 22, 2016 · N9410E · Substantial damageNTSB GAA17CA014Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.Oct 6, 2016 · N602ND · Substantial damageNTSB GAA17CA011Accident · No injuriesData collectionFinal reportFuller Neil H Glasair SH 2 · Bellingham, WAThe pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.Oct 5, 2016 · N724NF · Substantial damageNTSB ERA16LA320Accident · No injuriesLimited investigationFinal reportBeech B100 · Jackson, TNThe pilot’s improper landing flare, which resulted in a hard landing.Sep 21, 2016 · N66804 · Substantial damageNTSB WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.Sep 18, 2016 · N57TJ · Substantial damageNTSB GAA16CA483Accident · No injuriesData collectionFinal reportCessna 172 · Covington, GAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Sep 12, 2016 · N5283R · Substantial damageNTSB GAA16CA431Accident · No injuriesData collectionFinal reportCessna 152 · Hillsboro, ORThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the engine mount.Aug 12, 2016 · N48440 · Substantial damageNTSB GAA16CA425Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · San Diego, CAThe pilot's failure to maintain directional control during landing with a crosswind.Aug 10, 2016 · N35451 · Substantial damageNTSB CEN16LA309Accident · No injuriesLimited investigationFinal reportCessna 172K · Neenah, WIA loss of engine power due to oil starvation, which resulted from the pilot, who was not a certified airframe and powerplant mechanic, removing the vacuum pump from the engine, and his misconception that he could operate the airplane without the pump.Aug 2, 2016 · N46459 · Substantial damageNTSB GAA16CA373Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard · Somerset, KYThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with an airport sign.Jul 11, 2016 · N99CV · Substantial damageNTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.Jul 2, 2016 · N65645 · Substantial damageNTSB GAA16CA354Accident · No injuriesData collectionFinal reportCessna 188 · Saratoga, WYThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in substantial damage.Jul 1, 2016 · N60691 · Substantial damageNTSB GAA16CA349Accident · No injuriesData collectionFinal reportCessna 150 · Reno, NVThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, impact with a sign, and left wing damage.Jun 26, 2016 · N5842E · Substantial damageNTSB GAA16CA320Accident · No injuriesData collectionFinal reportBeech 77 · Santa Fe, NMThe pilot's decision to takeoff over the maximum takeoff weight in high density altitude conditions, which resulted in an inability to climb above terrain, a forced landing, and a collision with a road sign. Contributing to the accident was the pilot's…Jun 16, 2016 · N60189 · Substantial damageNTSB GAA16CA528Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Jacksonville, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.May 27, 2016 · N808ET · Substantial damageNTSB CEN16LA190Accident · No injuriesLimited investigationFinal reportBeech C24R · Marine City, MIThe misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…May 22, 2016 · N20135 · Substantial damageNTSB GAA16CA242Accident · Minor injuriesData collectionFinal reportVan B Anthony Zodiac · Grass Valley, CAThe pilot's failure to maintain a stabilized approach and landing, which resulted in a hard landing, loss of directional control, runway excursion, and collision with a parked airplane.May 17, 2016 · N99SZ · DestroyedNTSB WPR16LA030Accident · Serious injuriesLimited investigationFinal reportCessna T210N · La Verne, CAThe total loss of engine power for reasons that could not be determined based on the available information.Nov 19, 2015 · N91HC · Substantial damageNTSB GAA15CA249Accident · No injuriesData collectionFinal reportStinson L 5E · Tucson, AZThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and a collision with an object.Aug 20, 2015 · N944LB · Substantial damageNTSB ERA15LA263Accident · Minor injuriesLimited investigationFinal reportCessna 210 5A(205A) · Stafford Twp, NJThe total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic's failure to properly torque the engine cylinder through bolts.Jul 12, 2015 · N315EC · Substantial damageNTSB GAA15CA144Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Williston, NDThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with runway marking signs.Jun 28, 2015 · N8723 · Substantial damageNTSB GAA15CA120Accident · No injuriesData collectionFinal reportBeech RC 45J · Everett, WAThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with a sign.Jun 11, 2015 · N585PB · Substantial damageNTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.Jun 9, 2015 · N6919W · Substantial damageNTSB ERA15LA214Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Inverness, FLA disconnection of the tailwheel steering mechanism during landing, which resulted in the pilot’s loss of directional control.May 12, 2015 · N43715 · Substantial damageNTSB WPR15LA157Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Redlands, CAThe partial loss of engine power during takeoff due to oil starvation.May 9, 2015 · N4124R · Substantial damageNTSB GAA15CA060Accident · No injuriesData collectionFinal reportWatson David E Skybolt · Carson City, NVThe pilot's failure to maintain directional control of the airplane during takeoff, resulting in substantial damage to the airplane.May 4, 2015 · N88FX · Substantial damageNTSB GAA15CA042Accident · Minor injuriesData collectionFinal reportCessna 140 · Mize, MSThe pilot's failure to maintain clearance from obstacles during an off airport precautionary landing roll.Apr 18, 2015 · N76452 · Substantial damageNTSB GAA15CA017Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Greensboro, NCThe pilot's failure to maintain directional/pitch control during final approach, resulting in a collision with terrain.Mar 18, 2015 · N43MT · Substantial damageNTSB WPR15CA094Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · La Verne, CAThe student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.Jan 27, 2015 · N805ER · Substantial damageNTSB CEN15CA049Accident · No injuriesData collectionFinal reportCessna 210 · Kalamazoo, MIThe pilot's failure to ensure that the landing gear was fully extended in the down and locked position prior to touchdown, which resulted in the left main landing gear collapse, runway excursion, and impact with a runway exit sign.Oct 24, 2014 · N8219M · Substantial damageNTSB ERA15LA030Accident · No injuriesLimited investigationFinal reportNorth American T 6G · Naples, FLThe total loss of engine power during the initial climb due to fuel starvation for reasons that could not be determined because postaccident examinations of the airframe and engine fuel system components revealed no evidence of a mechanical malfunction or…Oct 23, 2014 · N22NA · Substantial damageNTSB CEN14CA291Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Middleton, WIThe pilot's failure to maintain directional control during takeoff.Jun 5, 2014 · N752J · Substantial damageNTSB ERA14CA277Accident · No injuriesData collectionFinal reportCessna 177B · Cartersville, GAThe pilot's failure to maintain directional control during a go-around after landing.Jun 2, 2014 · N30820 · Substantial damageNTSB WPR14CA163Accident · No injuriesData collectionFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain directional control during a takeoff, which resulted in the airplane veering off the runway surface and colliding with a sign.Apr 10, 2014 · N1152Z · Substantial damageNTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.Mar 6, 2014 · N108WA · Substantial damageNTSB ERA14CA134Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Gulf Shores, ALThe student pilot's incorrect rudder input, which resulted in a ground loop and collision with a runway sign.Feb 25, 2014 · N156WB · Substantial damageNTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.Feb 15, 2014 · N738BH · Substantial damageNTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.Jan 19, 2014 · N1960C · Substantial damageNTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.Jan 12, 2014 · N6888 · Substantial damageNTSB WPR14CA070Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAThe flight instructor's failure to correct for the student pilot's loss of aircraft control in a timely manner during takeoff. Contributing to the accident was the instructor's inability to see the taxiway sign from the rear seat.Dec 15, 2013 · N53893 · Substantial damageNTSB WPR14LA065Accident · No injuriesLimited investigationFinal reportAviat S 2C · Chandler, AZThe pilot’s failure to maintain airplane control during landing, which resulted in impact with a runway identifier sign, and the flight instructor’s delayed remedial action to take the controls and initiate a go-around.Dec 9, 2013 · N44HV · Substantial damageNTSB WPR14CA063Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Bryon, CAThe pilot's failure to maintain adequate wing clearance from a runway sign while taxiing.Dec 8, 2013 · N3981C · Substantial damageNTSB WPR14CA053Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe student pilot's failure to maintain directional control during the landing roll.Nov 13, 2013 · N821EB · Substantial damageNTSB WPR14CA021Accident · No injuriesData collectionFinal reportPiper PA28 - 160 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collison with a runway sign.Oct 19, 2013 · N5184W · Substantial damage