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.
Cases, newest first
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.
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 LAX97IA180Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · San Luis Obispo, CACompressor stalls of both engines due to in-service compressor contamination. Factors in the compressor stall of the right engine were an atmospheric temperature inversion and a transient fuel flow condition produced when the constant thrust on takeoff (CTOT)…NTSB FTW97LA190Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Laredo, TXloss of engine power due to fuel contamination, and the pilot's failure to properly check the fuel system for evidence of water during the preflight inspection. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA151Accident · No injuriesLimited investigationFinal reportBeech 35 · Liberty, MOretraction of the nose gear for undetermined reason(s).NTSB CHI97LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Sheboygan, WIthe pilot's failure to maintain control of the airplane during the landing roll. A factor associated with the accident was the sudden change in wind conditions.NTSB CHI97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILthe pilot's misjudgment of the aircraft's speed and runway distance available. Factors were an off-field ditch and a tailwind condition.NTSB ANC97LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Cordova, AKThe pilot's decision not to perform a go-around. A factor in the accident was the presence of birds which led the pilot to extend and misjudge his touchdown point.NTSB LAX97LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Burbank, CAimproperly secured upper cowl fasteners by unknown person(s).NTSB LAX97LA178Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Santa Margarita, CAThe failure of the pilot to maintain adequate rotor rpm during a low pass maneuvering flight resulting in loss of control. High density altitude was a factor in the accident.NTSB LAX97FA177Accident · 5 fatalField investigationFinal reportBeech A36TC · Truckee, CAfailure of the pilot to maintain altitude and clearance above the terrain, while turning (for an unknown reason) back toward the airport after takeoff. Factors relating to the accident were: the environmental conditions (light conditions at dusk and high…NTSB FTW97LA186Accident · No injuriesLimited investigationFinal reportSnow S2C · Hondo, TXThe pilot's failure to maintain directional control while landing.NTSB 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…NTSB NYC97LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Pottstown, PAwas the flight instructor's diverted attention while standing on the wing behind a turning propeller, which resulted in his departure from the wing, forward into the turning propeller.NTSB MIA97WA158Accident · 1 fatalForeign investigationAyres S2R · Brenon, PanamaNTSB MIA97LA159Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · San Juan, PRan on ground engine fire in the No. 3 (right) engine resulting from a failed heat exchanger, and subsequent fuel leak. A factor in this accident was the cabin crew's improper handling of the evacuation which resulted in serious injury to a passenger.NTSB LAX97LA176Accident · 2 fatalLimited investigationFinal reportHughes 369D · Puako, HIerosion of second stage stator vanes, inadequate maintenance inspection for the erosion, and subsequent fatigue failure of a stator vane, which resulted in loss of engine power and a forced landing on mountainous/hilly terrain. Also causal was: the pilot's…NTSB FTW97IA187Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Corpus Christi, TXThe flightcrew's inadequate in-flight planning and decision, and their failure to refer to the navaids needed for the instrument approach procedure. A factor was the lack of a minimum safe altitude warning from approach control.NTSB CHI97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Correctionville, IAthe pilot's inadequate compensation for wind conditions, while taxiing, which resulted in loss of aircraft control, an encounter with terrain, and subsequent failure of the left main landing gear. The unfavorable wind condition was a related factor.NTSB CHI97LA129Accident · No injuriesLimited investigationFinal reportBeech B33-35 · Mishawaka, INImproper flare. A factor associated with the accident was the gusty, crosswind condition.NTSB SEA97LA108Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · The Dalles, ORThe pilot-in-command misjudged his altitude and distance from the runway while landing.NTSB SEA97LA107Accident · No injuriesLimited investigationFinal reportCessna 170B · Ontario, ORThe pilot's failure to adequately compensate for the wind conditions. A factor contributing to the accident was gusting winds.NTSB SEA97LA104Accident · 1 fatalLimited investigationFinal reportCessna T188C · Mitchell, ORThe pilot's failure to maintain adequate airspeed while maneuvering, which led to a stall. A factor contributing to the accident was the lack of adequate altitude to effect a successful stall recovery.NTSB SEA97FA106Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Tigard, ORThe pilot's failure to properly manage the aircraft fuel supply, which led to fuel exhaustion of the right tank and subsequent fuel starvation/power loss of the engine during the final approach. Factors contributing to the accident were the lack of sufficient…NTSB SEA97FA105Accident · 3 fatalField investigationFinal reportCessna 182 · Clinton, UTInadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…NTSB NYC97LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · New Castle, DEthe pilot's failure to maintain directional control of the airplane. A contributing factor was the gusty wind conditions.NTSB NYC97LA088Accident · No injuriesLimited investigationFinal reportNorth American B-25J · Midland, VAThe pilot's misjudgment of distance and altitude during the final approach. A factor in the accident was the exposed runway lip/edge.NTSB IAD97LA074Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Lewisburg, WVThe pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.NTSB FTW97LA189Accident · No injuriesLimited investigationFinal reportTownsend Kitfox · Greeley, COThe engine manufacturer's inadequate quality control by failing to install the harmonic balancer, causing the engine to fail catastrophically. A factor was the lack of suitable terrain on which to make a forced landing.NTSB 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.NTSB ATL97FA072Accident · 1 fatalField investigationFinal reportBellanca 14-13 · Stockbridge, GAthe pilot's improper use of carburetor heat, which led to loss of engine power due to carburetor ice. Factors related to the accident were: carburetor icing (weather) conditions, and trees in the emergency landing area.NTSB SEA97LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Deer Lodge, MTThe pilot's improper decision to abort the takeoff, and his improper use of brakes during the abort. A factor contributing to the accident was the pilot's failure to maintain directional control during the takeoff roll.NTSB NYC97WA091Accident · No injuriesForeign investigationBritish Aerospace BA-31 · Hamilton, CanadaNTSB MIA97IA160Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Miami, FLfatigue failure of a segment of the elevator trim cable system. A factor relating to the incident was: inadequate procedure for inspection of the cable system by the airplane manufacturer.NTSB FTW97LA188Accident · No injuriesLimited investigationFinal reportAeromot AMT-200 · Longmont, COthe dual student pilot's improper landing flare and the flight instructor's inadequate supervision of the flight.NTSB FTW97LA185Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Torreon, NMfailure of the forward number four piston pin plug, and the subsequent obstruction of internal oil passages of the lubricating system, which resulted in partial loss of engine power. Factors relating to the accident were: the crosswind condition and lack of…NTSB FTW97LA182Accident · Minor injuriesLimited investigationFinal reportMooney M20K · N Little Rock, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's failure to use the proper aborted landing procedures.NTSB CHI97LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Prairie View, KSan undetermined event, which resulted in loss of engine power. Factors relating to the accident were: an automobile, which prevented the pilot from landing on a road; and a dirt bank (terrace) in the emergency landing area.NTSB LAX97LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T-34 · Tonopah, AZthe failure of the power turbine due to an overtemperature condition created by an improperly adjusted fuel control. A factor in the accident was the tripped circuit breaker which prevented the wing lights from operating during the forced night landing.NTSB FTW97LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe pilot's loss of control due to delayed landing flare. A factor was the porpoise encountered during landing.NTSB FTW97IA362Incident · No injuriesIncident investigationFinal reportAyres S2R-G10 · Munday, TXblockage of both fuel lines from the left wing tank to the header tank by silicone rubber contaminants (foreign material), which resulted in fuel starvation. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW97FA181Accident · 1 fatalField investigationFinal reportCessna 172RG · Intracoastal, LAthe pilot's decision to fly, when he was not in good physical condition; and his subsequent loss of aircraft control due to incapacitation. A related factor was: the pilot's perception of an urgency (pressure) to fly, induced by conditions/events.NTSB DCA97WA045Accident · 35 fatalForeign investigationBoeing 737-300 · Shenzhen, ChinaNTSB CHI97IA127Incident · No injuriesIncident investigationFinal reportCessna T210 · Winona, MNLoss of engine power due to improper maintenance installation.NTSB ATL97LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jacksonville, FLThe pilot's failure to maintain terrain clearance while on a low pass, leading to propeller damage. A factor was birds in the area.NTSB SEA97LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTThe pilot's failure to adequately compensate for wind conditions during the landing roll. Factors contributing to the accident were gusts and crosswinds.NTSB NYC97LA087Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Salem, OHthe pilot's failure to maintain aircraft control during the initial takeoff climb. Factors relating to the accident were the pilot's lack of experience in the make and model of airplane, and the gusty crosswind conditions.NTSB MIA97LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wilgrove, NCthe pilot's improper planning, which resulted in fuel exhaustion and a forced landing short of the intended destination airport.NTSB LAX97LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · El Monte, CAthe student pilot's misunderstanding of the controller's clearance during an aborted touch-and-go landing.NTSB FTW97LA195Accident · No injuriesLimited investigationFinal reportCessna 182K · Little Rock, ARthe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW97LA180Accident · No injuriesLimited investigationFinal reportCessna 172N · Las Cruces, NMThe improper installation of the throttle arm castellated nut, which resulted in a partial loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rogers City, MIthe disconnection of the tailwheel spring which resulted in the pilot's inability to maintain directional control of the airplane.