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 CHI95IA286Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Champaign, ILfatigue cracking and subsequent catastrophic failure of the number two engine helical drive (bull) gear, which resulted in an overtemperature condition, bursting of the combustion plenum, and a subsequent in-flight fire.NTSB CHI95FA285Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ardoch, NDthe pilot-in-command's continuing flight into adverse weather. Factors were the pilot-in-command's failure to obtain a weather observation and the adverse weather.NTSB ANC95LA144Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot's inadequate visual lookout for obstacles. The low light condition at dusk was a related factor.NTSB ANC95LA143Accident · Serious injuriesLimited investigationFinal reportWaco UPF-7 · Anchorage, AKThe pilot's inadequate preflight planning/preparation, which resulted in an unlocked engine primer and subsequent loss of engine power.NTSB ANC95FA157Accident · 1 fatalField investigationFinal reportPiper L-21A · Kaktovik, AKThe pilot's failure to maintain adequate altitude/clearance from mountainous terrain.NTSB NYC95LA197Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340-A · Philadelphia, PAthe failure of a titanium hydraulic line, which resulted in an uncontained hydraulic fluid wing fire. A factor was the use of a procedure by the operator, approved by the FAA, but not approved by the airplane manufacturer, which resulted in compartment…NTSB LAX95LA298Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas 500 · Pacific Ocean (Pacific Ocean)the accidental discharge of a spear gun by the observer.NTSB LAX95FA297Accident · 2 fatalField investigationFinal reportBeech D55 · Kingsburg, CAthe failure of the pilot to maintain sufficient airspeed during a simulated engine failure to avoid an inadvertent stall/spin, and inadequate supervision by the designated pilot examiner. A factor in the accident was the decision of the examiner to use an…NTSB ATL95FA159Accident · 1 fatalField investigationFinal reportWSK PZL Mielec M-26 · Jonesborough, TNa blocked fuel injector nozzle, which increased the engine fuel consumption; failure of the pilot to adequately monitor fuel consumption, which resulted in fuel exhaustion before the airplane reached the destination; and the passenger's interference with the…NTSB ANC95LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Nikiski, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain and contamination in the left brake cylinder were related factors.NTSB ANC95LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Skwentna, AKThe pilot's improper planning/decision. A factor relating to the accident was: the pilot's selection of a short/uneven landing area that required excessive braking action while landing with a tailwind.NTSB NYC95LA196Accident · Serious injuriesLimited investigationFinal reportCessna 150 · North East, PAThe student pilot's delay in initiating an aborted landing and his failure to attain obstacle clearance.NTSB NYC95LA194Accident · 2 fatalLimited investigationFinal reportGreat Lakes 2T1-A2 · Fombell, PAthe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB NYC95FA195Accident · 2 fatalField investigationFinal reportCessna 310R · Altoona, PApropagation of corrosion cracks in the right engine overboard exhaust stack and fatigue failure of the exhaust stack, which resulted in escape of hot/high velocity gases, in-flight fire, emergency descent, and subsequent collision with trees during an…NTSB MIA95LA206Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Caribbean SeaLoss of engine power for undetermined reasons. Contributing to the accident was the inability of the pilot to feather the propeller.NTSB LAX95LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Hesperia, CAThe failure of the connecting rod due to the rod bolt backing off, and the pilot's misjudging the distance and altitude.NTSB FTW95LA346Accident · No injuriesLimited investigationFinal reportCessna 150F · Manila, ARA blown (tripped) fuse, which rendered flap retraction inoperative. Factors relating to the accident were: the hot weather condition, the aircraft's lack of climb performance with the flaps extended, and the lack of suitable terrain in the forced landing area.NTSB FTW95LA345Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Wilmot, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA282Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Mount Vernon, MOloss of aircraft control for an undetermined reason.NTSB CHI95LA281Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILinadequate preflight planning and preparation by the pilot and an inadverent stall encountered by the pilot.NTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.NTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.NTSB ANC95LA142Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff. High vegetation and upsloping terrain were related factors.NTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.NTSB MIA95LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Immokalee, FLThe pilot's improper use of the cyclic during a power-on autorotative landing (low flare), resulting in the ventral fin colliding with the ground.NTSB LAX95LA295Accident · No injuriesLimited investigationFinal reportCessna 172F · Bradley, CAfuel exhaustion due to the pilot's failure to refuel prior to takeoff and his delayed decision to proceed to his alternate airport. The night light conditions and the lack of a suitable emergency landing area were factors.NTSB FTW95TA390Accident · Minor injuriesFinal reportPiper PA-18-150 · Brackettville, TXThe pilot's improper compensation for wind conditions, and failure to maintain directional control. A factor relating to the accident was: the variable crosswind.NTSB CHI95LA289Accident · No injuriesLimited investigationFinal reportBeech B-60 · Salina, KSthe pilot's inattentiveness to the severity of the weather conditions, and his failure to maintain airspeed. Factors in the accident were: the icing conditions, airframe ice accumulation, and the design stress limits of the airplane being exceeded by the…NTSB CHI95LA278Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-400 · Hayti, MOthe pilot inadvertently stalled the airplane. A factor was the reduced power setting.NTSB BFO95LA081Accident · No injuriesLimited investigationFinal reportBeech 55 · Mansfield, OHthe inflight and postimpact fire due to a short circuit in the main power distribution cable.NTSB ANC95LA140Accident · No injuriesLimited investigationFinal reportCessna 185A · Teller, AKDeflation of the left main tundra tire due to valve stem damage (failure) when the tire rotated independently of the wheel rim, resulting in loss of directional control and a ground swerve.NTSB ANC95LA139Accident · Serious injuriesLimited investigationFinal reportMaule MA-4 · Port Alsworth, AKThe pilot's improper planning/decision and failure to attain sufficient airspeed to sustain a climb before hitting trees. The unfavorable wind condition was a related factor.NTSB SEA95LA183Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Chimacum, WAthe improper top overhaul of the engine and subsequent release of the cylinder hold-down nuts/breakage of hold-down and through-bolts. Factors contributing to the accident were the fence posts and rough/uneven terrain.NTSB NYC95LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYthe pilot misjudged the flare, resulting in a hard landing and subsequent collapse of the nose gear.NTSB NYC95LA191Accident · No injuriesLimited investigationFinal reportBeech 23 · Spafford, NYthe loss of engine power for undetermined reasons resulting in a forced landing over unsuitable terrain and the subsequent collision with trees.NTSB NYC95IA192Incident · No injuriesIncident investigationFinal reportBoeing 747-130 · Jamaica, NYfailure and separation of the #1 engine turbine shroud assembly, which resulted in an uncontained engine failure, a puncture of the #2 outboard reserve fuel tank plate, and a fuel leak.NTSB NYC95FA188Accident · 1 fatalField investigationFinal reportBeech 58 · Mapleton, METhe pilot inadvertently shut down the right engine and feathered the propeller after a loss of power in the left engine, and he failed to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor relating…NTSB LAX95LA294Accident · No injuriesLimited investigationFinal reportThorp T18 · Sedona, AZthe pilot's loss of directional control in gusty tail wind conditions during the landing roll.NTSB FTW95LA343Accident · No injuriesLimited investigationFinal reportPark Wizard · Mineral Wells, TXA seized engine following the total loss of engine coolant from a loose line due to an inadequate maintenance installation by the builder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA342Accident · No injuriesLimited investigationFinal reportBeech 19 · Lago Vista, TXThe loss of engine power for undetermined reasons.NTSB FTW95LA341Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Englewood, COFailure by the pilot to maintain directional control which resulted in a ground loop. A factor was crosswind.NTSB FTW95LA340Accident · No injuriesLimited investigationFinal reportBeech J35 · Englewood, COInadvertent activation of the fuel boost pump by either the pilot (who was being instructed) or by the flight instructor (CFI). Factors relating to the accident were: the briefing of improper leaning procedures by the CFI, location of the boost pump switch…NTSB CHI95LA283Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Ironwood, MIthe pilot's failure to maintain control of the airplane during the aborted takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB CHI95LA279Accident · No injuriesLimited investigationFinal reportCessna 188B · Canton, KSfailure of the pilot to obtain the proper flying speed or to abort the takeoff, while there was sufficient runway remaining, which resulted in an inadvertent stall.NTSB CHI95LA276Accident · No injuriesLimited investigationFinal reportCessna A185E · Dickinson, NDthe pilot's inadequate compensation for the wind conditions, and his improper recovery from the bounced landing. The high wind was a factor.NTSB CHI95LA274Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSa fatigue failure of the propeller blade, and inadequate maintenance inspection performed by the propeller shop.NTSB ANC95LA138Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Togiak, AKThe pilot's inadequate compensation for wind conditions and failure to maintain proper alignment with the intended point of landing. A factor relating to the accident was: the unfavorable wind condition.NTSB SEA95LA182Accident · No injuriesLimited investigationFinal reportCessna 177B · Seattle, WALoss of engine power for undetermined reason(s).NTSB NYC95LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAthe flight instructor's inadequate supervision during the final approach which resulted in the student flying a low approach and a subsequent collision with the trees. A factor relating to the accident was the student pilot's failure to maintain a proper…NTSB MIA95LA204Accident · 1 fatalLimited investigationFinal reportCessna A188B · Muscle Shoals, ALFailure of the pilot to maintain adequate visual lookout to see-and-avoid electrical power lines, while approaching a field for aerial application.