NTSB investigations, SC
9 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2005 | 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\" = 'SC' 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" = 'SC' 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 ATL07CA056Accident · No injuriesData collectionFinal reportBeech B24R · Monks Corner, SCThe pilot's misjudgment of speed/distance/altitude which resulted in a undershoot of the runway.NTSB ATL06CA013Accident · Minor injuriesData collectionFinal reportBeech BE-76 · Greer, SCThe pilot's misjudgment of altitude and distance which resulted in an undershoot of the runway, and the collision with trees.NTSB ATL00LA071Accident · Minor injuriesLimited investigationFinal reportRyskamp Sonex · Greenville, SCThe pilot's misjudgment of airspeed and altitude resulting in an undershoot.NTSB ATL94LA017Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Lake City, SCThe pilot's failure to maintain a proper glidepath which resulted in collision with trees near the approach end of the runway.NTSB ATL88LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student pilot was flying solo for the first time. Two landings had been completed successfully. The pilot misjudged the final approach and touched down short of the runway. The aircraft landed hard causing the nose gear to collapse.NTSB ATL85FMG06Accident · No injuriesFinal reportLet L-13 · Chester, SCThe glider landed about 150 ft short of the rwy on the plts 1st solo in this acft. He said he noticed a rapid drop in alt at 55 mph on final approach and began to change spoiler position to compensate. He complained that the stiffness of the operation of the…NTSB ATL85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Conway, SCThe certificated pilot, receiving instruction from a certified flight instructor, was manipulating the controls at the time of the accident. The student undershot the runway and touched down short of the paved rwy surface. The aircraft landing gear struck the…NTSB ATL84LA066Accident · No injuriesLimited investigationFinal reportCessna P206A · Charleston, SCThe acft undershot the rwy during landing. The weather was VMC but the landing was made one hour after official sunset. Visibility was reported as 10 miles. There were no problems reported with the arpt or acft except the plt during one radio call saying he…NTSB ATL82DA282Accident · No injuriesFinal reportBeech C33 · Walterboro, SCPilot was not aligned with runway and was too low. When power was added and turn made to align, aircraft collided with ground short of runway. No malfunction found.