NTSB investigations, 1995
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\") = 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 NYC95LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's failure to obtain the proper touchdown point which resulted in insufficient runway stopping distance and a subsequent overrun of the runway, and collision with trees.NTSB NYC95LA184Accident · No injuriesLimited investigationFinal reportMooney M20C · Montgomery, PAThe partial loss of engine power, as a result of an excessively rich fuel flow in the carburetor, and a subsequent forced landing. A factor relating to the accident was the malfunction of the landing gear.NTSB MIA95LA198Accident · No injuriesLimited investigationFinal reportCessna 170B · Titusville, FLLoss of directional control during the landing roll. Contributing to the accident was the pilot's limited experience in the make and model airplane.NTSB LAX95LA284Accident · No injuriesLimited investigationFinal reportAviat A-1 · Elko, NVthe pilot's misjudged landing flare, which resulted in a hard landing.NTSB LAX95LA283Accident · No injuriesLimited investigationFinal reportPZL-Mielec PZL-M-18 · Sacaton, AZThe loss of engine power due to a decoupling of the accessory drive that runs the high pressure engine-driven fuel pump.NTSB BFO95LA078Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-5 · Luray, VAthe pilot's failure to attain the proper touchdown point on the runway during a precautionary landing. A factor was an undetermined lubricating system problem.NTSB BFO95LA077Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Paintersville, OHThe pilot's continued VFR flight into instrument meteorological conditions. Factors related to the accident were: the pilot's failure to obtain a weather briefing, and the weather conditions.NTSB ANC95LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKFailure of the pilot to maintain proper alignment with the intended takeoff area during the takeoff roll. Factors relating to the accident were: pilot fatigue and the proximity of rocks/boulders to the takeoff area.NTSB SEA95LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Panguitch, UTthe pilot's misjudgment of the distance from the sign post.NTSB NYC95LA186Accident · No injuriesLimited investigationFinal reportCessna 150E · West Addison, VTThe pilot's selection of an unsuitable landing area. A factor is a soft landing area.NTSB MIA95FA207Accident · 1 fatalField investigationFinal reportCessna 210C · Dawsonville, GAThe pilot's disregard of the weather forecast and flight into known adverse weather (instrument flight conditions), resulting in an in-flight collision while maneuvering in mountainous terrain. Contributing to the accident was the pilot's lack of recent…NTSB LAX95LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355-F1 · Daggett, CAthe failure of the Starflex arm due to fatigue, and the manufacturer's inadequate maintenance procedure. The operator's maintenance personnel failure to understand the repair procedure was a factor in the accident.NTSB CHI95LA264Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Murphysboro, ILthe pilot's improper use of carburetor heat which led to a loss of power due to carburetor ice, and his failure to maintain airspeed during the forced landing. The carburetor icing conditions were a factor.NTSB CHI95LA263Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Delavan, WIthe pilot's failure to assure an adequate amount of fuel was available for the flight. A factor was the improperly installed fuel level transmitter.NTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.NTSB ATL95LA150Accident · No injuriesLimited investigationFinal reportCessna 188T · Town Creek, ALThe pilot's failure to check the runway condition prior to takeoff. The soft runway was a factor.NTSB ANC95LA132Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's abrupt (improper) use of the throttle.NTSB SEA95LA174Accident · No injuriesLimited investigationFinal reportCessna T210K · Bliss, IDThe pilot's failure to properly manage the fuel system to avoid running a tank dry at a low altitude. A factor was the lack of suitable terrain for a forced landing.NTSB SEA95LA173Accident · No injuriesLimited investigationFinal reportCessna TU206F · Ennis, MTThe pilot-in-command's inaccurate weather evaluation and continued flight into adverse weather. The microburst was a factor.NTSB SEA95FA175Accident · 2 fatalField investigationFinal reportBeech F33A · Swan Lake, MTthe pilot's incapacitation due to a heart attack.NTSB NYC95LA183Accident · No injuriesLimited investigationFinal reportBeech C23 · Dublin, NHThe loss of engine power due to improper major overhaul of the engine by the reuse of worn piston pins. The rough/ uneven terrain in the emergency landing area was a factor.NTSB MIA95LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring Hill, FLThe pilot's premature decision to perform a precautionary landing. Contributing to the accident was partial loss of engine power due to failure of one of the two magnetos.NTSB MIA95LA195Accident · No injuriesLimited investigationFinal reportCessna 195B · Macon, GAa total loss of engine power for undetermined reasons. Contributing to the accident was an engine compartment fire of undetermined origin.NTSB FTW95LA335Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus A · Rocksprings, TXDebonding of mylar tape that was used to seal a gap on the elevator, which resulted in inadequate elevator control authority.NTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.NTSB SEA95LA177Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Boise, IDimproper adjustment of the engine fuel control units by company maintenance personnel which led to excessive fuel flow and subsequent partial loss of engine power. Factors contributing to the accident were the rough terrain and high density altitude.NTSB SEA95LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sekiu, WAThe pilot's continued flight into adverse weather necessitating a landing on a highway. The weather was a factor.NTSB NYC95LA182Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Owego, NYThe pilot's inadequate evaluation of weather conditions which resulted in an encounter with a downdraft, inflight loss of control, and a collision with a vehicle.NTSB MIA95LA196Accident · No injuriesLimited investigationFinal reportBoeing 727-264 · Orlando, FLThe failure of the ground crew to follow procedures/directives requiring that the airplane brakes be set before disconnecting the tow bar from the airplane.NTSB LAX95LA281Accident · No injuriesLimited investigationFinal reportBeech V35B · Minden, NVThe pilot's selection of the wrong runway, improper decision to land with a quartering tail wind, and his improper compensation of the prevailing wind conditions. The gusting crosswind and tail wind were factors in this accident.NTSB LAX95LA279Accident · No injuriesLimited investigationFinal reportMcnulty Kitfox IV 1200 · Weed, CAthe pilot's delayed application of sufficient power to arrest a high sink rate, which resulted in a hard landing. Factors in the accident were the pilot's lack of recent flight experience and the flight instructor's inadequate supervision of the flight.NTSB FTW95LA334Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · 0wasso, OKThe pilot's delayed decision to abort the takeoff. The pilot's failure to properly calculate the performance data prior to takeoff was a factor.NTSB FTW95LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind condition.NTSB FTW95LA332Accident · 1 fatalLimited investigationFinal reportCessna A188B · Fort Necessity, LAThe pilot's failure to maintain terrain clearance. A factor relating to the accident was: the gusty wind conditions.NTSB FTW95LA330Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hudson, COThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA275Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Lowell, INa loss of engine power due to carburetor ice. The lack of suitable terrain for a forced landing was a factor.NTSB ANC95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Alsworth, AKAn in-flight separation of a propeller blade, which resulted in a severe vibration, shutdown of the engine, and a forced landing in alder bushes.NTSB SEA95FA171Accident · 2 fatalField investigationFinal reportCessna 172M · Quilcene, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the mountains. Factors in the accident were the clouds and mountainous terrain.NTSB MIA95LA193Accident · No injuriesLimited investigationFinal reportCessna 150L · Picayune, MSLoss of engine power due to undetermined reasons.NTSB MIA95LA192Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Quitman, MSImproper (low) outflow from the fuel control unit, due to improper maintenance, which resulted in a loss of engine power and a forced landing.NTSB MIA95IA194Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Charlotte, NCImproper installation of the 'a' system flight control computer by company maintenance personnel, which resulted in pin connector(s) being pushed loose and subsequent malfunction of the autopilot.NTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.NTSB FTW95LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe pilot's improper compensation for the 6 knot crosswind. Factors were the pilot's delay in initiating an aborted landing and his lack of total experience.NTSB CHI95LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Detroit, MIthe flight's encounter with turbulence.NTSB CHI95LA261Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Mecosta, MIthe student's failure to maintain adequate airspeed, and the pilot-in-command's (CFI) inadequate remedial action.NTSB CHI95LA260Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A-450 · Grand Forks, NDthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the sunglare.NTSB BFO95LA076Accident · No injuriesLimited investigationFinal reportCessna 172D · Hague, VAFailure of the pilot to maintain proper alignment with the runway during the landing. Factors relating to the accident were: the crosswind and the proximity of tall corn (crop) to the narrow runway.NTSB ATL95LA149Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions Fantasy 6 · Kingsport, TNThe pilot's inadequate visual lookout.NTSB ANC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Ketchikan, AKThe pilot's inadequate preflight preparation and the water in the airplane's fuel system. A factor in the accident was the rough water in the forced landing area.NTSB ANC95FA129Accident · 2 fatalField investigationFinal reportCessna 170 · Coldfoot, AKThe pilot's failure to maintain adequate distance and/or altitude from terrain. Rising mountainous terrain and downdrafts associated with unfavorable wind conditions were factors in the accident.