# NTSB investigations: Universal Stinson 108, NC

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 CEN25FA194](https://openairdocs.org/ntsb/CEN25FA194.md): Universal Stinson 108 · Farmington, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 3, 2025 · N40158 · Substantial damage
  > On June 3, 2025, about 1145 eastern daylight time, a Universal Stinson 108 airplane, N40518 was destroyed when it was involved in an accident near Farmington, North Carolina. The pilot and one passenger were fatally injured, and one passenger was seriously…
- [NTSB MIA97LA144](https://openairdocs.org/ntsb/MIA97LA144.md): Stinson 108-1 · Smithfield, NC · Accident · No injuries · Limited investigation · Final report · Apr 19, 1997 · N9063K · Substantial damage
  > a fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.
- [NTSB DIA68F0095](https://openairdocs.org/ntsb/DIA68F0095.md): Stinson 108-2 · Morganton, NC · Accident · Minor injuries · Closed · Oct 8, 1967 · N6433M · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=9230412&state=NC

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