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 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW00RA062Accident · 3 fatalForeign investigationCessna 182S · Tepic, MexicoNTSB FTW00RA039Accident · 1 fatalForeign investigationBell 206-L1 · Cabinda, AngolaNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB MIA00WA033Accident · Minor injuriesForeign investigationBeech C90B · Charallave, VenezuelaNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC00LA043Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Grove City, PAThe flight instructor's failure to maintain control of the airplane during the landing rollout.NTSB 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.NTSB LAX00WA042Accident · 1 fatalForeign investigationHiller UH-12E · Kaohslung, TaiwanNTSB LAX00LA045Accident · Serious injuriesLimited investigationFinal reportLewis Stewart S-51 · Aguila, AZThe jamming of a main landing gear in its wheel well for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB NYC00WA038Accident · 4 fatalForeign investigationCessna 208 · Nairobi, KenyaNTSB 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.NTSB 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.NTSB 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.NTSB NYC00WA062Accident · 3 fatalForeign investigationEurocopter EC-135 · Basepohl, GermanyNTSB 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.NTSB CHI00LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenfield, INThe student pilot not maintaining aircraft control. A contributing factor was the student's aural perception.NTSB 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.NTSB NYC00LA034Accident · Serious injuriesLimited investigationFinal reportBates Kitfox · Westminster, MDThe pilot's failure to maintain aircraft control while maneuvering.NTSB NYC00IA036Incident · No injuriesIncident investigationFinal reportBoeing 767-200 · Jamaica, NYTotal failure of the stabilizer control system for undetermined reasons.NTSB 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.NTSB 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.NTSB IAD00LA007Accident · No injuriesLimited investigationFinal reportCessna 172XP · Phillipi, WVThe pilot's improper flare that resulted in a hard landing.NTSB DEN00LA020Accident · No injuriesLimited investigationFinal reportCessna 210D · Sheridan, WYThe partial failure of the engine driven hydraulic pump.NTSB 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.NTSB NYC00LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe flight instructor's delay in remedial action.