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 MIA97IA151Incident · No injuriesIncident investigationFinal reportBeech 100 · Kenly, NCInadequate inspection procedures by the airframe manufacturer for failure to require removal of the metal retaining ring to inspect the entire area of the window for cracks.NTSB LAX97LA147Accident · No injuriesLimited investigationFinal reportCessna 182D · Tucson, AZFuel exhaustion due to the inadequate preflight inspections performed by both pilots. A factor in the accident was the crosswind experienced during landing rollout.NTSB LAX97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Furnace Creek, CAFuel starvation resulting from disconnection of the fuel selector valve. Factors which contributed to the accident were the pilot's intentional operation with known airplane deficiencies and the rough terrain.NTSB LAX97LA145Accident · No injuriesLimited investigationFinal reportBeech B-60 · Big Bear City, CAThe pilot's decision to land with a tail wind condition, and a failure to attain the proper touchdown point which resulted in an overrun.NTSB FTW97LA155Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Silver City, NMThe high wind and the pilot's inadequate compensation for the crosswind conditions. Factors were the crosswind and wind gusts.NTSB ANC97LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kotzebue, AKthe pilot's selection of unsuitable terrain for taxi and takeoff. Soft/snow covered terrain was a related factor.NTSB NYC97LA068Accident · No injuriesLimited investigationFinal reportCessna 650 · Buffalo, NYA combination hydraulic fluid and fuel-fed fire which originated from electrical arcing, due to the lack of an adequate production standard from Cessna for the separation of flammable fluid lines and electrical lines. A factor was the lack of oversight from…NTSB MIA97LA117Accident · No injuriesLimited investigationFinal reportNorth American T6G · Wilmington, NCThe pilot's failure to maintain directional control on landing. Factors were: the crosswind and the pilot's lack of experience in type airplane.NTSB MIA97LA113Accident · No injuriesLimited investigationFinal reportChance Vought F4U · New Smyrna Bch, FLThe pilot's failure to assure that an adequate supply of fuel was on board for the intended flight.NTSB LAX97LA141Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Avalon, CAThe pilot's misjudging the airplane's altitude and distance to the runway and an excessive descent rate, which led to an undershoot, and the pilot's failure to maintain an adequate airspeed during the approach. Contributing factors were the pilot's delay in…NTSB FTW97LA150Accident · No injuriesLimited investigationFinal reportBell BH-47G2 · Laredo, TXThe pilot's failure to maintain alignment while landing on a stationary trailer. A factor was the pilot's lack of experience in trailer landing operations.NTSB CHI97LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Oshkosh, WIthe pilot's inadequate compensation for the wind conditions, and his failure to maintain proper runway alignment, which resulted in a subsequent nose over. The gusty crosswind condition was a related factor.NTSB ATL97FA057Accident · 2 fatalField investigationFinal reportDouglas C54A-DC · Griffin, GAThe flightcrew's inadequate procedures, during a rejected takeoff following a possible engine malfunction at a critical time in the takeoff, and the second pilot's physical impairment.NTSB SEA97LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Manzanita, ORThe pilot's failure to adequately compensate for wind conditions, and his failure to maintain directional control of the airplane during the go-around attempt. Factors contributing to the accident are gusty crosswinds.NTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.NTSB MIA97LA114Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Petersburg, FLthe student pilot's improper level off.NTSB LAX97FA143Accident · 2 fatalField investigationFinal reportCessna T210N · Grand Canyon, AZThe pilot's failure to maintain aircraft control due to spatial disorientation and his lack of proficiency in conducting instrument flight. Contributing were the inoperative alternator, cockpit lighting, and vacuum system.NTSB FTW97LA149Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Bartlesville, OKthe pilot's selection of an empty fuel tank, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's lack of familiarity with the aircraft.NTSB CHI97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INa fatigue failure of the fight main landing gear strut/spar attachment screws.NTSB ANC97LA047Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Teller, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control during the landing. Factors related to the accident were: a crosswind, a downdraft, the pilot's delayed go-around, improper raising of the flaps, and…NTSB IAD97LA061Accident · Minor injuriesLimited investigationFinal reportTheis Quickie · Fostoria, OHa disconnect of electrical wires to the engine ignition, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: the lack of suitable terrain for a forced landing, and the wheat (crop) that was encountered during…NTSB IAD97LA057Accident · Minor injuriesLimited investigationFinal reportFokker F-27 · Atlantic City, NJFailure of the driver of the van to set the parking brake before exiting the van.NTSB IAD97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsburgh, PAthe student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB CHI97LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Des Moines, IAoil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.NTSB ATL97LA056Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waynesboro, GAThe failure of the right wing after the pilot exceeded the design stress limit of the airplane, leading to a loss of control in flight.NTSB MIA97WA111Accident · No injuriesForeign investigationPiper PA-23-250 · Virgin Gorda, British Virgin IslandsNTSB LAX97LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Mokuleia, HIAn unintentional stall for undetermined reasons.NTSB IAD97FA060Accident · 1 fatalField investigationFinal reportCessna 337D · Hickory, PAServicing of the pilots portable oxygen system with compressed air, which resulted in pilot incapacitation due to Hypoxia.NTSB ATL97LA053Accident · Minor injuriesLimited investigationFinal reportCatchot Hauler · Centerville, ALthe engine manufacturer's failure to install ballast resistors in the ignition system, which resulted in an electrical short in the dual ignition system and subsequent loss of engine power.NTSB ANC97TA045Accident · No injuriesFinal reportPiper PA-18 · Noatak, AKfailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground loop and damage to the airplane. Factors associated with the accident were: the ice/snow covered runway, and the pilot's lack of experience in the…NTSB ANC97LA044Accident · No injuriesLimited investigationFinal reportCessna 175 · Naknek, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's inadequate preflight preparation and planning by failing to obtain information about the out of service runway lighting, and the rough…NTSB MIA97WA110Accident · No injuriesForeign investigationCessna 310R · Deep Water Cay, BahamasNTSB MIA97LA112Accident · Serious injuriesLimited investigationFinal reportCharles J. Keuthan Zephyr II · Bunnell, FLInadvertent stall/mush by the pilot while maneuvering for a forced landing. Contributing to the accident was the partial loss of engine power due to a partial failure of the top compression ring of one of the cylinders.NTSB MIA97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · St Matthews, SCthe pilot's improper decision to take off downwind with gusty wind conditions.NTSB LAX97LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Continental, AZloss of engine power as a result of detonation in the number 2 cylinder for undetermined reasons. A factor in the accident was the unsuitable nature of the forced landing area.NTSB LAX97FA142Accident · 2 fatalField investigationFinal reportCessna P210N · Corona, CAThe pilot's failure to maintain adequate terrain clearance during a nighttime flight at low altitude through a mountainous area. Factors in the accident were the conditions of low clouds and dark light conditions.NTSB IAD97LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during takeoff, which resulted in a collision with tree(s) and a ditch.NTSB ANC97LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Manley Hot Sprn, AKThe pilot's selection of an unsuitable landing area. A factor was the soft snow.NTSB SEA97LA102Accident · No injuriesLimited investigationFinal reportBoeing E75 · Spokane, WAThe pilot-in-command's inadequate application of crosswind controls during landing rollout. Factors were gusty crosswinds.NTSB SEA97LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAthe pilots' inadequate evaluation of the strong winds, when they attempted to turn to taxi with a very strong tailwind. Factors relating to the accident included the high and unfavorable winds.NTSB SEA97LA079Accident · 1 fatalLimited investigationFinal reportRose VP-1 · Gardiner, WAThe pilot-in-command's failure to maintain control of the aircraft. Factors contributing to the accident were gusty and high winds.NTSB NYC97LA066Accident · 2 fatalLimited investigationFinal reportLowe Super Koala · Perry Township, PAimproper construction by the builder which led to the failure of the strut and wing assembly.NTSB MIA97LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Atlantic Ocean (Atlantic Ocean)loss of engine power for undetermined reason(s). A factor relating to the accident was: the pilot's poor in-flight planning/decision by flying at too low of an altitude to glide to shore for a forced landing.NTSB MIA97LA106Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Cumming, GAa loss of engine power for an undermined reason, which resulted in a forced landing and subsequent impact with the ground.NTSB MIA97LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sarasota, FLa loss of engine power for undetermined reasons.NTSB LAX97LA136Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Camarillo, CAThe pilot's failure to adequately compensate for crosswind conditions during landing.NTSB FTW97LA147Accident · No injuriesLimited investigationFinal reportBeech M35 · Iowa Park, TXThe pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.NTSB DCA97WA035Accident · 1 fatalForeign investigationBell B212 · Nuevo Leon, MexicoNTSB ANC97LA070Accident · No injuriesLimited investigationFinal reportPiper J-3 · Soldotna, AKThe pilot's inadequate compensation for the gusty wind conditions, and his improper recovery from a bounced landing. A factor associated with the accident was the gusty wind.NTSB LAX97LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Little River, CAThe pilot's failure to properly judge the flare altitude.