NTSB investigations, 1997
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 LAX98LA056Accident · Serious injuriesLimited investigationFinal reportJohnson Bushrod · Corona, CAAn in-flight loss of control resulting from a malfunction in the wing flap operating system. The malfunction produced asymmetrical drag and induced a roll which could not be overcome by the pilot's flight control inputs.NTSB CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.NTSB CHI98LA057Accident · No injuriesLimited investigationFinal reportCessna 402A · Milwaukee, WIInadequate preflight planning/preparation, which resulted in fuel exhaustion.NTSB ATL98LA021Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Bushnell, FLThe pilot's failure to maintain clearance from the trees during a hover. A factor was the pilot's diverted attention.NTSB NYC98LA040Accident · No injuriesLimited investigationFinal reportCessna 172P · Mitchellville, MDThe pilot's improper recovery from a bounced landing.NTSB CHI98LA059Accident · 2 fatalLimited investigationFinal reportBellanca 17-30 · Independence, KSthe pilot's intentional flight into adverse weather. Contributing factors were low ceilings, fog, and the guy wire.NTSB LAX98FA052Accident · 2 fatalField investigationFinal reportCessna 172N · Lytle Creek, CAthe non-instrument rated pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the adverse weather conditions (low ceiling…NTSB FTW98FA063Accident · 3 fatalField investigationFinal reportPitts S-2B · Bozeman, MTThe failure of both pilots to maintain visual lookout. Factors were the pilot of N693SB not following procedures and directives, and the pilot of N693SB using poor judgment.NTSB CHI98LA058Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-50 · Memphis, TNthe flight attendant lost his balance during pushback and struck his head on a galley door.NTSB SEA98LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · John Day, ORa loss of engine power for undetermined reasons.NTSB MIA98WA042Accident · Minor injuriesForeign investigationSocata TB-20 · Little Cayman, Cayman IslandsNTSB LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.NTSB FTW98LA065Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Worland, WYloss of engine power for undetermined reason(s). A related factor was the rough and uneven terrain on which the forced landing was made.NTSB FTW98LA064Accident · 1 fatalLimited investigationFinal reportAdams A55S · Gallup, NMfailure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.NTSB CHI98LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cairo, MOa fractured muffler, failure of the owner/pilot to ensured that the annual maintenance inspection had been completed before flight, and subsequent pilot incapacitation due to carbon monoxide poisoning.NTSB ATL98LA020Accident · No injuriesLimited investigationFinal reportCessna 172B · Henderson, NCThe loss of engine power for undetermined reasons.NTSB ATL98LA019Accident · 2 fatalLimited investigationFinal reportSiggi's Airplane Works D-4 Fascination · Leesburg, FLstructural failure of the right wing, during the initial climb after takeoff, which resulted in an uncontrolled descent to the ground.NTSB ATL98LA018Accident · 1 fatalLimited investigationFinal reportJohn T. Simpson Challenger II · Rainbow City, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with the ground. A related factor was the pilot's lack of flying experience.NTSB SEA98LA020Accident · Minor injuriesLimited investigationFinal reportSchramm Helicycle · Big Timber, MTthe pilot's failure to maintain clearance from power lines. The pilot's diverted attention and transmission wires were factors.NTSB MIA98WA056Incident · No injuriesForeign investigationBoeing 707-320 · Montevideo, UruguayNTSB CHI98LA054Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lee'S Summit, MOthe pilot's inadequate remedial action concerning the loss of engine power, after inadvertently switching off the magnetos. Factors relating to the accident were: the broken springs for magneto cover guard; excessive drag from the extended landing gear and…NTSB ANC98TA011Accident · No injuriesFinal reportBell 206B · Anchorage, AKThe pilot's failure to maintain adequate rotor RPM during an autorotation landing.NTSB SEA98LA019Accident · Serious injuriesLimited investigationFinal reportBlue Denney Kitfox Model 3 · Caldwell, IDThe pilot's failure to maintain adequate airspeed.NTSB MIA98WA041Accident · Minor injuriesForeign investigationPiper PA-31-350 · Walker Cay, BahamasNTSB MIA98FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech G35 · Missingundetermined.NTSB LAX98FA050Accident · 2 fatalField investigationFinal reportMooney M20J · Sedona, AZthe failure of the pilot to maintain adequate terrain clearance during the climb. Contributing factors were dark night conditions, mountainous/hilly terrain, and mountain wave weather conditions.NTSB NYC98LA037Accident · Serious injuriesLimited investigationFinal reportCessna A152 · Moriches, NYA loss of engine power for undetermined reasons.NTSB MIA98FA039Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Lansing, NCthe pilot's failure to maintain clearance from a wire.NTSB LAX98LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Grass Valley, CAthe pilot's inadvertent activation of the aircraft brakes during the landing rollout.NTSB LAX98LA049Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Union City, CABlockage of the fuel flow transducer, which resulted in fuel starvation and the loss of engine power. Unsuitable terrain for an emergency landing was a contributing factor.NTSB DCA98WA017Incident · No injuriesForeign investigationMcDonnell Douglas MD83-2 · Paris, FranceNTSB CHI98LA052Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Vicksburg, MIthe pilot's inadequate preflight preparation and his failure to maintain directional control during takeoff. A factor was the uneven runway at the grass airstrip.NTSB SEA98LA018Accident · 3 fatalLimited investigationFinal reportAero Commander 112 · Kettle Falls, WAThe pilot's failure to maintain terrain clearance while maneuvering. Factors include the physiological impairment of the pilot's judgement due to alcohol.NTSB MIA98LA037Accident · Minor injuriesLimited investigationFinal reportCessna FR-172J · Marietta, GAA catastrophic failure of the oil cooler core which led to overboard porting of lubricating oil and subsequent engine failure.NTSB MIA98FA038Accident · 1 fatalField investigationFinal reportCessna C-182E · Townsend, TNthe pilot's failure to maintain VFR flight conditions in a mountainous area resulting in inflight collision with rising terrain.NTSB FTW98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Lubbock, TXThe inadequate maintenance of the landing gear assembly by maintenance personnel resulting in a partial gear extension, and the pilot's misjudgment of a proper touchdown point to intentionally shut down the engine resulting in the airplane landing short of…NTSB NYC98LA036Accident · No injuriesLimited investigationFinal reportCessna 310R · Hartford, CTThe pilot's improper in-flight decision to land on the departure end of the runway and not perform a go-around.NTSB MIA98FA040Accident · 3 fatalField investigationFinal reportCommander 114B · Cross City, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the terrain (tree,…NTSB CHI98LA050Accident · No injuriesLimited investigationFinal reportCessna 402B · Spencer, IAThe pilot failure to comply with the prescribed IFR procedure and his not following his company's operations specifications. Low clouds and fog were are contributing factors.NTSB NYC98FA035Accident · 2 fatalField investigationFinal reportCessna 310R · St Mary'S, PAwas the pilot's descent below the minimum descent altitude and his failure to comply with published procedures.NTSB MIA98LA036Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hazel Green, ALthe pilot's miscalculating the aircraft's fuel consumption for the flight, resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB LAX98LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAthe student pilot's failure to maintain an appropriate airspeed and proper rate of descent, and his misjudged landing flare, which led to an uncontrolled porpoise and eventual collapse of the landing gear.NTSB NYC98FA034Accident · 2 fatalField investigationFinal reportBeech BE-S35 · Chatham, MAThe pilot's failure to maintain adequate airspeed during initial climb which resulted in an inadvertent stall and subsequent impact into trees. Related factors were high wind and turbulence.NTSB LAX98FA048Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Carson City, NVThe failure of the pilot to maintain airspeed after being distracted by the nose baggage door opening in-flight resulting in a stall/spin. Factors contributing to the accident were the pilot's inadequate preflight inspection and lack of experience in the type…NTSB IAD98LA014Accident · Minor injuriesLimited investigationFinal reportJones Mini 500 · Bluefield, WVPilot's unfamiliarity with reciprocating engine powered helicopter lead to a reduction in main rotor rpm and subsequent uncontrolled rate of descent with insufficient altitude to recover.NTSB IAD98LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Center Village, OHThe student pilot's improper recovery from a bounced landing.NTSB FTW98LA059Accident · No injuriesLimited investigationFinal reportMooney M20F · Stuttgart, ARthe pilot's failure to activate the runway lights, which led to his selection of a closed/abandoned runway for the landing. Factors relating to the accident were: the unlatched cabin door, and the lack of lighting conditions at dusk.NTSB NYC98LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Johnstown, PAthe pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.NTSB LAX98LA047Accident · No injuriesLimited investigationFinal reportCessna 182F · Palmdale, CALoss of engine power due to icing conditions which plugged the fuel system vent.NTSB LAX98LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Saipan, MaliThe loss of engine power for undetermined reasons that resulted in the pilot ditching the aircraft into the ocean.