NTSB investigations, ID

6 cases where NTSB found Runway/land/takeoff/taxi surface, general.

Cases per year

20082026
NTSB investigations, ID per year, 2008–2026: 6 cases
20081
20091
20162
20191
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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023000'))
  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 WPR26LA184Accident · No injuriesClass 4 · LimitedFinal reportVans RV-6A · Kooskia, IDThe pilot’s collision with a hole in the runway surface during the landing roll, which resulted in a nose over.May 11, 2026 · N333PK · Substantial damageNTSB WPR20CA043Accident · No injuriesData collectionFinal reportJohn Sample Bearhawk · Nampa, IDThe pilot's selection of unsuitable terrain for landing, which resulted in impact with a knoll and a subsequent ground-loop.Dec 16, 2019 · N719JS · Substantial damageNTSB GAA17CA076Accident · No injuriesData collectionFinal reportCessna 172 · Salmon, IDThe airplane's encounter with a depression in a dirt runway during takeoff, which resulted in a tail strike.Nov 8, 2016 · N737MY · Substantial damageNTSB GAA16CA298Accident · No injuriesData collectionFinal reportCessna 182 · Stanley, IDThe pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.Jun 9, 2016 · N1403S · Substantial damageNTSB WPR09CA346Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Sulphur Creek, IDThe pilot's failure to maintain directional control during the landing roll.Jul 10, 2009 · N199CT · Substantial damageNTSB SEA08CA154Accident · Minor injuriesData collectionFinal reportUetz, Walter Spitfire II · Kamiah, IDThe total loss of engine power for undetermined reasons, and the pilot's failure maintain the proper descent rate during the last part of his approach to a forced landing in an open hayfield.Jun 19, 2008 · N7530L · Substantial damage