NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
  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.

NTSB FTW95LA296Accident · No injuriesLimited investigationFinal reportCessna 210D · Bentonville, ARThe pilot's failure to attain the proper touchdown point. Factors were the mown grass and the high density altitude.Jul 13, 1995 · N375HW · Substantial damageNTSB FTW95LA295Accident · No injuriesLimited investigationFinal reportCessna 172L · Porter, TXThe loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed resulting in overshooting the landing.Jul 13, 1995 · N3967Q · Substantial damageNTSB FTW95LA293Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Simmesport, LAThe loss of engine power as result of the failure of the number 7 cylinder. A factor was the lack suitable terrain for the forced landing.Jul 13, 1995 · N9949 · Substantial damageNTSB FTW95LA292Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Buren, ARA partial loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed during the precautionary landing resulting in an overshoot.Jul 13, 1995 · N9869K · Substantial damageNTSB FTW95FA294Accident · Serious injuriesField investigationFinal reportCessna 310D · Alamosa, COTotal loss of power in both engines due to flooding after the pilot had placed both fuel pump switches in the high boost position and moved the mixture controls to the full rich position. A factor related to the accident was: the lack of suitable terrain for…Jul 13, 1995 · N6976T · DestroyedNTSB ANC95LA100Accident · No injuriesLimited investigationFinal reportCessna 180K · King Salmon, AKFailure of the pilot to adequately compensate for wind conditions, which resulted in a failure to maintain directional control. The downdraft and crosswind were related factors.Jul 13, 1995 · N63336 · Substantial damageNTSB SEA95LA146Accident · No injuriesLimited investigationFinal reportMooney M20G · Rigby, IDThe pilot's premature liftoff and failure to attain adequate airspeed during takeoff. The high density altitude was a factor.Jul 12, 1995 · N3936N · Substantial damageNTSB NYC95LA155Accident · No injuriesLimited investigationFinal reportBeech 77 · Celina, OHfailure of the pilot to maintain control of the airplane during the landing.Jul 12, 1995 · N67212 · Substantial damageNTSB NYC95LA153Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, OHA loss of directional control during takeoff for undetermined reasons.Jul 12, 1995 · N1723E · DestroyedNTSB LAX95LA252Accident · No injuriesLimited investigationFinal reportPitts S-1S · Livermore, CAthe pilot's failure to maintain runway alignment and subsequent collision with some bales of hay.Jul 12, 1995 · N715L · Substantial damageNTSB CHI95LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot's failure to maintain altitude and/or clearance at the beginning of the spray run. A factor was turbulence due to the different Air temperatures of adjoining terrain.Jul 12, 1995 · N8673S · Substantial damageNTSB CHI95LA218Accident · No injuriesLimited investigationFinal reportBeech C24R · Freeport, ILthe pilot's failure to maintain control of the airplane during the aborted takeoff.Jul 12, 1995 · N67100 · Substantial damageNTSB ATL95LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Bayboro, NCThe pilot's inadequate procedure in that he elected to land the aircraft on unsuitable terrain with no mechanical malfunctions.Jul 12, 1995 · N13547 · Substantial damageNTSB ATL95LA132Accident · No injuriesLimited investigationFinal reportCessna 310 · Ridgeland, SCThe pilot's failure to assure that the airplane's alternators were on which led to a complete loss of electrical power, and his failure to attempt to lower the landing gear by emergency procedures.Jul 12, 1995 · N3083D · Substantial damageNTSB ANC95TA102Accident · No injuriesFinal reportCessna 185C · Bettles, AKThe pilot-in-command's failure to properly judge the height of the airplane above the water during landing. Contributing to the accident were the glassy water conditions and an excessive descent rate at touchdown.Jul 12, 1995 · N725 · Substantial damageNTSB SEA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mccall, IDImproper planning/decision by the pilot, which resulted in his failure (or inability) to remain clear of terrain after initiating a go-around. Factors relating to the accident were: the unfavorable terrain and wind conditions (including downdrafts).Jul 11, 1995 · N82555 · Substantial damageNTSB SEA95LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Esterbrook, WYThe pilot's failure to attain the proper touchdown point and airspeed for landing. Contributing to the accident were high density altitude, the short landing area, and the pilot's failure to initiate a go-around in time to allow recovery from the situation.Jul 11, 1995 · N70062 · Substantial damageNTSB NYC95LA157Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Queenstown, MDfailure of the fuselage longeron tubes due to fatigue, which resulted in partial separation (distortion) of the fuselage, partial loss of aircraft control, and a partial loss of engine power.Jul 11, 1995 · N260BF · Substantial damageNTSB NYC95LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Belmar, NJThe student pilot's (1) misjudged flare (2) inadequate recovery from a bounced landing (3) failure to maintain directional control and the certified flight instructor's inadequate supervision.Jul 11, 1995 · N43JA · Substantial damageNTSB NYC95LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Minersville, PAthe student pilot's improper go-around procedure, which resulted in an inadvertent stall/mush into trees.Jul 11, 1995 · N15157 · Substantial damageNTSB MIA95LA181Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Lambert, MSUnsuitable terrain encountered during the forced landing. Contributing to the accident was the partial loss of engine power due to failure of the no. 4 cylinder intake valve rocker arm bosses.Jul 11, 1995 · N8440V · DestroyedNTSB LAX95LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Van Nuys, CAfuel starvation resulting from the failure of the pilot to properly configure the fuel selector to a tank containing fuel during the landing approach.Jul 11, 1995 · N243CV · Substantial damageNTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.Jul 11, 1995 · N1004W · Substantial damageNTSB FTW95LA289Accident · No injuriesLimited investigationFinal reportCessna 182 · Port Sulphur, LAThe pilot's misjudgement of his short field landing resulting in an intentional ground loop to avoid an overrun. Factors were the reduced braking effectiveness on the wet grass runway.Jul 11, 1995 · N2878R · Substantial damageNTSB FTW95LA288Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARThe pilot delayed pull-up from a swath run and failed to maintain clearance from the obstruction (grain elevator). A factor relating to the accident was: the pilot's use of medications that were not approved for use while flying.Jul 11, 1995 · N4609P · DestroyedNTSB CHI95LA217Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Kenmare, NDthe pilot's not obtaining/maintaining proper climb rate.Jul 11, 1995 · N6623Q · DestroyedNTSB NYC95LA147Accident · 1 fatalLimited investigationFinal reportBell 47G-3B-1 · Hammonton, NJfailure of the collective yoke bearing, which resulted in an uncontrolled descent and collision with trees. A factor relating to the accident was: the manufacturer's inadequate inspection interval of the yoke bearing.Jul 10, 1995 · N48316 · DestroyedNTSB MIA95WA179Accident · 1 fatalForeign investigationAero Commander 500 · Treasure Cay, BahamasJul 10, 1995 · N89M · Substantial damageNTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.Jul 10, 1995 · N9186J · Substantial damageNTSB MIA95GA178Accident · 2 fatalFinal reportPiper L-21A · Lorida, FLThe pilot's failure to maintain airspeed while his attention was diverted.Jul 10, 1995 · N5425V · Substantial damageNTSB FTW95RA287Accident · 3 fatalForeign investigationAerospatiale AS355F · Mexico City, MexicoJul 10, 1995 · XBDDXNTSB FTW95LA290Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · De Witt, ARThe pilot's failure to maintain airspeed and the resulting inadvertent stall/mush.Jul 10, 1995 · N210H · Substantial damageNTSB FTW95LA285Accident · 2 fatalLimited investigationFinal reportMeyer Pulsar XP · Spring Branch, TXThe pilot's improper positioning of the fuel tank selector and his failure to maintain airspeed. A factor was the pilot's diverted attention to the power loss.Jul 10, 1995 · N912XP · DestroyedNTSB FTW95FA277Accident · 4 fatalField investigationFinal reportBellanca 17-31A · Hot Springs, ARThe partial loss of engine power as a result of the disengagement of the throttle cable housing due to improper maintenance. Factors were the night condition and the lack of suitable terrain.Jul 10, 1995 · N39875 · DestroyedNTSB CHI95IA215Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Chicago, ILthe flight attendant's failure to follow procedures which resulted in her inadvertently opening the main cabin door in flight. Factors associated with the incident were: the flight attendant's fatigue due to lack of sleep and a long duty day, interference…Jul 10, 1995 · N440AM · Minor damageNTSB SEA95LA145Accident · 2 fatalLimited investigationFinal reportWheeler Kitfox V · Silvana, WAThe pilot's failure to maintain aircraft control. The emergency ballistic parachute not being deployed was a factor in the accident.Jul 9, 1995 · N24KF · DestroyedNTSB NYC95LA156Accident · No injuriesLimited investigationFinal reportSchweizer S-2-33A · Elmira, NYThe pilot's delayed decision to return to the departure airport, which resulted in insufficient gliding altitude, and the subsequent off airport landing in the trees.Jul 9, 1995 · N3622X · Substantial damageNTSB NYC95LA150Accident · No injuriesLimited investigationFinal reportCessna 172N · Stormville, NYThe reported pothole in the runway.Jul 9, 1995 · N734CG · Substantial damageNTSB NYC95LA149Accident · No injuriesLimited investigationFinal reportMooney 20E · Burlington, CTthe pilot's failure to extend the landing gear resulting in a wheels up landing. A factor relating to the accident was the inoperative gear warning horn.Jul 9, 1995 · N9296V · Substantial damageNTSB NYC95LA145Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Monogahela, PAThe failure of the pilots of the monney M20C, N2763W, and the Piper PA-28, N7416R, to see and avoid each other.Jul 9, 1995 · N2763W · 2 aircraft · DestroyedNTSB NYC95LA144Accident · 1 fatalLimited investigationFinal reportKoval Quickie II · Akron, OHthe pilot's improper maneuver during the turn to final approach, which resulted in an inadvertent stall/spin, and collision with the terrain. Factors in this accident were the pilot's lack of experience in this make and model, and his lack of recent…Jul 9, 1995 · N4372V · DestroyedNTSB NYC95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, MAthe pilot's improper preflight planning/preparation, inaccurate fuel consumption calculations and failure to refuel, resulting in fuel exhaustion and a subsequent collision with trees during the forced landing.Jul 9, 1995 · N9143Y · DestroyedNTSB NYC95IA164Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Philadelphia, PAthe pilot's failure to maintain aircraft control resulting in a collision with the water.Jul 9, 1995 · N203Q · Minor damageNTSB LAX95LA247Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Columbia, CAthe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control.Jul 9, 1995 · N1050K · Substantial damageNTSB LAX95LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rubidoux, CAthe pilot's inadequate preflight planning/preparation in that he attempted to fly an aircraft without first verifying the aircraft's gross weight and published performance capabilities.Jul 9, 1995 · N2529A · Substantial damageNTSB LAX95FA243Accident · 1 fatalField investigationFinal reportCessna 152 · Miramar, CAThe pilot's failure to maintain proper altitude (or clearance) above the terrain, while attempting to perform VFR flight in instrument meteorological conditions (IMC). Factors relating to the accident were: darkness and the adverse weather conditions.Jul 9, 1995 · N757JP · DestroyedNTSB FTW95FA278Accident · 2 fatalField investigationFinal reportNorth American T-28B · Ramah, COThe aircrew allowed the airplane's design stress limits to be exceeded.Jul 9, 1995 · N28TP · DestroyedNTSB CHI95LA214Accident · Minor injuriesLimited investigationFinal reportAvid Flyer · Auburn, KSthe pilot operating the airplane with known deficiencies. Factors included lack of recent flight experience, inadequate maintenance, and low airspeed.Jul 9, 1995 · N8031M · Substantial damageNTSB ANC95LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Kotzebue, AKFuel exhaustion due to the pilot's improper planning/decision. The unfavorable (stronger than forecast) headwind was a related factor.Jul 9, 1995 · N1426U · Substantial damageNTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.Jul 8, 1995 · N8946H · Substantial damage