Final NTSB investigations

358 cases where the sequence of events included Landing area overshoot.

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '380' 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 ERA16FA269Accident · 1 fatalField investigationFinal reportYakovlev YAK11 · West Mifflin, PAA malfunction of the electrical system, which resulted in an electrical fire in the right wing root of the airplane, which compromised the fuel system and resulted in ignition of fuel. Contributing to the accident was the routing of the electrical wiring near…Jul 25, 2016 · N5940 · Substantial damageNTSB GAA16CA383Accident · No injuriesData collectionFinal reportAeronca 7AC · Lenoir, NCThe pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to…Jul 18, 2016 · N84690 · Substantial damageNTSB GAA16CA382Accident · Minor injuriesData collectionFinal reportGonzalez Manuel A RV 7 · Langley, WAThe pilot's decision to land with a tailwind, which resulted in, landing long, a runway overrun, and impact with a berm and nose over.Jul 16, 2016 · N228MG · Substantial damageNTSB ERA16LA251Accident · Serious injuriesLimited investigationFinal reportTumbling Goose 12S · Zellwood, FLA total loss of engine power during descent for reasons that could not be determined because impact damage precluded a complete examination of the fuel servo.Jul 11, 2016 · N867TG · DestroyedNTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…Jul 8, 2016 · N5331B · Substantial damageNTSB ERA16CA233Accident · Minor injuriesData collectionFinal reportCessna T206 · Farmington, PAThe pilot's failure to obtain the proper touchdown point and failure to perform a go-around once a safe landing on the runway could not be accomplished.Jun 28, 2016 · C-GPJH · Substantial damageNTSB ERA16CA218Accident · No injuriesData collectionFinal reportPiper PA32 · Block Island, RIThe pilot's failure to attain the proper touchdown point and the airplane’s subsequent collision with obstacles during an attempted go-around.Jun 19, 2016 · N44255 · Substantial damageNTSB GAA16CA342Accident · No injuriesData collectionFinal reportSchleicher ASW 28 · Cuddybackville, NYThe pilot's failure to maintain the glide path required for landing in the off-field landing zone.Jun 17, 2016 · N280E · Substantial damageNTSB GAA16CA276Accident · No injuriesData collectionFinal reportMooney M20C · Williamstown, NJThe pilot's landing area overshoot and failure to maintain surface speed and braking capability, which resulted in a runway overrun and a collision with a fence.Jun 4, 2016 · N6453U · Substantial damageNTSB WPR16CA121Accident · Serious injuriesData collectionFinal reportChampion 7ECA · Brookings, ORThe pilot’s failure to maintain directional control during the landing roll.May 25, 2016 · N9583S · Substantial damageNTSB WPR16FA115Accident · No injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Monica, CAA partial loss of engine power during takeoff due to vapor lock. Contributing to the accident was the student pilot's failure to notice that the engine had exceeded multiple temperature limits and that the fuel flow had become erratic during an extended…May 22, 2016 · N1111X · Substantial damageNTSB CEN16LA151Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Caldwell, TXThe failure of the No. 5 cylinder's exhaust pipe for undetermined reasons, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s fast and long landing, which led to a runway overrun.Apr 10, 2016 · N8PY · Substantial damageNTSB ERA16LA059Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Raeford, NCThe pilot's failure to obtain the proper touchdown point and speed during a precautionary landing with the engine shut down. Contributing to the accident was an erroneous engine torque indication, which led the pilot to shut the engine down, for reasons that…Dec 3, 2015 · N216PK · Substantial damageNTSB ERA15LA380Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Sarasota, FLThe pilot’s failure to attain the proper touchdown point and to adequately slow the airplane within the available runway, which resulted in a runway overrun.Sep 27, 2015 · N622PG · Substantial damageNTSB ERA15LA322Accident · Minor injuriesLimited investigationFinal reportEclipse EA500 · Danbury, CTThe pilot's failure to attain the proper touchdown point and exceedance of the target touchdown speed, which resulted in a runway overrun.Aug 21, 2015 · N120EA · Substantial damageNTSB CEN15LA369Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bolivar, MOTotal electrical failure due to a failed voltage regulator and the pilot’s failure to maintain a proper airspeed during a precautionary landing, which resulted in a loss of directional control and a runway excursion.Aug 18, 2015 · N6KW · Substantial damageNTSB ERA15LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Perkasie, PAThe pilot's failure to use the mixture control to override a throttle anomaly and reduce engine power, which resulted in excessive airspeed upon landing and a subsequent runway overrun. Contributing to the accident was the pilot’s inability to reduce the…Jul 25, 2015 · N777EX · Substantial damageNTSB GAA15CA190Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Greensboro, NCThe pilot's decision to continue the approach after realizing the intended parameters were not attainable, resulting in a runway over-shoot, a loss of control on the ground and the consequent collision with trees.Jul 18, 2015 · N96ML · Substantial damageNTSB WPR15CA214Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Laurier, WAThe pilot's inadequate decision to continue the approach, which resulted in a long landing and insufficient runway remaining to stop the airplane before it departed the end of the runway.Jul 15, 2015 · C-GDYN · Substantial damageNTSB WPR15LA175Accident · No injuriesLimited investigationFinal reportMooney M20K · Fresno, CAA total loss of engine power during cruise flight due to a failure of the No. 1 piston and connecting rod assembly.Jun 3, 2015 · N3567H · Substantial damageNTSB CEN15CA246Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Winnsboro, LAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot and collision with trees.May 29, 2015 · N1036S · Substantial damageNTSB GAA15CA081Accident · Serious injuriesData collectionFinal reportCitabria 7GCBC · Winnsboro, SCThe pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.May 20, 2015 · N50595 · Substantial damageNTSB ERA15LA200Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Sylacauga, ALA partial loss of engine power due to the failure of the throttle body/fuel metering unit to provide the engine with adequate fuel pressure for full power operation.Apr 27, 2015 · N248ME · Substantial damageNTSB ERA15CA196Accident · No injuriesData collectionFinal reportCessna 172P · Sebastian, FLThe pilot's misjudged airspeed and glidepath, which resulted in a landing area overshoot and runway excursion.Apr 17, 2015 · N66090 · Substantial damageNTSB GAA15CA034Accident · Minor injuriesData collectionFinal reportCessna 182F · Portland, TNThe pilot's failure to perform a go-around in time to prevent a runway overrun and collision with terrain.Apr 7, 2015 · N3586Y · Substantial damageNTSB ERA15LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Allentown, PAA total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.Apr 6, 2015 · N4826H · Substantial damageNTSB ERA15LA161Accident · Serious injuriesLimited investigationFinal reportLanshe Aerospace Lake 250 · Fernandina Beach, FLThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.Mar 18, 2015 · N99HB · Substantial damageNTSB ERA15CA154Accident · No injuriesData collectionFinal reportBeech 58 · Monroe, NCThe pilot's failure to maintain a proper glidepath and failure to perform a go-around once a safe landing could not accomplished, which resulted in a landing area overshoot and runway excursion.Mar 4, 2015 · N50NH · Substantial damageNTSB ERA15CA143Accident · No injuriesData collectionFinal reportPiper J3C 65 · Clermont, FLThe pilot's failure to land the airplane within the desired touchdown zone, resulting in a long landing and collision with a fence.Mar 1, 2015 · N717ML · Substantial damageNTSB WPR15LA106Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Alfalfa, ORA total loss of engine power after takeoff for reasons that could not be determined, because examination of the engine did not reveal any mechanical anomalies that would have precluded normal operation.Feb 18, 2015 · N4863 · Substantial damageNTSB WPR15CA100Accident · Minor injuriesData collectionFinal reportCessna U206 - G · Kernville, CAThe pilot's inadequate flare and failure to maintain airplane control during the landing with a tailwind which resulted in a bounce, long landing, and subsequent runway excursion.Feb 9, 2015 · CFGQQ · Substantial damageNTSB WPR15CA076Accident · No injuriesData collectionFinal reportBeech 35 A33 · Angwin, CAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, and collision with a fence.Jan 4, 2015 · N907Q · Substantial damageNTSB WPR15CA057Accident · Minor injuriesData collectionFinal reportCessna P210 - N · Jeffrey, WYThe pilot's inadequate approach and excessive airspeed, which resulted in a long landing, the subsequent runway overrun, and impact with terrain. Contributing to the accident was the pilot's delay in aborting the landing.Dec 9, 2014 · N4881K · Substantial damageNTSB CEN15LA057Accident · No injuriesLimited investigationFinal reportEmbraer EMB-500 · Sugarland, TXThe pilot's engagement of the emergency parking brake during the landing roll, which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the pilot's decision to engage the emergency parking…Nov 21, 2014 · N584JS · Substantial damageNTSB CEN15LA053Accident · Minor injuriesLimited investigationFinal reportBeech 58P · San Antonio, TXThe pilot’s improper decision to land long (past the midpoint) on a wet runway and his failure to conduct a go-around when the airplane did not touch down at the approach end of the runway, which resulted in an overrun.Nov 20, 2014 · N3689L · Substantial damageNTSB ERA15LA053Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Clinton, CTThe pilot's inadequate fuel planning and improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow proper procedures in response to the loss of engine power.Nov 15, 2014 · N4548S · Substantial damageNTSB ERA15CA021Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Everglades City, FLThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, runway excursion, and collision with vegetation and water.Oct 18, 2014 · N254WM · Substantial damageNTSB WPR14CA378Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Walla Walla, WAThe pilot's misjudged approach which resulted in overshooting the landing point and insufficient remaining landing surface.Aug 25, 2014 · N7860D · Substantial damageNTSB ANC14CA064Accident · No injuriesData collectionFinal reportCessna 182A · Gustavus, AKThe pilot's unstable landing approach which resulted in a long landing, and subsequent collision with terrain.Aug 14, 2014 · N2121G · Substantial damageNTSB ERA14CA373Accident · Minor injuriesData collectionFinal reportPiper PA-46-350P · Statesville, NCThe pilot's failure to maintain a proper glide path and airspeed on final approach, which resulted in a long landing and runway excursion.Aug 2, 2014 · N472ST · Substantial damageNTSB ANC14CA057Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Illiamna, AKThe pilot's inadequate landing technique that resulted in a landing area overrun. Contributing was the glassy water conditions.Aug 1, 2014 · N87808 · Substantial damageNTSB ERA14CA364Accident · No injuriesData collectionFinal reportCessna 177B · Falmouth, MAThe pilot's misjudgment of speed and distance on final approach resulting in a touchdown near the departure end of the runway, a runway excursion, and collision with trees.Jul 19, 2014 · N18509 · Substantial damageNTSB WPR14CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Hoopa, CAThe pilot's inadequate approach and excessive airspeed which resulted in a long landing and subsequent runway overrun onto rough terrain.Jul 18, 2014 · N528DC · Substantial damageNTSB ANC14CA045Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Nenana, AKThe pilot's excessive braking following his overshoot of the intended touchdown point on a short airstrip, which resulted in nose-over of the airplane. A contributing factor was the pilot's mental distraction during the landing.Jun 21, 2014 · N4000Z · Substantial damageNTSB WPR14CA264Accident · No injuriesData collectionFinal reportCessna 175A · Salmon, IDThe pilot's failure to attain the proper touchdown point that resulted in a runway overrun.Jun 19, 2014 · N7936T · Substantial damageNTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…Jun 6, 2014 · N1301H · Substantial damageNTSB ERA14CA263Accident · Minor injuriesData collectionFinal reportCessna 182J · Perkasie, PAThe pilot's failure to select and attain a proper touchdown point during landing which resulted in a runway overrun.May 24, 2014 · N3388F · Substantial damageNTSB ERA14CA238Accident · Serious injuriesData collectionFinal reportNorth American AT6 - C · Roxbury, NYThe pilot's failure to maintain adequate obstacle clearance, which resulted in the inflight collision with a power line.May 9, 2014 · N164EW · Substantial damageNTSB ERA14LA212Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Taylorsville, NCThe pilot’s improper approach, which resulted in a long landing right of the runway centerline and the airplane’s subsequent collision with a riding mower that would have been difficult for the pilot to see due to its color and the nose-high attitude of the…Apr 26, 2014 · N9122E · Substantial damageNTSB ERA14CA177Accident · No injuriesData collectionFinal reportAviat A 1B · Dadeville, ALThe pilot's failure to obtain the proper touchdown point while landing on a lake with a tailwind.Mar 27, 2014 · N59AW · Substantial damage