NTSB investigations, 1995
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 FTW96IA066Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Dfw Airport, TXfatigue failure of a first stage, high pressure, turbine blade.NTSB CHI96FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Steuben, WIfailure of the pilot to select alternate air. Darkness and snowy weather conditions were related factors.NTSB CHI96FA049Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Parker, KSthe pilot's impairment of judgment and performance due to a drug (cocaine); his improper in-flight decision to continue flight over an overcast condition and then to descend into instrument meteorological conditions (IMC); his failure to maintain control of…NTSB ANC96LA022Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Delta Junction, AKThe pilot's inadequate preflight preparation/planning, and his improper in flight decision making. Factors associated with the accident are the gusty crosswinds and associated turbulence.NTSB MIA96LA038Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Memphis, TNThe pilot's and ground personnel's improper starting procedure. Contributing to the accident were the communications being not understood and inadequate training for both the pilot and ground personnel.NTSB CHI96LA050Accident · No injuriesLimited investigationFinal reportBeech B90 · Eden Prairie, MNthe pilot's failure to maintain clearance with the hangar while taxiing. A factor associated with the accident was the pilot's impairment due to alcohol.NTSB ATL96LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA 315 · Manning, SCThe loss of engine power during takeoff for undetermined reason(s).NTSB MIA96IA039Incident · No injuriesIncident investigationFinal reportBoeing 747-212B · Amsterdam, NetherlandsThe failure of the captain to maintain a level wings attitude during a go-around resulting in the right wing dragging on the ground.NTSB ANC96LA021Accident · No injuriesLimited investigationFinal reportCessna U206G · Selawik, AKThe pilot's inadequate preflight of the airplane by failing to ensure that all the airplane's doors were properly closed. A factor associated with the accident is an open door.NTSB ANC96LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Nanwalek, AKThe pilot's inadequate compensation for wind conditions. A factor in the accident was the variable wind.NTSB LAX96LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Ocotillo Wells, CAthe failure of the pilot to maintain a proper glide path on final approach.NTSB FTW96LA064Accident · No injuriesLimited investigationFinal reportCessna 310D · Fort Worth, TXFailure of the left main landing gear strut at the fork weld.NTSB FTW96FA063Accident · 2 fatalField investigationFinal reportBalloon Works Firefly 7-15 · Oklahoma City, OKThe pilot's failure to maintain obstacle clearance during low altitude straight and level flight.NTSB SEA96IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Boise, IDthe pilot-in-command's misjudgment of the remedial action necessary to correct the aircraft's misalignment with the runway. The dark night conditions, fog, and the pilot-in-command's failure to maintain proper alignment with the runway were factors.NTSB NYC96LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Moultonboro, NHfailure of the pilot to maintain directional control of the airplane during the landing, which allowed the plane to depart the runway and collide with a snowbank. A factor relating to the accident was: the icy runway condition.NTSB LAX96LA068Accident · No injuriesLimited investigationFinal reportCessna T210N · Modesto, CAthe pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, due to an inadequate supply of fuel, followed by a forced landing in an area of trees. Darkness was a related factor.NTSB NYC96IA036Incident · No injuriesIncident investigationFinal reportBoeing 747-240 · Jamaica, NYfailure of the number two engine fan mid shaft, due a fatigue fracture caused by a previous bearing failure, and failure of the operator's maintenance personnel to detect the cracks during subsequent inspections.NTSB MIA96WA037Accident · 20 fatalForeign investigationBeech 1900D · Port-Au-Prince, HaitiNTSB LAX96FA067Accident · 1 fatalField investigationFinal reportCessna 340A · San Dimas, CAthe pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, his failure to follow proper IFR procedures, and his failure to maintain proper altitude during a missed approach. Factors relating to the accident…NTSB CHI96FA048Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Laupahoehoe, HIthe pilot falling asleep at the controls due to fatigue. Factors were: the pilot's inadequate preflight preparation and the dark night.NTSB MIA96LA036Accident · No injuriesLimited investigationFinal reportCessna 150J · Orange Springs, FLThe pilot's improper use of carburetor heat resulting in engine failure due to carburetor ice.NTSB MIA96FA035Accident · 3 fatalField investigationFinal reportAerospatiale TB-20 · Meridian, MSthe pilot's failure to maintain airspeed (VSO) while maneuvering during an ILS approach in instrument flight conditions. Factors related to the accident were: the pilot's failure to follow the published approach procedure, his failure to maintain a proper…NTSB FTW96FA062Accident · 3 fatalField investigationFinal reportCessna 182G · Caddo Mills, TXThe failure of the pilot-in-command in each airplane to see-and-avoid conflicting traffic (inadequate visual lookout). The localized haze and smoke were related factors.NTSB ATL96LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Athens, GAThe mechanic's failure to adequately inspect and repair the engine, which resulted in engine oil contamination, and the subsequent loss of engine power. A factor was the low ceiling.NTSB LAX96WA063Accident · 1 fatalForeign investigationPiper PA-28 · Baja California, MexicoNTSB LAX96LA064Accident · No injuriesLimited investigationFinal reportEmroth Emair MA-1B · Pahala, HIthe failure of the pilot to adequately compensate for wind conditions, and to maintain directional control of the aircraft during the landing.NTSB LAX96LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Winslow, AZthe student pilot's use of an excessive airspeed during the landing approach, which resulted in a hard landing, a porpoise, and a collapse of the nose landing gear.NTSB FTW96FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Thibodaux, LAfailure of the pilot to maintain clearance from the power line and utility pole. The gusty/crosswind (weather) condition was a related factor.NTSB ATL96FA018Accident · 2 fatalField investigationFinal reportNavion D · Canton, GAThe pilot's impairment of judgement and performance due to drugs which led to his overconfidence of personal ability and continued flight into known adverse weather conditions. The weather conditions and dark night were factors.NTSB ATL96FA017Accident · 2 fatalField investigationFinal reportCessna 402A · Avon Park, FLThe failure of the pilot to maintain the proper climb rate and direction of flight following takeoff, resulting in a collision with obstacles. The reason for the loss of control and subsequent unusual attitude ground impact was not determined.NTSB MIA96LA034Accident · No injuriesLimited investigationFinal reportCessna 172M · Madison, MSThe pilot's premature raising of flaps during a go-around.NTSB BFO96LA029Accident · 1 fatalLimited investigationFinal reportCessna 150K · Seville, OHpilot suicide (intentional in-flight collision with terrain).NTSB NYC96LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Somerset, PAthe pilot's improper planning/decision and use of unsuitable terrain for a precautionary landing, which resulted in a collision with an embankment and subsequent nose over of the airplane. Factors relating to the accident were: the adverse weather conditions,…NTSB NYC96LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTThe pilot's improper flare and improper recovery from a bounced landing. The unfavorable wind condition was a related factor.NTSB NYC96FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Rush Township, PAthe pilot's continued flight into adverse weather conditions which resulted in becoming lost and disorientated and subsequent impact with rising terrain. Factors in this accident were fog and a dark night.NTSB MIA96LA055Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Fort Myers, FLThe failure of the pilot-in-command to maintain directional control. Contributing to the accident was the inadequate amount of rudder input to compensate for engine torque during takeoff.NTSB IAD97WA047Accident · 5 fatalForeign investigationPiper PA-32R-300 · Luqua, MaltaNTSB DCA96RA014Accident · 72 fatalForeign investigationBoeing B-737-200 · Douala, CameroonNTSB CHI96FA045Accident · 1 fatalField investigationFinal reportPiper PA-28 · Friedens, PAthe pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…NTSB MIA96FA033Accident · 1 fatalField investigationFinal reportCessna 150M · Burlington, NCthe pilot's engagement in a low altitude ostentatious display from which he stalled the airplane.NTSB FTW96LA068Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Collinsville, OKThe pilot's improper planning/decision, his failure to periodically clear the engine during the glide, and failure to see-and-avoid the transmission line during the approach for an emergency landing.NTSB FTW96LA059Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 · Gallup, NMthe high winds and the pilot's failure to maintain aircraft control.NTSB FTW96FA058Accident · 3 fatalField investigationFinal reportCessna 172P · Hallett, OKThe flight instructor's intentional low altitude flight maneuver. Factors were the static wire and the bright night condition.NTSB CHI96LA046Accident · No injuriesLimited investigationFinal reportRobert Eckley Rotorway · Salina, KSthe pilot's improper maintenance of the helicopter. Factors in the accident were the pilot's lack of proper certification for the operation of the helicopter and his lack of recent experience in type of aircraft.NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB LAX96LA060Accident · Serious injuriesLimited investigationFinal reportLaister LP-15 · Adelanto, CAthe pilot's selection of the wrong runway for the prevailing wind conditions, and his failure to maintain an adequate airspeed during the base-to-final turn.NTSB FTW96LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Eads, COFailure of the engine connecting rod bolts and separation of the cylinder from the crankcase. Factors were the lack of suitable terrain for the forced landing, and reduced light conditions (dark night).NTSB CHI96LA044Accident · Minor injuriesLimited investigationFinal reportHerring Sport FAN · Newton, KSa loss of engine power for undetermined reasons. A factor related to the accident was the presence of traffic requiring the pilot to perform an evasive maneuver.NTSB BFO96LA030Accident · No injuriesLimited investigationFinal reportCessna 172K · Lovingston, VAthe pilot's improper planning/decision during the approach/landing phase of flight. Related factors were: the pilot's selection of the wrong runway, and the gusty tailwind conditions.NTSB ATL96LA031Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, SCAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of engine power. The tree stump was a factor.