# NTSB investigations: Beech B19, 1983

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 NYC83LA119](https://openairdocs.org/ntsb/NYC83LA119.md): Beech Sport · Bangor, ME · Accident · No injuries · Limited investigation · Final report · May 19, 1983 · N24687 · Destroyed
  > The acft ran off the runway and collapsed the landing gear during landing. The student pilot had made 7 successful landings. On this final landing a gust of wind blew the acft across the runway and the pilot lost direction control. The acft went off the left…
- [NTSB CHI83LA191](https://openairdocs.org/ntsb/CHI83LA191.md): Beech BE-19-180 · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Apr 22, 1983 · N5101R · Substantial damage
  > The acft drifted across the runway in a crosswind and collided with a runway light. The student pilot had taken off on runway 22 for his first solo flight. The tower changed runways according to the pilot and made 04 the active. The wind was 150 degrees at 8…

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

This list as a web page: https://openairdocs.org/ntsb?model=1151215&year=1983

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