NTSB investigations, UT

5 cases where the first occurrence was “Main gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19882026

NTSB investigations, UT per year, 1988–2026: 5 cases
1988	1
1990	1
1993	1
1994	1
1997	1

Where

Open the map

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" = 191) 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\" = 191)
  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" = 191)
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 SEA97LA091Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · West Jordan, UTlanding gear collapsed for undetermined reasons.Apr 19, 1997 · N616AS · Substantial damage NTSB SEA94LA172Accident · No injuriesLimited investigationFinal reportPitts S1 · Heber City, UTFailure of main landing gear axle hardware. Factors include collapse of main landing gear strut.Jul 5, 1994 · CGPUR · Substantial damage NTSB SEA93LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTThe student pilot's selection of a closed runway for landing. Factors contributing to the accident were the student pilot's anxiety and the rough landing surface.Jun 19, 1993 · N7045R · Substantial damage NTSB DEN90LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Ogden, UTThe failure of the main gear locking mechanism.May 28, 1990 · N8148M · Substantial damage NTSB DEN88LA175Accident · No injuriesLimited investigationFinal reportBraswell Scirroco MJ5-K2 · Hurricane, UTThe plt said he made a short flt to check out a mag. The eng performed satisfactorily and he landed. Upon touchdown one of the main landing gear collapsed and the tailwheel equipped acft ground looped. The plt said a gear downlock failed. The FAA…Aug 4, 1988 · N6XY · Substantial damage