# NTSB investigations: Beech 58P: On ground/water collision with object

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 LAX04CA065](https://openairdocs.org/ntsb/LAX04CA065.md): Beech 58P · San Diego, CA · Accident · No injuries · Data collection · Final report · Dec 9, 2003 · N58JG · Substantial damage
  > the pilot's inadequate lookout, which resulted in his failure to maintain clearance from the vehicle while taxiing.
- [NTSB CHI85LA089](https://openairdocs.org/ntsb/CHI85LA089.md): Beech 58P · Grand Rapids, MI · Accident · No injuries · Limited investigation · Final report · Jan 18, 1985 · N58PC · Substantial damage
  > At 1215 EST, a ground vehicle operator (S-1) rprtd that the braking action was poor on the rwys & taxiways (twys). In the next 9 min, 5 snow plows were cleared onto twys a & e. a short time later, the plt of N58PC was cleared to taxi fm the general aviation…
- [NTSB MIA85LA063](https://openairdocs.org/ntsb/MIA85LA063.md): Beech 58P · Deland, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1984 · N3707N · 2 aircraft · Substantial damage
  > N41Q was taxiing to the ramp after landing. As N41Q taxied behind N3707N, who was starting the rt engine, propwash caused plt of N41Q to lose directional control of the acft. Prop of N41Q contacted the left elevator of N3707N.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152744')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1152744&occurrence=310

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