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 ANC05CA122Accident · No injuriesData collectionFinal reportPiper PA-12 · Arctic Village, AKThe pilot's inadequate evaluation of the weather conditions, which resulted in an overrun and subsequent nose over during the landing roll. A factor contributing to the accident was a tailwind.NTSB LAX05FA262Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Big Bear City, CAThe pilot's failure to maintain aircraft control and adequate airspeed while executing an evasive maneuver during an aborted landing, which resulted in a cross-controlled accelerated stall and impact with terrain. Contributing to the accident was the probable…NTSB LAX05CA263Accident · No injuriesData collectionFinal reportHughes 369D · North Las Vegas, NVthe pilot's improper use of the cyclic flight control and the flight instructor's inadequate supervision of the flight.NTSB IAD05LA118Accident · No injuriesLimited investigationFinal reportBoeing 737-824 · Newark, NJThe airport's failure to install markings on a parking "block" that bordered the taxiway, which failed to provide adequate clearance between taxiing airplanes and airplanes parked in the block. Factors in the accident were air traffic control's use of the…NTSB DFW05CA211Accident · No injuriesData collectionFinal reportSchleicher ASW-27b · Encinal, TXThe pilot's misjudgment of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB ATL05FA142Accident · 1 fatalField investigationFinal reportBeech V35B · Ellijay, GAThe pilot's continued cruise flight under visual flight rules into known adverse weather, which resulted in his loss of control of the airplane due to spatial disorientation, and an uncontrolled descent and collision with terrain. A factor associated with the…NTSB ANC05CA119Accident · Minor injuriesData collectionFinal reportCessna 182 · Nabesna, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with brush, and subsequent loss of control during an aborted landing. Factors associated with the accident were high vegetation, and a jammed elevator control.NTSB SEA05LA165Accident · 1 fatalLimited investigationFinal reportCessna 120 · Chiloquin, ORThe pilot's failure to maintain airspeed and a loss of control during a pull-up maneuver. A factor contributing to the accident was the inadvertent stall/spin, which resulted in the subsequent collision with terrain.NTSB SEA05CA166Accident · No injuriesData collectionFinal reportLuscombe 8A · Otis Orchards, WAThe pilot's loss of directional control as a result of excessive braking while landing, which resulted in the nose over.NTSB NYC05LA131Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Farmingdale, NJA fire that originated at the right main landing gear brake caliper and piston, during taxi, which resulted in substantial damage to the airplane.NTSB NYC05LA130Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Nashua, NHThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion, and subsequent collision with trees during a forced landing.NTSB MIA05LA147Accident · No injuriesLimited investigationFinal reportCessna T210M · Kissimmee, FLA loss of engine power due to the pilot's inaccurate fuel consumption calculations and subsequent fuel exhaustion.NTSB LAX05LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Oro Valley, AZa loss of engine power due to the pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion. Contributing to the accident was the inaccuracy of the cockpit fuel gages which read 1/4 tank when empty.NTSB IAD05WA119Accident · 1 fatalForeign investigationReims FR172E · West Sussex, United KingdomNTSB IAD05LA116Accident · Minor injuriesLimited investigationFinal reportO'Connor Air Command Elite · Cincinnati, OHThe pilot's improper flare following a partial loss of engine power, which resulted in a hard landing. A factor was the partial loss of engine power for unknown reasons.NTSB DEN05LA123Accident · No injuriesLimited investigationFinal reportForbes Rutan Long EZE · Albuquerque, NMa total electrical failure due to a short in the master relay, causing the main fuse to open. Contributing factors included an inadequate electrical design by the airplane's builder, a low-output alternator, a cement wall, and unsuitable terrain on which to…NTSB DEN05LA121Accident · 1 fatalLimited investigationFinal reportSheel Vans RV-8 · Fort Collins, COthe pilot inadvertently stalling the airplane and descending into the ground. Contributing factors were the pilot's inadequate preflight planning/preparation and his failure to refuel the airplane, resulting in a loss of engine power due to fuel exhaustion.NTSB DEN05CA122Accident · No injuriesData collectionFinal reportStinson L-5G · Gallup, NMan on-ground loss of control due to the flight controls becoming jammed because the pilot failed to properly secure his flight bag.NTSB CHI05LA220Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Boston, ILThe loss of engine power due to a cylinder failure and the unsuitable terrain encountered by the pilot during the forced landing.NTSB CHI05LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Marshalltown, IAThe loss of engine power for an undetermined reason. A factor was the corn crop.NTSB CHI05CA215Accident · No injuriesData collectionFinal reportRosner Acro Sport II · Princeton, MNThe airplane nosed over during landing as a result of the pilot's failure to maintain control of the airplane when he applied excessive braking.NTSB CHI05CA172Accident · No injuriesData collectionFinal reportWaco CTO · Shelbyville, ILThe loss of engine power during cruise due to carburetor ice. A factor was conditions conducive to carburetor icing.NTSB ATL05LA140Accident · 2 fatalLimited investigationFinal reportAllegro 2000 · Supply, NCThe instructor pilot's failure to maintain airspeed for unknown reasons, resulting in an aerodynamic stall and subsequent collision with the ground.NTSB NYC05LA129Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Penn Yan, NYThe loss of engine power due to a fatigue fractured pushrod.NTSB MIA05LA146Accident · 1 fatalLimited investigationFinal reportGustafson Easy Eagle · Milton, FLA loss of engine power during initial climb after takeoff for an undetermined reason, which resulted in a forced landing and subsequent in-flight collision with tree-covered terrain.NTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.NTSB IAD05LA115Accident · No injuriesLimited investigationFinal reportCessna 182B · East Moriches, NYThe improper installation of the right magneto harness to the magneto housing by unidentified maintenance personnel, which resulted in arcing, significant wear, and a subsequent loss of engine power. Factors in the accident were the pilot's failure to attain…NTSB IAD05CA120Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's improper recovery from a bounced landing.NTSB DFW05FA204Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cypress, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB DEN05TA119Accident · Serious injuriesFinal reportHughes 369HS · Albuquerque, NMthe bullet(s), which severed the helicopter's left tail rotor pedal. Contributing factors were the severed anti-torque pedal and the unsuitable terrain for landing.NTSB DEN05CA120Accident · No injuriesData collectionFinal reportCessna 172RG · Fort Collins, COthe pilot's failure to maintain directional control. Contributing factors were the crosswind, the pilot's failure to compensate for the wind conditions --- allowing the airplane to touch down without being properly aligned with the runway --- and the flight…NTSB DCA05RA094Accident · 16 fatalForeign investigationATR ATR-72-202 · Palermo, ItalyNTSB CHI05WA216Accident · 2 fatalForeign investigationCessna A185F · Lake Simcoe, CanadaNTSB CHI05LA213Accident · Serious injuriesLimited investigationFinal reportWeatherly 620-B · Osage, IAThe partial loss of engine power for an undetermined reason. Contributing factors were the wires and the trees.NTSB CHI05CA232Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Blair, NEThe low airspeed by the pilot and the inadequate supervision by the certified flight instructor.NTSB ATL05FA139Accident · 1 fatalField investigationFinal reportBeech BE-D35 · Decatur, ALThe pilot's mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation, and subsequent inadvertent stall/spin during the forced landing.NTSB ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.NTSB ATL05CA138Accident · Minor injuriesData collectionFinal reportBeech C24R · Lumberton, NCThe pilot's improper/inadequate evaluation of the weather, which resulted into flight into a thunderstorm.NTSB ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.NTSB SEA05LA162Accident · 2 fatalLimited investigationFinal reportHarmon/Lance RV-4 · Coolin, IDThe pilot's failure to maintain clearance from trees while maneuvering to base leg for landing. Trees and inadequate in-flight planning were factors.NTSB SEA05LA161Accident · No injuriesLimited investigationFinal reportCessna A185F · Seattle, WALoss of engine power for undetermined reasons.NTSB SEA05FA158Accident · 2 fatalField investigationFinal reportCessna 150M · Renton, WAThe failure of the DHC-2 Beaver pilot to understand air traffic advisory information and the failure of the Cessna pilot to maintain visual separation, resulting in a midair collision. A factor contributing to the accident was the inadequate traffic advisory…NTSB SEA05CA167Accident · No injuriesData collectionFinal reportCessna 150L · Kellogg, IDThe pilot's failure to follow the correct go-around procedure during landing by advancing the power too rapidly and not repositioning the flaps to the required 20 degree position. Factors include a crosswind and high density altitude.NTSB IAD05CA117Accident · Minor injuriesData collectionFinal reportCessna C-172G · Eustis, METhe pilot's failure to maintain clearance from a bush during the aborted landing.NTSB DFW05WA221Accident · 2 fatalForeign investigationRobinson R-44 · Col de Menee, FranceNTSB CHI05LA218Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Goshen, INGround resonance experienced by the pilots.NTSB CHI05FA212Accident · Minor injuriesField investigationFinal reportCessna 421C · Wheeling, ILThe pilot's improper in-flight decision to execute a go-around without raising the landing gear and raising the flaps to the full UP position, resulting in low airspeed and the airplane stalling. Contributing factors to the accident included the pilot's…NTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.NTSB ANC05LA117Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe flight instructor's inadequate supervision of the dual student, and his failure to maintain control of the airplane. A factor associated with the accident was the dual student's excessive application of the brakes.NTSB ANC05FA121Accident · 2 fatalField investigationFinal reportBeech V35B · Denali Park, AKThe pilot's failure to maintain altitude/clearance from mountainous terrain while climbing, and his improper in-flight decision making by electing to fly at a low altitude toward rising terrain. A factor associated with the accident was mountainous terrain.