NTSB investigations, 1995
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI96FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Fond Du Lac, WIthe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.NTSB MIA96LA022Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Snellville, GAThe pilot's failure to attain the proper touchdown point on landing. The sunglare and wet grass were factors.NTSB LAX96LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAThe pilot's failure to maintain directional control which resulted in an inadvertent ground loop. The pilot's diverted attention while raising the flaps and pushing in the carburetor heat control was a factor in this accident.NTSB CHI96LA031Accident · No injuriesLimited investigationFinal reportBeech 35 · Belleville, KSthe pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…NTSB BFO96LA026Accident · No injuriesLimited investigationFinal reportCessna 210E · Newport News, VAthe failure of the engine-driven hydraulic pump drive shaft, the pilot's failure to properly engage the emergency landing gear handle.NTSB NYC96FA023Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Hartford, VTthe pilot's inadequate preflight planning/preparation, his inadequate removal of airframe ice, and his failure to maintain adequate airspeed, which resulted in a stall/spin and an inflight collision with terrain. Factors relating to the accident were: the…NTSB MIA96LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marco Island, FLA loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB LAX96FA042Accident · 4 fatalField investigationFinal reportBeech S35 · Kneeland, CAfailure of the pilot to correct a descending spiral and perform a missed approach, after becoming spatially disoriented and deviating from the planned ILS approach procedure. Factors relating to the accident were: darkness, and the pilot's excessive…NTSB CHI96LA032Accident · No injuriesLimited investigationFinal reportHughes 369D · Crystal, MIfuel contamination resulting in the loss of engine power, and improper fuel sump screen installation on the nurse truck resulting in contamination of the fuel supply.NTSB NYC96LA026Accident · No injuriesLimited investigationFinal reportFairchild Merlin Iiia · Butler, PAfailure of the pilot to perform a missed approach, when the airplane was not properly aligned with the landing runway; and his failure to properly flare the airplane, which resulted in a hard landing.NTSB MIA96LA019Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Pensacola, FLThe passenger failure to follow the instructions to be seated and utilize a seatbelt. Contributing to the accident was the in flight encounter with turbulence.NTSB LAX96LA041Accident · 1 fatalLimited investigationFinal reportCooke KR-2 · Watsonville, CApartial loss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, while maneuvering for an emergency landing, which resulted in an inadvertent stall and collision with the terrain.NTSB FTW96RA039Incident · Minor injuriesForeign investigationBoeing B727-224 · Panama City, PanamaNTSB BFO96LA016Accident · Serious injuriesLimited investigationFinal reportRyan Navion A3 · Mccomb, OHthe pilot's improper use of carburetor heat, and carburetor Ice, which resulted in loss of engine power and a subsequent forced landing. The carburetor icing (weather) condition was a related factor.NTSB SEA96LA014Accident · No injuriesLimited investigationFinal reportCessna 180J · Stanley, IDthe pilot's failure to maintain clearance with obstacles at the end of the takeoff area. His failure to attain sufficient altitude to clear the obstacles was a factor.NTSB NYC96LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · South Brunswick, NJloss of engine power for an undetermined reason.NTSB CHI96LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Wabash, INdeer that went onto the runway as the aircraft was landing. The light condition at dusk was a related factor.NTSB BFO96LA018Accident · No injuriesLimited investigationFinal reportBeech 35 · Phillipsburg, OHThe flight instructor's (CFI's) inadequate supervision of the flying pilot, and the flying pilot's abrupt handling of the airplane during an attempted go-around. Factors relating to the accident were: the flying pilot's lack of familiarity with light piston…NTSB ANC96LA013Accident · No injuriesLimited investigationFinal reportCessna 206 · Kodiak, AKThe pilot's inadequate visual lookout. A factor associated with the accident is reduced visibility due to sun glare.NTSB MIA96LA018Accident · Minor injuriesLimited investigationFinal reportBoeing E75N1 · Wauchula, FLA total loss of engine power due to worn serrated teeth on the valve timing gear and intermediate camshaft drive gear which prevented the valve train and generator from operating. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA040Accident · 2 fatalLimited investigationFinal reportCessna 180 · Placerville, CAthe pilot's intentional buzzing, his failure to identify an obstruction (inadequate visual lookout), and his failure to maintain adequate altitude/clearance from the obstruction (utility pole). Factors relating to the accident were: dust generated by farm…NTSB LAX96LA039Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Redwood City, CAthe simultaneous total loss of engine power for undetermined reasons.NTSB FTW96LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXInadequate preflight by the pilot, and improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power during takeoff. Darkness was a related factor.NTSB CHI96LA027Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Lone Rock, WIa partial loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during his attempt to land the airplane back on the runway. A factor in the accident was the pilot's decision not to land in the suitable fields…NTSB SEA96LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Salt Lake City, UTa carburetor fire.NTSB MIA96LA017Accident · No injuriesLimited investigationFinal reportBoeing B-17G · Fayetteville, NCthe failure of the airplane's normal brake system due to the open position of the pressure relief valve. Contributing to the accident was the pilot in command's premature engine shutdown resulting in the airplane colliding with the localizer building.NTSB MIA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Fort Lauderdale, FLThe pilot's failure to follow procedures, resulting in the airplane being landed with the landing gear in the up position.NTSB LAX96LA037Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Richvale, CAthe attempt by the pilot to execute an aerobatic maneuver with inadequate altitude to effect recovery before impacting terrain.NTSB CHI96LA025Accident · No injuriesLimited investigationFinal reportBeech A90 · Wichita, KSfailure of the pilot to follow procedures/directives regarding the entrance door, which resulted the door coming open in flight.NTSB BFO96LA020Accident · No injuriesLimited investigationFinal reportCessna 150F · New Carlisle, OHinadequate preflight planning/preparation by the flight instructor (CFI), which resulted in a loss of engine power during initial climb, due to an inadequate supply of fuel and fuel starvation. The soft terrain encountered during the forced landing was a…NTSB ANC96LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Toksook Bay, AKThe pilot's inadequate planning/decision, improper use of the flaps, and inadequate removal of snow/frost from the wings of the airplane. An upsloping runway and snow conditions were factors in the accident.NTSB NYC96IA022Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Portland, MEa bird strike during takeoff, which resulted in failure of several fan blades in the right engine and a partial loss of engine power.NTSB LAX96LA149Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Pacific Ocean (Pacific Ocean)failure of the pilot to maintain lateral control of the helicopter, while hovering in preparation for a precautionary landing next to a ship at sea. Factors relating to the accident were: the passenger's premature evacuation from the helicopter, and the…NTSB LAX96LA036Accident · Serious injuriesLimited investigationFinal reportAgusta F.260D · Grand Canyon, AZthe pilot inadvertently allowed the ferry tank fuel selector to be in (or to be moved to) a partially open position before or during takeoff, which allowed air to enter the fuel system lines and result in fuel starvation. The location of the valve in the…NTSB FTW96LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Oklahoma City, OKThe student pilot's failure to use carburetor heat resulting in loss of engine power due to carburetor icing. A factor was the lack of suitable terrain for a forced landing.NTSB BFO96LA017Accident · No injuriesLimited investigationFinal reportCessna 177RG · College Park, MDthe main landing gear retracted for undetermined reasons.NTSB LAX96LA035Accident · Serious injuriesLimited investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)the failure of the passenger to comply with the fasten seatbelt signs and the verbal directives of the flight and cabin crew.NTSB FTW96RA037Accident · 9 fatalForeign investigationCessna 208B · Piedras Negras, MexicoNTSB FTW96LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKthe pilot's failure to maintain directional control. A factor was the wet grass runway.NTSB FTW96LA035Accident · Serious injuriesLimited investigationFinal reportHelio HT-295 · Llano, TXThe pilot's encounter with a downdraft and his inability to outclimb rising terrain. Factors were the rising terrain and high winds.NTSB NYC96LA021Accident · Minor injuriesLimited investigationFinal reportBischoff VAN RV-6 · Monticello, NYthe pilot's improper inflight decision to continue flight without sufficient fuel, which resulted in a loss of power due to fuel exhaustion.NTSB LAX96LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Davis, CAthe pilot's failure to maintain directional control during the takeoff roll by diverting his attention.NTSB LAX96IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 737-5H4 · Las Vegas, NVThe flying pilot's inadvertent exposure to an unidentified ground-based laser beam. A factor in the incident is the lack of appropriate standards by the FAA and FDA for laser light exposure levels to aircrew in navigable airspace.NTSB ATL96FA010Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Isbela Segunda, PRthe pilot's failure to maintain control of the aircraft resulting in a stall. A factor was the mechanic's failure to properly maintain the forward baggage door locking mechanism.NTSB LAX96LA034Accident · No injuriesLimited investigationFinal reportCessna 310C · Boulder City, NVthe pilot's improper aircraft handling during touchdown which resulted in the right wing and horizontal stabilizer dragging on the runway. The poorly planned landing approach was a factor.NTSB LAX96LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bullhead City, AZThe failure of the pilot/flight instructor to adequately supervise the student pilot resulting in loss of directional control, and his abrupt overcorrection resulting in a waterloop. A contributing factor was the pilot's limited experience as a flight…NTSB LAX96LA029Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Madera, CAFuel exhaustion due to the pilot's improper preflight planning and failure to ensure that adequate fuel was onboard to complete the flight. Darkness was a related factor.NTSB FTW96LA031Accident · Serious injuriesLimited investigationFinal reportCessna 182TR · Boulder, COThe pilot's failure to determine the amount of fuel aboard the aircraft during preflight, and his failure to refuel the aircraft.NTSB BFO96LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, VAfailure of the propeller blade due to fatigue cracking originating from corrosion damage. A related factor was the soft terrain encountered during the forced landing.NTSB LAX96WA038Accident · No injuriesForeign investigationCessna 210 · Divisadero, Mexico