NTSB investigations, 1996
28 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\") = 1996
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") = 1996 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 LAX97LA333Accident · No injuriesLimited investigationFinal reportMikoyan MiG MIG 15UTI · Fallon, NVThe pilot misjudged his altitude and airspeed. A related factor was his diverted attention.NTSB ANC97LA006Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Kasilof, AKthe pilot's misjudgment of distance and altitude on final approach to land, which resulted in an undershoot and collision with a dirt bank before reaching the proper touchdown point. A factor related to the accident was: the proximity of the frozen dirt bank…NTSB LAX97LA024Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Los Alamitos, CAThe student pilot's failure to properly handle the glider, and the instructor pilot's inadequate supervision.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 SEA97LA007Accident · No injuriesLimited investigationFinal reportCessna 182Q · Manzanita, ORfailure of pilot to adequately compensate for wind conditions on final approach and attain a proper touchdown point for landing. A factor relating to the accident was: the unfavorable wind condition.NTSB NYC96LA172Accident · Minor injuriesLimited investigationFinal reportPzl-Bielsko SZD-59 · Franconia, NHThe pilot's misjudged altitude and distance which resulted in the collision with trees short of the runway.NTSB ANC96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe pilot's misjudgment of distance and altitude to the runway during the approach, and failure to attain the proper touchdown point. A factor relating to the accident was: the ditch.NTSB CHI96LA289Accident · Minor injuriesLimited investigationFinal reportMrotek Minicab GY20 · Albion, INthe pilot's misjudgment of distance and altitude during the approach to land, and his failure to attain the proper touchdown point. Factors relating to the accident were: the uneven and uphill terrain conditions at the approach end of the airstrip.NTSB ANC96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe airplane's low airspeed during final approach, and the pilot's delayed remedial action in correcting the low airspeed condition.NTSB FTW96LA314Accident · No injuriesLimited investigationFinal reportBarton Sylkie 1 · Erie, COThe pilot passenger's failure to maintain clearance from the fence due to his failure to maintain a proper glide path, and the pilot-in-command's failure to take remedial action in a timely fashion.NTSB CHI96LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Emily, MNthe pilot misjudged his altitude and distance to the runway on final approach, and he failed to maintain obstacle clearance during landing. A factor relating to the accident was: the parked car.NTSB CHI96LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Freeport, ILThe pilot's misjudgment of altitude and distance on final approach, and his failure to attain the proper touchdown point for landing.NTSB MIA96LA172Accident · No injuriesLimited investigationFinal reportCharles Raymond Glasair 2SFT · Apalachicola, FLInadequate application of throttle input and up elevator input by the pilot-in-command. Contributing to the accident was the in-flight encounter with a downdraft and inadequate design of the airplane by the kit manufacturer.NTSB LAX96LA252Accident · No injuriesLimited investigationFinal reportCessna 402A · Grand Canyon, AZFailure of the pilot to properly judge his altitude during final approach resulting in an undershoot. A factor was a downdraft weather condition.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 SEA96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hillsboro, ORthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point for landing. A factor relating to the accident was: upsloping terrain short of the threshold.NTSB LAX96LA224Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Santa Clarita, CAthe pilot's failure to abandon the pinnacle approach after encountering an excessive rate of descent.NTSB NYC96LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Readington, NJthe pilot's inadequate evaluation of the weather, and his misjudgment of altitude and distance from the runway. Contributing factors were the pilot's lack of recent experience and the weather.NTSB SEA96LA091Accident · No injuriesLimited investigationFinal reportLimes Challenger II · Redmond, ORthe pilot's misjudgment of distance and altitude on final approach, and his failure to maintain proper clearance from an object (fence) in his approach path. The fence was a related factor.NTSB NYC96LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Chester, NHThe pilot's misjudged distance and altitude during final approach.NTSB NYC96LA095Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R200 · Forks Township, PAthe flight instructor's misjudgment of distance and altitude, and delay in performing remedial action.NTSB LAX96LA166Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Independence, CAthe pilot's inadequate compensation for the wind conditions. The wind was a factor.NTSB LAX96LA158Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Jean, NVthe pilot's poorly planned approach. The flight's encounter with a downdraft is a factor in this accident.NTSB NYC96LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Matawan, NJthe pilot's misjudgment of altitude and distance during final approach.NTSB CHI96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Warren, MNthe dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.NTSB SEA96LA052Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Hubbard, ORthe pilot's misjudgment of altitude and distance on short final. A factor was the wet and soft terrain short of the runway threshold.NTSB MIA96LA073Accident · Minor injuriesLimited investigationFinal reportGilpatrick Baby Lakes · Deland, FLThe pilot's misjudgment of distance and altitude, while on final approach to land, and his failure to attain the proper touchdown point for landing. The unfavorable wind condition (crosswind) was a related factor.