OpenAirDocs.org

NTSB investigations, 2019

8 cases where the defining event was Loss of visual reference.

Cases per year

20082026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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 year(c.\"eventDate\") = 2019
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '402')
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN20FA010Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Aberdeen, SDThe noncertificated pilot’s decision to fly in dark night instrument conditions, resulting in impact with terrain.Oct 10, 2019 · N6483B · DestroyedNTSB GAA19WA574Accident · 2 fatalForeign investigationCirrus SR22 · Pedreguer, SpainThe government of Spain has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions…Sep 15, 2019 · F-HAMP · DestroyedNTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…Jul 24, 2019 · N921CD · DestroyedNTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.Jul 16, 2019 · N4876N · Substantial damageNTSB GAA19WA417Accident · 3 fatalForeign investigationDe Havilland DHC2 · Chibogamau, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…Jul 12, 2019 · C-GRHF · Substantial damageNTSB ERA19FA191Accident · 1 fatalClass 3 · FieldFinal reportAgusta A109 · New York, NYThe non-instrument-rated pilot’s decision to initiate the flight into marginal visual flight rules and instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.Jun 10, 2019 · N200BK · DestroyedNTSB ERA19FA163Accident · 2 fatalClass 2 · FieldFinal reportGuimbal Cabri · Kent Island, MDThe 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…May 4, 2019 · N572MD · DestroyedNTSB ERA19FA116Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Fellsmere, FLThe student pilot's loss of control due to spatial disorientation following an encounter with instrument meteorological conditions shortly after takeoff. Contributing to the accident was the failure of both the pilot and the flight school to ensure that the…Mar 5, 2019 · N556PU · Substantial damage