# NTSB investigations: Douglas DC-6B, FL

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 MIA88FA132](https://openairdocs.org/ntsb/MIA88FA132.md): Swearingen SA-227-TT · Miami, FL · Accident · No injuries · Field investigation · Final report · Mar 29, 1988 · N30042 · 2 aircraft · Substantial damage
  > The plt stated that during his attempt to taxi around N30042, he thought he had enough clearance to get by, but misjudged the distance & the rudder of the merlin acft was struck by the DC6B'S left wing tip.
- [NTSB MIA85IA120](https://openairdocs.org/ntsb/MIA85IA120.md): Douglas DC-6B · Miami, FL · Incident · No injuries · Incident investigation · Final report · Mar 15, 1985 · N55CA · Minor damage
  > Crew stated that on takeoff roll the number four engine failed and an aborted takeoff was intiated. During the decelleration after the throttles were closed the number four engine seized and the number four propeller separated when the propeller shaft failed.…

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

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

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