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 ANC97LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKthe flight instructor's inadequate preflight by failing to ensure his seat was properly latched, and his resultant failure (or inability) to recover from the student pilot's bounced landing. A factor associated with the accident was: the student pilot's…NTSB NYC97FA080Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Waterford, VAfailure of the pilot to follow the published instrument (IFR) approach procedure, by failing to maintain the minimum altitude for that segment of the approach.NTSB LAX97IA170Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Tucson, AZan undetermined failure in the #1 (left) engine turbine assembly, which resulted in a fracture of the first stage nozzle guide vane (NGV) and subsequent damage to the turbine blades.NTSB FTW97LA168Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Gatesville, TXInadvertent stall. A factor was the pilot's lack of total experience in the make and model of aircraft.NTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.NTSB CHI97IA117Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILinadequate nickel plating was applied to the compressor disk during the rework process at the operator's overhaul facility, which resulted in a brittle fracture in the disk and an uncontained engine failure. A factor was the operator's lack of written…NTSB ATL97LA064Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Atlanta, GAThe failure of the flight crew to alert the cabin crew to the possibility of turbulence, leading to a serious injury when severe turbulence was encountered..NTSB SEA97LA095Accident · No injuriesLimited investigationFinal reportCessna 172N · Pullman, WAThe pilot's failure to maintain clearance from a fuel truck parked near his taxi route. Factors include a dark night and a vehicle parked near the pilot's route of taxi.NTSB SEA97FA094Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Klammath Falls, ORThe pilot's failure to set the throttle of his second failed engine to 'Cracked-1/2-Open' as called for in the Engine Failure/Restart checklist, followed by a high-power engine surge. Factors include the pilot's delay in landing for refueling, the pilot…NTSB MIA97LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Key Largo, FLthe pilot's failure to maintain directional control during a crosswind landing, which resulted in an inadvertent ground swerve and collision with bushes and terrain.NTSB LAX97LA169Accident · No injuriesLimited investigationFinal reportCameron N-77 · Temecula, CAThe pilot's misjudgment of his speed and altitude, which led to a landing overshoot.NTSB FTW97LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Canon City, COThe pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.NTSB DCA97WA043Accident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Jinan, ChinaNTSB CHI97LA118Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAfailure of the student pilot to maintain directional control, inadequate supervision by the flight instructor (CFI), and subsequent failure of the pilot(s) to properly flare the helicopter during a hover autorotation.NTSB CHI97LA115Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Duluth, MNthe loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control.NTSB CHI97LA114Accident · Serious injuriesLimited investigationFinal reportOlsen Acro Sport II · Monon, INThe loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.NTSB SEA97LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYThe pilot's inadequate preflight planning. Factors include high density altitude, downdrafts, and rough/uneven terrain in the area where the pilot attempted the emergency landing.NTSB SEA97LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Ilwaco, WAThe student pilot's failure to land the aircraft at the proper touchdown point. Factors include inadequate preflight planning/preparation by the student pilot, inadequate supervision by the student pilot's flight instructor, rain, fog, strong crosswinds, a…NTSB LAX97LA168Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Hemet, CAthe pilot's decision not to dip check the aircraft fuel tanks after he had noted a disagreement between the cockpit fuel gages and what he had observed visually in the fuel tanks, and his failure to accomplish in-flight endurance calculations based on…NTSB FTW97FA171Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Rye, COThe pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.NTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.NTSB ATL97LA063Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lincolnton, GAThe pilot's inadequate preflight planning of the fuel requirement for this flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ANC97LA069Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Selawik, AKThe pilot's failure to extend the landing gear. A factor associated with the accident was the pilot's diverted attention while in the landing pattern.NTSB LAX97LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172P · San Jose, CAThe student pilot's failure to maintain adequate airspeed to preclude stalling following an improper recovery from a bounced landing. Contributing factors were the pilot's premature and excessive flap retraction and misjudged landing flare.NTSB ATL97LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Clearwater, FLThe pilot's failure to select the fuller tank for takeoff that resulted in fuel starvation to the engine, and the subsequent total loss of engine power.NTSB MIA97LA149Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Huntersville, NCThe pilot's failure to maintain a visual lookout on landing rollout, resulting in an on-ground collision with a known obstacle (ditch) and subsequent nose over.NTSB MIA97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLloss of engine for undetermined reason(s), which resulted in a forced landing and subsequent collision with a fence.NTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.NTSB CHI97LA113Accident · No injuriesLimited investigationFinal reportCessna 185 · Pella, IAthe pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.NTSB MIA97LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Augusta, GAflight by the pilot into known adverse weather conditions, which resulted in a loss of aircraft control during the landing flare, and collision with the terrain. The adverse weather with nearby thunderstorm activity, crosswind, and gusts was a related factor.NTSB FTW97TA165Accident · Minor injuriesFinal reportBell 206-L1 · Trinidad, COThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. A factor was the tailwind condition and the pilot's failure to maintain proper airspeed.NTSB FTW97LA178Accident · Serious injuriesLimited investigationFinal reportRans S-12 · Goldsby, OKthe pilot-in-command's improper judgment in allowing the passenger to control the airplane, and the pilot-in-command's inadequate supervision. Factors relating to the accident were: the passenger's failure to maintain minimum required airspeed, which resulted…NTSB FTW97FA166Accident · 1 fatalField investigationFinal reportSocata TB-20 · Pagosa Springs, COinadvertent flight by the pilot into known adverse weather conditions, and his failure to maintain altitude or clearance from terrain. Factors relating to the accident were: low ceiling, rain, snow, icing conditions, and mountainous terrain.NTSB ANC97LA075Accident · No injuriesLimited investigationFinal reportCessna 207A · Minto, AKThe pilot's inadequate preflight inspection of the airplane, which resulted in an unlatched door opening in-flight.NTSB NYC97LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lehighton, PAreplacement of the flap actuating system fuse by the pilot-in-command with the flap actuating handle in the fully retracted position. This resulted in the retraction of the flaps, an inadvertent stall/mush, and the subsequent in-flight collision with terrain.NTSB CHI97LA110Accident · Serious injuriesLimited investigationFinal reportGulfstream 500B · Mission, KSthe pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB ANC97LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Ninilchik, AKfailure of the pilot to maintain altitude/clearance from a closed runway, while making a low pass, which resulted in an inadvertent touchdown.NTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.NTSB FTW97LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Mckinney, TXthe student pilot's failure to maintain directional control on the ground after recovery from a bounced landing.NTSB CHI97LA109Accident · No injuriesLimited investigationFinal reportCessna 421C · Pierre, SDthe pilot's inadvertent activation of the number one throttle/power control. Factors were: the pilot left the cockpit unattended with the engines running and a wet ramp.NTSB CHI97FAMS2Accident · 2 fatalMissing aircraftFinal reportBeech 95-C55 · Grand Haven, MIundetermined.NTSB ATL97IA061Incident · No injuriesIncident investigationFinal reportBritish Aerospace 125-800A · Chamblee, GAphysical impairmant of the captain during flight, which was the resulted of a kidney stone.NTSB ANC97LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Soldotna, AKthe pilot's inadequate compensation for cross conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the variable/gusty/crosswind condition.NTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.NTSB IAD97LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wellsville, NYthe student pilot's improper flare, improper recovery from a bounced landing, and loss of directional control, during the landing.NTSB IAD97FA065Accident · 2 fatalField investigationFinal reportLockheed PV2 · Blandburg, PAPilot in command misjudged his maneuvering altitude. Factors to this accident were the mountainous terrain, windy conditions, turbulence in the area, and smoke.NTSB FTW97IA161Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe first officer's failure to maintain clearance while taxiing around a standing airplane.NTSB CHI97LA108Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Sioux Falls, SDthe ground crewmember failed to maintain visual contact with the balloon, while it was landing. A factor relating to the accident was: the ground crewmember allowed her attention to be diverted while keeping a child out of harms way.NTSB SEA97LA091Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · West Jordan, UTlanding gear collapsed for undetermined reasons.