NTSB investigations, ID
13 cases where the first occurrence was “Undershoot”.
Cases per year
| 1986 | 2 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 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\" = 'ID' 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" = 'ID' 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 SEA06LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Sandpoint, IDThe pilot's misjudged distance/altitude, which led to him landing short of the runway and impacting the runway's elevated lip. Contributing factors were the elevated runway lip and the right main landing gear failure.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 SEA02LA141Accident · No injuriesLimited investigationFinal reportCessna 210L · Cascade, IDThe pilot's failure to maintain the proper rate of descent on short final resulting in a touchdown short of the runway threshold. Contributing factors were the variable winds and swampy terrain at the touchdown site.NTSB SEA98LA173Accident · No injuriesLimited investigationFinal reportKoskella Long EZ · Cascade, IDThe pilot's failure to maintain airspeed on final approach. Factors include inadequate remedial action and erroneous airspeed indications.NTSB SEA97LA211Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mackay, IDThe pilot misjudged the distance/altitude while on final approach.NTSB SEA97LA009Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Caldwell, IDthe pilot's misjudgment of distance and altitude to the runway, while on final approach to land. The sunglare was a related factor.NTSB SEA95LA131Accident · No injuriesLimited investigationFinal reportCessna 172F · Homedale, IDThe pilot misjudged distance and altitude during the approach. The downdraft was a factor.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 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 SEA91LA147Accident · No injuriesLimited investigationFinal reportLet L-13 · Driggs, IDThe pilot misjudged his distance and altitude to the runway during the approach and failed to attain the proper touchdown point for landing. His lack of experience in the make and model of glider was a related factor.NTSB SEA90LA110Accident · No injuriesLimited investigationFinal reportCessna 340A · Priest River, IDThe pilot's misjudgement of distance and altitude and his failure to maintain an adequate airspeed during the landing approach.NTSB SEA86LA220Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Weippe, IDAn undershoot occurred during landing at an unlit airstrip at dusk. Shortly after touchdown the aircraft struck a six foot mound of dirt. The aircraft then nosed over inverted and slid 60 to 70 feet before it came to rest.NTSB SEA86LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenn'S Ferry, IDThe student pilot had to be vectored during a night x-country. During cruise, 35 miles from his destination, he became concerned about his low fuel state. He then diverted, with ATC assistance to an unlit airstrip for landing. The acft touched down short of…