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 LAX95LA164Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Peoria, AZthe pilot's misjudged evaluation of the weather, and his inadequate compensation for the gusting winds and downdrafts.NTSB ANC95LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKA failure of the instructor pilot to adequately supervise the student pilot's landing approach. The student pilot's failure to maintain a proper altitude and distance to the runway touch-down point, and a snow berm at the approach end of the runway were…NTSB SEA95LA069Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Bozeman, MTThe pilot misjudged his altitude and distance from the runway. A factor was the pilot's failure to obtain the current altimeter setting.NTSB CHI95LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeville, MNThe pilot misjudged distance and altitude during landing.NTSB NYC95LA057Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Warwick, NYthe pilot allowed the airplane to get too low on the approach, during a simulated engine out landing, which resulted in impacting high bushes, and landing short of the runway.NTSB CHI95LA076Accident · No injuriesLimited investigationFinal reportBeech V35A-TC · Pembina, NDthe pilot's misjudgement of the actual altitude of the airplane. Factors were the visual illusion caused by the snow covered runway environment and the whiteout weather condition.NTSB CHI95LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Brookfield, WIThe instructor's failure to maintain clearance with trees. Factors associated with the accident were the trees and the night lighting conditions.NTSB MIA95FA053Accident · 2 fatalField investigationFinal reportLarson, C.H. Cozy MK IV · Wauchula, FLDistance vs. altitude misjudged by the pilot-in-command while on short final approach. Additionally, altitude/clearance not maintained while on short final approach resulting in the collision with an unmarked static power line.NTSB NYC95LA040Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Blairstown, NJThe pilot's failure to maintain the proper descent rate.NTSB FTW95LA033Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Midlothian, TXThe pilot-in-command's misjudgment of altitude and distance to the runway, while on final approach to land, and his failure to ensure altitude and clearance from obstacles, while allowing the student pilot to be on the controls. Darkness was a related factor.NTSB LAX95LA013Accident · No injuriesLimited investigationFinal reportStan G. Hallam RV-6 · Bridgeport, CAthe pilot's poorly planned approach, his failure to maintain the proper airspeed and descent rate, and his failure to perform the necessary remedial action.NTSB CHI95LA013Accident · No injuriesLimited investigationFinal reportLearjet 23 · Holland, MIThe copilot's misjudgment of the touchdown point, and the pilot in command's inadequate supervision to avoid the accident.NTSB SEA95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Albany, ORThe failure of the dual student to maintain a proper glidepath and the pilot-in-command's inadequate supervision.NTSB LAX95LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Coalinga, CAthe pilot's failure to maintain a proper glide path.NTSB FTW95LA010Accident · Minor injuriesLimited investigationFinal reportWinn RV-6A · Marble Falls, TXThe pilot's improper compensation for the wind conditions. A factor was the unfavorable winds.NTSB NYC95FA001Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Montgomery, NYwas the failure of the pilot to maintain adequate terrain clearance on final approach which resulted in a tree strike. Factors were the night conditions and the failure of the pilot to use the recommended runway.NTSB FTW95LA005Accident · No injuriesLimited investigationFinal reportCessna 150L · Booker, TXThe pilot's failure to maintain a proper glidepath resulting in a collision with an object. Factors were the dark night and the pilot's disregard for the lack of lights.NTSB LAX94LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Woodland, CAthe failure of the pilot to maintain an adequate airspeed during a short field approach and the inadvertent entry into a stall/mush condition. In addition, the instructor failed to take proper remedial action.NTSB FTW94LA310Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Nikiski, AKThe pilot's improper descent rate. A factor was the check pilot's inadequate supervision.NTSB FTW94LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Byers, COFailure by the pilot to maintain a proper descent rate during approach to landing. A factor was lack of experience in make, model, and type of aircraft.NTSB CHI94LA341Accident · No injuriesLimited investigationFinal reportDooley, James M Velocity · Valparaiso, INthe pilot-in-command's improper use of the elevator trim. A factor was the pilot-in-command's lack of total experience in type of aircraft.NTSB ATL94LA173Accident · No injuriesLimited investigationFinal reportBeech M35 · Winston-Salem, NCThe student pilot's failure to maintain airspeed and a proper glidepath on final approach, resulting in an inadvertent stall and undershoot. Factors were the night lighting conditions, and the flight instructor's inadequate supervision of the student pilot.NTSB CHI94LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Madison, WIThe pilot-in-command not maintaining a proper glidepath during his final approach to landing. A factor associated with the accident was the lack of recent experience in the type operation performed by the pilot.NTSB NYC94LA173Accident · No injuriesLimited investigationFinal reportSchleicher ASW15B · Dansville, NYThe pilot allowed the speed of the glider to get to low on final approach which resulted in a rapid descent, subsequent undershoot of the runway, and impact with a tree. A factor in this accident was a downdraft condition.NTSB NYC94LA162Accident · No injuriesLimited investigationFinal reportCessna 310Q · Salem, OHThe pilot misjudged altitude and distance which resulted in a undershoot of the runway and collision with objects.NTSB NYC94LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wellsboro, PAThe pilot's impairment of judgment and performance due to alcohol, which led to his misjudgment of altitude and distance to the runway and collision with terrain, while on final approach to land. A factor related to the accident was: darkness.NTSB SEA94LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Salmon, IDThe pilot's failure to adequately judge the distance and altitude to the runway during the night VFR approach. Factors in the accident were: fatigue, lack of recent night flying experience, the dark night, and the operator's inadequate supervision of the…NTSB BFO94LA130Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Morris, PAThe pilot misjudged altitude and distance, which resulted in an undershoot of the runway.NTSB FTW94LA245Accident · No injuriesLimited investigationFinal reportCessna 150M · Owasso, OKThe pilot's failure to attain the proper touchdown point.NTSB ANC94LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Talkeetna, AKThe pilot misjudged clearance from a bush.NTSB CHI94LA221Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Land O'Lakes, WIthe pilot's failure to maintain clearance with trees. Factors in the accident were the trees, the pilot's operation with known deficiencies in equipment, and the pilot's diverted attention.NTSB BFO94LA123Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Waynesville, OHThe instuctors inadequate supervision of the student who misjudged distance/altitude.NTSB ANC94LA072Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sheldon Point, AKThe pilot's failure to attain a proper touchdown Point. Factor was the inadequate runway marking.NTSB BFO94LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Germansville, PAThe pilot failed to maintain a proper descent rate which resulted in an undershoot.NTSB FTW94LA194Accident · No injuriesLimited investigationFinal reportCessna 177 · Watonga, OKWas the pilot's failure to maintain the proper glidepath, his failure to compensate for existing wind conditions, and his failure to maintain clearance with the fence. A factor was the weather.NTSB FTW94LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Canton, TXWas the undershoot of the runway threshold due to the pilot's failure to attain the proper touchdown point, and his failure to compensate for the wind condition. A factor was the crosswind.NTSB NYC94LA087Accident · No injuriesLimited investigationFinal reportLutz Acro Sport II · Hornell, NYThe pilot's failure to maintain a proper glidepath. A factor in this accident was the pilot's lack of total experience in this type of airplane.NTSB NYC94LA081Accident · No injuriesLimited investigationFinal reportLet Super Blanik L-33 · New Castle, VAThe pilot's improper use of the flight controls resulting in failure to maintain a proper descent rate during the approach for landing. A factor in this accident was the pilot's lack of total experience in this type of glider.NTSB NYC94LA080Accident · No injuriesLimited investigationFinal reportDavis DK-1 · East Haddam, CTThe pilot's failure to maintain the proper glidepath during landing approach.NTSB MIA94LA135Accident · No injuriesLimited investigationFinal reportBeech A35 · St. Petersburg, FLFailure of the pilot-in-command to maintain airspeed and proper glidepath resulting in the in-flight collision with trees short of the airport property.NTSB BFO94LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Bedford, PAThe pilot's failure to maintain the proper descent rate which resulted in an undershoot of the runway.NTSB ATL94LA068Accident · No injuriesLimited investigationFinal reportBeech C23 · Dahlonega, GAThe poor in-flight decision by the pilot to divert his attention from the runway on short final in order to retrieve a flashlight.NTSB CHI94LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madison, WIThe pilot-in-command's poorly planned approach and failure to maintain the proper glidepath. The dark night was a factor.NTSB MIA94LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Tampa, FLThe student pilot's improper use of the flight controls and failure to maintain sufficient airspeed on final approach for landing resulting in an inadvertant stall and subsequent collision with terrain.NTSB BFO94LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Berlin, NJThe pilot not maintaining clearance from obstacles (trees) during final approach which resulted in a collision with a tree and a subsequent uncontrolled descent until colliding with the ground.NTSB MIA94FA069Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Vicksburg, MSFailure of the pilot-in-command to maintain the proper glidepath while on a straight in approach resulting in the inflight collision with trees short of the runway. Contributing to the accident was the dark night condition.NTSB CHI94LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Burlington, WIThe student pilot's failure to maintain the proper glideslope.NTSB MIA94IA059Incident · No injuriesIncident investigationFinal reportLearjet LR-35A · Key Largo, FLThe failure of the pilot-in-command to maintain the proper glidepath.NTSB FTW94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Dallas, TXThe pilot's failure to attain the proper touchdown point. A factor was the pilot's disorientation and dark night conditions.NTSB LAX94LA111Accident · No injuriesLimited investigationFinal reportBritten-Norman BN2A-8 Islander · Santa Rosa Isl, CAA failure of the pilot-in-command to maintain a proper glide path to the runway and his misjudgement of the touchdown point that resulted in an undershoot and subsequent hard landing.