Final NTSB investigations, ND

7 cases where NTSB found Inspection.

Cases per year

20082026
Final NTSB investigations, ND per year, 2008–2026: 7 cases
20081
20141
20161
20182
20191
20241

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\", '020615'))
  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 CEN24LA184Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22 · Enderlin, NDThe pilot’s failure to properly inspect and sump the fuel system before the flight and the maintenance personnel’s inadequate maintenance of the fuel system which resulted in fuel starvation and the subsequent loss of engine power due to the contamination of…May 13, 2024 · N669A · Substantial damageNTSB CEN19LA311Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Grassy Butte, NDA total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.Sep 10, 2019 · N5347T · Substantial damageNTSB CEN18LA334Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Kindred, NDThe pilot’s failure to adequately inspect the lower coupling driveshaft during his preflight inspection and his non-compliance with an applicable airworthiness directive, which resulted in the failure of the forward drive splines of the lower coupling…Aug 16, 2018 · N3625Z · DestroyedNTSB CEN18LA097Accident · No injuriesLimited investigationFinal reportPiper PA 24-260 · Fargo, NDThe pilot's failure to use the published emergency procedures to manually extend the landing gear when an electrical failure precluded normal extension of the landing gear, resulting in the gear collapse during landing. Contributing to the accident was the…Feb 8, 2018 · N9360P · Substantial damageNTSB CEN16LA314Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley City, NDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Aug 5, 2016 · N5599X · Substantial damageNTSB CEN14LA358Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Garrison, NDExcessive wear between the power turbine shaft and quill shaft spline, which led to the disconnection of the power turbine wheel, an overspeed of the power turbine, and the subsequent loss of engine power. Contributing to the accident was maintenance…Jul 9, 2014 · N6648Q · Substantial damageNTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.Jun 4, 2008 · N1437Y · Substantial damage