Major NTSB investigations, 1997

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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

19622026
Major NTSB investigations, 1997 per year, 1962–2026: 654 cases
19685
196913
197012
197112
197211
197310
19749
197511
19768
19777
197810
197911
19809
198111
19829
198319
198425
198531
198648
198730
198817
198924
199012
199114
199211
199314
199416
19957
199612
199710
19987
19998
200014
200113
20026
200310
200417
200518
200611
200712
200815
20098
20105
20119
20121
20139
20144
20156
20164
20174
20183
201911
20201
20211
20223
20233
20242
20259
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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
  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 DCA98MA015Accident · 1 fatalMajor investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)The pilot-in-command's inadvertent flight into adverse weather conditions, and the difficulty of obtaining adequate weather forecasts of over-ocean turbulence. Factors contributing to the accident include the presence of clear air turbulence, and the failure…Dec 28, 1997 · N4723U · Minor damageNTSB ANC98MA008Accident · 8 fatalMajor investigationFinal reportCessna 208B · Barrow, AKThe pilot's disregard for lateral fuel loading limits, his improper removal of frost prior to takeoff, and the resulting inadvertent stall/spin. Factors involved in this accident were the improper asymmetrical fuel loading which reduced lateral aircraft…Nov 8, 1997 · N750GC · DestroyedNTSB DCA98MA002Accident · 9 fatalMajor investigationFinal reportCessna 208B · Montrose, COthe pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…Oct 8, 1997 · N12022 · DestroyedNTSB DCA97MA059Accident · 5 fatalClass 1 · MajorFinal reportDouglas DC-8-61 · Miami, FLThe airplane being misloaded to produce a more aft center of gravity and a correspondingly incorrect stabilizer trim setting that precipitated an extreme pitch-up at rotation, was (1) the failure of Fine Air to exercise operational control over the cargo…Aug 7, 1997 · N27UA · DestroyedNTSB DCA97MA058Accident · 228 fatalClass 1 · MajorFinal reportBoeing 747-300 · Nimitz Hillthe captain's failure to adequately brief and execute the nonprecision approach and the first officer's and flight engineer's failure to effectively monitor and cross-check the captain's execution of the approach. Contributing to these failures were the…Aug 6, 1997 · H7468 · DestroyedNTSB DCA97MA055Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-11 · Newark, NJThe captain's overcontrol of the airplane during the landing and his failure to execute a go-around from a destabilized flare. Contributing to the accident was the captain's concern with touching down early to ensure adequate stopping distance.Jul 31, 1997 · N611FE · DestroyedNTSB DCA97MA053Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Honolulu, HIThe pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…Jun 21, 1997 · EICDK · Substantial damageNTSB DCA97MA049Accident · Serious injuriesMajor investigationFinal reportAirbus Industrie A300B4-605R · West Palm Beach, FLThe flightcrew's failure to maintain adequate airspeed during leveloff which led to an inadvertent stall, and their subsequent failure to use proper stall recovery techniques. A factor contributing to the accident was the flightcrew's failure to properly use…May 12, 1997 · N90070 · Minor damageNTSB ANC97MA161Accident · 5 fatalMajor investigationFinal reportCessna 208B · Wainwright, AKThe pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain altitude/clearance from terrain. Factors contributing to the accident were the weather conditions.Apr 11, 1997 · N408GV · DestroyedNTSB DCA97MA017Accident · 29 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Monroe, MIThe Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…Jan 9, 1997 · N265CA · Destroyed