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 ATL92IA113Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-1 · Atlanta, GAThe overheating of the number 2 air cycle machine which resulted in an emergency evacuation via slides; the failure of the flight attendants to secure the slide girt bars.Jun 2, 1992 · N718DA · No damageNTSB NYC92FA093Accident · 3 fatalField investigationFinal reportCessna 172N · Brookeville, MDImproper inflight planning/decision by the flight instructor (pic/cfi) in the Cessna 172, his misjudgement of distance between the two airplanes, and inadequate visual lookout by both pilots in the Cessna 172.Jun 1, 1992 · N738YV · 2 aircraft · DestroyedNTSB LAX92LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Delano, CAThe failure of the student pilot to adequately compensate for gusting cross wind conditions and his failure to maintain directional control during the landing roll.Jun 1, 1992 · N68342 · Substantial damageNTSB FTW92FA145Accident · 4 fatalField investigationFinal reportBellanca 17-30A · El Campo, TXThe pilot's failure to maintain adequate airspeed.Jun 1, 1992 · N8230R · DestroyedNTSB CHI92LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Round Lake, ILThe pilot-in-command's failure to follow emergency procedures, and the fire in the electrical system for reasons undetermined.Jun 1, 1992 · N812PC · DestroyedNTSB CHI92DTK02Accident · No injuriesFinal reportWeatherly 201C · Timber Lake, SDThe pilot's improper use of the propeller control during takeoff and initial climb.Jun 1, 1992 · N1290W · DestroyedNTSB ATL92LA122Accident · No injuriesLimited investigationFinal reportAirship Industries Airship 600 · Weeksville, NCThe improper installation of the elevator control cables by repair facility maintenance personnel, the inspector's inadequate inspection of the maintenance accomplished, and his failure to follow delineated procedures. An additional cause was the inadequate…Jun 1, 1992 · N600LP · Substantial damageNTSB ATL92FA111Accident · 1 fatalField investigationFinal reportCessna 152 · Lake Waccamaw, NCThe failure of the pilot to follow proper procedures while operating the aircraft in weather conditions favorable to carburetor icing. A factor in the accident was the weather condition, which was favorable for the formation of carburetor ice.Jun 1, 1992 · N757VN · Substantial damageNTSB ANC92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Alexander Creek, AKThe pilot's failure to maintain directional control during landing flare/touchdown. A factor relating to the accident was the crosswind weather condition.Jun 1, 1992 · N7475K · Substantial damageNTSB MIA92LA128Accident · 2 fatalLimited investigationFinal reportCessna A150L · Cocoa Beach, FLDescent into the ocean for undetermined reasons.May 31, 1992 · N106DM · DestroyedNTSB LAX92LA248Accident · No injuriesLimited investigationFinal reportCessna 172L · Safford, AZThe airplane colliding with animals which ran on to the runway during the pilot's takeoff roll. A factor in this accident was the pilot not being able to take remedial action and avoid the animals.May 31, 1992 · N4163L · Substantial damageNTSB LAX92LA228Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Strawberry, AZThe pilot committed suicide due to the pilot's emotional state from interpersonal relations.May 31, 1992 · N9645B · DestroyedNTSB LAX92LA225Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus A/16.6 · Tucson, AZThe inflight disconnection of the right aileron 'otellier coupler fitting due to lubricants on the coupler slide lock plate, and the failure of the glider manufacturer to include appropriate precautionary information in the maintenance and/or flight manual.…May 31, 1992 · N8KS · DestroyedNTSB FTW94LA288Accident · 1 fatalLimited investigationFinal reportBeech 35-C33 · Lake City, COFlight by the pilot into adverse weather conditions, and his subsequent loss of aircraft control due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument experience.May 31, 1992 · N2742T · DestroyedNTSB CHI92DCD06Accident · Minor injuriesFinal reportRonnie Baker BEE 2 · Lake Mills, IAExcessive taxispeed and inadvertent liftoff at an airspeed below stalling speed by the pilot in command.May 31, 1992 · N5141B · Substantial damageNTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.May 31, 1992 · N211CL · DestroyedNTSB ATL92LA114Accident · No injuriesLimited investigationFinal reportHopkins, R. And M. Protech PT-2 · Landrum, SCThe failure of the pilot to maintain aircraft control during the landing attempt. Factors were the inadequate climb capability of the aircraft and the pilot's lack of familiarity with the aircraft.May 31, 1992 · N523MH · Substantial damageNTSB ATL92LA110Accident · 1 fatalLimited investigationFinal reportWicks Bobcat · White House, TNThe pilot/owner's improper design change of the wing spar which resulted in the overload failure of the left wing. A factor was the pilot/owner's failure to perform a periodic inspection.May 31, 1992 · N9CK · DestroyedNTSB SEA92LA220Accident · No injuriesLimited investigationFinal reportBellanca 7ACA · Rosalia, WAFailure of the tailwheel spring bracket. A factor to the accident was: directional control was not maintained.May 30, 1992 · N9159L · Substantial damageNTSB SEA92LA117Accident · No injuriesLimited investigationFinal reportCessna 172L · Yakima, WAThe pilot's failure to maintain the proper descent rate and inadequate remedial action.May 30, 1992 · N7583G · Substantial damageNTSB SEA92LA112Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Wenatchee, WAThe pilot in command's inadequate visual lookout. Factors contributing to the accident were: object (fence post) and windshield dirty (foggy)May 30, 1992 · N86239 · Substantial damageNTSB SEA92LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Pleasant, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: weather (gusts) and terrain (berm).May 30, 1992 · N108ES · Substantial damageNTSB MIA92FA127Accident · 1 fatalField investigationFinal reportCessna 172-H · Clewiston, FLThe failure of the pilot-in-command (student pilot) to maintain an airspeed above stall, and his inadvertent stall and spin.May 30, 1992 · N3793R · DestroyedNTSB LAX92LA240Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Lone Pine, CAThe pilot did not abort the takeoff in time to avoid the on ground collision with the fence and creek bank.May 30, 1992 · N3349L · Substantial damageNTSB LAX92LA224Accident · No injuriesLimited investigationFinal reportHughes 369D · Volcanoes Ntl P, HIThe total loss of engine power due to a failure of the number 8 bearing. The bearing failure was caused by a lack of engine oil supply and inadequate maintenance.May 30, 1992 · N1100A · Substantial damageNTSB FTW92LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which the ensuing forced landing could be executed.May 30, 1992 · N6808Q · Substantial damageNTSB CHI92DCG02Accident · No injuriesFinal reportA. H. Gettings Glassair SH2 · Marshall, MOThe pilot's inadequate pre-takeoff flight control check.May 30, 1992 · N18KG · DestroyedNTSB ANC92LA082Accident · Minor injuriesLimited investigationFinal reportChampion 7GCB · Snow Lake, AKThe pilot's failure to keep the aircraft on the step and he allowed it to become airborne. The pilot subsequently lost depth perception, and his failure to maintain proper rate of descent, resulting in a hard landing and collapse of the float landing gear. A…May 30, 1992 · N9897Y · Substantial damageNTSB SEA92LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Monarch, MTThe pilot in command's disregard of the weather forecast and failure to maintain clearance with trees/terrain. Factors contributing to the accident were: hilly/mountainous terrain, weather conditions: rain, low ceilings and downdrafts, trees and the pilot in…May 29, 1992 · N6434R · DestroyedNTSB CHI92DTG01Accident · Serious injuriesFinal reportPiper PA-25-235 · Gardner, NDAn inadvertent stall with insufficient altitude for recovery.May 29, 1992 · N6541Z · Substantial damageNTSB BFO92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Danbury, CTThe national transportation safety board determines the probable cause of the accident was the pilot misjudged distance and altitude which resulted in an overrun of the runway.May 29, 1992 · N94RC · Substantial damageNTSB ATL92FA109Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Winnsboro, SCThe inadvertent flight into instrument meteorological conditions by the pilot. The dark night and fog were factors in the accident.May 29, 1992 · N5806K · DestroyedNTSB MIA92LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Miami, FLTotal loss of engine power due to improper placement of the fuel selector by the pilot-in-command following partial loss of engine power due to partial blockage of a fuel line. Contributing to the accident was the dark night condition and improper maintenance…May 28, 1992 · N5830U · Substantial damageNTSB LAX92TL#07Accident · No injuriesClass 3Final reportEnstrom F-28C · Oakland, CAMay 28, 1992 · N120PD · Substantial damageNTSB LAX92LA222Accident · No injuriesLimited investigationFinal reportCessna 182K · Lancaster, CAThe pilot's poor judgement in attempting flight with a known deficiency with the airplane engine's ability to produce power. The loss of engine power for undetermined reasons was a factor.May 27, 1992 · N2867R · Substantial damageNTSB LAX92LA221Accident · No injuriesLimited investigationFinal reportCessna 182E · Lone Pine, CAThe pilot's encounter with a sudden and strong quartering tailwind after landing on a short dirt runway, and the failure of the pilot to select the other airport runway, which was longer and more aligned with the wind, for the approach and landing.May 27, 1992 · N9340X · Substantial damageNTSB LAX92FA220Accident · 2 fatalField investigationFinal reportBeech S-35 · Avalon, CA1) Improper preflight planning, 2) the pilots selection of the wrong runway for departure which put the aircraft immediately in an area of restricted visibility and fog after liftoff, 3) the pilots intentional flight into instrument conditions, and 4) his…May 27, 1992 · N5874S · DestroyedNTSB BFO92LA079Accident · Minor injuriesLimited investigationFinal reportRichard N. Burns KR-2 · Middletown, DEThe pilot's lack of familiarity with the aircraft and his inadequate handling of the aircraft.May 27, 1992 · N183RB · DestroyedNTSB BFO92LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Middlesex, NYThe nose over of the aircraft during landing. A factor contributing to the accident was rough terrain.May 27, 1992 · N8569U · Substantial damageNTSB BFO92LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnstown, NYThe pilot misjudged altitude and distance which resulted in a landing undershood. Contributing to the accident was night conditions.May 27, 1992 · N9541M · Substantial damageNTSB LAX92LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Butte City, CAThe pilot's failure to follow normal procedures by selecting the wrong runway. Contributing to this accident was the pilot's premature lift off and the existing tailwind.May 26, 1992 · N6596K · Substantial damageNTSB FTW92LA141Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Graford, TXLoose jam nut on throttle cable. Factors were inadequate annual inspection and unsuitable terrain and water.May 26, 1992 · N9742E · Substantial damageNTSB DEN92LA054Accident · No injuriesLimited investigationFinal reportCessna T210H · Boulder, COPower loss due to low fuel pump pressure and a chafed upper deck reference line. A factor was: the pilot's inability to maintain directional control due to a partially extended main landing gear.May 26, 1992 · N57AB · Substantial damageNTSB ATL92LA112Accident · No injuriesLimited investigationFinal reportCessna 210F · Manteo, NCThe pilot's inadequate emergency procedures, in that he failed to note the discharge of electrical power on the ammeter, and his loss of directional control during the off airport landing. Factors were the disabled alternator and a low cloud ceiling.May 26, 1992 · N5811F · Substantial damageNTSB ANC92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Heiden, AKEngine power loss for undetermined causes. Contributing to the accident was the unsuitable terrain.May 26, 1992 · N3558M · Substantial damageNTSB SEA92LA118Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Deer Park, WAThe inadvertent activation of flight spoilers by the pilot and his failure to maintain airspeed, resulting in loss of control during takeoff. A factor relating to the accident was the presence of an irrigation sprinkler that was impacted by the aircraft…May 25, 1992 · N28CL · Substantial damageNTSB LAX92LA223Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Groveland, CAThe pilot's inadvertent placement of the landing gear selector in the up position during the initial portion of the landing rollout.May 25, 1992 · N2824F · Substantial damageNTSB LAX92LA218Accident · 1 fatalLimited investigationFinal reportWillis Homebuilt Gyrocopter · Adelanto, CAA loss of control for undetermined reasons.May 25, 1992 · UNREG · DestroyedNTSB CHI92DEV02Accident · Minor injuriesFinal reportSchweitzer Mustang II · Decatur, ILThe pilot's delay in initiating a go-around.May 25, 1992 · N91ES · Substantial damageNTSB BFO92LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Westhampton Bch, NYThe pilot's inadequate landing flare which resulted in a hard landing. Contributing was the pilot's failure to maintain directional control and inadequate supervision.May 25, 1992 · N15109 · Substantial damage