NTSB investigations, FL
34 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 2 |
| 1992 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 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\" = 'FL' 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" = 'FL' 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 MIA07CA108Accident · Minor injuriesData collectionFinal reportJames L. Stringfellow Glastar · Williston, FLThe pilot's misjudgment of distance/altitude and his improper touchdown point which resulted in an undershoot, nose over and damage to the airplane.NTSB MIA07CA010Accident · No injuriesData collectionFinal reportBeech A36 · St. Augustine, FLThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and on ground collision with a dirt bank.NTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.NTSB MIA05LA077Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · DeLand, FLThe failure of the pilot to maintain sufficient airspeed during landing, resulting in an inadvertent stall, undershoot and collision with the ground.NTSB MIA04LA124Accident · No injuriesLimited investigationFinal reportCessna 550 · Venice, FLThe pilot's failure to maintain adequate airspeed which resulted in a stall and undershoot of the runway.NTSB MIA04CA080Accident · Minor injuriesData collectionFinal reportBeech H35 · Fort Pierce, FLThe pilots failure to maintain the proper glide path during the approach which resulted in the airplane undershooting the runway and not attaining the proper touchdown point.NTSB MIA04CA006Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Everglades City, FLThe pilot's failure to maintain the proper glide path during the approach to land, which resulted in him undershooting the runway.NTSB MIA03LA189Accident · No injuriesLimited investigationFinal reportCessna 182P · Tampa, FLThe pilot's failure to attain the proper touchdown point which resulted in an undershoot.NTSB MIA00LA165Accident · No injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe student's failure to maintain the proper landing pattern altitude resulting in an undershoot during landing and collision with a fence. A factor in the accident was the pilot's failure to realize the spoilers were still deployed during the undershoot.NTSB MIA97LA132Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bushnell, FLThe pilot's failure to maintain a visual lookout and altitu de while on final approach to landing resulting in an in-flight collision with a fence and subsequent collision with terrain.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 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.NTSB MIA95FA053Accident · 2 fatalField investigationFinal reportLarson, C.H. Cozy MK IV · Wauchula, FLDistance vs. altitude misjudged by the pilot-in-command while on short final approach. Additionally, altitude/clearance not maintained while on short final approach resulting in the collision with an unmarked static power line.NTSB MIA94LA135Accident · No injuriesLimited investigationFinal reportBeech A35 · St. Petersburg, FLFailure of the pilot-in-command to maintain airspeed and proper glidepath resulting in the in-flight collision with trees short of the airport property.NTSB MIA94LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Tampa, FLThe student pilot's improper use of the flight controls and failure to maintain sufficient airspeed on final approach for landing resulting in an inadvertant stall and subsequent collision with terrain.NTSB MIA94IA059Incident · No injuriesIncident investigationFinal reportLearjet LR-35A · Key Largo, FLThe failure of the pilot-in-command to maintain the proper glidepath.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 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 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.NTSB MIA89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Clearwater, FLAs the student plt was making a simulated single eng apch, the instructor's attention was momentarily diverted inside the cockpit. When the instructor looked outside again, the acft was low & slow on a short final apch. The CFI applied power to arrest the…NTSB MIA88LA174Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Geneva, FLThe pilot state that he encountered turbulence over a tree line while on short final approach. The aircraft began to sink and before the sink rate could be arrested the aircraft struck a tree. The aircraft touched down short of the runway.NTSB MIA88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Captiva, FLThe pilot allowed the aircraft to descend below the normal approach angle and failed to correct the situation timely. The aircraft struck a seawall severing first the nose gear and then the main gear. The aircraft slid to a stop.NTSB MIA88LA050Accident · No injuriesLimited investigationFinal reportCessna A185F · Naples, FLThe plt stated that the flt was low and slow on final apch. As a result the main landing gear collided with a dirt bank located short of the rwy. The gear then collapsed and the acft slid to a stop.NTSB MIA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLThe pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted.NTSB MIA88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLDuring an instructional flt while practicing accuracy touch-and-go landings, the student plt flared the acft for landing at low altitude, aprx 45-60 feet from the apch end of the rwy. The acft landed hard short of the runway. As a result the landing gear…NTSB MIA86LA166Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe pvt glider plt with a total of 47 hours of flt time departed his local field with one passenger. At about 2000 ft AGL he disengaged the aero tow and proceeded to glide for about one hour. The plt stated that when he started back to his local airport and…NTSB MIA86LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · St.Petersburg, FLThe plt stated that while attempting a landing he realized his rate of descent was too high. He then applied power, the nose pitched up and the acft stalled, resulting in a hard landing.NTSB MIA85LA104Accident · No injuriesLimited investigationFinal reportAuton - Dunham Rutan Long EZ · Hollywood, FLThe plt stated that the flt was smooth until he crossed over the trees at the end of the rwy & was hit with a gust of wind & hit the ground short of the rwy causing the main & nose landing gear to separate. The plane continued to fly about 75 yards before…NTSB MIA85LA030Accident · No injuriesLimited investigationFinal reportLet L-13 · Homestead, FLAccording to the plt, a downdraft was encountered on base leg causing the acft to descend and decelerate. Unable to reach the rwy the glider landed in an orchard.NTSB MIA84LA237Accident · No injuriesLimited investigationFinal reportCessna 150 · Ft. Pierce, FLThe student plt on first solo flt misjudged his alt and landed the acft about 30 ft short of the rwy in the grass. This was his instructors assessment of the accident.NTSB MIA83LA156Accident · No injuriesLimited investigationFinal reportCessna 210L · Alva, FLOn departure the pilot stated that the landing gear would not retract fully and the engine did not seem to be producing full power so he elected to return to the airport. During the turn from base to final approach, flaps were extended to the full position.…NTSB MIA83LA095Accident · No injuriesLimited investigationFinal reportMolino PIK 20 · Highsprings, FLThe acft crashed short of the runway during a pleasure flight. The pilot was not injured. The pilot stated that he descended below the tree line and encountered a wind shear. He traded altitude for airspeed and the acft encountered thetop wire of a fence. The…NTSB MIA83LA007Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLDuring a simulated dual engine failure the student touched down short of the runway. The right main gear struck the edge of the runway with enough force to damage the innerstrut. The instructor then took control of the aircraft, landed, and the right landing…NTSB MIA82DA039Accident · No injuriesFinal reportPiper PA-28-161 · Deland, FLWhile practicing normal approaches and landings the student allowed the aircraft to get too low on final approach. The instructor took the controls but was unable to prevent a touchdown short of the runway threshold.