NTSB investigations, UT
6 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2006 | 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\" = 'UT' 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" = 'UT' 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 SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…NTSB DEN90LA133Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Brigham City, UTThe pilot's failure to attain the proper touchdown point.NTSB DEN88LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Ogden, UTThe low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…NTSB DEN85LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bountiful, UTThe student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.NTSB DEN85LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Taylor, UTAcft collided with a pile of snow near the edge of rwy while landing. Plt stated he misjudged the apch and reduced power prematurely.NTSB DEN82DA032Accident · Minor injuriesFinal reportCessna 210 · Blanding, UTThe pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway…