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 ANC01LA024Accident · No injuriesLimited investigationFinal reportMaule M-5 · King Salmon, AKThe loss of engine power during the landing approach due to the pilot's inadequate preflight of the airplane and contamination (water) in the carburetor.NTSB LAX01FA059Accident · 1 fatalField investigationFinal reportDehavilland DHC-6 · Sacramento, CAThe passenger committed suicide.NTSB DEN01FA027Accident · 1 fatalField investigationFinal reportMooney M20K · Ogden, UTthe pilot's inadvertent VFR flight into IMC, which resulted in a collision with mountainous terrain. Contributing factors were the blowing snow, turbulence, dark night light conditions, and pilot fatigue due to the long flight day.NTSB CHI01LA048Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Harrisburg, ILThe pilot not attaining the proper glidepath on the instrument approach. The pilot's decision not to fly to an alternate airport and his decision to continue the approach in weather conditions below the published minimums were contributing factors.NTSB NYC01FA056Accident · 1 fatalField investigationFinal reportCessna 310Q · Chesterfield, NHThe pilot's continued flight into icing conditions, and his failure to use alternate air. A factor was the icing conditions.NTSB MIA01WA045Accident · 3 fatalForeign investigationBell 47(Soloy) · Buga, ColombiaNTSB MIA01LA040Accident · No injuriesLimited investigationFinal reportCessna 421B · Pensacola, FLThe failure of the left main landing gear scissors washer during taxi for takeoff, and collapse of the left main landing gear. A factor in the accident was the failure of unknown maintenance personnel to comply with a manufacturers service letter concerning…NTSB MIA01FA043Accident · 1 fatalField investigationFinal reportPiper PA-31-325 · Belvidere, NCThe pilot's failure to maintain airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions resulting in the airplane entering a descending turn and crashing into terrain.NTSB MIA01FA041Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · Weston, FLAn inflight loss of control by both pilots while maneuvering, which resulted in an inverted flat spin, an uncontrolled descent, and an impact with terrain/water. A factor contributing to the accident was the failure of both pilots to ensure that the…NTSB LAX01LA058Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe pilot-in-command's inadequate supervision of the second pilot and delay taking control of the aircraft and implementing remedial action. A factor in the accident was the second pilot's interference with the pilot-in-command's operation of the collective…NTSB DEN01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Leadville, COthe student pilot's failure to maintain directional control during landing roll. A contributing factor was the snow bank next to the runway.NTSB CHI01IA046Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-31 · Chicago, ILFailure of the captain to maintain clearance from the other airplane that was stopped. Factors relating to this accident were the snow-covered taxiways and the ground controller disregarding the captain's warning of the unsafe/hazardous situation of being…NTSB ANC01LA023Accident · No injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe failure of a mechanic to ensure the throttle linkage was secure. A factor in the accident was the pilot's failure to take remedial action during an emergency landing and overrun.NTSB FTW01LA040Accident · No injuriesLimited investigationFinal reportCartercopter Model 1 · Olney, TXThe pilot's delay in lowering the collective during a run-on landing, which resulted in a runway overrun. A factor was the muddy terrain.NTSB DEN01LA031Accident · No injuriesLimited investigationFinal reportCessna R182 · Broomfield, COthe flight instructor's inadequate supervision of the dual student, which resulted in a hard landing. Contributing factors were the dual student flaring the airplane prematurely, resulting in an inadvertent stall/mush.NTSB DEN01LA022Accident · No injuriesLimited investigationFinal reportCessna 210C · Boulder, COTotal loss of engine power due to fuel contamination (water), and failure of the pilot to have the airplane completely refueled. A factor was unsuitable terrain on which to make a forced landing.NTSB LAX01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 172H · San Diego, CAThe pilot's inadequate preflight planning and weather evaluation that resulted in the inadvertant entry into instrument meteorological conditions while conducting visual flight. A factor was fog and the night visual conditions.NTSB LAX01GA057Accident · 1 fatalFinal reportCessna 182P · Lancaster, CAthe pilot's in-flight loss of control for undetermined reasons.NTSB CHI01IA047Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Cloud, MNthe fatigue failure of the propeller blade during the initial takeoff climb. The failure was a result of a material defect, which occurred during the manufacturing process and the manufacturers failure to detect the defect.NTSB ATL01LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Plant City, FLThe loss of engine power due to fuel starvation resulting from the separation of the mixture control cable from the carburetor. Factors were cows, rough and uneven terrain.NTSB ANC01IA022Incident · Minor injuriesIncident investigationFinal reportBoeing 747-422 · Port Heiden, AKAn encounter with severe turbulence while in cruise flight. Factors in the incident were a delay in notification of the turbulence, and the lack of controller/pilot data link communications in the Anchorage ARTCC area.NTSB MIA01LA039Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Marathon, FLThe certified flight instructors disregard of an FAA weather forecast stating VFR flight not recommended resulting in VFR flight into known instrument flight conditions, loss of aircraft control due to spatial disorientation, and subsequent in-flight descent…NTSB FTW01RA035Accident · 6 fatalForeign investigationCessna U206G · Sumacal, BoliviaNTSB ATL01WA015Accident · 2 fatalForeign investigationPiper PA-28-160 · Alaj Uela, Costa RicaNTSB SEA01LA029Accident · No injuriesLimited investigationFinal reportKaman K-1200 · Prineville, ORThe pilot's failure to adequately compensate for wind conditions.NTSB LAX01FA055Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's improper IFR procedure, failure to maintain course alignment, and use of a nonapproved handheld GPS receiver for navigation during flight in actual instrument meteorological conditions. Factors contributing to the accident were the low clouds and…NTSB FTW01LA034Accident · Minor injuriesLimited investigationFinal reportEvans Varieze · Ingleside, TXthe loss of control during takeoff initial climb due to the binding rudder, which restricted the pilot's control of the aircraft.NTSB FTW01FA033Accident · 2 fatalField investigationFinal reportCessna 421B · Norman, OKthe pilot's failure to follow the instrument approach procedure and his continued descent below the prescribed minimum descent altitude (MDA). Contributory factors were the pilot's physical impairment from drugs, the low ceiling, fog, and dark night light…NTSB NYC01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20J · Trenton, NJThe flight instructor's improper decision to allow his student to land in close proximity to a hovering helicopter.NTSB NYC01LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Sterling, KYThe student pilot's inadequate recovery from a bounced landing.NTSB MIA01LA038Accident · No injuriesLimited investigationFinal reportGrob G102 · Clermont, FLThe pilot's premature extension of the speed brakes on landing resulting in the glider colliding with trees short of the runway.NTSB DEN01LA020Accident · Serious injuriesLimited investigationFinal reportThomas VP-1 · West Jordan, UTthe lack of suitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the pilot to adjust the manual propeller pitch to permit the engine to achieve sufficient rpm for sustained flight, and the…NTSB DEN01FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Antimony, UTthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his VFR flight into IMC, lack of instrument certification, spatial disorientation, low ceiling, and snow.NTSB CHI01LA045Accident · No injuriesLimited investigationFinal reportLarson Aero COMP-6 · Brainerd, MNThe pilot's inadequate preflight of the airplane which resulted in fuel exhaustion. Factors associated with the accident were the loose fuel cap and the snow covered terrain.NTSB NYC01LA054Accident · Serious injuriesLimited investigationFinal reportEmbraer 120RT · Charleston, WVDeer on the runway. Factors included reduced visibility due to nighttime lighting and light snow conditions, breaches in the perimeter fence, increased seasonal deer activity, and the rural location of the airport.NTSB LAX01LA061Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-BA · Henderson, NVThe pilot misjudged his practice approach into a remote pinnacle landing site, dragging a skid across a rock resulting in a hard landing.NTSB SEA01WA028Accident · 1 fatalForeign investigationCessna 182N · Tofino, CanadaNTSB SEA01LA027Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Gleneden Beach, ORThe pilot's excessive application of main wheel brakes. Factors include the pilot's failure to maintain directional control and his inadequate remedial action during his attempt to regain control.NTSB MIA01LA037Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with known wires along the swath run, and a loss of directional control on landing roll due to flight control damage sustained during the in-flight…NTSB MIA01LA036Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Clarksville, FLThe pilot's delay in aborting a takeoff after hitting a soft spot (sand) in the runway resulting in the airplane going off the end of the runway and colliding with trees. Contributing to the accident was the pilots decision to attempt the flight in an over…NTSB FTW01LA032Accident · 1 fatalLimited investigationFinal reportSmith Team Tango 2 · Dry Creek, LAthe pilot's VFR flight into IMC while in cruise, which resulted in his loss of control of the airplane due to spatial disorientation. Contributing factors were the clouds, and icing weather conditions, and the inadequate weather briefing.NTSB DEN01TA019Accident · No injuriesFinal reportHughes 369D · Montrose, COthe foreign object damage to a main rotor blade, while maneuvering.NTSB SEA01LA026Accident · No injuriesLimited investigationFinal reportCessna 150C · Pacific City, ORThe pilot's failure to maintain aircraft control during the landing roll. Factors include a higher than normal approach speed.NTSB NYC01LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Danbury, CTWater/ice in the fuel system and the pilot's inadequate preflight inspection.NTSB NYC01FA053Accident · 3 fatalField investigationFinal reportRobinson R-44A · Sandgap, KYthe pilot's improper weather evaluation, and his failure to maintain terrain clearance while operating over unlighted terrain at night. Factors were the isolated areas of fog, and night conditions.NTSB LAX01LA053Accident · No injuriesLimited investigationFinal reportHughes 269C · Carlsbad, CAThe CFI's inadequate supervision and failure to maintain control of the helicopter during a practice autorotation. A contributing factor was the student's improper in-flight planning/decision.NTSB IAD01WA018Accident · No injuriesForeign investigationRobinson R-22 · Bolzano, ItalyNTSB SEA01LA025Accident · No injuriesLimited investigationFinal reportCessna A185F · Lynwood, WAFuel exhaustion due to refueling was not performed by the pilot-in-command. Trees and a fence were factors.NTSB NYC01WA048Accident · 4 fatalForeign investigationPiper PA-28R-200 · Lambourne, United KingdomNTSB NYC01LA050Accident · 1 fatalLimited investigationFinal reportMiller Slingshot · Kingwood, WVThe pilot's failure to maintain control of the airplane, and subsequent collision with trees.