# NTSB investigations, MD: Loss of visual reference

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 ERA18LA094](https://openairdocs.org/ntsb/ERA18LA094.md): Cessna 172 · Ocean City, MD · Accident · 2 fatal · Limited investigation · Final report · Mar 1, 2018 · N615JA · Destroyed
  > The pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.
- [NTSB GAA16CA077](https://openairdocs.org/ntsb/GAA16CA077.md): Piper PA 28 · California, MD · Accident · No injuries · Data collection · Final report · Dec 11, 2015 · N432FL · Substantial damage
  > The student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.
- [NTSB GAA15CA014](https://openairdocs.org/ntsb/GAA15CA014.md): Costruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MD · Accident · No injuries · Data collection · Final report · Mar 19, 2015 · N731HG · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB ERA13CA122](https://openairdocs.org/ntsb/ERA13CA122.md): Amirkhanian Shahram Charl Commander · Westminster, MD · Accident · Minor injuries · Data collection · Final report · Jan 29, 2013 · N393GX · Substantial damage
  > Impact with power lines due to the pilot’s obscured vision due to the low angle of the sun, which prevented the pilot from seeing the lines.
- [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" = '402' 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/402/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.
