NTSB investigations, 1997
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 IAD97LA110Accident · No injuriesLimited investigationFinal reportCessna 170B · Jamestown, NYThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB CHI97LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Elwood, NEthe pilot not maintaining clearance from the bushes. Factors contributing to this accident were the pilot's inadequate preparation prior to the takeoff attempt, his changing flap positions during the takeoff run which degraded the airplane's performance…NTSB ANC97LA123Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area. A factor related to the accident was the rocky terrain.NTSB ANC97LA122Accident · No injuriesLimited investigationFinal reportStinson 108 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. A factor was the crosswind.NTSB SEA97LA187Accident · No injuriesLimited investigationFinal reportCessna 140 · Hillsboro, ORThe pilot's failure to maintain directional control during landing.NTSB LAX97LA287Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Marana, AZThe pilot's in-flight planning/decision to continue his flight after striking a fence, and his inability to attain the proper climb rate, which subsequently led to the in-flight collision with the transmission power line.NTSB MIA97LA229Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Pink Hill, NCFailure of the dual student to maintain airspeed resulting in an inadvertent stall and uncontrolled descent until ground impact. Contributing to the accident was improper supervision of the dual student by the pilot-in-command flight instructor.NTSB LAX97LA285Accident · No injuriesLimited investigationFinal reportBell 47G2 · Mojave, CAThe student's improper use of the throttle and collective controls and the flight instructor's inadequate supervision of the flight.NTSB LAX97LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · San Manuel, AZThe student pilot's improper recovery from a bounced landing, and failure to maintain directional control of the aircraft. A factor related to the accident was the pilot's fatigue from improper rest the evening before the flight.NTSB IAD97LA109Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Louisville, KYInadequate compensation for wind conditions by the pilot.NTSB FTW97LA311Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Patterson, LAThe pilot's failure to maintain terrain clearance.NTSB FTW97IA305Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lafayette, LAThe failure of the AC generator due to the failure of the anti-drive end bearing.NTSB CHI97FA256Accident · 4 fatalField investigationFinal reportBeech BE-65-A90 · Alice, TXloss of control due to the pilot's improper in-flight decision. A factor was the improper installation of the secondary low pitch stop system by the mechanic.NTSB ANC97FA121Accident · 3 fatalField investigationFinal reportCessna U206G · Halibut Cove, AKThe pilot's improper evaluation of the weather conditions which led the pilot to maneuver within the confines of the lake to avoid surrounding terrain and a subsequent inadvertent stall. Factors were the terrain-induced turbulence and gusts.NTSB LAX97LA283Accident · Serious injuriesLimited investigationFinal reportCessna 195 · Santa Ana, CAWater contamination in the fuel system due to the failure of the mechanic who performed the last annual inspection to adequately comply with the AD which required inspection of the fuel tank filler area for proper sealing, and the pilot's inadequate preflight…NTSB FTW97FA304Accident · 1 fatalField investigationFinal reportGrumman G-164 · Wilmot, ARThe loss of engine power due to a fractured throttle cable because the cable housing prevents an inspection of the cable by maintenance personnel. Factors were the pilot's impairment due to a heart attack, the lack of suitable terrain for the forced landing,…NTSB CHI97LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft L2A · Shelbyville, INthe inadequate preflight by the pilot and the loose fuel line fitting.NTSB CHI97LA254Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Britton, SDthe pilot's failure to maintain clearance with the terrain during the spray run and his failure to maintain adequate airspeed during the turn after having contacted the terrain. A factor was the pilot's diverted attention.NTSB ATL97LA122Accident · Minor injuriesLimited investigationFinal reportZenair 701 · Spruce Creek, FLThe failure of the engine for undetermined reasons, while maneuvering close to the ground. Factors included the soft terrain and the conditions favorable for carburetor icing.NTSB ATL97LA121Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Holcomb, MSThe failure of the pilot to adequately see and avoid all obstructions while doing aerial application work.NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB ATL97FA118Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Palm Bch Garden, FLloss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.NTSB ATL97FA115Accident · 2 fatalField investigationFinal reportMooney M20F · Tallahassee, FLfatigue failure of the crankshaft for undetermined reasons. Related factors were: darkness, and obstructions (trees) in the emergency landing area.NTSB ANC97LA119Accident · No injuriesLimited investigationFinal reportTaylorcraft TC-19 · Anchorage, AKThe pilot's excessive descent rate during a touch-and-go landing, which resulted in damage to the landing gear and inability to control the airplane during a subsequent landing. A factor was his lack of total experience in tailwheel-equipped airplanes.NTSB SEA97LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Bountiful, UTThe pilot's inadequate fuel management which resulted in fuel starvation.NTSB NYC97LA162Accident · Minor injuriesLimited investigationFinal reportSimpson Avid Flyer · Westerly, RIThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB LAX97LA281Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Borrego, CAThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain runway alignment during the takeoff roll.NTSB LAX97LA280Accident · Serious injuriesLimited investigationFinal reportNorth American Navion B · Las Vegas, NVThe separation of the number 3 cylinder due to improper overhaul procedures, and the failure to adequately torque the cylinder hold down nuts and through bolts to specification.NTSB IAD97LA107Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Slatington, PAThe pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.NTSB FTW97LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Arriba, COfailure of the pilot to properly plan the flight and determine the field conditions before landing. The soft runway condition was a related factor.NTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA305Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Columbia, MOthe pilot's improper planning/decision. The unfavorable wind was a related factor.NTSB CHI97FAMS3Accident · 1 fatalMissing aircraftFinal reportGrumman American AA-5 · Lower Brule, SDundetermined due to the accident airplane not being available for examination.NTSB ATL97LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunlap, TNa loss of engine power for undetermined reasons.NTSB ATL97LA114Accident · No injuriesLimited investigationFinal reportHughes 269A · Dandridge, TNthe pilot's failure to properly plan the approach for landing, which led to a loss of tail rotor authority and directional control, while close to the ground. The tailwind was a related factor.NTSB SEA97LA185Accident · No injuriesLimited investigationFinal reportCessna 172L · Townsend, MTThe pilot's failure to maintain airspeed.NTSB NYC97LA163Accident · 1 fatalLimited investigationFinal reportElliot Monnett Moni · Hollis, NHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall spin and collision with terrain.NTSB LAX97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAa loss of engine power for undetermined reasons.NTSB LAX97LA278Accident · No injuriesLimited investigationFinal reportCessna 150G · Palos Verdes, CALoss of engine power due to fuel starvation and the pilot's mismanagement of the aircraft's fuel supply.NTSB LAX97LA277Accident · No injuriesLimited investigationFinal reportCessna 310 · Mesa, AZinadequate maintenance inspection of the landing gear system, following a prior incident, due to the mechanic's failure to follow the service manual instructions.NTSB IAD97LA108Accident · 1 fatalLimited investigationFinal reportRiekkenen Ryelong LE · Wurtsboro, NYThe pilot performed an aerobatic maneuver and misjudged the altitude.NTSB FTW97LA307Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Eagle, COwater contamination of the fuel, which led to a total loss of engine power and a forced landing. Factors relating to the accident were: the delay in refueling the aircraft by the FBO, which allowed condensation to form in the fuel tanks, and inadequate…NTSB FTW97LA306Accident · No injuriesLimited investigationFinal reportCessna 305A (L-19) · Aspen, COFailure of the pilot to maintain direction control of the aircraft during landing roll, which resulted in a ground swerve and subsequent collapse of the right main landing gear. A related factor was the pilot's lack of experience in the make and model of…NTSB ANC97LA120Accident · No injuriesLimited investigationFinal reportCessna 185 · Chickaloon, AKinadequate maintenance inspection and failure of the left main landing gear attachment due to fatigue. A factor was continuous use of the airplane for rough area, off-airport landings.NTSB ANC97LA118Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle, AKThe inadequate visual lookout by the pilot, and his selection of a landing area with high vegetation in the landing path. Factors which contributed to the accident were fatigue and the high vegatation.NTSB SEA97LA183Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, IDThe pilot's failure to attain rotation speed. The pilot's failure to maintain aircraft control and rough runway conditions were factors.NTSB LAX97LA282Accident · No injuriesLimited investigationFinal reportMooney M20K · Lakeport, CAthe pilot's inadequate preflight by failing to ensure that the fuel selector was positioned to a tank containing fuel, which resulted in fuel starvation, and a forced landing shortly after takeoff.NTSB LAX97LA275Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5 · Monterey, CAthe pilot's failure to maintain adequate clearance from surrounding terrain.NTSB LAX97FA276Accident · Serious injuriesField investigationFinal reportLockheed L-1011-385-1-15 · Honolulu, HIthe cumulative distance taxied immediately prior to takeoff that precipitated an excessive heat buildup in the tires and resulted in the bead separation of a single tire during the takeoff roll. The absence of cockpit procedures/directives or monitoring…NTSB FTW97FA302Accident · 1 fatalField investigationFinal reportBeech G35 · Alpine, TXThe pilot's performance of aerobatics at low altitude and his failure to maintain aircraft control.