# NTSB investigations: Meteorological services, general

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 CEN19FA072](https://openairdocs.org/ntsb/CEN19FA072.md): Bell 407 · Zaleski, OH · Accident · 3 fatal · Class 1 · Field · Final report · Jan 29, 2019 · N191SF · Destroyed
  > The NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…
- [NTSB DCA17FA076](https://openairdocs.org/ntsb/DCA17FA076.md): Mcdonnell Douglas MD80 · Ypsilanti, MI · Accident · Minor injuries · Class 1 · Field · Final report · Mar 8, 2017 · N786TW · Substantial damage
  > the jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…
- [NTSB CEN15LA288](https://openairdocs.org/ntsb/CEN15LA288.md): Bell 407 - NO Series · South Timbalier 127 · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2015 · N311RL · Substantial damage
  > The pilot's lack of awareness of the severity of the gusting winds, which led to the helicopter being pushed off of the oil platform by a wind gust during engine start. Contributing to the accident was the unavailability of a nearby weather monitoring system.
- [NTSB CEN15FA044](https://openairdocs.org/ntsb/CEN15FA044.md): Mooney M20K · Clines Corners, NM · Accident · 1 fatal · Field investigation · Final report · Nov 13, 2014 · N231JF · Destroyed
  > The noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03013000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03013000/cases

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