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 LAX95LA287Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Chino, CAa forced landing into unsuitable terrain due to an engine failure for undetermined reasons.Aug 10, 1995 · N16CN · Substantial damageNTSB 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.Aug 10, 1995 · N14361 · Substantial damageNTSB 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.Aug 10, 1995 · N462E · Substantial damageNTSB FTW95LA344Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Monroe, LAThe student pilot's improper flare and the inadequate supervision by the flight instructor.Aug 10, 1995 · N5147T · Substantial damageNTSB DCA95RA051Accident · 65 fatalForeign investigationBoeing 737-200 · San Vicente, El SalvadorAug 10, 1995 · N125GUNTSB 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.Aug 10, 1995 · N69VZ · Substantial damageNTSB 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.Aug 10, 1995 · CGQGZ · DestroyedNTSB 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.Aug 10, 1995 · N6771Q · Substantial damageNTSB 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…Aug 10, 1995 · N890JH · DestroyedNTSB 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.Aug 10, 1995 · N731DB · DestroyedNTSB 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.Aug 10, 1995 · N9692P · Substantial damageNTSB ANC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Cordova, AKThe pilot's improper planning/decision and delayed decision to abort the takeoff.Aug 10, 1995 · N758PX · Substantial damageNTSB 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.Aug 9, 1995 · N8121K · Substantial damageNTSB 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.Aug 9, 1995 · N9216V · Substantial damageNTSB 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.Aug 9, 1995 · N2715D · Substantial damageNTSB LAX95LA284Accident · No injuriesLimited investigationFinal reportAviat A-1 · Elko, NVthe pilot's misjudged landing flare, which resulted in a hard landing.Aug 9, 1995 · N12TQ · Substantial damageNTSB 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.Aug 9, 1995 · N6657C · Substantial damageNTSB 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.Aug 9, 1995 · N830JD · Substantial damageNTSB 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.Aug 9, 1995 · N3944N · DestroyedNTSB 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.Aug 9, 1995 · N7459L · Substantial damageNTSB SEA95LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Panguitch, UTthe pilot's misjudgment of the distance from the sign post.Aug 8, 1995 · N23AF · Substantial damageNTSB NYC95LA186Accident · No injuriesLimited investigationFinal reportCessna 150E · West Addison, VTThe pilot's selection of an unsuitable landing area. A factor is a soft landing area.Aug 8, 1995 · N3992U · Substantial damageNTSB 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…Aug 8, 1995 · N3698Y · DestroyedNTSB 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.Aug 8, 1995 · N813CE · Substantial damageNTSB 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.Aug 8, 1995 · N11346 · Substantial damageNTSB 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.Aug 8, 1995 · N9055J · DestroyedNTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.Aug 8, 1995 · N9174Z · Substantial damageNTSB 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.Aug 8, 1995 · N731MK · Substantial damageNTSB ANC95LA132Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's abrupt (improper) use of the throttle.Aug 8, 1995 · N144Q · Substantial damageNTSB 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.Aug 7, 1995 · N8273M · Substantial damageNTSB 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.Aug 7, 1995 · N777FN · Substantial damageNTSB SEA95FA175Accident · 2 fatalField investigationFinal reportBeech F33A · Swan Lake, MTthe pilot's incapacitation due to a heart attack.Aug 7, 1995 · N8014R · DestroyedNTSB 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.Aug 7, 1995 · N9310S · Substantial damageNTSB 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.Aug 7, 1995 · N67597 · Substantial damageNTSB 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.Aug 7, 1995 · N2180C · Substantial damageNTSB 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.Aug 7, 1995 · N307L · Substantial damageNTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.Aug 7, 1995 · N794CF · Substantial damageNTSB 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.Aug 6, 1995 · N9111Y · Substantial damageNTSB 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.Aug 6, 1995 · N98350 · Substantial damageNTSB 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.Aug 6, 1995 · N3716G · Substantial damageNTSB 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.Aug 6, 1995 · N764AT · Substantial damageNTSB 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.Aug 6, 1995 · N444DG · Substantial damageNTSB 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.Aug 6, 1995 · N38HM · Substantial damageNTSB 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.Aug 6, 1995 · N4546J · Substantial damageNTSB 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.Aug 6, 1995 · N7980W · Substantial damageNTSB 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.Aug 6, 1995 · N4866R · DestroyedNTSB 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.Aug 6, 1995 · N7415W · DestroyedNTSB 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.Aug 6, 1995 · N1829K · Substantial damageNTSB 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.Aug 6, 1995 · N814JM · Substantial damageNTSB 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.Aug 5, 1995 · N1464U · Substantial damage