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 CHI97LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Huron, SDThe pilot's failure to maintain clearance from known transmission lines.NTSB ATL97LA080Accident · No injuriesLimited investigationFinal reportLearjet 31A · Atlantic Ocean (Atlantic Ocean)the pilot-in-command's failure to maintain airspeed within the design structural limits of the airplane.NTSB SEA97LA100Accident · No injuriesLimited investigationFinal reportCessna TR182RG · Ennis, MTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting winds, and the presence of a ditch on the edge of the landing area.NTSB SEA97LA099Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Rosalia, WAThe pilot-in-command's failure to maintain clearance with terrain. Factors contributing to the accident were, hilly terrain conditions and impairment due to recent use of marihuana.NTSB FTW97LA179Accident · Serious injuriesLimited investigationFinal reportCallair A2A · Grants, NMInadvertent stall. Factors were the ground depression, the high density altitude, and a lack of recent experience in the make and model of aircraft.NTSB CHI97LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochelle, ILthe student pilot's delay in aborting the takeoff and the use of excessive braking after deciding to abort the takeoff. A factor was the pilot's failure to maintain runway alignment during the landing.NTSB SEA97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Tooele, UTthe pilot's excessive rotation of the aircraft during takeoff, and his failure to obtain/maintain adequate airspeed. Inadequate supervision by the instructor pilot (CFI/check pilot) was a related factor.NTSB IAD97LA072Accident · No injuriesLimited investigationFinal reportCessna 172H · Westminister, MDThe pilot misjudged landing distance on the runway and his failure to perform a go-around.NTSB CHI97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILthe pilot-in-command's inadequate compensation for the wind conditions. A factor associated with the accident was the gusty crosswind condition.NTSB NYC97LA085Accident · 1 fatalLimited investigationFinal reportMarsh-Turner BG-12A · Marion, OHDisconnection of the elevator control rod which resulted in the loss of elevator control. A factor was failure to complete the required maintenance inspection.NTSB MIA97WA181Accident · 1 fatalForeign investigationPiper PA-23-250 · Bimini, BahamasNTSB MIA97LA153Accident · No injuriesLimited investigationFinal reportCessna 182P · Mobile, ALthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during landing rollout, which resulted in a collision with a runway light.NTSB FTW97LA177Accident · Serious injuriesLimited investigationFinal reportBoeing 737-201 · Denver, COThe flight attendant's failure to assure that the jetway was placed in the proper position prior to opening the forward cabin entry door.NTSB FTW97LA176Accident · Serious injuriesLimited investigationFinal reportLockheed P-38L · Galveston, TXfailure of the pilot to maintain aircraft clearance from the ground vehicle.NTSB FTW97LA175Accident · No injuriesLimited investigationFinal reportCessna 172P · Austin, TXThe pilot's failure to maintain aircraft control. A factor was the pilot's inadequate compensation for the wind conditions.NTSB ANC97LA068Accident · No injuriesLimited investigationFinal reportHammer Avid Flyer · Chitina, AKimproper overhaul of the engine, which resulted in a seized piston and resultant loss of engine power. Rough terrain in the emergency landing area was a related factor.NTSB ANC97LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the crosswind.NTSB SEA97FA097Accident · 4 fatalField investigationFinal reportCessna T210M · Bullfrog, UTThe pilot-in-command's failure to maintain adequate flying airspeed, for reason(s) unknown, resulting in a subsequent stall.NTSB MIA97LA155Accident · No injuriesLimited investigationFinal reportPiper PA31-350 · St Thomasfailure of the pilot to follow emergency procedures for loss of power in the right engine, by failing to shutdown the right engine and feather the right propeller. This resulted in the aircraft being unable to maintain altitude and a subsequent ditching in…NTSB LAX97LA175Accident · No injuriesLimited investigationFinal reportAeronca 7AC-EC · Truckee, CAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control during the landing and go-around. The gusty/crosswind condition and proximity of obstructions (runway sign and rocks) were related factors.NTSB FTW97FA174Accident · 2 fatalField investigationFinal reportBeech V35 · Lake George, COThe pilot-in-command's failure to maintain control of the airplane. A factor was the terrain-induced turbulence.NTSB FTW97FA173Accident · Minor injuriesField investigationFinal reportGowan LONG-EZ · Roanoke, TXThe pilot's failure to maintain the proper descent rate. A factor was the gascolator's filter screen becoming contaminated with fiber glass residue due to the pilot/mechanic's inadequate maintenance.NTSB 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.NTSB ANC97LA073Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Togiak, AKfailure of the pilot to properly compensate for crosswind conditions. The crosswind was a related factor.NTSB SEA97LA096Accident · Minor injuriesLimited investigationFinal reportHendrix Talon XP · Redmond, ORincomplete installation (omission of the aft control stick and interlink tube) of the flight control system, resulting in failure of the combined (torque) elevator and aileron rod and a disconnection of the forward flight control stick from the ailerons and…NTSB MIA97LA157Accident · No injuriesLimited investigationFinal reportThacker Starduster TOO SA300 · Lake Wales, FLfailure of the tail wheel to lock in the centered detent during the beginning of the takeoff roll, which resulted in the pilot being unable to maintain directional control and the aircraft drifting off the runway and nosing over in the soft ground.NTSB MIA97FA152Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · New Smyrna Bch, FLan in flight loss of control for undetermined reasons.NTSB LAX97LA174Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Peoria, AZfailure of the student pilot to maintain proper runway alignment and wing tip clearance from high vegetation beside the runway during landing, and the flight instructor's inadequate supervision of the flight. High vegetation on the runway shoulder was a…NTSB IAD97LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Washington, DCtotal loss of power on both engines due to fuel exhaustion as a result of the pilot's improper fuel consumption calculations.NTSB ANC97LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor associated with the accident was: the variable crosswind condition.NTSB ATL97WA068Accident · 6 fatalForeign investigationBeech 58 · St. Vincent, SpainNTSB ATL97LA070Accident · Minor injuriesLimited investigationFinal reportEugene Clements Pulsar · Indianola, MSThe pilot's failure to correctly recover from a bounced landing leading to the collapse of the nose gear. Factors were the pilot's lack of recent flight time and lack of aircraft familiarity.NTSB ATL97LA067Accident · No injuriesLimited investigationFinal reportHughes 269A · Lake Wales, FLloss of engine power for undetermined reason(s); and the flight instructor's improper flare and improper use of the flight controls, while flaring for an autorotative landing.NTSB ATL97LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-180 · Russellville, ALThe loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.NTSB ANC97LA065Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Hope, AKa loss of engine power resulting from fuel starvation due to the pilot's improper positioning of the fuel selector, and the pilot's failure to identify and correct the deficiency during the ensuing emergency descent.NTSB NYC97LA086Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, OHThe flight instructor's inadequate supervision and his failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and striking the precision approach path indicator lights.NTSB NYC97LA083Accident · 1 fatalLimited investigationFinal reportPorter Stolp SA-750 · E. Huntingdon, PAwas the pilot's entry into an uncontrolled stall/spin and his inadequate recovery from the maneuver which resulted in collision with terrain. Factors in the accident were the low entry altitude for the maneuver and the pilot's lack of recent flight experience.NTSB NYC97LA082Accident · No injuriesLimited investigationFinal reportBeech F33A · Mattituck, NYthe pilot's inadequate compensation for the wind conditions and improper flare, which resulted in a hard landing.NTSB MIA97LA154Accident · No injuriesLimited investigationFinal reportGrumman American G-1159 · Miami, FLThe failure of the Landing gear nose gear for undetermined reasons.NTSB LAX97LA171Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAthe pilot's failure to obtain and/or maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. A factor relating to the accident was: the degraded climb performance due to an…NTSB IAD97LA070Accident · No injuriesLimited investigationFinal reportMbb BK-117-A1 · Kane, PAThe pilot's decision to perform a low airspeed vertical descent with a tailwind, which resulted in settling with power.NTSB DCA97WA044Accident · 2 fatalForeign investigationCessna 208 · CambodiaNTSB ANC97LA064Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dillingahm, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the wind gusts and crosswind.NTSB LAX97LA173Accident · 2 fatalLimited investigationFinal reportShoaf Christen Eagle II · Half Moon Bay, CAundetermined.NTSB IAD97LA069Accident · Serious injuriesLimited investigationFinal reportJaquish Challenger Spec II · Mansfield, PAinadequate visual lookout by the pilot, which led to an in-flight collision with an electrical wire. Related factors were: low altitude flight by the pilot, and the proximity of the transmission line.NTSB FTW97LA170Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · El Dorado, ARThe pilot misjudging his altitude above the airport, resulting in not attaining the proper touchdown point. A factor was the separation of teeth from the aft gear of the spur gear assembly, which resulted in the interruption of fuel.NTSB CHI97LA119Accident · No injuriesLimited investigationFinal reportBeech D35 · Lexington, KYflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB CHI97IA122Incident · No injuriesIncident investigationFinal reportBeech 35 · Spokane, WAthe vibration of the fuselage was due to flutter.NTSB ATL97LA069Accident · No injuriesLimited investigationFinal reportBeech 33 · Carrollton, GAThe inadequate maintenance inspection of the airplane that resulted in the disconnection of the propeller governor linkage and the subsequent reduction in engine power. The pilot also failed to maintain flying speed that resulted in an inadvertent stall…NTSB ATL97LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Hazelhurst, GAThe loss of engine power for undetermined reasons. Factors were, conditions were favorable for the formation of carburetor ice, and the pilot lack of qualification for the flight.