Fatal NTSB investigations, 2019

13 cases where the sequence of events included Loss of visual reference.

Cases per year

20082026
Fatal NTSB investigations, 2019 per year, 2008–2026: 138 cases
200811
20097
20101
20118
20129
20133
20144
201513
20164
201715
201813
201913
20202
202112
20223
202312
20246
20251
20261

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.\"highestInjuryLevel\" = 'Fatal'
    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"

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 CEN20FA034Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Flower Pot, AZThe noninstrument-rated pilot’s decision to initiate and continue the visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of airplane control. Contributing was…Dec 8, 2019 · N5557Q · DestroyedNTSB CEN20WA024Accident · 7 fatalForeign investigationPiper PA32 · Kingston, CanadaNov 28, 2019 · N50DK · DestroyedNTSB 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 ERA19FA240Accident · 3 fatalClass 3 · FieldFinal reportBeech F33 · Hatboro, PAThe pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.Aug 8, 2019 · N4082S · 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 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 CEN19FA140Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Eagle Lake, TXThe non-instrument-rated pilot's decision to fly into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and a subsequent impact with terrain.May 11, 2019 · N713LA · 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 WPR19FA103Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Farmington, NMThe noninstrument-rated pilot's continued visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.Mar 31, 2019 · N173CT · 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 damageNTSB WPR19FA084Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Ely, NVThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and icing conditions which resulted in a high rate of descent and impact with terrain. Contributing to the accident was the inaccurate weather reporting…Feb 16, 2019 · N917SR · Destroyed