NTSB investigations, 1989
30 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 102 |
|---|---|
| 1983 | 62 |
| 1984 | 60 |
| 1985 | 45 |
| 1986 | 35 |
| 1987 | 44 |
| 1988 | 30 |
| 1989 | 30 |
| 1990 | 22 |
| 1991 | 20 |
| 1992 | 33 |
| 1993 | 36 |
| 1994 | 43 |
| 1995 | 30 |
| 1996 | 28 |
| 1997 | 28 |
| 1998 | 16 |
| 1999 | 21 |
| 2000 | 17 |
| 2001 | 8 |
| 2002 | 14 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 24 |
| 2006 | 13 |
| 2007 | 22 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1989
AND 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 year(c."eventDate") = 1989 AND 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 FTW90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKPilots failure to correctly maintain the proper glidepath, which caused him to impact short of the runway.NTSB FTW90DQG01Accident · 1 fatalFinal reportSenior Aerosport/Paet PJ 260 · Hereford, TXThe pilot's failure to maintain adequate obstacle clearance on the approach to landing. A factor was the power pole just short of the end of the runway.NTSB CHI90LA045Accident · No injuriesLimited investigationFinal reportBeech 58P · Harrison, OHThe pilot misjudged his distance, speed, and altitude on final approach and failed to attain the proper touchdown. Factors related to the accident were: uneven (rising) terrain near the runway threshold and the runway light.NTSB BFO90LA014Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Chesapeake, VAThe pilot misjudged distance and altitude to the runway, while on final approach to land. The light condition at dusk was a related factor.NTSB MKC90LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot misjudged distance and altitude to the runway while on final approach to land. Factors related to the accident were: dark night and static wires.NTSB LAX90LA024Accident · No injuriesLimited investigationFinal reportCessna 320 · Hayward, CAFailure of the pilot to attain the proper touchdown point and his improper flare for landing. Factors related to the accident were: the pilot's lack of experience in the make and model of aircraft, and company induced pressure.NTSB SEA90LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Las Vegas, NVThe pilot misjudged his altitude and distance to the runway, while on final approach, and failed to attain the proper touchdown point or flare the aircraft during the landing. Darkness was a related factor.NTSB ANC90LA002Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kwethluk, AKThe pilot misjudged his altitude and distance from the runway drg the approach, which resulted in a premature touchdown and failure of the right main landing gear, when it hit the runway lip. The sunglare and lack of visual cues (visual perception) were…NTSB LAX89LA322Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria · Auburn, CAThe pilot's inadvertent activation of nose down trim which resulted in a loss of control and collision with a tree. Contributing factor(s) was: the pilot's lack of experience in this type of airplane.NTSB LAX89LA321Accident · No injuriesLimited investigationFinal reportCessna 150 · Paradise, CAThe pilot's failure to adequately compensate for the existing wind conditions and to maintain adequate airspeed. Contributing to the accident were the adverse wind conditions.NTSB CHI89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Delphi, INThe pilot-in-command's failure to properly compensate for the high sink rate that developed on final approach to land. Factors related to the accident were: the downdraft and the student pilot's failure to maintain a proper rate of descent on final approach.NTSB CHI89LA177Accident · No injuriesLimited investigationFinal reportCessna 177B · Auburn, INFailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. Contributing factors were: the pilot's misjudgement of distance, speed, and altitude on final approach and high vegetation (tall grass & brush) beside…NTSB MIA89LA226Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe pilot's failure to attain the proper touchdown point during landing.NTSB NYC89LA194Accident · Minor injuriesLimited investigationFinal reportMBB ME 209 · Chatham, MAThe pilot stalled the aircraft while landing. Contributing factors to the accident were haze and the pilot applied power too late to arrest the airplane's sink rate.NTSB LAX89LA249Accident · No injuriesLimited investigationFinal reportBeech C24R · Lower Lake, CAPilot-in-command's failure to identify the sink rate soon enough to take corrective action.NTSB ANC89LA115Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Queens Cannery, AKThe pilot misjudged his altitude and distance to the runway during the approach and failed to attain the proper touchdown point. The gusty crosswind and berm were contributing factors.NTSB NYC89LA152Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26 · Elmira, NYAn inadvertent encounter with a downdraft.NTSB CHI89LA111Accident · No injuriesLimited investigationFinal reportBoeing E75 · Shelbyville, INThe pilot allowed his attention to be devaited, misjudged altitude and distance to the runway while on final approach, and failed to maintain clearance above the power lines. Contributing factors were: the power lines and parked aircraft.NTSB CHI89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172I · New Era, MIThe pilot's misjudgement of the proper touchdown point.NTSB MKC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Buffalo, MNMisjudgement of altitude and distance by the student and inadequate supervision of flight by the instructor (CFI). Contributing factors were: unfavorable wind conditions, high vegetation (grass), and a ditch.NTSB FTW89LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Crosbyton, TXThe pilot's judgement of altitude and distance while on an approach to land. Factors related to the accident were: the high wind, transmission line, and airport fuel tank.NTSB MKC89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Creve Couer, MOThe pilot's misjudgement of altitude and distance to the runway, and his failure to attain the proper touchdown point for landing. A factor related to the accident was: the soft/uneven terrain short of the runway.NTSB LAX89LA159Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS125-700 · Scottsdale, AZThe captain misjudged distance and altitude to the runway and allowed the aircraft to touch down just short of the runway lip. The runway lip was a related factor.NTSB CHI89LA072Accident · No injuriesLimited investigationFinal reportBeech A60 · Indianapolis, INThe pilot misjudged altitude and/or distance to the runway wile on final approach to land. Factors related to the accident were: dark night and pilot fatigue.NTSB LAX89DVA04Accident · Minor injuriesFinal reportLowe Quickie Q-200 · Hanford, CAThe pilot misjudged his altitude & distance to the runway, while on final approach, which resulted in an undershoot of the runway. A factor related to the accident was the fence.NTSB LAX89LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZThe failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.NTSB DEN89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Evanston, WYThe failure of the pilot to maintain the proper descent rate on final approach which resulted in a landing short of the runway.NTSB MIA89LA075Accident · No injuriesLimited investigationFinal reportCessna T310R · Pensacola, FLFailure of the pilot to maintain the proper airspeed during the approach resulting in landing short of the runway and failure to maintain directional control during the landing roll.NTSB LAX89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gualala, CAPilot misjudged the altitude and distance to the runway and subsequently did not attain the proper touchdown point.NTSB MIA89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bunnell, FLMisjudgement of altitude and distance to the runway by the student pilot, and inadequate supervision by the instructor pilot (CFI). The exposed (raised) runway lip was a factor.