# NTSB investigations: Fokker F.27MK 100

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 DCA84AA014](https://openairdocs.org/ntsb/DCA84AA014.md): Fokker F27-100 · Jamaica, NY · Accident · Serious injuries · Final report · Jan 13, 1984 · N148PM · Substantial damage
  > During the previous flt, the acft encountered light icing conditions while crusing at 4000 ft. the capt stated that the ice disappeared from the acft's structure in the course of its descent at 3000 ft & he did not use wing de-icing or the eng cowling…
- [NTSB NYC83LA036](https://openairdocs.org/ntsb/NYC83LA036.md): Fokker F-27-100 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Nov 30, 1982 · N141PM · Substantial damage
  > Aircraft collided with a power cart as taxi to takeoff began.

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

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

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