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 GAA19CA225Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe pilot's improper rudder inputs and failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway sign.Apr 20, 2019 · N6023V · Substantial damageNTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.Apr 17, 2019 · N425PA · Substantial damageNTSB ERA19CA148Accident · Minor injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a runway marker.Apr 8, 2019 · N68727 · Substantial damageNTSB ERA19CA289Accident · No injuriesData collectionFinal reportPiper PA28 · Winder, GAThe student pilot’s loss of airplane control, the flight instructor's delayed remedial action, and the student's delay in relinquishing the flight controls, which resulted in the airplane striking a runway sign during a go-around.Mar 28, 2019 · N6412W · Substantial damageNTSB GAA19CA178Accident · No injuriesData collectionFinal reportPiper PA 12 · Mecosta, MIThe pilot's failure to maintain directional control during the landing roll, which resulted in impact with a windsock pole.Mar 23, 2019 · N2733M · Substantial damageNTSB GAA19CA146Accident · No injuriesData collectionFinal reportCessna 182 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll with a gusting tailwind, which resulted in a runway excursion and collision with runway lights and taxiway signage.Feb 22, 2019 · N8644T · Substantial damageNTSB GAA19CA150Accident · No injuriesData collectionFinal reportPiper PA22 · Scappoose, ORThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with taxiway signage.Feb 21, 2019 · N7822D · Substantial damageNTSB GAA19CA118Accident · No injuriesData collectionFinal reportCessna 172 · Appleton, MNThe student pilot’s loss of directional control while landing on an ice-covered runway, which resulted in a loss of directional control, and his failure to attain sufficient airspeed during a subsequent aborted landing, which resulted in a nose-over.Jan 2, 2019 · N12181 · Substantial damageNTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.Dec 27, 2018 · N17SJ · Substantial damageNTSB ERA19LA091Accident · Serious injuriesLimited investigationFinal reportCzech Sport Sportcruiser · Naples, FLCollision with a bird in flight, which resulted in damage to the engine, a fuel leak, and a subsequent total loss of engine power due to fuel exhaustion.Dec 22, 2018 · N564SC · Substantial damageNTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.Dec 12, 2018 · N5800U · Substantial damageNTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.Nov 29, 2018 · N3619M · Substantial damageNTSB GAA19CA092Accident · No injuriesData collectionFinal reportMaule MX7 · Immokalee, FLThe flight instructor's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with runway signage during the subsequent attempted aborted landing.Nov 5, 2018 · N9225G · Substantial damageNTSB GAA19CA053Accident · Minor injuriesData collectionFinal reportPiper PA24 · Texico, NMThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 5, 2018 · N3214P · Substantial damageNTSB GAA19CA038Accident · No injuriesData collectionFinal reportDiamond DA 40 · Marana, AZThe student pilot's excessive taxi speed during a turn from the runway to a taxiway, which resulted in a runway excursion and collision with a taxiway sign.Oct 27, 2018 · N537MA · Substantial damageNTSB ERA19TA011Accident · No injuriesFinal reportBeech F33 · Reidsville, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.Oct 13, 2018 · N9469Q · 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 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 CEN18LA315Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Dallas, TXThe pilot's inability to maintain directional control during taxi due to excessively worn brake pads and a deflated right main tire.Aug 3, 2018 · N2546B · Substantial damageNTSB GAA18CA460Accident · No injuriesData collectionFinal reportCessna 172 · Grand Prairie, TXThe student pilot’s failure to maintain the runway centerline during takeoff with a crosswind.Jul 29, 2018 · N24144 · Substantial damageNTSB ERA18LA213Accident · No injuriesLimited investigationFinal reportPiper PA46 · West Columbia, SCThe pilot’s inadvertent navigation onto a service road instead of a taxiway, which resulted in a collision with a stop sign.Jul 25, 2018 · C-GRFF · Substantial damageNTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Jul 22, 2018 · N99243 · Substantial damageNTSB CEN18LA237Accident · No injuriesLimited investigationFinal reportZenith Stol CH701 · Maple Lake, MNThe total loss of engine power for reasons that could not be determined based on the available evidence.Jun 22, 2018 · N736MM · Substantial damageNTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.May 12, 2018 · N2485D · Substantial damageNTSB GAA18CA274Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to maintain directional control during the landing roll in tailwind conditions.May 10, 2018 · N430PA · Substantial damageNTSB CEN18LA148Accident · Serious injuriesLimited investigationFinal reportMaule M 5-235C · Roxbury, KSThe pilot's failure to maintain directional control during takeoff from a road, which resulted in impact with a sign.Apr 24, 2018 · N9281E · Substantial damageNTSB GAA18CA232Accident · No injuriesData collectionFinal reportCessna 172 · San Jose, CAThe student pilot’s failure to maintain the runway heading during the approach to land, and the flight instructor’s delayed remedial action.Apr 20, 2018 · N23AT · Substantial damageNTSB GAA18CA193Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe student pilot’s improper selection of the flap setting during a go-around, and the flight instructor’s delayed remedial action, which resulted in an aerodynamic stall.Apr 1, 2018 · N297PA · Substantial damageNTSB GAA18CA172Accident · No injuriesData collectionFinal reportLithuanian Factory Of LAK 12 · Sunriver, ORThe glider pilot's inadequate flight planning, which resulted in an off-airport landing.Mar 20, 2018 · N63010 · Substantial damageNTSB GAA18CA204Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot’s failure to maintain a stabilized approach, which resulted in overcorrection with the rudder during the landing, loss of control, and a runway excursion.Mar 2, 2018 · N158ND · Substantial damageNTSB GAA18CA121Accident · No injuriesData collectionFinal reportPiper PA28 · Metter, GAThe student pilot’s failure to maintain directional control during landing.Feb 5, 2018 · N8475W · Substantial damageNTSB GAA18CA109Accident · No injuriesData collectionFinal reportBeech B60 · Scottsdale, AZThe pilot’s improper brake application during landing, which resulted in a tire blowout and a loss of directional control.Jan 16, 2018 · CFESG · Substantial damageNTSB GAA18CA094Accident · No injuriesData collectionFinal reportPiper PA32 · Spearfish, SDThe pilot’s inadvertent landing in snow adjacent to the snow-covered runway resulting in a collision with runway signs.Dec 28, 2017 · N11KX · Substantial damageNTSB CEN18LA034Accident · No injuriesLimited investigationFinal reportErcoupe 415 CD · Aurora, COThe failure of the engine-driven fuel pump and the pilot's failure to identify the pump's failure, which resulted in a loss of engine power due to fuel starvation and a forced landing on a road, during which the airplane hit obstacles.Nov 20, 2017 · N3067H · Substantial damageNTSB GAA18CA033Accident · No injuriesData collectionFinal reportEvolution Revo · Berlin, NHThe pilot’s failure to center the ground steering before landing, which resulted in a loss of directional control.Oct 29, 2017 · N401HK · Substantial damageNTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.Oct 22, 2017 · N83512 · Substantial damageNTSB GAA17CA567Accident · No injuriesData collectionFinal reportChancey Gerry M RV-12 · Dunkirk, NYThe pilot's failure to maintain lateral/bank control during takeoff in crosswind conditions.Sep 6, 2017 · N1214J · Substantial damageNTSB GAA17CA549Accident · No injuriesData collectionFinal reportCessna U206 · Chicken, AKThe pilot’s failure to maintain clearance from a sign while taking off from a road.Sep 5, 2017 · N734GW · Substantial damageNTSB GAA17CA516Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZThe student pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll.Sep 2, 2017 · N910XD · Substantial damageNTSB GAA17CA482Accident · No injuriesData collectionFinal reportCessna 172 · Kearney, NEThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.Aug 2, 2017 · N91966 · Substantial damageNTSB GAA17CA462Accident · No injuriesData collectionFinal reportChampion 7ECA · Butler, PAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.Jul 30, 2017 · N9682S · Substantial damageNTSB CEN17LA274Accident · No injuriesLimited investigationFinal reportEndler Glasair/Glasair 1-Td SH2 · Colorado Springs, COThe pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…Jul 15, 2017 · N181AL · DestroyedNTSB GAA17CA358Accident · No injuriesData collectionFinal reportVans RV-12 · Eugene, ORThe student pilot’s failure to maintain directional control during takeoff.Jun 20, 2017 · N234VA · Substantial damageNTSB GAA17CA329Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot’s failure to maintain directional control during the landing roll.Jun 8, 2017 · N4284Q · 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 WPR17LA116Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/S · Pendelton, ORThe pilot’s failure to follow checklists to ensure the canopy was secured before takeoff.May 20, 2017 · N68PW · Substantial damageNTSB CEN17LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Muskogee, OKThe pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.May 13, 2017 · N3976K · Substantial damageNTSB GAA17CA200Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Ketchikan, AKThe floatplane pilot's failure to avoid a buoy during takeoff.Mar 22, 2017 · N264P · Substantial damageNTSB GAA17CA189Accident · No injuriesData collectionFinal reportPiper PA 28 · Gila Bend, AZThe flight instructor’s failure to review the notices to airmen related to the airport, which resulted in his landing on a closed runway and the airplane striking runway closed markers.Mar 12, 2017 · N288PA · Substantial damageNTSB GAA17CA163Accident · No injuriesData collectionFinal reportCessna 172S · St Petersburg, FLThe student pilot’s overcompensation of right rudder pedal application during the landing roll, which resulted in a loss of directional control and impact with runway signage and a fence.Mar 1, 2017 · N22904 · Substantial damage