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 CEN11LA426Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphia, OHThe pilot's incorrect identification of the wind direction before landing, which resulted in a tailwind landing and subsequent runway excursion.Jun 25, 2011 · N6980W · Substantial damageNTSB ERA11CA372Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carbondale, PAThe pilot's inadequate recovery from a bounced landing, which resulted in a runway overrun. Contributing to the accident was that the pilot did not attain the proper landing point.Jun 18, 2011 · N3068E · Substantial damageNTSB ERA11CA350Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Sterling, MAThe pilot's misjudgment of the amount of flaps required to attain the proper touchdown point. Contributing to the accident was the pilot's limited experience in the high performance glider.Jun 16, 2011 · N99136 · Substantial damageNTSB ERA11LA345Accident · No injuriesLimited investigationFinal reportCessna 525A · Nashville, TNThe pilot-in-command's failure to execute a go-around when the airplane was high and fast on the final approach.Jun 15, 2011 · N129SG · Substantial damageNTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.Jun 8, 2011 · N8895B · Substantial damageNTSB ERA11CA273Accident · No injuriesData collectionFinal reportCessna 172M · Suchez, GAThe failure of the pilot to initiate a go-around and his excessive airspeed on the final landing approach.Apr 30, 2011 · N12839 · Substantial damageNTSB DCA11IA047Incident · No injuriesIncident investigationFinal reportBoeing 737-7Q8 · Chicago, ILThe flight crew's delayed deployment of the speedbrakes and thrust reversers, resulting in insufficient runway remaining to bring the airplane to a stop. Contributing to the delay in deployment of these stopping devices was the flight crew's inadequate…Apr 26, 2011 · N799SW · Minor damageNTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.Apr 24, 2011 · N304EB · Substantial damageNTSB ERA11LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Maury City, TNThe pilot's failure to attain the proper glidepath during on off-airport landing.Mar 20, 2011 · N6555S · Substantial damageNTSB CEN11LA223Accident · No injuriesLimited investigationFinal reportLearjet 25 · Houston, TXThe flying pilot's failure to attain the proper touchdown point in low-visibility conditions, which resulted in a runway overrun. Contributing to the accident was mission pressure to land at that airport.Mar 4, 2011 · XA-TWH · Substantial damageNTSB ERA11LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Welch, WVThe unlicensed pilot’s decision to land on a closed runway with a tailwind, his failure to attain the proper touchdown point, and his delayed decision to attempt a go-around, resulting in a collision with trees.Feb 27, 2011 · N739NY · Substantial damageNTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.Jan 29, 2011 · N64FM · Substantial damageNTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…Nov 17, 2010 · N25PJ · Substantial damageNTSB WPR11CA026Accident · No injuriesData collectionFinal reportCessna 340A · Camp Verde, AZThe pilot's misjudged approach and failure to attain the correct touchdown point, which resulted in a runway overrun.Oct 23, 2010 · N630PL · Substantial damageNTSB WPR11CA022Accident · Minor injuriesData collectionFinal reportRotherwick Glasair III · Colville, WAThe pilot's misjudged approach and failure to attain the proper touchdown point, which resulted in a runway overrun.Oct 21, 2010 · N471B · Substantial damageNTSB WPR11CA007Accident · No injuriesData collectionFinal reportPiper PA-12 · Valley, WAThe pilot's excessive brake application during the landing roll after overshooting the intended touchdown point, resulting in a nose over.Oct 9, 2010 · N2971M · Substantial damageNTSB ERA11IA006Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe pilot-in-command's failure to attain the proper touchdown point while landing with a gusting crosswind and failure to initiate a go-around, which resulted in a landing more than halfway down the runway and a subsequent runway overrun. Contributing to the…Oct 1, 2010 · N923CL · Minor damageNTSB ERA11FA001Accident · Minor injuriesField investigationFinal reportCessna 550 · Manteo, NCThe pilot-in-command's failure to maintain proper airspeed and his failure to initiate a go-around, which resulted in the airplane touching down too fast on a short, wet runway and a subsequent runway overrun. Contributing to the accident was the copilot's…Oct 1, 2010 · N262Y · Substantial damageNTSB CEN11CA004Accident · No injuriesData collectionFinal reportCessna 172N · Wabash, INThe student pilot's failure to maintain proper airspeed during the landing and certificated flight instructor's failure to execute a go-around.Oct 1, 2010 · N2140E · Substantial damageNTSB CEN10CA577Accident · No injuriesData collectionFinal reportCessna T182T · Downers Grove, ILThe pilot's improper airspeed during landing, which resulted in a runway overrun, and his delayed decision to execute a go-around.Sep 28, 2010 · N2439W · Substantial damageNTSB CEN10CA562Accident · Minor injuriesData collectionFinal reportCessna 172M · Point Lookout, MOThe pilot receiving instruction's failure to attain the proper touchdown point and execute a go-around and the CFI’s delayed remedial action, which resulted in a runway overrun.Sep 25, 2010 · N1131U · Substantial damageNTSB ERA10CA496Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Marlboro, MAThe pilot’s improper touchdown point and failure to perform a go-around in a timely manner, which resulted in a runway excursion.Sep 22, 2010 · N260ND · Substantial damageNTSB CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.Sep 20, 2010 · N9071X · Substantial damageNTSB CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.Sep 5, 2010 · N4664 · Substantial damageNTSB ERA10CA451Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Montauk, NYThe pilot's delay in aborting the landing, which resulted in a collision with a fence.Aug 28, 2010 · N9532L · Substantial damageNTSB ERA10CA447Accident · No injuriesData collectionFinal reportCessna T206H · Clayton, GAThe pilot's improper touchdown point while landing on the wet grass.Aug 27, 2010 · N6075M · Substantial damageNTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.Aug 14, 2010 · N677DS · Substantial damageNTSB WPR10CA402Accident · No injuriesData collectionFinal reportCessna 182P · Compton, CAThe pilot's failure to attain the proper touchdown point that resulted in an overrun of the runway and collision with a wall.Aug 14, 2010 · N20872 · Substantial damageNTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.Aug 12, 2010 · N9353C · Substantial damageNTSB CEN10CA464Accident · No injuriesData collectionFinal reportCessna 414 · Vici, OKThe pilot's failure to ensure adequate runway remaining during landing.Aug 4, 2010 · N414TT · Substantial damageNTSB WPR10CA351Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Fullerton, CAThe pilot’s improper flare and inadequate bounced landing recovery, which resulted in a hard landing and porpoise down the runway.Jul 15, 2010 · N8337A · Substantial damageNTSB CEN10CA405Accident · No injuriesData collectionFinal reportCessna 172K · Boyne City, MIThe pilot's failure to attain the proper touchdown point and delayed go-around.Jul 10, 2010 · N79097 · Substantial damageNTSB CEN10CA387Accident · No injuriesData collectionFinal reportCessna 140 · Franklin, INThe pilot's improper touchdown point and excessive braking, which resulted in a nose over.Jul 10, 2010 · N72609 · Substantial damageNTSB ERA10LA345Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fairfield, PAThe pilot's improper touchdown point which resulted in an overrun.Jul 3, 2010 · N9809P · 2 aircraft · Substantial damageNTSB ERA10LA322Accident · Serious injuriesLimited investigationFinal reportCessna 172N · West Milford, NJThe student pilot’s control interference which resulted in a landing with a higher than normal airspeed, and the commercial pilot’s failure to initiate a go-around to avoid the runway overrun.Jun 20, 2010 · N738QZ · Substantial damageNTSB ERA10LA294Accident · Minor injuriesLimited investigationFinal reportSwanson RV-9A · Ashland, VAThe pilot's failure to obtain the proper touchdown point during a forced landing in gusting wind. Contributing to the accident was a total loss of engine power, likely due to carburetor ice.Jun 1, 2010 · N858JK · Substantial damageNTSB WPR10CA281Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Avalon, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun.May 29, 2010 · N314CP · Substantial damageNTSB WPR10CA244Accident · Minor injuriesData collectionFinal reportSchweizer SGS136 · Reno, NVThe student pilot’s selection of the wrong runway for the wind conditions and his failure to attain the proper touchdown point. Contributing to the accident was the student's lack of total experience, lack of experience in the operating area, lack of…May 16, 2010 · N3617E · Substantial damageNTSB WPR10LA235Accident · No injuriesLimited investigationFinal reportBeech 35 · South Bend, WAA loss of engine power during takeoff for undetermined reasons, which resulted in a runway overrun.May 2, 2010 · N3174V · Substantial damageNTSB ERA10CA274Accident · No injuriesData collectionFinal reportCessna T210N · Fuquay-Varina, NCThe pilot's improper decision to land with a tailwind resulting in an overrun.Apr 28, 2010 · N110KM · Substantial damageNTSB ERA10CA209Accident · Minor injuriesData collectionFinal reportCessna 182S · Montauck, NYThe pilot’s excessive airspeed on final approach and his failure to achieve the proper touchdown point.Apr 3, 2010 · N127S · Substantial damageNTSB CEN10CA177Accident · No injuriesData collectionFinal reportCessna 182T · Lansing, IAThe pilot's failure to attain a proper touchdown point, resulting in an overrun and intentional ground loop.Mar 29, 2010 · N3503H · Substantial damageNTSB WPR10CA145Accident · No injuriesData collectionFinal reportTerrell Caragol RV-7 · Oregon City, ORThe pilot’s failure to attain a proper touchdown point.Feb 22, 2010 · N209MT · Substantial damageNTSB ERA10CA124Accident · No injuriesData collectionFinal reportCessna 150 · Taunton, MAThe pilot's failure to obtain the proper touchdown point during landing.Jan 26, 2010 · N5478Q · Substantial damageNTSB ERA10CA122Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's improper approach, failure to perform a go-around, and failure to maintain directional control while braking after a long landing.Jan 21, 2010 · N8428H · Substantial damageNTSB CEN10LA105Accident · No injuriesLimited investigationFinal reportBeech B200 · Sioux City, IAThe flight crew's decision to attempt a flight that was below takeoff, landing, and alternate airport weather minimums, which led to a touchdown off the runway surface by the pilot-in-command.Jan 19, 2010 · N586BC · Substantial damageNTSB WPR10CA095Accident · No injuriesData collectionFinal reportCessna 182P · Fallbrook, CAThe pilot's misjudged altitude and airspeed that resulted in his failure to attain the proper touchdown point.Jan 3, 2010 · N7417N · Substantial damageNTSB WPR10LA072Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Clarksburg, CAThe pilot’s improper touchdown point and excessive airspeed during landing, which resulted in a runway overrun.Dec 4, 2009 · N6649M · Substantial damageNTSB ERA10CA030Accident · No injuriesData collectionFinal reportCessna 182 · White Plains, NYThe pilot's failure to attain the proper touchdown point, resulting in a landing overrun. Contributing to the accident was the pilot’s excessive airspeed in an attempt to comply with air traffic control’s request to expedite his landing.Oct 21, 2009 · N4731N · Substantial damageNTSB CEN10CA015Accident · Serious injuriesData collectionFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to select an adequate landing area.Oct 8, 2009 · N4014J · Minor damage