NTSB investigations, 1995
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\") = 1995 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") = 1995 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 CHI96LA057Accident · No injuriesLimited investigationFinal reportBeech 58 · Minneapolis, MNthe pilot-in-command's abrupt maneuvering during the circling approach. The factors involved were the airframe ice and fog.NTSB FTW96FA073Accident · 6 fatalField investigationFinal reportCessna 421C · Cleveland, OKthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…NTSB DCA96RA020Accident · 160 fatalForeign investigationBoeing B757 · Buga, ColombiaNTSB CHI96LA060Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe failure of the turbocharger, caused by a unapproved rebuild of the turbocharger which contained automotive parts. Debris from the failed turbocharger damaged the oil pump resulting in lack of engine lubrication.NTSB BFO96FA032Accident · 3 fatalField investigationFinal reportCessna 310R · Bellville, OHthe pilot's in-flight loss of aircraft control for undetermined reason(s), which resulted in the airplane exceeding its design stress limitations and an in-flight breakup.NTSB LAX96FA076Accident · 1 fatalField investigationFinal reportHughes 369D · Feather Falls, CAthe pilot's failure to jettison his external load after it came in contact with trees and terrain. The pilot's failure to maintain altitude/clearance above trees and hilly terrain was a related factor.NTSB DCA96MA029Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 747-136 · Jamaica, NYthe captain's failure to reject the takeoff in a timely manner when excessive nosewheel steering tiller inputs resulted in a loss of directional control on a slippery runway. Inadequate Boeing 747 slippery runway operating procedures developed by Tower Air,…NTSB BFO96LA031Accident · Minor injuriesLimited investigationFinal reportBellanca BL14-19-3 · Toledo, OHan improper splice of the magneto 'P' lead wires, and the pilot's improper positioning of the throttle and mixture controls while he rotated the propeller by hand.NTSB ATL96LA025Accident · 1 fatalLimited investigationFinal reportMoravan Zlin Z50 LA · Springfield, TNthe pilot's failure to maintain control of the aircraft.NTSB MIA96FA048Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Memphis, TNthe pilot's continued flight into known forecast icing conditions which resulted in the aircraft developing an ice buildup, and the pilot's failure to maintain control of the aircraft. The icing conditions was a factor.NTSB LAX96FA075Accident · Serious injuriesField investigationFinal reportGreat Lakes 2T-1A-2 · Fillmore, CAfailure of the pilot to take proper remedial action to recover from an intentional spin.NTSB CHI96IA059Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Saint Louis, MOloss of induction air into the engine inlets resulting in simultaneous loss of power on both engines. Factors relating to this incident were: disconnection of the airplane's hydraulic pumps and generators, slush on the runway and the hydroplaning condition.NTSB ATL96LA024Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Monroe, NCThe pilot's inadequate planning and failure to follow operating procedures resulted in his descent below the decision height while on final approach.NTSB MIA96FA047Accident · 3 fatalField investigationFinal reportCessna 205 · Culebra, PRFailure of the pilot to maintain sufficient altitude/clearance above the terrain, while maneuvering at night. Factors relating to the accident were: darkness with no visible horizon, and the pilot's lack of recent experience in night flight.NTSB FTW96LA074Accident · No injuriesLimited investigationFinal reportBeech 200 · Ingleside, TXThe pilot's improper decision, while evading law enforcement personnel during an illegal/unauthorized operation.NTSB ATL96LA023Accident · No injuriesLimited investigationFinal reportHiller 12C · N. Myrtle Beach, SCThe pilot's improper operation of the flight controls during a practice autorotation, and the certified flight instructor's inadequate supervision of the operationNTSB ANC96LA020Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Nome, AKThe pilot exceeding the weight and balance limitations of the airplane and improperly utilizing the airplane's elevator trim by selecting full nose up trim.NTSB SEA96LA032Accident · No injuriesLimited investigationFinal reportCessna 172K · Owyhee, ORthe pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.NTSB SEA96FA031Accident · 1 fatalField investigationFinal reportCessna T210M · Netarts, ORa loss of control for undetermined reasons.NTSB MIA96LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryceville, FLThe pilot's improper planning/decision. Factors relating to the accident were: the pilot's inaccurate evaluation of the weather conditions, the pilot becoming lost/disoriented, and the lack of braking action on wet grass during the precautionary landing.NTSB MIA96LA043Accident · 2 fatalLimited investigationFinal reportPro Star PRO Tech · Sebring, FLthe pilot-in-command(CFI) allowed the airplane's design limits to be exceeded which resulted in the overload failure and separation of the right wing.NTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.NTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.NTSB SEA96LA030Accident · No injuriesLimited investigationFinal reportCessna 170B · John Day, ORThe pilot's failure to maintain a proper glidepath.NTSB NYC96LA041Accident · No injuriesLimited investigationFinal reportCessna U206G · Bangor, MEthe pilot's improper inflight planning/decision, and his failure to properly plan his approach for landing, so that the airplane would not stall or touchdown hard. Factors relating to the accident were: the adverse weather (icing) condition, the accumulation…NTSB MIA96LA045Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLThe pilot's failure to properly plan the flight.NTSB MIA96LA042Accident · 2 fatalLimited investigationFinal reportOtis King COBRA-B · Newberry, FLan in-flight loss of control for undetermined reasons.NTSB FTW96FA072Accident · 2 fatalField investigationFinal reportBeech 35 · Kremmling, COa loss of engine power due to fuel starvation as a result of the student pilot's improper positioning of the fuel selector and the the CFI's inadequate fuel management. Factors in the accident were: the unmarked fuel selector and the CFI's excessive descent…NTSB FTW96FA071Accident · 2 fatalField investigationFinal reportCessna 150M · S Padre Island, TXVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the surface of the water. Factors relating to the accident were: the adverse weather conditions (low ceiling and…NTSB CHI96LA058Accident · No injuriesLimited investigationFinal reportCessna 150B · Grant, MIthe pilot's selection of unsuitable terrain and the weak ice-covered runway.NTSB CHI96LA055Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Mason, MIthe improper application of the throttle by the pilot resulting in a delayed engine response, and the improper decision by the pilot to make a long fast touchdown requiring the need to take off under powerlines.NTSB CHI96LA054Accident · Minor injuriesLimited investigationFinal reportBitonti Wittman WT-8 · Plymouth, MIa stuck exhaust valve resulting in an overtemperature condition of the cylinder, the pilot's continued operation without corrective maintenance, and his failure to maintain aircraft control.NTSB ANC96LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Newtok, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident are the snow covered runway, and gusty crosswinds.NTSB CHI96LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226AT · Detroit, MIthe pilot's failure to extend the landing gear. A factor in the accident was the pilot's diverted attention.NTSB SEA96FA029Accident · 1 fatalField investigationFinal reportCessna 340A · Mead, WAthe pilot's failure to maintain terrain clearance in mountainous terrain. Factors contributing to the accident were: dark night conditions, mountainous terrain, and instrument meteorological conditions.NTSB MIA96WA046Accident · 2 fatalForeign investigationAero Commander 1121 · Guatemala City, GuatemalaNTSB MIA96LA040Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.NTSB LAX96LA072Accident · No injuriesLimited investigationFinal reportCessna P210N · Grass Valley, CAthe failure of the pilot to follow the before starting engine checklist and ensure that the landing gear selector was in the down position, and the pilot's decision to takeoff with a known aircraft deficiency.NTSB CHI96LA051Accident · No injuriesLimited investigationFinal reportCessna 182 · Tamms, ILfuel exhaustion due to inadequate maintenance performed on the fuel cap by the maintenance personnel, fuel siphoning out of the left fuel cap, and the failure of the pilot to properly monitor his fuel consumption.NTSB ATL96FA022Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Greenwood, SCthe loss of engine power for undetermined reason.NTSB ATL96FA021Accident · 2 fatalField investigationFinal reportMooney M20J · Bay Minette, ALfailure of the alternate air door, which resulted in blockage of air through the induction system. A factor relating to the accident was: failure to comply with Safety Bulletin SB-M20-253.NTSB LAX96LA071Accident · No injuriesLimited investigationFinal reportCessna 172M · Palm Springs, CAthe pilot's inadequate bounced landing recovery technique, which resulted in porpoising during a downwind emergency landing. The loss of engine power for undetermined reasons was a factor.NTSB FTW96LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pawnee, OKThe pilot's failure to maintain adequate clearance from the terrain.NTSB FTW96LA069Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · West Helena, ARBinding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.NTSB SEA96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chimacum, WAthe pilot-in-command's delayed application of carburetor heat which resulted in a power loss due to carburetor ice. Carburetor icing conditions, a short takeoff area, and a ditch at the end of the airstrip were factors.NTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.NTSB MIA96LA041Accident · No injuriesLimited investigationFinal reportMckibben GN-1 Aircamper · Mayhew, MSThe pilot's improper planning/decision, and failure to verify the airplane's performance data. The airplane's lack of climb capability with the newly manufactured propeller was a related factor.NTSB LAX96LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Mohave Valley, AZthe failure of the pilot to assure that clearance was maintained while taxiing in proximity of buildings at an excessive taxi speed.NTSB LAX96LA070Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAthe pilot was given an erroneous wind velocity due to a malfunctioning wind gauge in the control tower. Factors relating to the accident were: the high/gusty wind conditions, and the pilot's improper evaluation of the actual wind condition.NTSB FTW96LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Erie, COinadequate preflight by the pilot, by failing to properly remove water and other contamination from the fuel system before the flight. Factors relating to the accident were: deteriorated seals at the fuel filler neck/caps, and the annual inspection was…