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 WPR13FA430Accident · 4 fatalField investigationFinal reportCessna 525A · Santa Monica, CAThe pilot’s failure to adequately decrease the airplane’s ground speed or maintain directional control during the landing roll, which resulted in a runway excursion and collision with an airport sign and structure and a subsequent postcrash fire.Sep 30, 2013 · N194SJ · DestroyedNTSB WPR13CA426Accident · No injuriesData collectionFinal reportPiper PA28 - 161 · Lancaster, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Sep 21, 2013 · N6313C · Substantial damageNTSB WPR13LA262Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Burlington, WAThe failure of the rudder bar assembly during landing due to a fatigue crack. Contributing to the accident was the failure of maintenance personnel to perform an adequate inspection of the rudder bar assembly.Jun 4, 2013 · N5808U · Substantial damageNTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.Feb 26, 2013 · N107BW · Substantial damageNTSB WPR13CA124Accident · No injuriesData collectionFinal reportBeech B19 · Ephrata, WAThe student pilot's failure to maintain directional control during the takeoff ground roll in crosswind conditions, and the flight instructor's delayed remedial action.Feb 13, 2013 · N2059L · Substantial damageNTSB ERA12CA529Accident · No injuriesData collectionFinal reportStinson 108-2 · Winter Haven, FLThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.Aug 23, 2012 · N340C · Substantial damageNTSB WPR12CA357Accident · No injuriesData collectionFinal reportCessna 172R · Everett, WAThe pilot’s failure to maintain directional control during takeoff.Aug 14, 2012 · N863CP · Substantial damageNTSB WPR12LA285Accident · No injuriesLimited investigationFinal reportSchweizer SGS233 · Truckee, CAThe pilot's failure to maintain control of the glider while taking off with a gusting wind, which resulted in the glider impacting a runway sign.Jun 9, 2012 · N2061T · Substantial damageNTSB WPR12CA254Accident · No injuriesData collectionFinal reportCessna 162 · Santa Ana, CAThe pilot’s failure to compensate for the gusting wind and failure to maintain airplane control during the approach to land.Jun 9, 2012 · N5211Y · Substantial damageNTSB WPR12LA252Accident · No injuriesLimited investigationFinal reportStaudacher Hydroplanes S300X · Ephrata, WAThe pilot’s inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control.May 12, 2012 · N336JS · Substantial damageNTSB WPR12CA083Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Barbara, CAThe pilot did not maintain directional control during takeoff.Jan 26, 2012 · N4297S · Substantial damageNTSB WPR11CA341Accident · No injuriesData collectionFinal reportCliff Starduster II SA300 · San Jose, CAThe pilot's decision to not follow the designated taxiway, and failure to maintain clearance from a sign.Jul 19, 2011 · N411TM · Substantial damageNTSB WPR11CA337Accident · No injuriesData collectionFinal reportCessna 172N · Porthill, IDThe pilot's failure to maintain clearance from a pole.Jul 17, 2011 · N733BT · Substantial damageNTSB WPR11LA056Accident · No injuriesLimited investigationFinal reportBell 407 · Riverdale, UTThe pilot's failure to maintain clearance from a highway marker sign while maneuvering.Nov 22, 2010 · N408UH · Substantial damageNTSB ERA11LA015Accident · No injuriesLimited investigationFinal reportCessna 172SP · Boynton Beach, FLThe loss of engine power for undetermined reasons.Oct 10, 2010 · N423FT · Substantial damageNTSB WPR11CA008Accident · No injuriesData collectionFinal reportCessna 172N · Salem, ORThe pilot's failure to maintain directional control during the landing roll.Oct 2, 2010 · N545DS · Substantial damageNTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.Sep 6, 2010 · N515CW · Substantial damageNTSB ANC10CA079Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKA faulty fuel quantity indication in-flight, which precipitated a precautionary off-airport landing, and collision with a road sign.Aug 26, 2010 · N5114H · Substantial damageNTSB ERA10CA440Accident · No injuriesData collectionFinal reportBeech P35 · Hartford, CTThe pilot's inadequate compensation for the crosswind, resulting in a loss of directional control during landing.Aug 23, 2010 · N8667M · Substantial damageNTSB ERA10CA427Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Erwin, NCThe pilot's excessive use of spoiler on final approach, which resulted in a landing short of the runway.Aug 15, 2010 · N940CB · Substantial damageNTSB CEN10CA454Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Petersburg, TXThe pilot's failure to maintain clearance from a signpost during an aerial application flight.Jul 29, 2010 · N57706 · Substantial damageNTSB CEN10LA414Accident · No injuriesLimited investigationFinal reportWogenstahl Wallace L Wogenstahl 281 MR · Mount Cory, OHThe improper installation of the rivets at the aft fuselage bulkhead which resulted in the pilot not having full elevator control on landing.Jul 14, 2010 · N5281R · Substantial damageNTSB WPR10CA338Accident · No injuriesData collectionFinal reportAdams John R JR Piel Diamant · Montezuma, UTThe pilot's failure to maintain clearance from road signs during landing.Jul 3, 2010 · N278JA · Substantial damageNTSB CEN10CA329Accident · No injuriesData collectionFinal reportPiper/Wally'S Flyers J3C-65 · Crystal, MNThe pilot's failure to maintain directional control during the crosswind landing and the instructor pilot's delayed remedial action.Jun 19, 2010 · N25WF · Substantial damageNTSB WPR10CA269Accident · No injuriesData collectionFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Koosharem, UTThe pilot's failure to maintain clearance from a sign on the side of his landing area (a dirt road). Contributing to the accident was the pilot's failure to perform a fly-by of the road to check for hazards.May 29, 2010 · N151YZ · Substantial damageNTSB WPR10CA243Accident · No injuriesData collectionFinal reportCessna 170B · Moab, UTThe pilot's failure to maintain directional control during the landing roll.May 15, 2010 · N8379A · Substantial damageNTSB ERA10CA244Accident · No injuriesData collectionFinal reportCessna 172N · Poughkeepsie, NYThe pilot's failure to maintain directional control on the landing rollout.Apr 24, 2010 · N5371D · Substantial damageNTSB WPR10LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Apple Valley, CAThe pilot's loss of directional control during the landing roll and the check airman’s delayed remedial response.Jan 8, 2010 · N29285 · Substantial damageNTSB WPR10LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZA loss of engine power for undetermined reasons.Nov 8, 2009 · N2165M · Substantial damageNTSB ERA10CA045Accident · No injuriesData collectionFinal reportBeech 77 · Gainesville, FLThe pilot's failure to maintain aircraft control during landing.Nov 1, 2009 · N6715V · Substantial damageNTSB WPR10CA017Accident · No injuriesData collectionFinal reportCessna 182F · Elko, NVThe pilot's failure to maintain directional control while taking off in known gusty wind conditions.Oct 12, 2009 · N3567Y · Substantial damageNTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.Oct 10, 2009 · N51302 · Substantial damageNTSB WPR10CA008Accident · No injuriesData collectionFinal reportCessna 172P · Renton, WAThe failure of the student pilot to maintain directional control during the takeoff portion of a touch-and-go landing resulting in a collision with a sign.Oct 7, 2009 · N54088 · Substantial damageNTSB WPR09CA478Accident · No injuriesData collectionFinal reportCessna T210J · Albany, ORThe malfunction of the left main wheel brake during landing due to inadequate hydraulic fluid in the left brake pedal master cylinder due to leakage.Sep 14, 2009 · N899KM · Substantial damageNTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.Aug 9, 2009 · N32105 · Substantial damageNTSB WPR09LA302Accident · No injuriesLimited investigationFinal reportMooney M20TN · San Jose, CAThe pilot's improper landing flare in gusting wind conditions resulting in a collision with an airport sign.Jun 20, 2009 · N411JL · Substantial damageNTSB WPR09CA300Accident · No injuriesData collectionFinal reportNorth American/Victoria MNT LT AT-6A · Olympia, WAThe pilot's inadequate compensation for the crosswind gust and failure to maintain directional control while landing.Jun 20, 2009 · N9793Z · Substantial damageNTSB WPR09CA274Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Grangeville, IDThe pilot's failure to maintain clearance from an obstacle during taxi.May 28, 2009 · N25353 · Substantial damageNTSB WPR09CA143Accident · No injuriesData collectionFinal reportBellanca 17-31ATC · Bakersfield, CAThe pilot's failure to maintain directional control while landing.Mar 6, 2009 · N4134B · Substantial damageNTSB ERA09CA086Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Linden, NJThe unknown pilot's failure to maintain adequate clearance from the taxiway sign.Dec 6, 2008 · N2125J · Substantial damageNTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.Oct 3, 2008 · N5172J · Substantial damageNTSB ANC08CA108AccidentData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain clearance from a tarp used as a marker at the departure end of the takeoff area.Aug 14, 2008 · N3573Z · Substantial damageNTSB CHI08CA249Accident · No injuriesData collectionFinal reportMorane-Saulnier MS-760/B · St Paul, MNRestriction of the elevator controls due to the presence of the seat belt buckled around the co-pilot control stick. An additional cause was the failure of the pilot to verify that the flight controls were unobstructed before flight. Contributing factors were…Aug 9, 2008 · N69X · Substantial damageNTSB LAX08CA222Accident · No injuriesData collectionFinal reportCessna 172R · Byron, CAThe pilot's failure to maintain directional control during the landing rollout.Jul 9, 2008 · N354ES · Substantial damageNTSB CHI08CA175Accident · No injuriesData collectionFinal reportBeech A36 · Dwight, ILThe loss of engine power for undetermined reasons. Contributing to the accident was the highway signpost that the airplane impacted during the landing rollout.Jul 1, 2008 · N6051M · Substantial damageNTSB NYC08CA220Accident · No injuriesData collectionFinal reportCessna 172P · Lancaster, PAThe student pilot's failure to maintain directional control during the landing rollout.Jun 19, 2008 · N52632 · Substantial damageNTSB NYC08CA193Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was a crosswind.May 24, 2008 · N9245Q · Substantial damageNTSB CHI08CA138Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg. LC41-550FG · Columbus, OHThe pilot not maintaining directional control during the landing. Contributing to the accident were the gusty crosswinds and the airport sign that was impacted.May 21, 2008 · N1387C · Substantial damageNTSB ANC08CA069Accident · No injuriesData collectionFinal reportCessna 421 · Caldwell, NJThe pilot's failure to maintain directional control while landing. Factors in the accident were a hydroplaning condition, and a wet runway.May 17, 2008 · N777FF · Substantial damageNTSB ANC08CA048Accident · No injuriesData collectionFinal reportCessna 172 · Anchorge, AKThe pilot's failure to maintain clearance from a road sign while taxiing from landing.May 3, 2008 · N7886G · Substantial damage