NTSB investigations
136 cases where the defining event was Landing area undershoot.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '370') 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.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '370') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA11CA294Accident · Minor injuriesData collectionFinal reportPiper PA-23-250 · Clayton, NYThe pilot's failure to obtain a proper touchdown point while landing with a gusting tailwind.NTSB ANC11CA025Accident · No injuriesData collectionFinal reportPiper PA-12 · Delta Junction, AKThe pilot's misjudged altitude while landing in bright sunlight on an airstrip surrounded by snow, resulting in an undershoot and a nose over.NTSB ERA11LA224Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Greenwood, MSThe pilot did not obtain the proper touchdown point as a result of his decision to shut down the engine and to deploy the landing gear and flaps before the landing was assured. Contributing to the accident was his decision to overfly a closer suitable airport…NTSB CEN11CA166Accident · No injuriesData collectionFinal reportMcholland C L Solitare · Wellington, COThe glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.NTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.NTSB WPR11CA040Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Carnation, WAThe pilot's failure to attain the proper touchdown point during a practice off-airport landing.NTSB ERA11CA040Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Julian, NCThe pilot's failure to attain the proper touchdown point.NTSB ENG12RA005Accident · Minor injuriesForeign investigationAirbus A319 - 132 · Palermo (Sicily), ItalyNTSB ANC10CA089Accident · No injuriesData collectionFinal reportCessna 150M · Bethel, AKThe pilot's failure to maintain altitude/clearance during a night approach, resulting in a collision with terrain short of the runway.NTSB CEN10CA504Accident · Minor injuriesData collectionFinal reportRauch RV-3 · Newark, OHThe pilot’s failure to attain the proper touchdown point, resulting in an undershoot.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB CEN10CA499Accident · No injuriesData collectionFinal reportCessna 182P · Del Rio, TXThe pilot's failure to monitor his altitude while making a visual approach, which resulted in landing short of the runway and subsequent collision with terrain.NTSB 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.NTSB ERA10CA343Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Burnsville, NCThe pilot's failure to maintain a proper visual glideslope during final approach.NTSB ERA10CA265Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Carrollton, GAThe pilot's improper touchdown point during landing. Contributing to the accident was the certificated flight instructor's lack of remedial action.NTSB CEN10CA106Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Cherokee, IAThe pilot misjudged his altitude while on short final approach.NTSB WPR10CA020Accident · Minor injuriesData collectionFinal reportMooney M20J · Hesperia, CAThe pilot's improper glide path and failure to maintain clearance from the airport perimeter fence during the landing approach.NTSB CEN09CA453Accident · No injuriesData collectionFinal reportPiper PA28 · Malvern, ARThe pilot's failure to maintain adequate airspeed during the approach to landing.NTSB ERA09CA387Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Winder, GAThe pilot's failure to obtain the proper touchdown point during a practice forced landing, and the flight instructor's delayed decision to initiate a go-around.NTSB CEN09CA351Accident · No injuriesData collectionFinal reportBell 206B · Justin, TXThe instructor pilot's failure to add sufficient power early enough to compensate for the strong gusting headwinds.NTSB WPR09CA148Accident · No injuriesData collectionFinal reportEurocopter AS350BA · Long Beach, CAThe pilot's misjudged speed and altitude, which resulted in an undershoot of the landing zone.NTSB CEN09CA166Accident · No injuriesData collectionFinal reportPiper PA-28 · Terrell, TXThe commercial pilot's failure to maintain adequate airspeed during the approach which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of recent flight experience.NTSB CEN09CA004Accident · No injuriesData collectionFinal reportCessna 182P · Mount Vernon, MOThe pilot failed to maintain a proper landing aim point. Contributing to the accident were the setting sun and the uneven terrain approaching the runway.NTSB ERA09CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Chester, CTThe pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.NTSB LAX08CA262Accident · Minor injuriesData collectionFinal reportLet Blanik L-13 · Bend, ORThe pilot's misjudged distance/altitude which resulted in an undershoot while on final approach to land. Factors contributing to the accident were the lack of thermal lift (sinking air), and the lack of suitable terrain for the off-airport landing.NTSB LAX08CA278Accident · No injuriesData collectionFinal reportPiper PA-22 · St. Paul, ORThe pilot's misjudged altitude, speed, and subsequent failure to attain the proper touchdown point while landing.NTSB MIA08CA136Accident · No injuriesData collectionFinal reportSchleicher ASK-21 · Elmira, NYThe glider pilot's misjudged distance/altitude while soaring.NTSB LAX08CA216Accident · No injuriesData collectionFinal reportCessna 172M · Skykomish, WAThe pilot's inadequate in-flight planning/decision and failure to execute a go-around when the airplane floated during the flare. Contributing to the accident was the short and wet turf runway surface, which reduced braking action.NTSB NYC08CA227Accident · No injuriesData collectionFinal reportNord Stampe SV4C · Taneytown, MDThe pilot's misjudgment of the airplane's altitude during the final approach.NTSB DFW08CA164Accident · No injuriesData collectionFinal reportBritish Jet Provost T Mk.5A · Bay City, TXThe pilot's failure to maintain aircraft control during final approach. Contributing to the accident was the downdraft.NTSB LAX08CA176Accident · No injuriesData collectionFinal reportClarke Colin Glastar · Wenatchee, WAThe pilot's failure to initiate a timely go-around after the first bounce.NTSB LAX08CA172Accident · No injuriesData collectionFinal reportCessna T337G · GreatBarrington, MAThe pilot's misjudgment of distance and altitude, and failure to attain the proper touchdown point. The pilot's delayed remedial action was also causal.NTSB LAX08CA136Accident · Minor injuriesData collectionFinal reportA. Schleicher ASW 27-18 · Peoria, AZThe pilot's misjudged distance and altitude while on final approach to land. A factor contributing to the accident was a downdraft.NTSB NYC08LA168Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Dansville, NYThe pilot's failure to attain the proper glide path and the flight instructor's delayed remedial action. Contributing to the accident was the encountered headwind.NTSB MIA08CA093Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Ellington, CTThe pilot's failure to perform a go-around when the airplane floated during landing.NTSB ANC08CA051Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Stevensville, MDThe pilot's misjudged speed/distance during landing.