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.
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
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 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.NTSB 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.NTSB 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.NTSB FTW92FA145Accident · 4 fatalField investigationFinal reportBellanca 17-30A · El Campo, TXThe pilot's failure to maintain adequate airspeed.NTSB 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.NTSB CHI92DTK02Accident · No injuriesFinal reportWeatherly 201C · Timber Lake, SDThe pilot's improper use of the propeller control during takeoff and initial climb.NTSB 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…NTSB 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.NTSB 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.NTSB MIA92LA128Accident · 2 fatalLimited investigationFinal reportCessna A150L · Cocoa Beach, FLDescent into the ocean for undetermined reasons.NTSB 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.NTSB LAX92LA228Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Strawberry, AZThe pilot committed suicide due to the pilot's emotional state from interpersonal relations.NTSB 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.…NTSB 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.NTSB 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.NTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.NTSB 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.NTSB 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.NTSB SEA92LA220Accident · No injuriesLimited investigationFinal reportBellanca 7ACA · Rosalia, WAFailure of the tailwheel spring bracket. A factor to the accident was: directional control was not maintained.NTSB SEA92LA117Accident · No injuriesLimited investigationFinal reportCessna 172L · Yakima, WAThe pilot's failure to maintain the proper descent rate and inadequate remedial action.NTSB 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)NTSB 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).NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI92DCG02Accident · No injuriesFinal reportA. H. Gettings Glassair SH2 · Marshall, MOThe pilot's inadequate pre-takeoff flight control check.NTSB 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…NTSB 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…NTSB CHI92DTG01Accident · Serious injuriesFinal reportPiper PA-25-235 · Gardner, NDAn inadvertent stall with insufficient altitude for recovery.NTSB 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.NTSB 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.NTSB 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…NTSB LAX92TL#07Accident · No injuriesClass 3Final reportEnstrom F-28C · Oakland, CANTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB BFO92LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Middlesex, NYThe nose over of the aircraft during landing. A factor contributing to the accident was rough terrain.NTSB 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.NTSB 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.NTSB FTW92LA141Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Graford, TXLoose jam nut on throttle cable. Factors were inadequate annual inspection and unsuitable terrain and water.NTSB 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.NTSB 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.NTSB ANC92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Heiden, AKEngine power loss for undetermined causes. Contributing to the accident was the unsuitable terrain.NTSB 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…NTSB 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.NTSB LAX92LA218Accident · 1 fatalLimited investigationFinal reportWillis Homebuilt Gyrocopter · Adelanto, CAA loss of control for undetermined reasons.NTSB CHI92DEV02Accident · Minor injuriesFinal reportSchweitzer Mustang II · Decatur, ILThe pilot's delay in initiating a go-around.NTSB 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.