# NTSB investigations: Boeing-Vertol 107-II

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 SEA90TL#07](https://openairdocs.org/ntsb/SEA90TL%2307.md): Boeing Vertol 107-11 · Leavenworth, WA · Accident · Minor injuries · Class 3 · Final report · Aug 4, 1990 · N6672D · Destroyed
- [NTSB LAX83FA395](https://openairdocs.org/ntsb/LAX83FA395.md): Boeing Vertol BV-107-II · Shaver Lake, CA · Accident · 2 fatal · Field investigation · Final report · Aug 20, 1983 · N190CH · Destroyed
  > The only witness, the hooker, who gets logs ready for transport by the helicopter, stated that he heard noises and the rotor blades began coming apart as the acft started downhill with a log. Examination of the wreckage revealed that #3 sychronizing shaft…
- [NTSB NYC70I0006](https://openairdocs.org/ntsb/NYC70I0006.md): Vertol 107-II · Flushing, NY · Incident · No injuries · Closed · Jul 4, 1969 · N6675D · No damage
- [NTSB NYC67A0122](https://openairdocs.org/ntsb/NYC67A0122.md): Lockheed 1049 · Newark, NJ · Accident · No injuries · Closed · Feb 27, 1967 · N6209C · 2 aircraft · Substantial damage
- [NTSB UNK64X3892](https://openairdocs.org/ntsb/UNK64X3892.md): Vertol 107 · New York, NY · Incident · No injuries · Closed · Sep 10, 1964 · N6672D · Substantial damage
- [NTSB UNK64X3829](https://openairdocs.org/ntsb/UNK64X3829.md): Vertol 107 · New York, NY · Accident · No injuries · Closed · Sep 6, 1964 · N6672D · Substantial damage
- [NTSB UNK64X1395](https://openairdocs.org/ntsb/UNK64X1395.md): Vertol 107 II · Asheville, NC · Accident · No injuries · Closed · Apr 20, 1964 · N6679D · Substantial damage
- [NTSB DCA64A0012](https://openairdocs.org/ntsb/DCA64A0012.md): Vertol 107-II · Jamaica, NY · Accident · 6 fatal · Closed · Oct 14, 1963 · N6673D · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1385007'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1385007

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