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 SEA00LA027Accident · Serious injuriesLimited investigationFinal reportBeech B-19 · Grand Coulee, WAThe pilot's failure to maintain clearance from power transmission lines. Factors include dark night conditions.Dec 2, 1999 · N4617M · DestroyedNTSB LAX00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palo Alto, CAThe failure of the pilot to properly calculate fuel consumption rate, and his improper in-flight planning to continue the flight to the destination airport instead of landing at a closer alternate airport. A factor was the pilot's inadequate aircraft control…Dec 2, 1999 · N4319Y · Substantial damageNTSB CHI00LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Raymond, NEthe pilot's lack of recent experience in the type of aircraft and type of operation, and the pilot not maintaining directional control. A finding was the glassy condition of the water.Dec 2, 1999 · N1756R · Substantial damageNTSB MIA00LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Morristown, TNThe pilot's failure to maintain directional control during the takeoff phase of a touch and go landing, and the subsequent skid off the runway and collapsed nose landing gear during the attempt to abort the takeoff.Dec 1, 1999 · N704YE · Substantial damageNTSB MIA00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe inadequate supervision of the student pilot by the pilot-in-command (CFI) for his failure to take the controls from the student and initiate a go-around earlier following the airplane drifting off the runway centerline.Dec 1, 1999 · N46946 · Substantial damageNTSB MIA00LA035Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Daytona Beach, FLThe pilot's failure to maintain directional control during an attempted go-around, and the subsequent wing tip strike of the ground and collision with a tree. A factor in the loss of control was the crosswind conditions present during the landing attempt.Dec 1, 1999 · N35RH · Substantial damageNTSB FTW00RA062Accident · 3 fatalForeign investigationCessna 182S · Tepic, MexicoDec 1, 1999 · N5439NTSB FTW00RA039Accident · 1 fatalForeign investigationBell 206-L1 · Cabinda, AngolaDec 1, 1999 · N5005BNTSB CHI00LA034Accident · No injuriesLimited investigationFinal reportTaylorcraft F-21 · Houlton, WIthe mechanic failed to torque the rod cap bolt during the major engine overhaul. Factors relating to the accident included the rough field and the collapsed landing gear.Dec 1, 1999 · N2005J · Substantial damageNTSB CHI00IA037Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Chicago, ILAn undetermined failure in the hydraulic system, which resulted in the airplane's entire braking system becoming temporarily inoperative. A factor associated with the incident was the airport terminal building that was contacted by the airplane.Dec 1, 1999 · N606AW · Minor damageNTSB SEA00LA026Accident · No injuriesLimited investigationFinal reportRockwell NA-265-65 · Seattle, WAInadequate visual lookout and clearance was not maintained. Diverted attention, dark night conditions and rain were factors.Nov 30, 1999 · N920DY · 2 aircraft · Substantial damageNTSB MIA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, FLThe pilot's failure to complete the before landing checklist and extend the landing gear, resulting in a gear up landing. A factor in the accident is the failure of the landing gear warning circuit to activate the cockpit warning horn.Nov 30, 1999 · N1818R · Substantial damageNTSB LAX00LA047Accident · No injuriesLimited investigationFinal reportBoeing 369E · Taft, CAThe fatigue failure of a second stage compressor vane due to erosion, which resulted in a catastrophic engine failure. An inadequate inspection of the compressor section by company maintenance personnel during the last 300-hour inspection was also causal in…Nov 30, 1999 · N5238C · Substantial damageNTSB NYC00LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Annapolis, MDThe pilot's failure to adequately adjust engine power to compensate for the winds on final approach.Nov 29, 1999 · N8119P · Substantial damageNTSB MIA00WA033Accident · Minor injuriesForeign investigationBeech C90B · Charallave, VenezuelaNov 29, 1999 · N568SA · Substantial damageNTSB MIA00LA031Accident · No injuriesLimited investigationFinal reportCessna 175-235 · Mint Hill, NCThe PIC's improper preflight fuel planning and preparation and the PIC's improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.Nov 29, 1999 · N7145M · Substantial damageNTSB LAX00LA046Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Sedona, AZThe pilot's inadequate compensation for the crosswind conditions and subsequent failure to maintain directional control of the airplane.Nov 29, 1999 · N3933E · Substantial damageNTSB LAX00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Surprise, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff from a short and unimproved dirt road, which resulted in an inadvertent stall/mush condition and impact with the ground.Nov 29, 1999 · N48WT · Substantial damageNTSB SEA00LA024Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Goldendale, WAThe pilot's failure to maintain directional control. A factor was a rock just off the edge of the runway surface.Nov 28, 1999 · N7243V · Substantial damageNTSB NYC00LA043Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Grove City, PAThe flight instructor's failure to maintain control of the airplane during the landing rollout.Nov 28, 1999 · N89F · Substantial damageNTSB NYC00LA042Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Discus A · Palmerton, PAThe pilot's improper decision to delay his landing. A factor related to the accident was the loss of thermal lift.Nov 28, 1999 · N117TB · Substantial damageNTSB LAX00WA042Accident · 1 fatalForeign investigationHiller UH-12E · Kaohslung, TaiwanNov 28, 1999 · B3100 · DestroyedNTSB LAX00LA045Accident · Serious injuriesLimited investigationFinal reportLewis Stewart S-51 · Aguila, AZThe jamming of a main landing gear in its wheel well for undetermined reasons.Nov 28, 1999 · N151L · Substantial damageNTSB IAD00LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Olean, NYthe loss of engine power from water-contaminated fuel due to the pilot's inadequate preflight inspection.Nov 28, 1999 · N7407J · DestroyedNTSB FTW00LA038Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Stillwater, OKThe total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.Nov 28, 1999 · N444D · Substantial damageNTSB FTW00LA037Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Hillsboro, TXThe pilot's failure to maintain directional control of the airplane during the go-around. A factor was the gust of wind.Nov 28, 1999 · N6766U · Substantial damageNTSB DEN00FA021Accident · 2 fatalField investigationFinal reportPiper PA-18-125 · Afton, WYFailure of the pilot to remove frost from the wings prior to takeoff, causing an inadvertent stall/spin on initial climbout. Factors included exceeding the aircraft's certificated gross weight, and fog conditions.Nov 28, 1999 · N1132A · DestroyedNTSB SEA00LA025Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Boise, IDFailure of the forward gear door lock pin. An inoperative landing gear door and inadequate maintenance inspection of the aircraft were factors.Nov 27, 1999 · N216SA · Substantial damageNTSB SEA00FA023Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 MK. I · Washougal, WAThe pilot's failure to ensure attainment of adequate airspeed prior to initiating a steep turn at low altitude, resulting in an accelerated stall. A factor contributing to the occurrence of the accident was the aircraft's low altitude. Factors contributing to…Nov 27, 1999 · N666XT · Substantial damageNTSB NYC00LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Coudersport, PAThe pilot's improper preflight planning and decision to attempt a takeoff with the passenger from the confined area.Nov 27, 1999 · N940B · Substantial damageNTSB NYC00LA040Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · Flushing, NYwas the use of a defective tow bar, due to the lack of an adequate inspection by contract personnel, the airlines lack of an adequate preventative maintenance program for the tow bars, and the lack of oversight by the airline on the contract personnel who…Nov 27, 1999 · N521DA · Substantial damageNTSB MIA00LA032Accident · No injuriesLimited investigationFinal reportBeech 90 · St. George, SCthe pilot's improper preflight planning/preparation and failure to ensure adequate fuel to safely complete the flight resulting in fuel exhaustion and engine failure, and his inadequate compensation for the wind that resulted a forced landing short of the…Nov 27, 1999 · N866A · Substantial damageNTSB MIA00FA030Accident · 2 fatalField investigationFinal reportBell 212 · Philadelphia, MSThe failure of the pilot and company maintenance personnel during preflight and periodic inspections to identify the signs of fretting and looseness in the "red" main rotor blade pitch change horn to main rotor blade grip attachment, resulting in the…Nov 27, 1999 · N8144M · DestroyedNTSB LAX00TA051Accident · No injuriesFinal reportde Havilland DHC-7 · Kwajalein, Marshall IslandsThe failure of the flight crew to properly execute the emergency landing gear extension procedure in response to a landing gear unsafe cockpit indication.Nov 27, 1999 · N273EP · Substantial damageNTSB NYC00WA038Accident · 4 fatalForeign investigationCessna 208 · Nairobi, KenyaNov 26, 1999 · 5YRANNTSB NYC00FA039Accident · 3 fatalField investigationFinal reportBeech S35 · Newark, NJThe pilot's failure to maintain aircraft control. Factors in the accident were failure of the horizontal situation indicator for undetermined reasons, and the pilot's use of inappropriate medication.Nov 26, 1999 · N8992M · DestroyedNTSB CHI00LA038Accident · No injuriesLimited investigationFinal reportCessna 310Q · Moline, ILthe landing gear locking mechanism was not properly locked. Factors relating to this accident were the improper rigging of the gear and the runway marker.Nov 26, 1999 · N7762Q · Substantial damageNTSB MIA00FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · Helena, ALThe pilots continued visual flight rules flight into instrument meteorological conditions resulting in his becoming spatially disoriented and loosing control of the helicopter, which resulted in an uncontrolled descent and impact with the ground.Nov 25, 1999 · N395WM · DestroyedNTSB NYC00WA062Accident · 3 fatalForeign investigationEurocopter EC-135 · Basepohl, GermanyNov 24, 1999 · DHMVB · DestroyedNTSB DEN00GA022Accident · No injuriesFinal reportBell 206 L-3 · Rifle, COa forced landing on rough, unsuitable terrain. A contributing factor was the partial loss of engine power, which resulted from improper maintenance by repair station personnel.Nov 24, 1999 · N617DE · Substantial damageNTSB CHI00LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenfield, INThe student pilot not maintaining aircraft control. A contributing factor was the student's aural perception.Nov 23, 1999 · N65668 · Substantial damageNTSB MIA00LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Defuniak Spgs, FLWas the pilot's failure to obtain a proper weather briefing resulting in his encounter with fog, his having to make a precautionary landing in a field when the aircraft became low on fuel, and the on ground collision with trees during landing roll.Nov 22, 1999 · N733AH · Substantial damageNTSB NYC00LA034Accident · Serious injuriesLimited investigationFinal reportBates Kitfox · Westminster, MDThe pilot's failure to maintain aircraft control while maneuvering.Nov 21, 1999 · N993DB · Substantial damageNTSB NYC00IA036Incident · No injuriesIncident investigationFinal reportBoeing 767-200 · Jamaica, NYTotal failure of the stabilizer control system for undetermined reasons.Nov 21, 1999 · N610UA · No damageNTSB LAX00LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hilo, HIAn oil starvation induced failure and seizure of the engine. The reasons for the oil starvation event are undetermined.Nov 21, 1999 · N4148X · DestroyedNTSB LAX00LA038Accident · 1 fatalLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Avalon, CAThe pilot's in-flight loss of control due to physical incapacitation from sudden cardiac death secondary to an acute myocardial infarction.Nov 21, 1999 · N97CC · DestroyedNTSB IAD00LA007Accident · No injuriesLimited investigationFinal reportCessna 172XP · Phillipi, WVThe pilot's improper flare that resulted in a hard landing.Nov 21, 1999 · N758LR · Substantial damageNTSB DEN00LA020Accident · No injuriesLimited investigationFinal reportCessna 210D · Sheridan, WYThe partial failure of the engine driven hydraulic pump.Nov 21, 1999 · N3928Y · Substantial damageNTSB ANC00LA014Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Juneau, AKAn inadvertent stall. Factors in the accident were the instructor pilot's excessive angle of climb, and gusty wind conditions.Nov 21, 1999 · N5730G · Substantial damageNTSB NYC00LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe flight instructor's delay in remedial action.Nov 20, 1999 · N17883 · Substantial damage