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 FTW94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mckinney, TXThe pilot's improper approach angle.NTSB FTW94IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-33A · Dfw Airport, TXA failure by the pilot-in-command to attain a stabilzed approach. Factors were the fog and failure of the copilot to monitor the approach.NTSB NYC94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lumberton, NJThe pilot's failure to maintain a proper glidepath due to improper compensation for the wind conditions. A factor was a crosswind.NTSB ANC94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Northway, AKThe pilot-in-command did not maintain the proper glidepath.NTSB FTW94LA045Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Denton, TXThe cause was the pilot's failure to compensate for existing wind conditions. A factor was the turbulent weather.NTSB BFO94LA016Accident · No injuriesLimited investigationFinal reportTaylorcraft J-2 · Pittstown, NJThe pilot failed to maintain a proper glidepath. A factor in the accident was the presence of sunglare.NTSB ATL94LA017Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Lake City, SCThe pilot's failure to maintain a proper glidepath which resulted in collision with trees near the approach end of the runway.NTSB NYC94LA010Accident · Minor injuriesLimited investigationFinal reportSchlappi RV3 · Hatfield, MAThe pilot misjudged his distance and altitude which resulted in an undershoot of the runway. A factor was his delay in intiating a go around.NTSB CHI94LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Independence, MOThe pilot's misjudgment of distance, altitude, and speed on final approach to land, and failure to maintain obstacle clearance from the vehicle. The proximity of the vehicle to the approach path was a related factor.NTSB LAX94LA002Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Fallon, NVwas the pilot's failure to maintain an adequate approach path to the runway and his inadequate altitude. Contributing factors were the pilot's delayed remedial action and his lack of recent experience in the airplane.NTSB ATL93LA160Accident · 1 fatalLimited investigationFinal reportCornwell KR-2 · Covington, TNThe pilot's misjudged obstacle clearance on final approach. Factors were, the dark night, and the pilot's defective distant vision.NTSB BFO93LA160Accident · No injuriesLimited investigationFinal reportSmyth Sidewinder · Point Pleasant, WVThe pilot's failure to maintain a proper glidepath.NTSB CHI93LA348Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Blakesburg, IAThe pilot's failure to maintain clearance with the fence post and his midjudging the airplane glidepath.NTSB NYC93LA167Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Slattington, PAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the proper touchdown point was not obtained.NTSB ANC93LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe inadvertent raising of the flaps.NTSB SEA93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yellow Pine, IDThe pilot's improperly planned approach and delayed remedial action. A factor related to the accident was: the proximity of mountainous terrain.NTSB ANC93LA133Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Soldotna, AKThe pilot's failure to attain a proper touchdown point. A factor was the pilot's improper in flight planning/decision.NTSB LAX93FA274Accident · 5 fatalField investigationFinal reportCessna T303 · Prescott, AZThe pilot misjudging distance and altitude during a night approach. Factors which contributed to the accident were: the pilot's impairment due to fatigue exacerbated by alcohol consumption, the dark night, and the high density altitude and turbulent weather…NTSB LAX93LA266Accident · No injuriesLimited investigationFinal reportGlenn BD-4 · Somerton, AZThe second pilot's misjudgement of altitude and distance from the runway which resulted in an undershoot, and the pilot-in-command's inadequate supervision in not taking timely corrective action. In addition, neither pilot had any experience in the airplane,…NTSB CHI93LA232Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Northwood, NDThe pilot in command's failure to attain a proper touchdown point.NTSB CHI93LA230Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Ionia, MIThe pilot in command's failure to maintain the proper glidepath.NTSB CHI93LA229Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Point Lookout, MOThe pilot in command's failure to maintain proper glide path, and her failure to attain the proper touch down Point.NTSB LAX93LA259Accident · 1 fatalLimited investigationFinal reportRaymond Long EZ · Groveland, CAThe pilot's failure to maintain a proper glide path during final approach. A factor in the accident was sun glare in the pilot's line of vision.NTSB NYC93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kutztown, PAThe pilot's failure to maintain the proper glidepath and execute a proper flare. Lack of familiarity is a contributing factor.NTSB ATL93LA110Accident · Serious injuriesLimited investigationFinal reportAerotek Zuni · Brownsboro, ALThe pilot's misjudgment of distance and altitude which resulted in the collision with trees short of the runway.NTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.NTSB SEA93LA119Accident · No injuriesLimited investigationFinal reportApplebay Zuni · Deer Park, WAImproperly planned approach by the PIC.NTSB BFO93LA095Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Johnson City, NYImproper planning/decision by the flight crew. Factors related to the accident were: the downdraft on final approach, the terrain conditions (cliff & obstructions) near the approach end of the runway, and the lack of relative experience for each of the pilots.NTSB ANC93LA065Accident · No injuriesLimited investigationFinal reportCessna 172K · Rohn Roadhouse, AKThe pilot in command's inadequate compensation for the wind conditions and allowing the airspeed to go below stalling speed in the landing configuration.NTSB CHI93LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Festus, MOThe pilot-in-command's failure to maintain a proper glidepath during approach. Factors which contributed to the accident were: the pilot's motion sickness and the effect of the over-the-counter medication on his piloting performance.NTSB BFO93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springboro, OHThe pilot misjudged his distance, and altitude on final approach, and failed to attain the proper touchdown point.NTSB BFO93LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sandusky, OHThe pilot's misjudgement of distance and altitude to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. A factor related to the accident was the proximity of the snowbank to the runway threshold.NTSB FTW93LA089Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Indian Village, LALanding performed short of the runway threshold. Factor was wet grassy terrainNTSB LAX93LA121Accident · No injuriesLimited investigationFinal reportBeech C35 · Susanville, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot's misjudging his distance and altitude and the prevailing light snow conditions.NTSB ATL93LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe student pilot's failure to judge a proper touchdown point, and his failure to maintain directional control after landing. A factor was the pilot's lack of total experience.NTSB LAX93LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Columbia, CAThe pilot's failure to maintain a proper glidepath while on short final approach. A factor in the accident was the dark night lighting conditions which may have affected the pilot's perceptual awareness of the airport environment and the cues for a proper…NTSB ATL93LA045Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe poor judgement of the flight instructor in allowing his student to return from a cross country at night, and the student pilot's failure to maintain a proper altitude on final approach. Factors were the dark night conditions, the trees below the final…NTSB ATL93FA041Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Atlanta, GAThe pilot's failure to maintain clearance from approach lights while conducting a night landing. A factor was a dark night.NTSB ANC93LA017Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Huslia, AKThe failure of the pilot to maintain proper glidepath due to loss of visual cues over snow covered terrain in shadow of setting sun. Factors relating to the accident were the reduced light of dusk and the reduction of visual perception of the pilot in civil…NTSB CHI93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brookfield, WISpatial disorientation, and failure to maintain proper glidepath.NTSB FTW93LA038Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Joshua, TXThe pilot's failure to maintain a proper descent rate during the approach and his inadequate visual lookout.NTSB CHI93LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Makoti, NDThe pilot not maintaining a proper glidepath during his approach to landing.NTSB ANC93LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nightmute, AKPilot did not attain proper touchdown point while landing on a raised gravel runway.NTSB CHI92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Peoria, ILThe private pilot's misjudged touchdown. Related factors are the reduced visibility due to sunglare, ongoing runway construction, and the pilot's inattention to atc/communications/information.NTSB SEA92LA201Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAInadequate remedial action of the pilot in command (CFI). Factors include airspeed not being maintained by the student pilot, and rough/uneven terrain.NTSB LAX92LA375Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Santa Monica, CAThe the pilot's poorly planned approach; his failure to select the proper touch down point; and inadequate remedial action.NTSB NYC92LA183Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Griswold, CTThe pilot failed to maintain control of the airplane which resulted in the airplane touching down short of the intended touchdown point, and collapsing the landing gear.NTSB ANC92LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Talkeetna, AKThe pilot's improper in flight planning/decision, and his premature touch down. Contributing to the accident were the downdraft and the unsuitable terrain.NTSB CHI92LA240Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Osage Beach, MOFailure to attain the proper touchdown point.NTSB ANC92LA123Accident · No injuriesLimited investigationFinal reportBeech C99 · Nuiqsut, AKThe pilot's improper inflight planning/preparation, and his failure to attain the proper touchdown point. Contributing to the accident was the downdraft.