NTSB investigations, UT

55 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

Cases, newest first

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\" = 130)
  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.

NTSB DEN83LA145Accident · No injuriesLimited investigationFinal reportCessna 195A · St. George, UTThe prop blade separated causing the acft to veer sharply to the left out of control. The acft came to rest about 30 ft from the rwy with the right main landing gear broken off. A metallurgical exam revealed that the blade failed from fatigue. The fatigue…Jun 18, 1983 · N1537H · Substantial damageNTSB DEN83LU001Accident · 1 fatalFinal reportIntl Ultralight Banshee · St. George, UTReportedly, the ultralight vehicle was assembled at an abandoned arpt, then was test flown by an international ultralight company salesman. The non-rated plt, who was planning to buy the ultralight, then flew the vehicle to familiarize himself with its flt…May 21, 1983 · UNREG · DestroyedNTSB DEN83FTM01Accident · 1 fatalFinal reportBowers Flybaby 1A · Ephriam, UTApproximately 4 ft of the inboard section of the left wing separated in flight during an aerobatic maneuver. Witnesses stated that the acft had been performing little loops & then it went straight up & rolled off to the left upside down. It then spiralled…Oct 16, 1982 · N63498 · DestroyedNTSB DEN82DA160Accident · No injuriesFinal reportCessna 421C · Bountiful, UTThe pilot reported that the approach and landing to touchdown were normal. At touchdown, the aircraft shuttered and pulled to the right, but was kept on the runway through the use of left brake and nosewheel steering. After continuing down the runway for…Aug 10, 1982 · N6771C · Substantial damageNTSB DEN82DA073Accident · Minor injuriesFinal reportHughes 369D (500D) · Coalville, UTThe helicopter made a hard landing after the pilot experienced a power train failure while flying low and slow. The weather was VMC and a VFR flight plan was filed. The crew was searching for lost mining equipment in a low slow search pattern. The pilot heard…Apr 27, 1982 · N8684F · Substantial damage