NTSB investigations, 2003, UT

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

Cases per year

19822026
NTSB investigations, 2003, 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\") = 2003
    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 DEN04LA004Accident · No injuriesLimited investigationFinal reportCessna 182L · Randolph, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing factors were the wind gusts and crosswind conditions.Oct 7, 2003 · N3348R · DestroyedNTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.Jul 26, 2003 · N35KR · DestroyedNTSB DEN03LA121Accident · Serious injuriesLimited investigationFinal reportPringle Rans S-7 Courer · Manti, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Low altitude flight and high density altitude are contributing factors.Jul 5, 2003 · N6687 · DestroyedNTSB DEN03LA115Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Bountiful, UTthe pilot not maintaining aircraft control during the aerial taxi. Factors contributing to the accident were the oscillating cyclic, the pilot's diverted attention, and the gusting crosswind.Jun 28, 2003 · N3623U · Substantial damageNTSB DEN03LA104Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Eureka, UTthe pilot's improper in-flight planning and failure to maintain aircraft control. Contributing factors include high density altitude, hilly terrain, low airspeed and the subsequent inadvertent stall/mush.Jun 13, 2003 · N630DA · DestroyedNTSB DEN03LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Cedar City, UTthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control.May 21, 2003 · N5278H · Substantial damage