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 SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.May 1, 1991 · N50488 · Substantial damageNTSB NYC91LA124Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Oxford, CTThe failure of the pilot to maintain the proper landing descent rate and the resultant right main landing gear assembly collapse.May 1, 1991 · N445BL · Substantial damageNTSB LAX91LA189Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Fresno, CAThe pilot-in-command's failure to maintain directional control and inadequate compensation for wind conditions during the landing touchdown. Contributing to the accident was the pilot-in-command's overconfidence in his ability while analyzing the forecast…May 1, 1991 · N2578L · Substantial damageNTSB FTW91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Longview, TXFuel exhaustion resulting in a complete power loss due to the pic/cfi's failure to refuel at intermediate destinations.May 1, 1991 · N29049 · Substantial damageNTSB DEN91LA066Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Englewood, COPower loss on both engines as a result of exhaust system failure.May 1, 1991 · N18DF · Substantial damageNTSB DEN91FA065Accident · 1 fatalField investigationFinal reportPiper PA-31B-310 · Bennett, COIn-flight separation of the left engine cowl assembly that was not properly latched, and failure of the pilot to maintain minimum control speed, which resulted in his loss of aircraft control. Factors related to the accident were: an inadequate preflight…May 1, 1991 · N7407L · DestroyedNTSB BFO91LA046Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Christiansburg, VAInadequate maintenance. Contributing was an obstructed air filter.May 1, 1991 · N6632T · Substantial damageNTSB ATL91LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Hampton, GAThe pilot's improper flare and his failure to execute an abort in a timely manner when a safe landing was not possible. Factors in the accident were the wet grass conditions at the airstrip, and the pilot's lack of recent total flying experience.May 1, 1991 · N6301L · Substantial damageNTSB MIA91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the PA-28 pilot to maintain proper brake pressure, while diverting his attention to his notepad.Apr 30, 1991 · N150ER · 2 aircraft · Minor damageNTSB NYC91IA133Incident · No injuriesIncident investigationFinal reportBoeing 747SP · Churchville, NYA failure of the sixth rotating airseal which led to an uncontained engine failure.Apr 29, 1991 · N148UA · Minor damageNTSB LAX91LA188Accident · Serious injuriesLimited investigationFinal reportEnstrom F28C · Palm Springs, CAInadequate inspection of the fuel system resulting in an engine power loss and inflight fire due to a loose fuel connection.Apr 29, 1991 · N214MM · Substantial damageNTSB LAX91LA187Accident · No injuriesLimited investigationFinal reportBeech F33A · Goodyear, AZThe pilot's failure to ensure that the airplane's landing gear was extended by the passenger who he was allowing fly the airplane. A contributing factor related to the pilot's inadequate supervision of the passenger.Apr 29, 1991 · N5585Y · Substantial damageNTSB NYC91FA123Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Hancock Village, NYThe loss of aircraft control and subsequent collision with trees after the pilot became physically incapacitated.Apr 28, 1991 · N102LW · DestroyedNTSB MIA91LA130Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Leesburg, FLThe failure of the pilot to maintain directional control during the landig roll, and his failure to maintain airspeed during the attempted go-around which resulted in a descent and collision with two parked airplanes. Contributing to the accident was the…Apr 28, 1991 · N84986 · Substantial damageNTSB LAX91LA186Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Madera, CAFailure of the pilot to maintain adequate clearance from the guy wire.Apr 28, 1991 · N5250 · DestroyedNTSB LAX91LA184Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Redlands, CAThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.Apr 28, 1991 · N53782 · Substantial damageNTSB BFO91LA045Accident · No injuriesLimited investigationFinal reportGrumman AA5B · College Park, MDThe pilot's failure to maintain aircraft control. Related factors were: hydroplaning conditions on the wet runway and the pilot's lack of recent experience.Apr 28, 1991 · N20NA · Substantial damageNTSB SEA91FA095Accident · 1 fatalField investigationFinal reportCessna 150H · Sumpter, ORThe pilot's improper inflight planning and decisions and the pilot's VFR flight into IMC conditions.Apr 27, 1991 · N970MA · DestroyedNTSB NYC91LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Jessup, PAA power loss due to oil starvation for unknown reasons, over unsuitable terrain.Apr 27, 1991 · N4930J · DestroyedNTSB NYC91LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Meadville, PAThe improper use of carburetor heat control by the pilot, which resulted in the total loss of engine power and the subsequent emergency forced landing in rough terrain. A factor relating to the accident was the lack of experience of the student pilot.Apr 27, 1991 · N739EC · Substantial damageNTSB MIA91LA129Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Winter Haven, FLFailure of the pilot to maintain directional control and improper use of the collective and cyclic flight controls after the loss of tail rotor effectiveness during the approach to land. Contributing to the accident was his lack of total experience in type…Apr 27, 1991 · N2193U · Substantial damageNTSB MIA91LA128Accident · 1 fatalLimited investigationFinal reportDonald L. Hedeman SONERAI-II · Jacksonville, FLThe pilot's improper adjustment of the carburetor.Apr 27, 1991 · N4FD · Substantial damageNTSB MIA91LA127Accident · No injuriesLimited investigationFinal reportTravel Air 2000 · Homestead, FLAn on ground encounter with weather conditions that were favorable for carburetor icing at a low power setting (glide power), and failure of the pilot to abort the takeoff after recognizing that the eng was not developing full power during the initial climb.Apr 27, 1991 · N1572 · Substantial damageNTSB LAX91LA185Accident · No injuriesLimited investigationFinal reportCessna 182B · Arvin, CA1) The pilot inadequately compensated for wind conditions; 2) the pilot's improper inflight decision; and 3) the pilot not attaining the proper landing touchdown point.Apr 27, 1991 · N7220E · Substantial damageNTSB LAX91LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Grass Valley, CAThe failure of the pilot to maintain directional control and to adequately compensate for the wind conditions resulting in an on ground loss of control and subsequent on ground collision with a drainage ditch.Apr 27, 1991 · N737GY · Substantial damageNTSB FTW91LA064Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Corpus Christi, TXThe initial restricted movement and eventual locking of the cyclic control as a result of the failure of the lateral servo. A factor was the installation of the failed component by an unqualified person.Apr 27, 1991 · N1195W · DestroyedNTSB SEA91LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Vernal, UTThe pilot's impairment due to alcohol consumption and his failue to control the airplane during landing.Apr 26, 1991 · N40LT · Substantial damageNTSB CHI91LA145Accident · No injuriesLimited investigationFinal reportAeronca 7EC · O'Neill, NEThe pilot's selection of unsuitable terrain for a precautionary landing. Factors were the pilot's disregarding the weather briefing and his intentional flight into adverse weather.Apr 26, 1991 · N4652E · Substantial damageNTSB CHI91LA141Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Evansville, WIThe pilot's selection of unsuitable terrain for landing, not maintaining directional control and attempting a go-around without sufficient airspeed. A factor was the rutted runway surface.Apr 26, 1991 · N61978 · Substantial damageNTSB CHI91LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hibbing, MNThe student pilot's improper flare of the airplane and the cfi's failure to maintain directional control during the recovery. A factor was the soft terrain.Apr 25, 1991 · N95406 · Substantial damageNTSB CHI91LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Detroit, MIThe proper touchdown point was not attained and the pilot failed to perform a go around. A factor related to the accident was the tailwind condition in which the pilot was attempting to land.Apr 25, 1991 · N66717 · Substantial damageNTSB CHI91IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Chicago, ILThe failure of the ground crew to properly align the airplane in the gate alley during the push back from the gate.Apr 25, 1991 · N6815 · Minor damageNTSB CHI91FA140Accident · 1 fatalField investigationFinal reportCessna P210 · Kansas City, MOThe pilot in command's intentional flight with known mechanical deficiencies in the aircraft which resulted in a fire & forced landing in unsuitable terrain. A factor contributing to the accident was improper maintenance to the turbocharger waste gate by…Apr 25, 1991 · N65M · DestroyedNTSB ATL91LA088Accident · 1 fatalLimited investigationFinal reportCessna 150J · Kure Beach, NCThe pilot's poor judgement, while impaired by alcohol, and his misjudgement of altitude/clearance above the water after initiating a low pass.Apr 25, 1991 · N50738 · DestroyedNTSB MIA91FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-24-260 · Missing, FLUndetermined.Apr 24, 1991 · N8938P · DestroyedNTSB CHI91LA143Accident · No injuriesLimited investigationFinal reportCessna 170A · Newell, SDThe pilot's improper aircraft handling.Apr 24, 1991 · N5720C · Substantial damageNTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.Apr 24, 1991 · N2409J · Substantial damageNTSB NYC91FA120Accident · 1 fatalField investigationFinal reportPiper J5A · Newbury, MAThe loss of inflight control, which was the result of a jammed right aileron bellcrank assembly. Factors related to the accident were; the improper maintenance of the flight control system, and the incomplete preflight by the pilot.Apr 23, 1991 · N35826 · DestroyedNTSB FTW91FA070Accident · 2 fatalField investigationFinal reportBell 206B · So. Marsh 275The inflight structural failure and separation of the vertical fin which led to a loss of control and mast bumping. The failure of the fin was due to inadequate corrosion control efforts by the operator.Apr 23, 1991 · N213AL · DestroyedNTSB DEN91T#A01Accident · 2 fatalClass 3Final reportHughes TH-55 · Traskwood, ARApr 23, 1991 · N8127G · Substantial damageNTSB CHI91LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Millard, NEImproper use of APU by unknown personnel which resulted in the airplane's electrical wiring melting and subsequent short.Apr 23, 1991 · N5421Z · DestroyedNTSB CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.Apr 23, 1991 · N32478 · 2 aircraft · Substantial damageNTSB MIA91LA126Accident · 1 fatalLimited investigationFinal reportRudolph Zeller Lancair · Titusville, FLThe use of improper materials for construction of the alternate air door by the aircraft owner/builder resulting in failure and separation of the door which resulted in blockage of air flow to the carburetor and loss of all engine power.Apr 22, 1991 · N360R · DestroyedNTSB DEN91LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Steamboat Sprin, COThe CFI used poor judgement in giving a simulated engine failure by turning off the fuel selector valve.Apr 22, 1991 · N6231K · Substantial damageNTSB MIA91LA125Accident · 1 fatalLimited investigationFinal reportRutan Aircraft Factory Vari EZE · Panama City, FLThe pilot-in-command misjudged his altitude while conducting an aerobatic maneuver, resulting in an in flight collision with water.Apr 21, 1991 · N32F · DestroyedNTSB LAX91FA181Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Carpenteria, CA1) Inadequate weather evaluation by the pilot, 2) poor inflight decision to try and continue VMC flight, and 3) the pilot's lack of total experience.Apr 21, 1991 · N8019N · DestroyedNTSB CHI91FA135Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Wadsworth, ILThe pilot in command's failure to select the proper fuel tank and not performing emergency procedures when the engine ceased to run. A factor related to this accident was power transmissions wires located on the pilot's approach path to landing.Apr 21, 1991 · N651OP · DestroyedNTSB SEA91LA093Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Elma, WAThe pilot used inadequate starting procedures. Factors to the accident were: the pilot did not use proper assistance and the passenger's inadvertent control interference.Apr 20, 1991 · N81578 · Substantial damageNTSB SEA91LA092Accident · Minor injuriesLimited investigationFinal reportSmelser KR-2 · Spokane, WAA failure of the fuel drain valve which resulted in fuel exhaustion and a loss of engine power.Apr 20, 1991 · N570TS · Substantial damageNTSB SEA91LA091Accident · 1 fatalLimited investigationFinal reportSchwartz Bushby MM-1 · Ephrata, WAThe pilot's loss of control after he initiated a maneuver at low altitude.Apr 20, 1991 · N484N · Destroyed