NTSB investigations, UT
4 cases where the first occurrence was “Forced landing”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1999 | 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\" = 180)
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" = 180) 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 DEN99LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Panguitch, UTInadequate preflight planning and preparation by the pilot in command. Factors were high velocity gusty winds, high-density altitude, and unsuitable terrain for a forced landing.NTSB DEN85LA164Accident · Serious injuriesLimited investigationFinal reportCessna T210J · Moab, UTThe plt & a passenger made a low level pass over the Colorado river to drop a package to friends, who were rafting on the river. The river was in a canyon with walls aprx 500 to 700 ft high. The plt said the eng lost power when the acft was in the canyon, so…NTSB DEN84LA269Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Price, UTThe pilot was following a mountain road through a pass when aircraft performance became insufficient to out climb risingterrain and continued until there was insufficient manuvering room to reverse course. A forced landing was effected on the road and the…NTSB DEN83LA175Accident · No injuriesLimited investigationFinal reportCessna U206E · Bryce Canyon, UTThe pilot said that while enroute to albuquerque from las vegas he encountered deteriorating weather that he could not get around he tried to climb over it but was unable. Once clear of cloud he descended trying to get back to Bryce Canyon. As the ceiling…