NTSB investigations
820 cases where the first occurrence was “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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 390) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 390) 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 IAD05LA109Accident · No injuriesLimited investigationFinal reportBeech BE-35-C33A · East Hampton, NYThe pilot's failure to attain the proper touchdown point during landing, which resulted in the airplane touching down short of the landing surface.NTSB LAX05CA219Accident · Minor injuriesData collectionFinal reportCessna 180A · Big Bend, CAthe pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.NTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.NTSB NYC05CA097Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin Astir · Wellington, OHThe pilot's misjudgment of distance and altitude which resulted in an undershoot of the runway.NTSB CHI05CA119Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Beloit, WIThe pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.NTSB ATL05LA078Accident · 1 fatalLimited investigationFinal reportEarnest Jodel D-9 · Memphis, TNThe pilot's misjudgment of distance/altitude, and his failure to maintain adequate airspeed resulting in a stall and subsequent undershoot.NTSB MIA05LA077Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · DeLand, FLThe failure of the pilot to maintain sufficient airspeed during landing, resulting in an inadvertent stall, undershoot and collision with the ground.NTSB ANC05LA045Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fairbanks, AKThe pilot's delay in performing a go-around, and his failure to maintain obstacle clearance.NTSB LAX05LA089Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601 · Murrieta, CAThe pilot's misjudgment of distance/altitude on final approach, which resulted in an undershoot of the runway.NTSB SEA05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Spanaway, WAThe pilot's misjudgment of distance/altitude during final approach to land which resulted in an undershoot and in flight collision with a fence. A factor was the pilot's alcohol impairment.NTSB NYC05CA023Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Appomattox, VAthe pilot's misjudgment of distance and altitude.NTSB MIA04LA124Accident · No injuriesLimited investigationFinal reportCessna 550 · Venice, FLThe pilot's failure to maintain adequate airspeed which resulted in a stall and undershoot of the runway.NTSB DEN04CA125Accident · Minor injuriesData collectionFinal reportMaule M-6-235 · Dubois, WYthe pilot's misjudgment of altitude/distance resulting in an undershoot of the runway.NTSB ANC04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's misjudged distance/altitude during the final approach phase of landing, which resulted in an undershoot and subsequent collision with terrain.NTSB CHI04CA190Accident · No injuriesData collectionFinal reportSelby Dean KR-2-SS · Lake Elmo, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control. A related factor was the crosswind.NTSB ATL04CA144Accident · Minor injuriesData collectionFinal reportMooney M-20E · Thomasville, GAThe pilot's misjudgment of the airspeed and distance during approach to land that resulted in an undershoot and the subsequent collision with the ground.NTSB LAX04CA246Accident · No injuriesData collectionFinal reportSchweizer 1-35 · Sparks, NVthe pilot's misjudgment of altitude and distance resulting in an undershoot of the runway.NTSB LAX04LA235Accident · 1 fatalLimited investigationFinal reportHarold W Bruce RV-6 · Cloverdale, CAthe pilot's inadequate in-flight planning/decision and selection of the wrong runway, and his inadequate compensation for the gusting tail wind conditions, which resulted in a stall/mush.NTSB SEA04LA085Accident · No injuriesLimited investigationFinal reportStinson SR-10E · Eliza Island, WAThe pilot's misjudgment of altitude/distance resulting in an undershoot of the runway.NTSB ATL04LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cortland, ALThe pilot's misjudgment of distance/altitude and his failure to maintain obstacle clearance which resulted in an undershoot and collision with trees.NTSB CHI04CA117Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · DeKalb, ILThe failure of the pilot and his flight instructor to identify the location of the relocated threshold and proper touchdown point, which resulted in the airplane striking the construction barricade while on approach. A factor to the accident was the…NTSB MIA04CA080Accident · Minor injuriesData collectionFinal reportBeech H35 · Fort Pierce, FLThe pilots failure to maintain the proper glide path during the approach which resulted in the airplane undershooting the runway and not attaining the proper touchdown point.NTSB ANC04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were a downdraft, and an embankment.NTSB NYC04CA112Accident · No injuriesData collectionFinal reportBolger Scott RV-6A · Fredericksburg, VAThe pilots failure to maintain airspeed during a precautionary landing which resulted in an undershoot and subsequent impact with terrain. A factor was the inadequate pre-flight inspection.NTSB NYC04LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAThe pilot's misjudgment of altitude/distance and his failure to maintain adequate clearance from trees while landing. Factors related to the accident were the lack runway displaced threshold markings, the trees located at the end of the runway, and the…NTSB CHI04LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Carroll, IAThe pilot's misjudgment of altitude and distance, and his inadequate remedial action which resulted in the failure to attain the proper touchdown point on the runway. A factor was the snow covered terrain which was encountered by the airplane.NTSB LAX04CA115Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Placerville, CAthe pilot's failure to attain a proper glide path during the final approach and delayed go-around, resulting in an undershoot of the runway. The inadequate supervision of the flight and flight instructor's delayed remedial action was also causal.NTSB ANC04LA013Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Anchorage, AKThe pilot's misjudged altitude during final approach, which resulted in an undershot landing, and subsequent nose over.NTSB MIA04CA006Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Everglades City, FLThe pilot's failure to maintain the proper glide path during the approach to land, which resulted in him undershooting the runway.NTSB SEA04LA008Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Spanaway, WAThe pilot's misjudgment of distance and altitude resulting in an undershoot of the runway and collision with a fence. A fence was a factor in the accident.NTSB CHI04LA008Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Harvard, ILThe pilot misjudged his altitude and distance from the approach end of the airstrip, along with his decision to land at an unlit airstrip at night. Factors involved in the accident were the the night lighting conditions, the unlit airstrip, and the corn crop…NTSB SEA03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cle Elum, WAAn undershoot due to the pilot's failure to maintain a proper glide path on final approach to landing. A factor was the gravel.NTSB ANC03LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKThe pilot's misjudgment of the distance/altitude to the touchdown point during landing, which resulted in an undershoot and collision with a river bank. A factor contributing to the accident was the presence of a river bank that formed the beginning of the…NTSB SEA03LA182Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Hillsboro, ORThe pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.NTSB LAX03CA266Accident · No injuriesData collectionFinal reportCessna 172M · Riverside, CAThe student pilot's misjudged distance and altitude, and the instructor's inadequate supervision of the flight. Also causal was the instructor's delayed remedial action.NTSB MIA03LA189Accident · No injuriesLimited investigationFinal reportCessna 182P · Tampa, FLThe pilot's failure to attain the proper touchdown point which resulted in an undershoot.NTSB ANC03LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with terrain.NTSB ANC03LA062Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-226T · Goodnews, AKThe flight crew's inadequate evaluation of the weather conditions, which resulted in their inadequate compensation for the wind conditions, and subsequent undershoot. A contributing factor in the accident was a downdraft.NTSB ATL03LA101Accident · No injuriesLimited investigationFinal reportBeech 58P · Gatlinburg, TNThe pilot's misjudgment of altitude and distance to the runway during final approach, and his failure to attain the proper touchdown point for landing.NTSB CHI03LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeport, ILThe pilot's misjudgment of distance and altitude, and his failure to maintain obstacle clearance.NTSB ATL03LA092Accident · No injuriesLimited investigationFinal reportCessna 172H · Somerville, TNThe pilot's misjudged approach airspeed and distance which resulted in an undershoot of the runway and collision with terrain.NTSB SEA03LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orofino, IDThe pilot's misjudgment of speed and distance resulting in a loss of airspeed, stall and undershoot of runway.NTSB NYC03LA081Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-30 · Du Bois, PAThe captain's failure to maintain the proper glidepath during the instrument approach, and his failure to perform a go-around. Factors were a low ceiling and reduced visibility due to mist.NTSB FTW03LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moran, TXLanding short of the runway due to the pilot's failure to maintain a proper glide path, which resulted in the airplane impacting a tree. A contributing factor was the short runway.NTSB NYC03LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's misjudgment of distance/altitude and the instructor's delayed remedial action,NTSB NYC03LA050Accident · No injuriesLimited investigationFinal reportCessna 182R · Warwick, NYThe pilot's inadequate compensation for winds, and his failure to maintain the proper descent rate. A factor in the accident was the gusty wind conditions.NTSB ATL02LA177Accident · No injuriesLimited investigationFinal reportSchempp-Hirth KA8B · Tullahoma, TNThe student pilot misjudged the airspeed and altitude during a visual approach to land that resulted in the in-flight collision with the trees.NTSB CHI02CA287Accident · No injuriesData collectionFinal reportCessna 150G · Dodge Center, MNThe pilot's misjudgment of distance resulting in an undershoot of the runway.NTSB FTW02LA246Accident · No injuriesLimited investigationFinal reportCessna 182-Q · New Roads, LAThe pilot's failure to maintain airspeed which resulted in a stall.NTSB NYC02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · New Bedford, MAThe pilots failure to obtain the proper touchdown point, and the CFI's delay in remedial action.