Final NTSB investigations, ND

9 cases where NTSB found Airspeed.

Cases per year

20082026
Final NTSB investigations, ND per year, 2008–2026: 9 cases
20081
20111
20131
20141
20171
20181
20211
20221
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\", '01062010'))
  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 CEN23LA347Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Jamestown, NDThe pilot’s failure to maintain proper airspeed after liftoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.Aug 3, 2023 · N6015W · Substantial damageNTSB CEN22LA291Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Minot, NDThe student pilot’s failure to maintain airspeed and yaw control of the airplane during an aborted takeoff, which resulted in an aerodynamic stall and impact with the ground.Jun 12, 2022 · N737BW · Substantial damageNTSB CEN22LA007Accident · Minor injuriesClass 3 · LimitedFinal reportSoneral L2 · Minot, NDThe pilot’s failure to maintain proper airspeed and exceedance of the airplane’s critical angle of attack on final landing approach, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the pilot’s inexperience with the…Oct 3, 2021 · N9115Y · Substantial damageNTSB CEN19LA039Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Fargo, NDThe pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…Nov 30, 2018 · N941JM · Substantial damageNTSB CEN18LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Dickinson, NDThe pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Nov 22, 2017 · N4040M · Substantial damageNTSB CEN14FA400Accident · 1 fatalField investigationFinal reportLarry Ketterling FEW P-51 Mustang · Lisbon, NDThe partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…Aug 1, 2014 · N116LK · DestroyedNTSB CEN13LA348Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate recovery from a bounced landing, which resulted in an aerodynamic stall during the go-around.Jun 13, 2013 · N552ND · Substantial damageNTSB CEN11CA502Accident · No injuriesData collectionFinal reportCessna A188B · Devils Lake, NDThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall during the aerial application.Jul 22, 2011 · N731AU · Substantial damageNTSB CHI08CA201Accident · Minor injuriesData collectionFinal reportGrumman G-164D · Esmond, NDThe pilot's delay in advancing the throttle during the takeoff which resulted in inadequate airspeed and the subsequent stall/mush. Factors associated with the accident were the leaking hopper, the pilot continuing to operate the airplane with the known…Jul 21, 2008 · N996QC · Substantial damage