NTSB investigations, FL
11 cases where the sequence of events included Landing area undershoot.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2014 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '370' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '370' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA22LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Immokalee, FLThe flight instructor’s delayed remedial action which resulted in the airplane impacting terrain short of the runway.NTSB ERA20CA106Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Tampa, FLThe flight instructor's inadvertent throttle reduction below idle, which resulted in a total loss of engine power and subsequent impact with terrain following a power-off autorotation.NTSB GAA18CA406Accident · No injuriesData collectionFinal reportBeech 76 · Fort Lauderdale, FLThe pilot receiving instruction's failure to maintain a proper approach path and her delayed go-around during a simulated emergency landing, which resulted in landing short of the runway. Contributing to the accident was the flight instructor's failure to…NTSB GAA17CA477Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Homestead, FLThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in the pilot landing short of the intended runway.NTSB ERA15FA085Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Lake Worth, FLA main rotor stall due to low rotor rpm, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA14CA298Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Milton, FLThe pilot's failure to maintain the proper approach path, and his delayed remedial action, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB ERA14CA213Accident · No injuriesData collectionFinal reportBeech 76 · Fort Pierce, FLThe instructor's failure to obtain the proper touchdown point in a multiengine airplane, during a single-engine approach in a strong gusty headwind.NTSB ERA12CA010Accident · No injuriesData collectionFinal reportCalvin Nate H CALVIN-VELOCITY · Sebastian, FLThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB ERA11CA487Accident · Serious injuriesData collectionFinal reportKaribian Hurant Thorp T-18 · Panama City, FLThe pilot's selection of an unsuitable landing site, which resulted in a collision with a culvert.NTSB ERA10CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-36 · Jacksonville, FLThe glider pilot’s delayed decision to divert following a loss of thermal lift.NTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.