NTSB investigations, WA
29 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 4 |
|---|---|
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA' 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 SEA08FA013Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Sequim, WAThe pilot's misjudged distance and altitude that led to an undershoot; his failure to maintain directional control during the landing roll; and his failure to maintain clearance from trees during an attempted aborted landing.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 SEA04LA085Accident · No injuriesLimited investigationFinal reportStinson SR-10E · Eliza Island, WAThe pilot's misjudgment of altitude/distance resulting in an undershoot of 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 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 SEA99LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Silverdale, WAThe pilot-in-command's misjudgment of distance/altitude (undershoot) on final, and his failure to maintain directional control during the aborted landing.NTSB SEA97FA215Accident · 3 fatalField investigationFinal reportCessna 172M · Bremerton, WAThe pilot's misjudgment of distance and altitude from the runway, and his subsequent failure to maintain clearance from the terrain. Factors contributing to the accident were dark night conditions, the pilot's improper decision to conduct the flight at night,…NTSB SEA96LA124Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Gardiner, WAthe pilot's inadequate compensation for wind conditions and failure to maintain the proper altitude/clearance from obstruction(s), while on final approach. Factors relating to the accident were: the downdraft, and the obstruction (tree).NTSB SEA96LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Roche Harbor, WAthe pilot's inadequate compensation for wind conditions and failure to attain a proper touchdown point for landing. Factors relating to the accident were: downdraft conditions and soft/uneven terrain short of the runway.NTSB SEA95FA103Accident · 2 fatalField investigationFinal reportCessna 177RG · Kent, WAThe pilot's misjudgment of distance and altitude during the approach. Factors in the accident were the dusk light condition and the shadows.NTSB SEA93LA119Accident · No injuriesLimited investigationFinal reportApplebay Zuni · Deer Park, WAImproperly planned approach by the PIC.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 SEA92LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Vancouver, WAThe pilot's failure to maintain the proper rate of descent.NTSB SEA92LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Toledo, WAThe pilot's failure to maintain a proper glidepath.NTSB SEA90LA099Accident · No injuriesLimited investigationFinal reportBriegleb BG-12B · Wenatchee, WAPilot's improper inflight planning which resulted in the aircraft undershooting the runway. Factors in the accident were the high, gusty wind conditions.NTSB SEA89LA008Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Cashmere, WAPlt landed short of hard surface, collapsing lndg gear.NTSB SEA88LA008Accident · No injuriesLimited investigationFinal reportCessna T210N · Walla Walla, WAThe pilot landed short and the aircraft's main landing gear struck the edge of a plateau at the approach end of the private strip. The aircraft swerved off the grass runway, the nose gear collapsed, and the aircraft nosed over.NTSB SEA87LA184Accident · No injuriesLimited investigationFinal reportBeech C-23 · Bremerton, WAOn the pilots third touch and go an undershoot occurred during landing onto runway 1. VASI lights are available for that runway. The plt was unable to explain why the undershoot occurred.NTSB SEA87LA054Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAWhen psgr became nauseous in flt, plt attempted downwind lndg onto pinnacle in rough terrain. Acft contacted slope short of intended point of lndg, main rotor flexed downward, severing tail boom.NTSB SEA86LA209Accident · No injuriesLimited investigationFinal reportLet L-13 · Issaquah, WAPlt undershot approach after encountering downdraft, collided with perimeter fence.NTSB SEA85LA062Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Pasco, WAPlt made full flap apch at idle pwr while practicing a short field landing. Plt stated apch originally was high and later became low. Plt delayed adding pwr and acft touched down 130 ft short of the rwy. Acft bounced and contacted the ground again nose wheel…NTSB SEA85LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Deer Park, WAAcft touched down in the displaced threshold which was not plowed clear of snow as the remaining portion of the rwy was. Acft nosed over following touchdwon.NTSB SEA84LA187Accident · No injuriesLimited investigationFinal reportCessna A188B · Palouse, WAPIC stated he landed in S0FT dirt short of the 1600 ft ag strip. The acft nosed over.NTSB SEA84LA141Accident · No injuriesLimited investigationFinal reportCessna 207 · Anacortes, WAThe plt stated he added 10 degrees of flaps on downwind and applied full flaps on final. A rapid rate of descent was experienced 200 yards from touchdown. The pilot said he added power to arrest the sink rate. The acft collided with trees on final. The pilot…NTSB SEA84IA033Incident · No injuriesIncident investigationFinal reportBoeing B-727-90C · Seattle, WAThe acft struck the approach lights to rwy 16R while on an ILS approach. Analysis of the FDR readout showed an increased descent rate following visual sighting of the rwy environment.NTSB SEA82DA156Accident · Minor injuriesFinal reportCessna 172N · Cle Elum, WAThe pilot elected to get additional cross-country and mountain flying time, so she elected to fly to Cle Elum, WA. Upon arrival, she flew over and observed the wind sock to be limp. While on approach to runway 25, she decided she was too low and executed a…NTSB SEA82DA141Accident · No injuriesFinal reportPiper PA-28-161 · Olympia, WAThis was the student pilot's first night flight. The instructor pilot reported that on the second landing, the aircraft struck an elevated set of approach lights, short of the runway.NTSB SEA82DA131Accident · No injuriesFinal reportCessna 172N · Roche Harbor, WAThe pilot flew to a private airstrip that was open to grazing animals. During arrival, he made a low pass to check that the runway was clear of animals and other obstructions. He then circled to land. During final approach, he noticed sheep coming onto the…NTSB SEA82DA042Accident · No injuriesFinal reportCessna 150H · Camas, WADuring the pilot's sixth touch and go landing the aircraft struck a tree on short final. The pilot maintained control of the aircraft and completed his landing.