NTSB investigations, MS
7 cases where the first occurrence was “Undershoot”.
Cases per year
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2002 | 2 |
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\" = 'MS' 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" = 'MS' 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 ATL02LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Picayune, MSThe pilot's misjudged the touch down point on the runway and collided with the ground short of the runway.NTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.NTSB MIA94FA069Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Vicksburg, MSFailure of the pilot-in-command to maintain the proper glidepath while on a straight in approach resulting in the inflight collision with trees short of the runway. Contributing to the accident was the dark night condition.NTSB MIA90LA057Accident · No injuriesLimited investigationFinal reportBeech 400 · West Point, MSThe pilot misjudged distance, speed, and altitude on final approach, and failed to attain the proper touchdown Point for landing.NTSB MIA89LA226Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe pilot's failure to attain the proper touchdown point during landing.NTSB MIA87LA085Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Pelahatchie, MSThe plt stated that he was practicing emerg power-off landings, when, on final apch, realized he wouldn't clear the trees located west of the rwy. He then cleared them by adding power thought the acft then descended in a flare attitude until contact with the…NTSB ATL85LA253Accident · No injuriesLimited investigationFinal reportPiper PA-18S · Carlisle, MSAfter aprx 1 hr of LCL flt, the 67 hr pvt plt returned to his pvt grass strip for landing. He made a full left traffic pattern. At the 180 deg point, carb heat was applied and pwr reduced. After turning final and lowering full flaps, the plt added throttle…