Skip to content

NTSB investigations, 1997

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA97LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sanford, FLFailure of the oil cooler radiator hose which resulted in oil exhaustion and subsequent engine failure. Contributing to the accident was the failure of the FAA to require a recurrent detailed examination and or require those hoses be life limited to prevent…Jun 26, 1997 · N859KW · Substantial damage NTSB CHI97FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Canton, MIA loss of engine power due to fuel starvation from a binding throttle/power lever cable. Also causal was the improper maintenance, installation of the throttle arm. Contributing to the accident were the dark night and unsuitable terrain for the forced landing.Jun 26, 1997 · N7031Q · Substantial damage NTSB ANC97LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKwater contamination in the fuel, the second pilot's inadequate preflight/preparation to ensure all water was drained from the airplane fuel tanks, and inadequate supervision by the first pilot (CFI). A factor relating to the accident was: the lack of suitable…Jun 26, 1997 · N1386A · Substantial damage NTSB SEA97LA151Accident · No injuriesLimited investigationFinal reportCessna 182P · Yakima, WAThe loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.Jun 25, 1997 · N9932E · Substantial damage NTSB LAX97LA224Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28-F · Riverside, CAfailure by unknown maintenance personnel to retorque the nuts on the retainer cover.Jun 25, 1997 · N99YC · Substantial damage NTSB LAX97LA223Accident · No injuriesLimited investigationFinal reportCessna 140 · Columbia, CAthe student pilot's failure to maintain directional control of the aircraft during a bounced landing recovery.Jun 25, 1997 · N4293N · Substantial damage NTSB FTW97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Whitewright, TXThe pilot's selection of an unsuitable area for takeoff. A factor was the dirt bank (terrace).Jun 25, 1997 · N8326S · Substantial damage NTSB FTW97LA234Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sugar Land, TXthe pilot's improper landing flare and improper recovery from a bounced landing.Jun 25, 1997 · N96TJ · Substantial damage NTSB 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 damage NTSB CHI97FA187Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Lenox Township, MIThe pilot's failure to follow the procedures and directives as listed on the placard in the aircraft resulting in fuel starvation and subsequent engine failure.Jun 25, 1997 · N4882Z · Substantial damage NTSB ANC97LA090Accident · No injuriesLimited investigationFinal reportBeech D18S · Willow, AKThe loss of engine power for an undetermined reason.Jun 25, 1997 · N765D · Destroyed NTSB NYC97LA128Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bellwood, PAthe total loss of engine power due to failed connecting rods.Jun 24, 1997 · N6756N · Substantial damage NTSB MIA97LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Tunica, MSThe pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.Jun 24, 1997 · N45461 · Substantial damage NTSB MIA97LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Walls, MSThe poor in-flight planning by the pilot for her failure to divert to an alternate airport after recognizing that a low fuel quantity state existed when preflight and in-flight planning revealed sufficient fuel for the flight. Contributing to the accident was…Jun 24, 1997 · N3692M · Substantial damage NTSB LAX97LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe dual student's premature rotation and failure to attain/maintain an adequate airspeed, which lead to a stall/mush and loss of control in-flight, and the flight instructor's inadequate supervision of the flight. A factor in this accident was the flight…Jun 24, 1997 · N96736 · Substantial damage NTSB FTW97LA233Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Swifton, ARthe pilot's improper planning/decision. Factors relating to the accident were: the pilot's lack of recent experience in type of airplane, the weather condition (high temperature and tailwind), and the proximity of the fence and trees to the runway.Jun 24, 1997 · N6740Q · Destroyed NTSB CHI97LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lansing, ILthe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.Jun 24, 1997 · N99BF · Substantial damage NTSB ANC97IA089Incident · No injuriesIncident investigationFinal reportCessna 185 · Anchorage, AKThe pilot-in-command's failure to retract the landing gear which led to an inadvertent water landing with the amphibian float wheels extended. Associated factors are the pilot's habit interference and the FAA inspector's inadequate monitoring of the flight.Jun 24, 1997 · N4952E · Minor damage NTSB NYC97LA127Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Rochester, VTThe pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.Jun 23, 1997 · N1043G · Substantial damage NTSB NYC97LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to secure the cargo. A factor was the pilot's failure to perform weight and balance calculations.Jun 23, 1997 · N8321Y · Destroyed NTSB FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…Jun 23, 1997 · N7684V · Substantial damage NTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.Jun 23, 1997 · N9842J · Substantial damage NTSB ATL97LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ridgely, TNThe pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.Jun 23, 1997 · N6128W · Substantial damage NTSB NYC97LA125Accident · 1 fatalLimited investigationFinal reportShafer SONERAI-I · W.Hampton Beach, NYfailure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.Jun 22, 1997 · N20CS · 2 aircraft · Destroyed NTSB LAX97LA222Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · San Diego, CAthe pilot-in-command's failure to maintain an adequate airspeed which resulted in a stall/mush.Jun 22, 1997 · N6471C · Substantial damage NTSB LAX97FA286Accident · 1 fatalField investigationFinal reportCessna 172N · Cuyama, CAundetermined.Jun 22, 1997 · N6141D · Destroyed NTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.Jun 22, 1997 · N4491R · Substantial damage NTSB CHI97LA180Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chicago, ILthe pilot inadvertently executed a wheels up landing.Jun 22, 1997 · N6280R · Substantial damage NTSB ATL97LA089Accident · No injuriesLimited investigationFinal reportCessna 175A · Panama City Bch, FLfailure of the pilot to account for the reduced braking effectiveness on the wet/grass airstrip, which resulted in an overrun and encounter with a ditch. Factors relating to the accident were: failure of the pilot to obtain weather information before…Jun 22, 1997 · N6844E · Substantial damage NTSB ANC97LA105Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK-I · Juneau, AKThe pilot's misjudged touchdown which resulted in dragging the right wingtip and rupturing the fuel tank. A factor associated with the accident is the rough water conditions.Jun 22, 1997 · N470DB · Substantial damage NTSB ANC97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hoonah, AKThe pilot's failure to maintain directional control while landing.Jun 22, 1997 · N7025B · Substantial damage NTSB SEA97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madras, ORThe pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.Jun 21, 1997 · N1357T · Substantial damage NTSB SEA97FA148Accident · 2 fatalField investigationFinal reportBeech 77 · Cottage Grove, ORFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.Jun 21, 1997 · N6630C · Substantial damage NTSB NYC97LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Charleston, WVthe pilot's inadequate compensation for unfavorable (variable) wind conditions, and his failure to maintain directional control of the airplane. The wind condition and proximity of a hangar were related factors.Jun 21, 1997 · N47282 · Substantial damage NTSB NYC97LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJA loss of engine power due to a partially blocked engine muffler.Jun 21, 1997 · N43464 · Destroyed NTSB MIA97WA189Accident · No injuriesForeign investigationAviat A-1 · San Fernando, ArgentinaJun 21, 1997 · N12HU · Substantial damage NTSB MIA97LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Orangeburg, SCFailure of the pilot to recover from the bounced landing. Contributing to the accident was the pilots complacency.Jun 21, 1997 · N64936 · Substantial damage NTSB MIA97LA192Accident · 1 fatalLimited investigationFinal reportUnknown Kolb Firestar II · Orlando, FLInadvertent stall by the pilot while turning from the upwind to the crosswind leg. Contributing to the accident was the pilots lack of total experience in the make and model airplane.Jun 21, 1997 · UNREG · Substantial damage NTSB MIA97LA191Accident · No injuriesLimited investigationFinal reportSherman Powell Kitfox IV · Concord, NCFailure of the pilot-in-command to maintain directional control and his poor preflight planning preparation for allowing the pilot rated passenger to manipulate the throttle control. Contributing to the accident was the pilots total lack of experience in make…Jun 21, 1997 · N582KF · Substantial damage NTSB MIA97FA188Accident · 1 fatalField investigationFinal reportBeech 77 · Fort Lauderdale, FLloss of engine power for undetermined reason(s), and failure of the student pilot to remain clear of obstructions, while attempting to make a forced landing.Jun 21, 1997 · N1821B · Destroyed NTSB IAD97LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Defiance, OHThe failure of a wheel rim due to overstress separation with no clear evidence initiating event.Jun 21, 1997 · N5716F · Substantial damage NTSB 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 damage NTSB CHI97LA182Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Willard, MOremedial action delayed by the flight instructor. A factor in this accident was the instructor's lack of recent experience in this type airplane.Jun 21, 1997 · N7506F · Substantial damage NTSB CHI97LA177Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot not maintaining aircraft control shortly after it had touched down during its liftoff. A factor in this accident was the premature liftoff during takeoff by the pilot.Jun 21, 1997 · N4954R · Substantial damage NTSB CHI97LA176Accident · No injuriesLimited investigationFinal reportMaule M5C · Lino Lakes, MNthe flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…Jun 21, 1997 · N5643Y · Substantial damage NTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.Jun 21, 1997 · N6535R · Substantial damage NTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.Jun 21, 1997 · N7378Z · Destroyed NTSB ANC97LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Prudhoe Bay, AKThe pilot's improper preflight inspection of the airplane and failure to properly secure the baggage door.Jun 21, 1997 · N756DJ · Substantial damage NTSB SEA97LA150Accident · No injuriesLimited investigationFinal reportCorben Junior ACE · East Wenatchee, WAThe dual student's improper attempt to abort the takeoff and the flight instructor's inadequate supervision of the flight.Jun 20, 1997 · N9017 · Substantial damage NTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…Jun 20, 1997 · N168RW · Destroyed