# NTSB investigations, MD: VFR encounter with IMC

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 ERA19FA163](https://openairdocs.org/ntsb/ERA19FA163.md): Guimbal Cabri · Kent Island, MD · Accident · 2 fatal · Class 2 · Field · Final report · May 4, 2019 · N572MD · Destroyed
  > The noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in an inadvertent descent into the water. Contributing to the accident was the pilot's decision to conduct the flight at a low altitude without…
- [NTSB ERA09FA417](https://openairdocs.org/ntsb/ERA09FA417.md): Robinson Helicopter R44 · Boonsboro, MD · Accident · 4 fatal · Field investigation · Final report · Jul 24, 2009 · N7189W · Substantial damage
  > The pilot’s improper decision to depart on a visual flight rules (VFR) flight at night in adverse weather conditions in close proximity to rising mountainous terrain in a helicopter that was only certified to be operated under VFR and his subsequent failure…
- [NTSB MIA08MA203](https://openairdocs.org/ntsb/MIA08MA203.md): Aerospatiale SA365N-1 D · District Heights, MD · Accident · 4 fatal · Class 1 · Major · Final report · Sep 28, 2008 · N92MD · Substantial damage
  > The pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…
- [NTSB NYC08LA310](https://openairdocs.org/ntsb/NYC08LA310.md): Dufault Mark V Pitts S-1D · Ridgely, MD · Accident · 1 fatal · Limited investigation · Final report · Sep 9, 2008 · N511MD · Substantial damage
  > The pilot's inadequate preflight weather evaluation which resulted in an attempted landing in fog and subsequent impact with terrain.

## 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" = 'MD' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '401' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/401/sequence?state=MD

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