NTSB investigations, 1997

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

19622026
NTSB investigations, 1997 per year, 1962–2026: 180,581 cases
196272
196378
19645,253
19655,377
19665,912
19676,339
19685,199
19695,027
19704,915
19714,825
19724,430
19734,398
19744,565
19754,403
19764,314
19774,412
19784,624
19794,165
19803,921
19813,836
19823,545
19833,514
19843,405
19853,055
19862,831
19872,774
19882,685
19892,502
19902,479
19912,419
19922,328
19932,283
19942,229
19952,281
19962,150
19972,121
19982,195
19992,175
20002,183
20012,031
20022,000
20032,062
20041,930
20052,001
20061,826
20071,984
20081,882
20091,783
20101,786
20111,848
20121,834
20131,561
20141,534
20151,581
20161,662
20171,635
20181,687
20191,626
20201,396
20211,645
20221,700
20231,678
20241,693
20251,655
20261,342

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
  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 NYC98LA058Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355 · New York, NYthe pilot's misjudgment of distance and speed on final approach with a tailwind, and his failure to perform a go-around in a timely manner. A factor in the accident was the strong tailwind.Dec 31, 1997 · N355DS · Substantial damageNTSB MIA98WA049Accident · 10 fatalForeign investigationBritten-Norman Islander · Rio Sidra, PanamaDec 31, 1997 · HP986 · DestroyedNTSB FTW98LA083Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Lakeview, ARthe pilot's failure to maintain runway alignment during the approach, and his delayed decision to execute a go-around. A related factor was the sunglare interfering with the pilot's view.Dec 31, 1997 · N736VQ · DestroyedNTSB CHI98LA076Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Chesterfield, MOthe pilot's failure to position the fuel selector to the proper fuel tank which led to fuel starvation.Dec 31, 1997 · N627V · Substantial damageNTSB CHI98LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boone, IAfailure of the pilot to maintain sufficient altitude/clearance from obstruction(s), while flying low over a river. The obstruction (power line) was a related factor.Dec 31, 1997 · N8465F · Substantial damageNTSB CHI98LA073Accident · 1 fatalLimited investigationFinal reportCessna 402B · Watertown, SDthe pilot's failure to perform an aircraft preflight and to remove the ice which had accumulated on the airframe. A factor involved in the accident was the icing weather conditions which existed and the ice which accumulated on the airplane.Dec 31, 1997 · N5087Q · DestroyedNTSB LAX98LA065Accident · No injuriesLimited investigationFinal reportCessna 172RG · Van Nuys, CAThe student and flight instructor's failure to verify that the landing gear was in the down position, and the design of the electrical system in which a single-point aircraft system malfunction (one open circuit breaker) disabled both the landing gear warning…Dec 30, 1997 · N5404V · Substantial damageNTSB LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.Dec 30, 1997 · N5532H · DestroyedNTSB FTW98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Grants, NMThe pilot's failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was the pilot's inadequate preflight inspection, which failed to secure the right engine oil cap, resulting in oil exhaustion and the loss of engine…Dec 30, 1997 · N87358 · Substantial damageNTSB FTW98LA080Accident · No injuriesLimited investigationFinal reportBeech E18S · Dfw Airport, TXfailure of the pilot in the 2nd airplane (N4980V) to see-and-avoid the standing airplane (N2069C). Related factors were: darkness, and inadequate (vague) instructions issued by the UPS ramp controller.Dec 30, 1997 · N4980V · 2 aircraft · Minor damageNTSB CHI98FA074Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-30 · Wayne, ILthe pilot in command failed to maintain control of the aircraft. A factor was the lack of experience of the pilot and copilot in the type and model of aircraft. An additional factor was the pilot did not follow the proper procedure when the flaps were raised…Dec 30, 1997 · N999WB · DestroyedNTSB MIA98FA047Accident · 2 fatalField investigationFinal reportCessna 414A · Guyton, GAInadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system.Dec 29, 1997 · N414MT · DestroyedNTSB CHI98LA126Accident · 1 fatalLimited investigationFinal reportCessna 177 · Ft. Leonardwood, MOThe pilot's failure to maintain adequate obstacle clearance and his inadequate inflight decision which resulted in VFR flight in to instrument meteorological conditions. The pilot's overconfidence in his ability is a contributing factor.Dec 29, 1997 · N30255 · DestroyedNTSB NYC98LA057Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Elkins, WVThe flight instructor's failure to identify an unsafe runway condition and his delay in aborting the takeoff. Contributing was the aircraft's maximum takeoff weight exceeded, and a snow-covered runway.Dec 28, 1997 · N1348T · DestroyedNTSB NYC98LA056Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Ferncliff, VAthe improper installation of the engine oil temperature probe which resulted in oil starvation and a total loss of engine power. A factor in the accident was the pilot's overflight of available airports in an effort to reach the 'Nearest Airport' displayed on…Dec 28, 1997 · N9717M · DestroyedNTSB NYC98LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Mansfield, MAThe pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.Dec 28, 1997 · N9604H · DestroyedNTSB NYC98LA051Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Albany, OHthe pilot's improper in-flight planning/decision and failure to turn off the carburetor heat during the go-around. Related factors were: the pilot's lack of experience in make and model, and the proximity of trees.Dec 28, 1997 · N1469N · Substantial damageNTSB MIA98WA075Accident · No injuriesForeign investigationRockwell 690A · Villavicencio, ColombiaDec 28, 1997 · N60B · Substantial damageNTSB FTW98LA078Accident · No injuriesLimited investigationFinal reportBeech 35 · Springdale, ARThe fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…Dec 28, 1997 · N2815V · Substantial damageNTSB FTW98LA077Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Worth, TXthe pilot's improper planning/decision, by allowing the airplane to get in a situation, where he could not compensate for wind conditions. A related factor was the gusty crosswind.Dec 28, 1997 · N121KS · Substantial damageNTSB 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 FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.Dec 27, 1997 · N2343T · Substantial damageNTSB FTW98LA079Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Englewood, COThe pilot's improper decision to land in wind conditions that exceeded the airplane's crosswind component, and his failure to divert to an alternate airport with runways more nearly aligned with the wind. Factors were the icy runway and crosswind.Dec 27, 1997 · N5743K · Substantial damageNTSB CHI98LA067Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · Troy, MIloss of engine power for undetermined reason(s). Factors associated with the accident were: the lack of a suitable forced landing site, and the embankment (dirt bank), which the airplane contacted.Dec 27, 1997 · N512WM · Substantial damageNTSB SEA98IA027Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Eugene, ORA checklist procedure was not followed. The initiation of an evacuation was a factor.Dec 26, 1997 · N918UA · No damageNTSB NYC98LA054Accident · Minor injuriesLimited investigationFinal reportMayers SEA REY · Gloucester, VAThe pilot's failure to maintain aircraft control during landing, which resulted in a nose over.Dec 26, 1997 · N100RZ · Substantial damageNTSB NYC98LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Riverside, PAthe pilot's improper response to the low rotor RPM warning. Factors in the accident were the pilot's failure to turn for the forced landing area and the carburetor icing conditions.Dec 26, 1997 · N8015V · Substantial damageNTSB MIA98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, SCThe pilot's inadequate preflight planning, and his poor in-flight decision making.Dec 26, 1997 · N9514K · Substantial damageNTSB MIA98FA045Accident · 1 fatalField investigationFinal reportCessna 172M · Raleigh-Durham, NCWas loss of control of the airplane on initial climb after entering instrument flight conditions resulting in a turn opposite in direction from that given by ATC, and eventual collision with terrain.Dec 25, 1997 · N12172 · DestroyedNTSB SEA98LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kenmore, WAthe pilot's inadequately planned approach and failure to maintain directional control. The pilot's lack of total experience in kind of aircraft and haze were factors.Dec 24, 1997 · N9566L · Substantial damageNTSB NYC98LA052Accident · Minor injuriesLimited investigationFinal reportBeech BE-33A · Lancaster, PAPassenger control interference which resulted in pilot's failure to maintain control of the airplane during landing.Dec 24, 1997 · N4133S · Substantial damageNTSB LAX98LA054Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stoil, CAThe pilot's failure to maintain adequate obstacle clearance and his inadequate visual outlook.. Factors were a severed fuel line which resulted in an in-flight fire, which diminished the pilot's ability to land the airplane with smoke and fire in the cockpit.Dec 24, 1997 · N91915 · DestroyedNTSB FTW98LA075Accident · 1 fatalLimited investigationFinal reportCessna 172M · Monticello, UTThe pilot's failure to maintain adequate altitude and clearance from obstacles. Also causal was the pilot becoming lost and disoriented. Contributing factors were his lack of familiarity with the geographical area, lack of experience, night conditions, and…Dec 24, 1997 · N1596V · Substantial damageNTSB DCA98WA025Accident · No injuriesForeign investigationBoeing 757 · Amsterdam, NetherlandsDec 24, 1997 · PHTKC · Substantial damageNTSB CHI98LA072Accident · 1 fatalLimited investigationFinal reportPiper PA-30/A · Hastings, NEThe pilot's improper IFR procedure, by which he failed to maintain minimum descent altitude. Fog, a low ceiling, and night condition were a contributing factor.Dec 24, 1997 · N9WG · DestroyedNTSB NYC98LA050Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe inadequate snow removal by airport personnel. Contributing factors were the snowbank and whiteout conditions.Dec 23, 1997 · N140ZV · Substantial damageNTSB CHI98FA070Accident · 4 fatalField investigationFinal reportPiper PA-32-301 · Hampshire, ILthe pilot's intentional flight into known icing conditions, and the accumulation of ice on the leading edges of the airplane's empennage and wings leading to the inadvertent stall/mush. A factor contributing to this accident was the icing conditions.Dec 23, 1997 · N2586Y · DestroyedNTSB ATL98FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Tallahassee, FLThe pilot's failure to maintain the proper glidepath and adequate obstacle clearance which resulted in collision with a power transmission line.Dec 23, 1997 · N8074Z · DestroyedNTSB MIA98LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Everglades City, FLthe pilot's improper fuel management and improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: the light conditions at dusk, and the lack of suitable terrain for a forced…Dec 22, 1997 · N9640J · Substantial damageNTSB DCA98WA019Accident · No injuriesForeign investigationBell UH-1H · Columbia, ColombiaDec 22, 1997 · UNKNTSB ATL98LA029Accident · 1 fatalLimited investigationFinal reportLutz EAA Biplane P-2 · Wellington, FLfailure of the pilot to ensure the fuel selector was properly positioned to a tank with adequate fuel before takeoff, which resulted in fuel starvation and loss of engine power; failure of the pilot to accomplish the emergency procedure (restart the engine…Dec 22, 1997 · N913AM · Substantial damageNTSB ATL98LA028Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Eustis, FLfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve and subsequent collision with a parked airplane. Related factors were: the pilot's lack of experience in tailwheel aircraft, the…Dec 22, 1997 · N83589 · Substantial damageNTSB NYC98FA048Accident · 2 fatalField investigationFinal reportCessna 152 · Spring City, PAThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent in-flight collision with terrain.Dec 21, 1997 · N22LU · DestroyedNTSB LAX98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Healdsburg, CAthe pilot's misjudged distance and altitude relationship to the runway during a short field approach, which resulted in an undershoot and a hard landing.Dec 21, 1997 · N8805P · Substantial damageNTSB FTW98LA071Accident · Serious injuriesLimited investigationFinal reportUnknown Quicksilver GT-500 · San Antonio, TXthe kitplane builder's improper installation of the bolts attaching the left leading edge wing strut fitting to the leading edge spar, which resulted in the eventual failure of the fitting and the ensuing loss of control. Related factors were: the…Dec 21, 1997 · UNREG · Substantial damageNTSB FTW98FA074Accident · 2 fatalField investigationFinal reportBeech A100 · Colo Springs, COFailure of the pilot to follow IFR Procedures and maintain the minimum descent altitude (MDA). A related factor was fog.Dec 21, 1997 · N100BE · DestroyedNTSB NYC98FA047Accident · 1 fatalField investigationFinal reportCady LONG-EZ · West Milford, NJFailure of the pilot to use carburetor heat, which resulted in carburetor ice. Carburetor icing conditions and terrain conditions were contributing factors.Dec 20, 1997 · N18CC · Substantial damageNTSB LAX98LA059Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Safford, AZThe pilot's poor in-flight judgement and intentional flight into known adverse weather conditions. Related factors were, mountainous terrain, rain and fog.Dec 20, 1997 · N2965L · DestroyedNTSB LAX98LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Truckee, CAinternal mechanical failure of the engine due to a progressive failure of the No. 3 connecting rod assembly. A contributing factor was the snow pack which covered the only accessible emergency landing area.Dec 20, 1997 · N5058L · Substantial damageNTSB LAX98IA061Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · San Francisco, CAAn emergency evacuation due to fumes from a failed hydraulic line that entered into the cabin.Dec 20, 1997 · N932AS · No damage