# NTSB investigations: Beech B19, WI

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 CHI93LA210](https://openairdocs.org/ntsb/CHI93LA210.md): Beech B19 · Janesville, WI · Accident · No injuries · Limited investigation · Final report · Jun 15, 1993 · N24674 · Substantial damage
  > The pilot's improper landing flare.
- [NTSB CHI84LA253](https://openairdocs.org/ntsb/CHI84LA253.md): Beech B-19 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Jun 21, 1984 · N5204M · Substantial damage
  > The student pilot stated that he rounded out a little high, while landing on rwy 09, stalled & contacted the runway in a crabbed position. A hard landing resulted which substantially damaged the aircraft.
- [NTSB CHI82DA140](https://openairdocs.org/ntsb/CHI82DA140.md): Beech BE-19 · Ridgeville, WI · Accident · No injuries · Final report · Apr 28, 1982 · N5204M · Substantial damage
  > The student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the…
- [NTSB CHI80DEP01](https://openairdocs.org/ntsb/CHI80DEP01.md): Beech 19 · Big Bend, WI · Accident · No injuries · Closed · Oct 8, 1979 · N5431M · Substantial damage
- [NTSB CHI79DEP28](https://openairdocs.org/ntsb/CHI79DEP28.md): Beech BE-19 · Milwaukee, WI · Accident · No injuries · Closed · Feb 10, 1979 · N1990L · Substantial damage
- [NTSB CHI77DEP52](https://openairdocs.org/ntsb/CHI77DEP52.md): Beech B-19 · Milwaukee, WI · Accident · No injuries · Closed · Jul 30, 1977 · N1990L · Substantial damage

## 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" = 'WI' 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 ('1151215'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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