NTSB investigations, 1997, 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, 1997, 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\") = 1997
    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 CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.Dec 9, 1997 · N55259 · Substantial damageNTSB CHI98LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot's inadequate preflight planning which resulted in a low fuel state, and his inability to see the wire which the helicopter contacted. Factors associated to the accident were the precautionary landing, the dark night conditions, and the wire which…Oct 15, 1997 · N557DC · Substantial damageNTSB CHI98LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Williston, NDthe pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.Oct 11, 1997 · N9691P · Substantial damageNTSB CHI98LA001Accident · No injuriesLimited investigationFinal reportCessna T210N · Fargo, NDthe circuit breaker for the hydraulic pump popped during gear extension which resulting in the failure of the landing gear to lock in the extended position.Oct 1, 1997 · N5168A · Substantial damageNTSB CHI97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fargo, NDthe pilot's misjudgment of altitude and distance to the runway, while on final approach to land, and failure to attain the proper touchdown point on the runway during the landing. The exposed runway lip was a related factor.Sep 17, 1997 · N2680Q · Substantial damageNTSB CHI97LA292Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Grand Forks, NDThe flight attendant's seat belt was not secured. A factor was turbulence in the clouds.Sep 14, 1997 · N175UA · No damageNTSB CHI97LA278Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Larimore, NDthe pilot delaying the swath run turnaround maneuver at the end of the field boundary, and his failure to maintain clearance between the airplane and the high tension wires. A factor was the pilot's inattentiveness regarding the time to begin the swath run…Sep 3, 1997 · N8326K · DestroyedNTSB CHI97LA238Accident · No injuriesLimited investigationFinal reportVelocity Velocity Elite RG · Langdon, NDfailure of the pilot to maintain directional control during the landing roll. The crosswind and proximity of the taxiway sign were related factors.Jul 31, 1997 · CGPNX · Substantial damageNTSB CHI97LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fessenden, NDthe pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.Jul 17, 1997 · N41371 · Substantial damageNTSB FTW97IA261Incident · Minor injuriesIncident investigationFinal reportBoeing 757-223 · Dickinson, NDan encounter with unforecast convection induced turbulence (CIT). Related factors were: the flight crew's improper evaluation of the weather, and an inaccurate preflight weather briefing by company weather personnel.Jul 10, 1997 · N660AM · Minor damageNTSB CHI97LA184Accident · Minor injuriesLimited investigationFinal reportWeatherly 201C · Buffalo, NDthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control of the airplane. Water on the runway and the soft terrain were related factors.Jun 25, 1997 · N1299W · Substantial damageNTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.Jun 5, 1997 · N8293G · Substantial damageNTSB CHI97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dickinson, NDthe student pilots failure to maintain directional control of the airplane. A factor associated with the accident was the pilot's runway selection.May 10, 1997 · N280TC · Substantial damageNTSB CHI97LA120Accident · No injuriesLimited investigationFinal reportMaule M-5 · West Fargo, NDthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point. Factors relating to the accident were: the unfavorable wind conditions, and the terrain condition where the airplane touched down.May 3, 1997 · N290X · Substantial damageNTSB CHI97LA101Accident · Serious injuriesLimited investigationFinal reportAeronca 7CCM · Carson, NDa loss of engine power due to ice in the fuel line. A factor was inadequate maintenance and inspection.Apr 9, 1997 · N85257 · Substantial damageNTSB CHI97LA090Accident · No injuriesLimited investigationFinal reportCurtiss-Wright P-40E · Grand Forks, NDthe pilot's improper flare during landing.Mar 25, 1997 · N7205A · Substantial damage