# NTSB investigations: Meteo equip coverage/avail

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 ANC17MA001](https://openairdocs.org/ntsb/ANC17MA001.md): Cessna 208B · Togiak, AK · Accident · 3 fatal · Class 1 · Major · Final report · Oct 2, 2016 · N208SD · Destroyed
  > The flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…
- [NTSB ERA14CA185](https://openairdocs.org/ntsb/ERA14CA185.md): Cessna 205A · Leesburg, VA · Accident · No injuries · Data collection · Final report · Apr 8, 2014 · N4862U · Substantial damage
  > The pilot's inadequate compensation for the wind conditions during landing, resulting in a runway excursion and impact with terrain. Contributing to the accident was the pilot's inadequate evaluation of the wind conditions.
- [NTSB ANC10MA068](https://openairdocs.org/ntsb/ANC10MA068.md): Dehavilland DHC-3 · Aleknagik, AK · Accident · 5 fatal · Class 1 · Major · Final report · Aug 9, 2010 · N455A · Substantial damage
  > The pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…

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

This list as a web page: https://openairdocs.org/ntsb-findings/03013010/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.