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 MIA95LA203Accident · Serious injuriesLimited investigationFinal reportFairchild 24-G · Harold, FLThe engine missing for undetermined reasons, and the failure of the pilot in command to maintain airspeed while turning toward a landing area.NTSB MIA95LA202Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCThe failure of the pilot to maintain runway alignment. Contributing to the accident was the failure of the pilot to execute a go-around when he saw that he would not land on the runway.NTSB CHI95LA272Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Wadena, MNthe pilot's inattentiveness during the reversal turn, the pilot not maintaining control of the airplane, and the stall/mush encountered by the pilot.NTSB CHI95LA268Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Auburn, INthe pilot's impairment of judgement and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB BFO95LA085Accident · Serious injuriesLimited investigationFinal reportBirdman Enterprises Chinook 2S · Hammondsville, OHthe pilot's failure to maintain adequate altitude/clearance from obstacles (power lines) in his flight path.NTSB BFO95LA080Accident · No injuriesLimited investigationFinal reportCessna 182F · Mitchellville, MDthe pilot's delay in aborting the takeoff.NTSB SEA95LA181Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · St. Mary, MTThe pilot-in-command's failure to maintain proper altitude while maneuvering in high, mountainous, terrain. The terrain and the downdrafts were factors.NTSB NYC95TA190Accident · Minor injuriesFinal reportSchweizer 269C · Baltimore, MDThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the ground.NTSB NYC95LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norfolk, MAThe pilot's misjudgement of speed and distance during the landing, which resulted in a runway overrun. Factors relating to the accident were: heavy rain, wet runway, and hydroplaning conditions.NTSB LAX95LA293Accident · No injuriesLimited investigationFinal reportPitts S-2B · Phoenix, AZThe inadequate supervision by the instructor pilot by allowing the trainee to initiate a late go-around from a simulated forced landing.NTSB LAX95LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Truckee, CAA failure in the aircraft electrical system, and the pilot's failure (or inability) to extend the landing gear with the emergency extension system. A factor relating to the accident was: the pilot's decision to continue the flight with a known deficiency.NTSB LAX95LA291Accident · Serious injuriesLimited investigationFinal reportKinner Sportster K · Los Banos, CAthe pilot's failure to maintain minimum control airspeed resulting in a stall, and not maintaining proper altitude on final approach. Contributing to the accident was the unfavorable wind condition.NTSB LAX95LA290Accident · Serious injuriesLimited investigationFinal reportPiper PA-30-B · Wickenberg, AZthe pilot's improper emergency procedures. The pilot's diverted attention, and the magnetos clearance and timing were factors in this accident.NTSB LAX95LA289Accident · 1 fatalLimited investigationFinal reportRonneberg/Murphy Berkut · Santa Paula, CAthe pilot's inadvertent entry into an accelerated stall in a maximum performance high-g turn at an altitude insufficient to recover aircraft control prior to colliding with the ground.NTSB FTW95LA339Accident · No injuriesLimited investigationFinal reportReims Cessna FR182 · Lakeview, ARThe pilot's improper recovery from a bounced landing, and failure to maintain directional control. Factors related to the accident were: the pilot's failure to attain the proper touchdown point or abort the landing.NTSB FTW95LA338Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon Newport AX8 · Houston, TXThe loss of lift and subsequent hard landing as result of the disengagement of a velcro strip at the top of the balloon's envelope.NTSB FTW95FA337Accident · 2 fatalField investigationFinal reportCessna 150M · Armorel, ARThe pilot's impairment of judgement and performance due to drugs which led to his failure to maintain airspeed and resulted in an inadvertent stall/spin. Factors were the pilot's overconfidence in personal ability and interpersonal relations.NTSB CHI95LA277Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Prague, MNthe failure of the pilot to maintain adequate airspeed to permit control of the aircraft and to prevent an inadvertent stall. Contributing factors include gusty wind conditions and turbulence.NTSB CHI95LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wheeling, ILthe pilot's abrupt raising of the flaps during the attempted go-around and the resulting stall.NTSB CHI95LA270Accident · Minor injuriesLimited investigationFinal reportBell 47 · Arlington Hts, ILplot misjudged the flare. The factors included the pilot getting too close to the lead helicopter, allowing his airspeed to get too slow, and encountering settling with power.NTSB CHI95LA269Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Tell City, INthe pilot initated the flight with an inadequate fuel supply and failed to add sufficient fuel en route which resulted in fuel exhaustion. A factor related to the accident was the rough terrain.NTSB ATL95LA157Accident · No injuriesLimited investigationFinal reportCessna 172H · Manteo, NCThe pilot's improper in-flight decision to touchdown at the mid-field point of the runway.NTSB ATL95LA156Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mckenzie, TNThe pilot's failure to comply with the performance data for the aircraft in his attempt to takeoff, downwind, from the short sod runway, with high density altitude, and with the aircraft weight in excess of the maximum gross weight allowed.NTSB ATL95LA155Accident · No injuriesLimited investigationFinal reportSchweizer 233A · Louisburg, NCThe flight instructor's improper in-flight planning and decision, in that he failed to maintain sufficient altitude to clear the trees surrounding the airport, and failed to take into consideration the high density altitude at the time of the accident.NTSB ATL95LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Dayton, TNThe pilot's failure to maintain control of the aircraft during landing.NTSB SEA95LA180Accident · No injuriesLimited investigationFinal reportMooney M20A · Rock Springs, WYThe pilot's failure to maintain control of the aircraft. Factors include the uneven runway condition, the information regarding the crowned condition not being disseminated by airport personnel, and the inadequate review/inspection of the condition by FAA…NTSB MIA95FA200Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pulaski, TNFailure of the pilot to perform the before-takeoff checklist, and his failure to abort the takeoff due to inadequate acceleration. Contributing to the accident was an inadequate annual inspection by maintenance personnel for failure to safety the carburetor…NTSB FTW95LA347Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Lake City, ARThe pilot's failure to maintain clearance with the transmission wires.NTSB FTW95LA336Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Cannon Afb, NMThe inadvertent stall. A factor was the pilot's premature retraction of the flaps.NTSB ATL95LA153Accident · No injuriesLimited investigationFinal reportYothment KOLB-FIRESTAR II · Lawrenceville, GAThe pilot's failure to maintain flying speed. A factor was the pilot's lack of familiarity with the aircraft.NTSB ATL95LA152Accident · Serious injuriesLimited investigationFinal reportAero Commander 100-180 · Ocracoke, NCA shattered windshield which precluded maintaining level flight due to increased aerodynamic drag.NTSB ANC95LA141Accident · No injuriesLimited investigationFinal reportShort Brothers SC.7 · Nikolai, AKIgnition of hazardous cargo (aviation fuel) by an exposed electrical wire, after leaking from a container of fuel that was being transported on the flight. Factors relating to the accident were: inadequate inspection of the airplane by company maintenance…NTSB ANC95LA137Accident · No injuriesLimited investigationFinal reportGuevremont Pitts Special S1C · Talkeetna, AKThe pilot's excessive application of rudder control, as he yawed the airplane to see ahead during the takeoff roll, which resulted in a loss of directional control and a subsequent ground swerve. Factors related to the accident were: the animal (moose) and…NTSB SEA95LA179Accident · No injuriesLimited investigationFinal reportCessna T188C · Mattawa, WAA partial loss of engine power for undetermined reasons.NTSB SEA95LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · Bullfrog, UTThe right brake locking for undetermined reasons.NTSB MIA95TA199Accident · No injuriesFinal reportCessna 404 · Raiford, FLThe pilot's selection of unsuitable terrain for landing.NTSB MIA95LA201Accident · No injuriesLimited investigationFinal reportCessna 150L · Opa Locka, FLThe pilot-in-command's improper use of flaps during an attempted go-around.NTSB LAX95LA288Accident · No injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAThe failure of the landing gear strut due to fatigue.NTSB LAX95LA287Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Chino, CAa forced landing into unsuitable terrain due to an engine failure for undetermined reasons.NTSB LAX95LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Overgaard, AZthe pilot's improper use of the mixture controls, failure to maintain a proper glidepath, failure to maintain an adequate approach airspeed, and failure to maintain directional control of the aircraft.NTSB LAX95LA285Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-B · Peoria, AZthe pilot's improper inflight decision to attempt a tail wind landing to a short runway.NTSB FTW95LA344Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Monroe, LAThe student pilot's improper flare and the inadequate supervision by the flight instructor.NTSB DCA95RA051Accident · 65 fatalForeign investigationBoeing 737-200 · San Vicente, El SalvadorNTSB CHI95LA284Accident · No injuriesLimited investigationFinal reportVan Zwoll Viking · Decker, INthe failure of the head gasket resulting in a coolant leak and subsequent engine overtemperature. A factor was the unsuitable terrain encountered in the cornfield.NTSB CHI95LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Fremont, NEa loss of engine power for undetermined reasons. A factor in the accident was the unsuitable landing terrain.NTSB CHI95LA266Accident · No injuriesLimited investigationFinal reportGrumman G164B · Bloomington, NEthe disintegration of the engine's super charger bearings. Factors associated with the accident were the total failure of the engine's super charger and the unsuitable terrain surrounding the airplane's departure path encountered by the pilot.NTSB BFO95LA079Accident · 1 fatalLimited investigationFinal reportHughlett Challenger II · Madisonville, KYan intermittent short of the ignition system, due to improper maintenance/modification of the engine, which resulted in partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision…NTSB ATL95LA151Accident · No injuriesLimited investigationFinal reportCessna 188T · Town Creek, ALThe chafing of the fuel flow gage pressure line with an electrical system wire which resulted in arcing.NTSB ANC95LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aniak, AKThe pilot's misjudged landing flare, which resulted in a hard landing and overload failure of the main landing gear.NTSB ANC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Cordova, AKThe pilot's improper planning/decision and delayed decision to abort the takeoff.