# Final NTSB investigations: Cameron Balloons US N-145

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 LAX02FA069](https://openairdocs.org/ntsb/LAX02FA069.md): Cameron Balloons US N-145 · North Las Vegas, NV · Accident · 1 fatal · Field investigation · Final report · Jan 26, 2002 · N8004J · Substantial damage
  > The pilot's misjudged approach and inadequate obstacle clearance, which resulted in his failure to attain the proper touchdown point. Contributing factors were the high gusty wind condition, and the pilot's failure to provide protective safety equipment.
- [NTSB DEN93FA100](https://openairdocs.org/ntsb/DEN93FA100.md): Cameron N-145 · Woody Creek, CO · Accident · 6 fatal · Field investigation · Final report · Aug 8, 1993 · N4141D · Substantial damage
  > Failure by the pilot in command to maintain proper altitude and visual lookout. A factor was high wind.

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1880230'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1880230&status=final

---
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.