Final NTSB investigations, ND

5 cases where NTSB found Ceiling/visibility/precip.

Cases per year

20082026
Final NTSB investigations, ND per year, 2008–2026: 5 cases
20081
20161
20171
20201
20231

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 c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030350'))
  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 CEN23LA126Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Bismark, NDThe ground vehicle driver’s failure to see and maintain clearance from the airplane while conducting ground operations.Mar 9, 2023 · N46CV · Substantial damageNTSB CEN21LA044Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-22-135 · Dunn Center, NDThe noninstrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in a loss of control.Nov 8, 2020 · N3606A · DestroyedNTSB CEN17LA244Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 602 · Stirum, NDThe pilot's decision to attempt flight with low-level fog in the area, which resulted in an encounter with instrument meteorological conditions and impact with terrain.Jun 29, 2017 · N4196Y · DestroyedNTSB CEN16LA098Accident · No injuriesLimited investigationFinal reportCessna 441 · Fargo, NDThe pilot’s failure to cycle the surface deice boots during the instrument approach in icing conditions, which led to ice accumulation on the leading edges of the wings and empennage, and resulted in an aerodynamic stall and subsequent hard landing.Jan 8, 2016 · N779CC · Substantial damageNTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…May 10, 2008 · N610RD · Substantial damage