# NTSB investigations, UT: Monitoring other aircraft

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB GAA15CA157](https://openairdocs.org/ntsb/GAA15CA157.md): Balloon Works FIREFLY8 - 24 · Provo, UT · Accident · Minor injuries · Data collection · Final report · Jul 2, 2015 · N7148P · 2 aircraft · Substantial damage
  > **This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…
- [NTSB WPR11LA477](https://openairdocs.org/ntsb/WPR11LA477.md): Starduster II SA-300 · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Sep 24, 2011 · N23UT · 2 aircraft · Minor damage
  > The pilot of the other airplane's inadequate visual lookout, which resulted in a collision with the standing airplane.
- [NTSB WPR10LA294](https://openairdocs.org/ntsb/WPR10LA294.md): Schleicher Alexander ASH 26 E · Parowan, UT · Accident · No injuries · Limited investigation · Final report · Jun 15, 2010 · N455S · 2 aircraft · Substantial damage
  > The pilot's failure to see and avoid the other glider climbing in the same thermal.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02021540'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02021540/cases?state=UT

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
