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 MIA97LA067Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Salisbury, NCcontinued operation of the aircraft by the flight instructor (CFI) and student after identifying a brake problem, which resulted in a fire that erupted from the brake system and subsequently destroyed the aircraft.NTSB MIA97LA066Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fort Lauderdale, FLFailure of other maintenance personnel to properly torque a connecting rod bolt and nut for the No. 3 cylinder during engine overhaul.NTSB FTW97LA086Accident · Serious injuriesLimited investigationFinal reportMahan Starduster II · Atlanta, TXimproper maintenance by unknown person(s), which resulted in the failure of the throttle cable and a substantial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB NYC97LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thorndale, PAInadequate overhaul of the crankshaft that failed to detect fatigue cracks, which resulted in a total loss of engine power when the crankshaft separated in two.NTSB MIA97WA069Accident · Serious injuriesForeign investigationBoeing 737-400 · Aruba, ArubaNTSB LAX97FA091Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD600N · Flagstaff, AZfailure of the manufacturer to follow its directive to develop corrective measures in response to known accident data, and their failure to ensure that pertinent information (in engineering department) was communicated to the test pilot and flight test…NTSB IAD97LA044Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · University Park, PAthe pilot's inability to control the airplane due to a damaged/bent elevator control lever and resultant lack of elevator authority.NTSB ANC97LA023Accident · No injuriesLimited investigationFinal reportMaule M-5 · Chugiak, AKThe pilot's failure to attain the proper touchdown point during landing. The snow-covered runway was a factor.NTSB MIA97LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Boca Raton, FLImproper overhaul of the left magneto which resulted in a defect in the left magneto rotating magnet to go undetected which caused the magneto to stop rotating and break several teeth from engine crankshaft gears and disconnect the crankshaft drive gear.NTSB IAD97LA042Accident · No injuriesLimited investigationFinal reportCessna 310F · Bridgeport, CTthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane during the landing roll. Related factors were: the pilot's misunderstanding of the wind conditions, and the resultant quartering tail wind.NTSB IAD97FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Alton, NHAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, and incapacitation of the pilot.NTSB FTW97LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Steamboat Spgs, COFailure of the flight instructor and the dual student to maintain an adequate visual lookout. Factors were the flight instructor's inadequate supervision of the flight, inadequate altitude in which to clear obstacles, and the dual student's lack of…NTSB CHI97LA055Accident · No injuriesLimited investigationFinal reportBeech D95A · Olathe, KSthe pilot improperly selecting the 'off' position on the left engine fuel selector valve, his failure to verify the fuel selector valve's proper position prior to landing, and his inability to obtain best rate-of-climb single-engine speed.NTSB ANC97LA022Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Tununak, AKthe pilot's decision to continue VFR flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from rising terrain. Factors associated with the accident were: low ceiling, fog, rising terrain, and the pilot's inadequate…NTSB MIA97LA064Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLInadequate inspection of the fuel caps by company maintenance personnel resulting in a cap with a deteriorated seal being allowed to continue in service. This allowed water to leak into the fuel tank which resulted in loss of engine power due to water…NTSB MIA97FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Okeechobee, FLthe noninstrument-rated pilot's decision to conduct a VFR flight into instrument meteorological flight conditions. The weather was a factor.NTSB CHI97LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Bloomington, INthe pilot failed to maintain control of the aircraft. Factors included the icy runway and the crosswind.NTSB CHI97LA053Accident · No injuriesLimited investigationFinal reportLearjet 24 · Muscatine, IAthe pilot's failure to maintain directional control. A factor was the snow covered runway edge.NTSB LAX97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZfailure of the student pilot to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight. The student's diverted attention was a related factor.NTSB FTW97LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Laporte, TXThe pilot's diminished ability to maintain control of the airplane due to a jammed elevator control as result of inadequate maintenance procedures by the operator's mechanic.NTSB ANC97LA021Accident · No injuriesLimited investigationFinal reportHefty Polar CUB · Anchorage, AKfailure of the pilot to maintain sufficient altitude/clearance from a snow berm during the landing. The snow berm and flat light conditions were related factors.NTSB MIA97LA062Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Sanibel, FLA partial loss of engine power (rough running engine) for undetermined reason.NTSB MIA97LA061Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lincolnton, NCThe student pilot's improper use of flaps and failure to maintain airspeed during a go-around.NTSB FTW97LA082Accident · Minor injuriesLimited investigationFinal reportJohn T. Garrett Baby Great Lakes · El Paso, TXThe pilot's failure to maintain control during takeoff.NTSB LAX97FA089Accident · 2 fatalField investigationFinal reportBeech F33A · Mt San Jacinto, CAcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude or clearance from mountainous terrain. Factors relating to the accident were: the high/mountainous terrain, and the adverse weather…NTSB CHI97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Franklin, MNThe pilot's inadequate inflight planning and his fuel mismanagement, which resulted in fuel exhaustion and the loss of engine power. A contributing factor with this accident was a frost blocked cockpit windshield.NTSB CHI97LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIthe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the snowbank which the airplane contacted.NTSB ANC97LA020Accident · No injuriesLimited investigationFinal reportCessna 140 · Gustavus, AKthe pilot's selection of unsuitable terrain for landing. The soft terrain was a related factor.NTSB ANC97LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Dillingham, AKthe pilot's failure to maintain sufficient altitude or clearance from terrain during a go-around. A factor related to the accident was: the dark, night condition.NTSB SEA97LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Sun River, ORinadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude/clearance above moutainous/wooded terrain. Factors relating to the accident were: darkness, adverse weather conditions, and the proximity…NTSB NYC97LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marlboro, NJthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the pilot's failure to perform a go-around.NTSB NYC97FA043Accident · 2 fatalField investigationFinal reportCessna 150L · Collegeville, PAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.NTSB LAX97LA088Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Kamuela, HIfuel system contamination resulting in a partial loss of power, and the failure of the pilot to maintain adequate rotor rpm to cushion the autorotative landing and prevent main rotor blade contact with the tailboom. Factors were the inadequacy of…NTSB LAX97FA086Accident · 2 fatalField investigationFinal reportEnstrom F28A · Saipan Island, Sarkloss of engine power due to fuel exhaustion, resulting from improper planning/decision; and the pilot's abrupt handling of the flight controls, while maneuvering to avoid swimmers, which resulted in main rotor blade contact with the tail boom. A related…NTSB FTW97LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Baton Rouge, LAfuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB ANC97LA018Accident · No injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKthe pilot's selection of an unsuitable area (terrain) for landing. A factor relating to the accident was: excessive snow cover on the airstrip.NTSB NYC97FA045Accident · Minor injuriesField investigationFinal reportBeech 1900D · Bangor, METhe inadequate flight and winter operations training provided by the operator, and the pilot's improper decision to abort the takeoff while airborne above V1, due to a false stall warning horn. Also casual was the airport operations improper decision to…NTSB LAX97LA087Accident · No injuriesLimited investigationFinal reportBeech C24R · Santa Cruz Is., CAA loss of engine power for undetermined reasons.NTSB SEA97LA047Accident · No injuriesLimited investigationFinal reportBarriger RV-6 · The Dalles, ORThe pilot's failure to maintain clearance from a powerline during an intentional low altitude maneuver.NTSB LAX97LA085Accident · No injuriesLimited investigationFinal reportMooney M20K · Van Nuys, CAthe pilot's failure to maintain directional control of the aircraft during landing rollout.NTSB LAX97LA084Accident · No injuriesLimited investigationFinal reportBeech N35 · Holbrook, AZfatigue failure of the propeller hub, which resulted in separation of the propeller assembly and reduction of aircraft control. Also causal was: the resultant lack of compliance with Airworthiness Directive (AD) 89-26-08, due to ambiguous and unclear wording…NTSB IAD97LA041Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blue Bell, PAthe pilot's inadequate handling of the airplane and failure to maintain adequate airspeed, which resulted in a stall, and collision with the ground.NTSB DCA97MA017Accident · 29 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Monroe, MIThe Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…NTSB ATL97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lebanon, TNThe pilot's improper short, soft field takeof. A factor was the pilot's poor in-flight decision to operate over an overcast until near the airplane's maximum endurance.NTSB FTW97LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale ATR-42-320 · Houston, TXThe pilot's failure to follow the proper taxi route while taxiing back to the terminal. A factor was the glare radiating from the airport's terminal area.NTSB SEA97LA046Accident · Serious injuriesLimited investigationFinal reportCessna TU-206 · Cascade, IDThe pilot's failure to maintain adequate altitude/clearance from the terrain while reversing course in mountainous terrain. Factors include the mountainous terrain and tall trees in the area where he was maneuvering.NTSB SEA97FA044Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Winston, MTPilot incapacitation due to hypoxia. Failure of the pilot to use available oxygen is a factor.NTSB NYC97LA040Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean)an encounter with unforecast clear air turbulence and the flight attendant's failure to use the seat belt.NTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.NTSB FTW97LA079Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Wellington, COThe pilot's failure to maintain control of the aircraft and his improper autorotation technique that induced the roll and subsequent ground collision. A factor was his lack of recurrent training.