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 FTW91LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe pilot's failure to maintain airspeed and altitude on final approach.Mar 6, 1991 · N7120R · Substantial damageNTSB CHI91LA105Accident · No injuriesLimited investigationFinal reportCessna 401 · St. Louis, MOThe landing gear locking mechanism (bell crank) had fractured.Mar 6, 1991 · N401RW · Substantial damageNTSB NYC91LA082Accident · Minor injuriesLimited investigationFinal reportLatham Pitts Special S-1C · Glens Falls, NYA loss of control on the ground due to the improper operation of flight controls by the pilot. A factor related to the accident was the variable wind.Mar 5, 1991 · N98RL · DestroyedNTSB FTW91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Leander, TXThe pilot's failure to maintain a proper descent rate during the final approach.Mar 5, 1991 · N9190A · Substantial damageNTSB DEN91FA051Accident · 2 fatalField investigationFinal reportBeech 58 · Whites City, NMThe pilot's inflight decision to fly at low altitude. Factors were: turbulence and downdrafts.Mar 5, 1991 · N2019V · DestroyedNTSB CHI91LA107Accident · No injuriesLimited investigationFinal reportBeech 55 · Forest Lake, MNAn aborted landing not performed by the pilot. Factors related to the accident were a runway that was wet and ice covered.Mar 5, 1991 · N29SF · Substantial damageNTSB BFO91LA029Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Chesapeake, VAThe pilot's failure to maintain directional control. Contributing was the pilot's lack of experience.Mar 5, 1991 · N61533 · Substantial damageNTSB ATL91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNThe inadvertent stall of the aircraft, encountered as a result of the student pilot's inability to maintain the proper compensation for wind and the lack of total experience of the student pilot.Mar 5, 1991 · N4663B · Substantial damageNTSB NYC91FA080Accident · Serious injuriesField investigationFinal reportBeech F-33A · West Brookfield, MAThe decision of the pilot to fly the airplane in conditions that prevented him from seeing and avoiding higher terrain. Factors related to the accident were the pilot's decision to not follow the instrument approach into palmer, and the reduced visibility due…Mar 4, 1991 · N77Y · DestroyedNTSB MIA91LA092Accident · No injuriesLimited investigationFinal reportCessna 172K · Everglades City, FLInformation given during a weather briefing was disregarded, in-flight encounter with wind gust, and failure of the pilot to execute a go-around. Contributing to the accident was inadequate placement of a windsock which was blocked by trees resulting in an…Mar 4, 1991 · N84461 · Substantial damageNTSB BFO91LA028Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Garrisonville, VAThe pilot's failure to maintain adequate clearance with the terrain. Contributing to the accident was VFR flight into IMC.Mar 4, 1991 · N2632Z · DestroyedNTSB LAX91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe failure of the CFI aboard N25378 to adequately supervise the flight and the dual student pilot's improper use of the normal brakes.Mar 3, 1991 · N25378 · 2 aircraft · Minor damageNTSB LAX91FA116Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Monterey Park, CASuicide.Mar 3, 1991 · N5290T · DestroyedNTSB DCA91MA023Accident · 25 fatalClass 1 · MajorFinal reportBoeing 737-291 · Colorado Spgs, COA loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…Mar 3, 1991 · N999UA · DestroyedNTSB CHI91LA102Accident · 1 fatalLimited investigationFinal reportAeronca 15AC · St.Croix Falls, WIFailure to conduct a passenger safety briefing, and inadequate supervision, by the pilot in command. A factor related to the accident is the passenger's inattentiveness.Mar 3, 1991 · N1340H · No damageNTSB ANC91LA032Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Finger Lake, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the rough and uneven terrain.Mar 3, 1991 · N5349G · No damageNTSB NYC91LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PADue to failure of the induction air control/air filter/screen, which blocked airflow through the carburetor throat.Mar 2, 1991 · N2960B · DestroyedNTSB MIA91IA091Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-200 · Jacksonville, FLInadequate engine performance in the designed airplane flight envelopes.Mar 2, 1991 · CGRNU · Minor damageNTSB LAX91LA120Accident · No injuriesLimited investigationFinal reportBoeing A75 · Marana, AZThe failure of the pilot in the trailing airplane to maintain clearance from the lead airplane.Mar 2, 1991 · N803RB · 2 aircraft · Substantial damageNTSB LAX91LA119Accident · No injuriesLimited investigationFinal reportCessna 172G · Reno, NVThe pilot's improper planning/preparation decision. Factors related to the accident were the high wind condition and the pilot in commands inability to compensate for the wind condition.Mar 2, 1991 · N4417L · Substantial damageNTSB LAX91LA118Accident · Serious injuriesLimited investigationFinal reportBeech BE-77 · Carmel Valley, CAThe failure of the PIC to supervise a non-certificated pilot and to maintain adequate airspeed with subsequent collision with trees. Contributing to the accident was the failure of the PIC to obtain a weather briefing and assess hazardous wind conditions and…Mar 2, 1991 · N3846X · DestroyedNTSB LAX91LA115Accident · No injuriesLimited investigationFinal reportCessna 182P · Pacoima, CAFailure of the PIC to ensure that the fuel system was free of water prior to flight. Contributing to the accident was the inadequate compliance with airworthiness directives by maintenance personnel to preclude water from entering the fuel system.Mar 2, 1991 · N182WS · Substantial damageNTSB LAX91FA117Accident · 1 fatalField investigationFinal reportBeech 58P · Green Valley, CAThe pilot's loss of aircraft control due to his disregard for and poor evaluation of significant weather advisories forecasting adverse weather conditions along the route of flight and the pilot's decision to initiate the flight.Mar 2, 1991 · N6666Q · DestroyedNTSB DEN91FA048Accident · 1 fatalField investigationFinal reportCessna T210M · Taos, NMThe pilot's decision to initiate flight into freezing rain which resulted in structural icing that exceeded the ability of the aircraft to maintain flight. A factor was: improper deicing.Mar 2, 1991 · N761MU · DestroyedNTSB CHI91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Genesee, MIPositive liftoff airspeed was not attained, an aborted takeoff was not performed which resulted in a stall/mush descent to the terrain. Factors related to the accident were a dark raining night, soft, wet grass runway and a downwind surface wind.Mar 2, 1991 · N8026W · Substantial damageNTSB CHI91LA103Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Chicago, ILAn excessive landing flare by the copilot. Factors associated with the accident are the inoperative wing flaps and the captain's inadequate supervison.Mar 2, 1991 · N385MQ · Substantial damageNTSB NYC91LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Nashua, NHThe failure of the pilot to compensate for wind conditions during landing, resulting in a loss of control and collision with a tree.Mar 1, 1991 · N97313 · Substantial damageNTSB MIA91LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Jensen Beach, FLImproper in-flight planning decision by the pilot resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the unreliable fuel quantity indicators.Mar 1, 1991 · N5282H · Substantial damageNTSB FTW91LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Friendswood, TXThe duel student's failure to maintain directional control during the landing and his inadvertent activation of the brakes. A factor was the ditch.Mar 1, 1991 · N5524K · Substantial damageNTSB FTW91FA045Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Fort Chaffee, ARThe pilot's operation of the aircraft with known deficiencies in equipment. Factors were the improper overhaul of the engines by other maintenance personnel resulting in oil loss, deteriorated engine performance, and unsuitable terrain.Mar 1, 1991 · N7488S · DestroyedNTSB ATL91LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Suches, GAThe pilot's failure to maintain altitude during cruise flight after loss of electrical power for an undetermined reason.Mar 1, 1991 · N6546Y · DestroyedNTSB ANC91DAG01Accident · No injuriesFinal reportPiper PA-20 · Anchorage, AKThe student pilot's failure to maintain aircraft control.Mar 1, 1991 · N2636A · Substantial damageNTSB SEA91FA059Accident · 1 fatalField investigationFinal reportCessna 172 · Oregon City, ORThe pilot's failure to attain proper airspeed before takeoff. Factors relating to the accident were the binding brake, the uphill grass airstrip, the tail wind weather conditions, and the improper annual inspection that was just completed on the aircraft.Feb 28, 1991 · N7119T · DestroyedNTSB CHI91LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Springfield, MOThe pilot's poor evaluation of high wind conditions and the subsequent inability to compensate for the winds. Related to the accident was the gusty crosswind conditions.Feb 28, 1991 · N3658P · Substantial damageNTSB SEA91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Townsend, WAThe pilot's failure to maintain aircraft directional control during landing roll. Factors relating to the accident were the crosswind weather conditions and the soft terrain beside the runway.Feb 27, 1991 · N67705 · Substantial damageNTSB LAX91LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fullerton, CAThe pilot's improper preflight inspection. Contributing to this accident was water in the fuel tank.Feb 27, 1991 · N3724P · Substantial damageNTSB CHI91LA101Accident · No injuriesLimited investigationFinal reportCessna T210N · Elwood, INThe pilot's improper use of the fuel selector which resulted in fuel starvation. A related factor was: soft terrain in the emergency landing area.Feb 27, 1991 · N210MS · Substantial damageNTSB ANC91LA031Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Flat Top Mtn., AKThe pilot's failure to maintain directional control of the airplane on landing roll out in unsuitable terrain. Contributing to the accident was the rough and uneven terrain.Feb 27, 1991 · N7578F · Substantial damageNTSB LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.Feb 26, 1991 · N8290R · Substantial damageNTSB CHI91LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILFailure of the student pilot to maintain directional control during takeoff. Her lack of flying expereince was a related factor.Feb 26, 1991 · N49485 · Substantial damageNTSB SEA91LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Glasgow, MTThe loss of engine power due to carburetor icing. Factors relating to the accident were the strong winds, high obstructions in the area and tailwind conditions for landing at the only available area.Feb 25, 1991 · N7676A · Substantial damageNTSB MIA91LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Valkaria, FLThe failure of the instructor pilot to supervise the student pilot's actions, resulting in a stall at a low altitude where recovery was not possible.Feb 25, 1991 · N609FT · Substantial damageNTSB MIA91FA089Accident · 2 fatalField investigationFinal reportCessna 152 · La Belle, FLThe pilot-in-command/cfi improper supervision of the dual student. This resulted in an in flight loss of control, stall/spin, and collision with terrain for failure to maintain airspeed while maneuvering in a turn.Feb 25, 1991 · N25938 · DestroyedNTSB LAX91LA121Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Mesa, AZ1) The failure of the airplane's engine upper crankcase oil breather line; 2) total loss of engine power caused by a lack of lubricating oil. A factor in this accident was the pilot inadvertantly stalling the aircraft to avoid a collision with a wire.Feb 25, 1991 · N138WW · Substantial damageNTSB LAX91LA112Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Los Angeles, CAThe poor preflight planning performed by the pilot-in-command in accurately determining the weight and fuel consumption of the airplane which resulted in loss of engine power due to fuel exhaustion.Feb 25, 1991 · N9132X · Substantial damageNTSB FTW91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Davant, LAThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Feb 25, 1991 · N7388J · Substantial damageNTSB DEN91IA047Incident · No injuriesIncident investigationFinal reportCessna 421C · Fort Morgan, COThe total failure of the flight compartment windshield (copilot's side) for undetermined reasons.Feb 25, 1991 · N125KS · Minor damageNTSB CHI91DCJ01Accident · 1 fatalFinal reportCessna 172N · Western, NESpatial disorientation which resulted in a loss of aircraft control. A factor related to the accident was VFR flight into IMC.Feb 25, 1991 · N738LL · DestroyedNTSB MIA91LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Everglades City, FLInadequate supervision by the flight instructor. Factors were: dark night condition, penetration of a cloud, and spatial disorientation resulting in a spiral.Feb 24, 1991 · N1469Q · Substantial damageNTSB BFO91LA025Accident · 1 fatalLimited investigationFinal reportCessna 182C · Bonnyman, KYThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.Feb 24, 1991 · N8696T · Destroyed