NTSB investigations, 2000, UT

6 cases where the first occurrence was “Loss of control - in flight”.

Cases per year

19822026
NTSB investigations, 2000, UT per year, 1982–2026: 149 cases
19828
19839
198412
19854
19862
19873
19886
19894
19902
19919
19922
19934
19943
19952
19967
19978
19987
19992
20006
20015
20027
20036
20048
200510
20063
200710

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\") = 2000
    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\" = 250)
  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 DEN00LA163Accident · 2 fatalLimited investigationFinal reportNicholson Thorp T-18CWS · Tooele, UTFailure by the pilot to maintain control of the airplane during aerobatic maneuvers as a result of his alcohol impairment. Factors were: The pilot's inadequate planning and decision making and the inadequate altitude he choose for maneuvering.Sep 3, 2000 · N24WN · DestroyedNTSB DEN00LA131Accident · Minor injuriesLimited investigationFinal reportRotorway Executive 162F · Tooele, UTThe pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.Jul 16, 2000 · N6399L · Substantial damageNTSB DEN00LA120Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-350P · Spanish Fork, UTFailure by the pilot to maintain control of the aircraft during initial climb following takeoff.Jun 26, 2000 · N9246D · Substantial damageNTSB DEN00FA084Accident · 3 fatalField investigationFinal reportAerospatiale AS-350B · Blanding, UTthe pilot's loss of aircraft control due to abrupt flight maneuvering. Contributing factors were the high density altitude weather condition, the total loss of engine power due to the pilot manually introducing excessive fuel into the engine and over temping…May 4, 2000 · CGPTT · DestroyedNTSB DEN00GA050Accident · 2 fatalFinal reportBell OH-58A+ · Woods Cross, UTThe pilot's failure to roll throttle back on (return the power to the normal operating range) during an attempted power recovery from an autorotation, and his subsequent failure to maintain aircraft control.Feb 11, 2000 · N7UT · DestroyedNTSB DEN00LA043Accident · No injuriesLimited investigationFinal reportBeech K35 · Fillmore, UTThe pilot's improper use of elevator trim, resulting in his failure to obtain sufficient takeoff airspeed and subsequent inadvertent stall/mush. A Factor was his failure to follow the preflight checklist.Jan 13, 2000 · N9500R · Substantial damage