NTSB investigations, 1982, UT
5 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 8 |
| 1984 | 2 |
| 1985 | 10 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 7 |
| 2000 | 7 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 2 |
Where
Latest 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 year(c.\"eventDate\") = 1982
AND 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\" = 240)
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 year(c."eventDate") = 1982 AND 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" = 240) 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 DEN83FA133Accident · 1 fatalField investigationFinal reportCessna 182A · Orderville, UTThe acft crashed in mountainous terrain on a x-country in bad weather. The plt had received a weather briefing which hadincluded the caution that VFR flt was not recommended. Also the acft had no radio so the plt told the briefer to assume him off at 1330…NTSB DEN82DTM18Accident · No injuriesFinal reportCessna A185 · Huntington, UTThe aircraft struck trees with the left wing after takeoff. The pilot stated that he experienced a downdraft and that he was unable to recover altitude that was sufficient to clear the trees. The wind was reported to be from 270 degrees at 10 knots, gusting…NTSB DEN82DA190Accident · Minor injuriesFinal reportCessna 310P · Wendover, UTThe pilot stated he became disoriented while flying from salt lake city to Wendover. He descended to 8000 ft to keep clear of ice and hail and could not receive a navigational signal from the Wendover or bonneville navigational facility. While attempting to…NTSB DEN82FTM16Accident · 2 fatalFinal reportVarieze · Milcreek Canyon, UTThe aircraft crashed into trees in a Canyon at an elevation of 9300 MSL. The weather was reported as marginal VFR. No flight plan was filed. VFR flight was not recommended. A toxicological check of the pilot's blood showed an alcohol level of 91 mg%; however,…NTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…