NTSB investigations, 1992
33 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
Latest 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\") = 1992
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") = 1992 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 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.NTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.NTSB FTW92LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Lubbock, TXThe pilot under instruction misjudged his distance and altitude during a simulated forced landing, and the CFI failed to take timely action to prevent the accident as a result of his alcoholic impairment of efficiency and judgement.NTSB LAX92LA266Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Coalinga, CAThe failure of the pilot to maintain the proper glide path during the night VFR approach which resulted in a landing undershoot and a subsequent collision with the raised asphalt lip of the runway edge.NTSB DEN92LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student pilot misjudged his landing and landed short of the runway. A factor was: lack of total experience on the part of the student pilot.NTSB LAX92LA253Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Coalinga, CAThe pilot's failure to attain the proper touchdown point and misjudging the aircraft's distance from the runway. Contributing to this accident was the crosswind condition and the nose and main landing gear collapsing due to overload.NTSB CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.NTSB BFO92LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnstown, NYThe pilot misjudged altitude and distance which resulted in a landing undershood. Contributing to the accident was night conditions.NTSB CHI92LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brookfield, WIFailure of the pilot (CFI) to attain the proper touchdown point for landing. Factors related to the accident were: the unfavorable wind condition, the excessive descent rate that developed on final approach, and the cfi's delay in taking remedial action to…NTSB CHI92LA122Accident · No injuriesLimited investigationFinal reportCessna 150F · Centralia, ILThe pilot's failure to maintain the proper altitude during the final approach to landing. A factor in the accident was the pilot's delayed remedial action.NTSB BFO92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Stevensville, MDThe certificated flight instructor's (cfi's) inadequate supervision during the simulated emergency landing. Soft terrain in the touchdown area was a related factor.NTSB SEA92LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Vancouver, WAThe pilot's failure to maintain the proper rate of descent.NTSB FTW92LA086Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Harrison, ARThe pilot's failure to attain the proper touchdown point, and his failure to maintain the proper descent rate.NTSB NYC92LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fredericksburg, VAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were delayed remedial action by the pilot and night conditions.NTSB CHI92LA097Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Alpena, MIThe student pilot's failure to attain the proper touchdown point. Related factors are his misjudged approach and failure to take remedial action.NTSB ATL92LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA32-300 · Hickory, NCWhile on final approach for a visual landing, the pilot reported an unspecified problem to the flight service station and elected to go around. The airplane crashed 300 feet short of the runway on the second approach. Examination of the accident site…NTSB ANC92LA033Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Cube Cove, AKThe encounter of windshear during the final approach and the pilot's improper in flight planning and decisions by electing to land downwind. Factor in this accident was the rough and uneven terrain.NTSB ANC92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe pilot misjudged the altitude necessary for terrain clearance on the final approach. Factors which contributed to the accident were the snowbank and the dusk lighting conditions.NTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.NTSB MIA92LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Eustis, FLThe pilot misjudged altitude and distance resulting in undershooting the landing. Contributing to the acident was the dark night condition.NTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…