NTSB investigations, 2006, ND

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
NTSB investigations, 2006, ND per year, 1964–2026: 1,129 cases
196432
196551
196649
196744
196850
196935
197033
197133
197223
197328
197427
197524
197622
197713
197821
197917
198021
198125
198229
198324
198427
198522
198630
198734
19885
198913
199018
199114
199217
199314
199424
199518
199618
199716
199822
199911
200012
200113
20027
200310
20048
200512
200614
200715
20087
200910
20108
201113
201213
20134
20146
20156
20169
20173
201810
20195
20206
20216
20227
202310
20244
20255
20262

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\") = 2006
    AND c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
  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 CHI07CA019Accident · No injuriesData collectionFinal reportAviat S2B · Larimore, NDThe pilot's failure to maintain proper alignment with the runway which resulted in the airplane nosing over. A factor associated with the accident was the soft terrain encountered.Oct 29, 2006 · N149TM · Substantial damageNTSB CHI07CA003Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Fargo, NDThe pilot's inadequate flare which resulted in a hard landing. Factors associated with the accident were the gusty winds and the pilot's lack of experience.Oct 6, 2006 · N275ND · Substantial damageNTSB CHI06CA257Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Anamoose, NDThe pilot not maintaining altitude/clearance from terrain during the aerial application pass.Sep 6, 2006 · N8501L · Substantial damageNTSB CHI06FA275Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kulm, NDThe non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.Aug 24, 2006 · N9714W · DestroyedNTSB CHI06CA242Accident · No injuriesData collectionFinal reportBell 47G-5 · Sanborn, NDThe pilot's failure to maintain clearance from the power lines during the aerial application flight. The power lines were a factor.Aug 23, 2006 · N2251W · Substantial damageNTSB CHI06LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Rolla, NDThe pilot's failure to maintain clearance from terrain during the aerial-application flight, and the loss of engine power due to the overstress failure of the engine crankshaft sustained during ground impact. Contributing to the accident was the low-altitude…Aug 18, 2006 · N9224R · Substantial damageNTSB CHI06CA229Accident · No injuriesData collectionFinal reportCessna 150 · Jamestown, NDThe pilot's inadequate preflight planning resulted in the pilot not attaining the proper takeoff climb and failure to maintain terrain clearance. Contributing factors included the transmission wires, the row of trees, and the field of corn.Aug 12, 2006 · N17015 · Substantial damageNTSB CHI06CA216Accident · No injuriesData collectionFinal reportPiper PA-25 · Minot, NDThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel calculations and the low airspeed which resulted in the pilot stalling the airplane. A factor was the car on the road which prevented the pilot from landing on the road.Aug 5, 2006 · N7587Z · Substantial damageNTSB CHI06LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Underwood, NDThe pilot's failure to maintain clearance with the power line during the aerial application flight.Aug 3, 2006 · N4693Y · Substantial damageNTSB CHI06CA162Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Bowbells, NDThe pilot's failure to maintain clearance to the rising terrain while maneuvering during the agricultural application flight. Contirbuting factors were the low altitude operation and the rising terrain.Jun 22, 2006 · N1263W · Substantial damageNTSB CHI06CA156Accident · No injuriesData collectionFinal reportCessna 182N · Cooperstown, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control while landing. Factors associated with the accident were the crosswind condition, the high vegetation which the airplane contacted, and the high…Jun 19, 2006 · N9073G · Substantial damageNTSB CHI06CA168Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe dual student's failure to maintain rotor speed during the recovery from the intentional autorotation and the flight instructor's delayed remedial action. Contributing factors were the flight crew's intentional autorotation and dual student's misjudged…Jun 17, 2006 · N1675U · Substantial damageNTSB CHI06CA153Accident · No injuriesData collectionFinal reportCessna R182 · Cooperstown, NDThe pilot's inability to gain sufficient altitude during the aborted landing. Factors associated with the accident were the tailwind, the pilot's selection of the runway used, the wet runway, the roadway, and the corn crop.Jun 9, 2006 · N3360C · Substantial damageNTSB CHI06CA114Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Drayton, NDThe pilot's failure to maintain directional control during takeoff. A related factor was the high wind condition.Apr 12, 2006 · N2555P · Substantial damage