Skip to content

NTSB investigations, UT

11 cases where the first occurrence was “Nose over”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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" = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 300)
  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" = 300)
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 SEA07LA018Accident · No injuriesLimited investigationFinal reportAviat A-1B · Fruitland, UTThe pilot's improper in-flight decision to land on snow covered terrain. Deep snow on the terrain that the pilot chose to land on was a factor in this accident.Nov 15, 2006 · N85HY · Substantial damage NTSB SEA96LA051Accident · No injuriesLimited investigationFinal reportMadorin Kitfox III · Grantsville, UTthe pilot's selection of an unsuitable area for a precautionary landing. A factor was the snow covered terrain.Feb 9, 1996 · N32308 · Substantial damage NTSB SEA95LA036Accident · No injuriesLimited investigationFinal reportCessna 172G · Salt Lake City, UTThe pilot's inadequate compensation for wind conditions during runup. The unfavorable wind was a factor.Jan 10, 1995 · N3708L · Substantial damage NTSB SEA94LA006Accident · No injuriesLimited investigationFinal reportCessna 177A · La Sal, UTThe pilot in command's failure to abort the takeoff. Factors contributing to the accident were the high (10,000 foot) density altitude and the fence.Oct 4, 1993 · N30365 · Substantial damage NTSB SEA93LA065Accident · No injuriesLimited investigationFinal reportCessna 182C · Huntington, UTThe improper in flt decision by the pilot in command to land on an airstrip unsuitable for landing. A factor relating to the accident was the soft snow covering the airstrip.Jan 29, 1993 · N8540T · Substantial damage NTSB SEA92LA043Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Jordan, UTThe pilot in command's failure to maintain control of the aircraft. A factor contributing to the accident was gusty wind conditions.Feb 8, 1992 · N50659 · Substantial damage NTSB DEN90LA117Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Morgan, UTPilot's improper use of the brakes during landing roll.May 26, 1990 · N1113B · Substantial damage NTSB DEN88LA130Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · West Jordon, UTJun 15, 1988 · N70471 · Substantial damage NTSB DEN84LA040Accident · No injuriesLimited investigationFinal reportCessna P206C · Tremonton, UTBefore takeoff, the plt obtained a wx briefing & filed a flt plan, but did not ask for NOTAMS. He was unaware that the destination arpt was notamed as closed until after the flt. He said that during arrival, he 'discovered an unplowed but apparently used…Dec 5, 1983 · N8669Z · Substantial damage NTSB DEN83LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mount Pleasant, UTBefore departing salt lake city, UT, the pilot obtained information about the weather and destination airport at mt Pleasant, UT. The weather was reported VFR and the mt Pleasant municipal airport was reported open. During arrival, the pilot observed furrows…Jan 19, 1983 · N9672P · Substantial damage NTSB DEN82DA094Accident · No injuriesFinal reportCessna T210L · Salt Lake City, UTOne of the runways at the destination airport was out of service. After landing, the pilot was instructed to hold for air carrier aircraft. After about a five minute delay, he was cleared to the general aviation parking area. In the meantime, there was a…May 18, 1982 · N30796 · Substantial damage