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 ATL07CA121Accident · No injuriesData collectionFinal reportBeech BE-76 · Pompano Beach, FLThe pilot's improper flare resulting in a hard landing. A factor in the accident was the certified flight instructor's inadequate supervision.NTSB SEA07FA240Accident · Serious injuriesField investigationFinal reportFlight Design Ctsw · St. George, UTThe loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA07CA238Accident · No injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Blaine, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing from the paved runway surface. Contributing factors were the crosswind and the soft ground.NTSB NYC07CA204Accident · Minor injuriesData collectionFinal reportCessna 172 · Julian, WVThe pilot's inadequate preflight planning. Contributing to the accident were the overcast cloud conditions and the pilot's failure to maintain directional control during the landing roll.NTSB DEN07LA145Accident · 1 fatalLimited investigationFinal reportAdams Airborne Australia O · Taos, NMThe pilot's intentional low altitude flight in a confined area and an inadvertent stall/spin. Contributing factors in this accident were the blind/box canyon and the aircraft's low airspeed.NTSB CHI07CA278Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Hagerstown, INThe pilot's use of an unsuitable runway for takeoff and delayed aborted takeoff. Factors were the wet grass and the fence the airplane impacted and subsequently nosed over.NTSB ATL07LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Danube, NYThe pilot's mismanagement of the fuel supply.NTSB ATL07LA119Accident · 1 fatalLimited investigationFinal reportCessna P206 · Center Hill, FLThe pilot committed suicide. Contributing to the event was the pilot's impairment due to alcohol.NTSB SEA07CA241Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Soda Springs, IDThe pilot's inadequate in-flight planning/decision making and subsequent loss of engine power due to fuel exhaustion. Contributing factors were the terrain conditions (soft and rough/uneven) and the tailwind weather conditions.NTSB SEA07CA239Accident · No injuriesData collectionFinal reportCessna 210L · Cottage Grove, ORThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC07FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-260 · Westhampton, NYUndetermined. The airplane remains missing.NTSB LAX07LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lopez Island, WAA loss of engine power due to the fatigue failure of the left idler gear. Inadequate maintenance installation of the recently installed left magneto was also causal.NTSB LAX07LA257Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Heber, UTThe pilot's failure to maintain sufficient airspeed during landing, resulting in an inadvertent stall/spin, undershoot and collision with the ground.NTSB LAX07LA253Accident · No injuriesLimited investigationFinal reportEdra Aeronautica Seastar · Kapolei, HIA loss of engine power due to fuel starvation that resulted from the pilot's inadequate preflight planning/preparation and failure to ensure that an adequate fuel supply was onboard the aircraft.NTSB DFW07IA193Incident · 1 fatalIncident investigationFinal reportCessna A188B · Colorado City, TXThe pilot's failure to maintain clear of the rotating propeller.NTSB DEN07WA147Accident · 2 fatalForeign investigationPiper PA-39 · Vannes, FranceNTSB ATL07CA132Accident · No injuriesData collectionFinal reportCessna C172N · Manassas, VAThe student pilot's failure to correct for a pilot-induced oscillation/porpoise, during flare/touchdown, which resulted in a hard landing.NTSB ATL07CA107Accident · Serious injuriesData collectionFinal reportMcNicholas S-12 · Cambridge, MDThe non certificated pilot's failure to remove the control lock prior to taxi and takeoff.NTSB ANC07LA090Accident · No injuriesLimited investigationFinal reportCessna 150G · Kenai, AKThe pilot's excessive flap setting during takeoff.NTSB ANC07CA084Accident · No injuriesData collectionFinal reportCessna 180 · Skwentna, AKThe pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in the airplane descending uncontrolled into high vegetation. Factors contributing to the accident were wind gusts and a crosswind.NTSB SEA07IA237Incident · No injuriesIncident investigationFinal reportRaytheon Cobra · Whetstone, AZThe student pilot's failure to follow proper procedures, specifically not verifying that the mode switch was in the automatic position before changing the pilot address, which resulted in a loss of aircraft control. Contributing to the accident was the flight…NTSB NYC07LA202Accident · No injuriesLimited investigationFinal reportLearjet 60 · Westhampton, NYThe captain's failure to properly align the airplane prior to touchdown.NTSB DEN08LA024Accident · No injuriesLimited investigationFinal reportIniziative Industriali Italian Sky Aero 600 Sport · Stevensville, MDThe pilot's premature flare that resulted in a hard landing, fracturing the left main landing gear strut that subsequently collapsed. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN07IA144Incident · No injuriesIncident investigationFinal reportNunn KR2 · Pueblo, COThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions . A contributing factor in this accident was the crosswind.NTSB CHI07LA277Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Anoka, MNThe loss of helicopter pitch control for undetermined reasons during the aerial application maneuver and the pilot's inability to control the aircraft during the descent.. A contributing factor to the accident was the soft terrain.NTSB CHI07FA279Accident · 2 fatalField investigationFinal reportSocata TB-20 Trinidad · Pointe Aux Pins, MIUndetermined.NTSB NYC07LA203Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vandemere, NCThe loss of engine power due to the failure of the supercharger bearings.NTSB NYC07LA201Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-31 · Markham, VAThe pilot's failure to maintain aircraft control. Contributing to the accident were a fuel leak as reported by the pilot, the pilot's diverted attention, a low cloud ceiling, and fog.NTSB MIA07CA134Accident · Minor injuriesData collectionFinal reportCessna 152 · Labelle, FLThe student pilot's attempted precautionary landing on unsuitable terrain which resulted in damage to the airplane during the landing.NTSB NYC07FA200Accident · Serious injuriesField investigationFinal reportBeech C24R · Niceville, FLThe pilot’s inadequate preflight inspection of the fuel quantity.NTSB MIA07WA135Accident · 2 fatalForeign investigationCessna U206G · Anaco, VenezuelaNTSB DFW07CA189Accident · Serious injuriesData collectionFinal reportMitsubishi MU-2B-36 · Hobby Airport, TXThe failure of the ramp employee to maintain clearance from the rotating propeller. A contributing factor was the prevailing night conditions.NTSB DEN07LA142Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Mullinville, KSThe pilot's failure to maintain main rotor rpm resulting in an uncontrolled descent, collision with transmission wires, and a hard landing. A contributing factor was the tranmission wires.NTSB ANC07LA092Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's failure to maintain adequate altitude/clearance from a parked airplane during the landing flare.NTSB DEN07CA141Accident · Minor injuriesData collectionFinal reportEaa Biplane P · Parker, COThe loss of engine power for undetermined reasons. A contributing factor was the pilot's intentional maneuver into a piece of machinery.NTSB CHI07CA275Accident · Minor injuriesData collectionFinal reportWeaver, David A Pulsar 912XP · Plato Center, ILthe pilot's failure to maintain airspeed. Factors were the pilot's lack of familiarity with the aircraft and pilot's failure to maintain altitude.NTSB DFW07LA187Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Cary, MSThe total loss of engine power due to a power turbine failure. Contributing to the accident were the lack of suitable terrain available to pilot for the forced landing and the low altitude.NTSB DFW07CA186Accident · No injuriesData collectionFinal reportEurocopter Deutschland BK117 · Slaton, TXThe pilot's failure to maintain control of the hovering helicopter and the flight instructor's improper supervision of the flight.NTSB DEN07WA143Incident · No injuriesForeign investigationBoeing 767-323 · Frankfurt, GermanyNTSB DEN07FA140Accident · 3 fatalField investigationFinal reportCessna 182R · Dayton, WYthe pilot's inability to maintain aircraft control while maneuvering in mountainous terrain due to gusty wind conditions, and lee side turbulence. Contributing to the accident was the pilot's improper in-flight planning and decision making, and his failure to…NTSB DCA07RA061Accident · No injuriesForeign investigationBoeing 737-800 · Naha, Okinawa, JapanNTSB ATL07CA123Accident · No injuriesData collectionFinal reportVans Vans RV-6 · Stockbridge, GAThe pilot's failure to maintain airplane control during the landing roll.NTSB ATL07CA117Accident · Minor injuriesData collectionFinal reportCessna 172K · Charlotte, NCThe pilot's failure to maintain directional control while landing.NTSB NYC07LA197Accident · No injuriesLimited investigationFinal reportCessna T210N · Old Bridge, NJThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation during approach.NTSB NYC07FA196Accident · Serious injuriesField investigationFinal reportLiberty Aerospace XL2 · Ormond Beach, FLThe student pilot's failure to maintain aircraft control during an attempted go-around.NTSB NYC07CA198Accident · No injuriesData collectionFinal reportChristen Industries Pitts S-2B · Springfield, TNThe pilot's inadequate compensation for wind conditions during landing.NTSB LAX07CA254Accident · Minor injuriesData collectionFinal reportCessna 172 · Leavenworth, WAthe pilot's failure to maintain an adequate clearance from the trees.NTSB DEN07CA139Accident · No injuriesData collectionFinal reportCessna A185F · Lake City, COThe pilot's improper preflight planning, his inability to attain short field takeoff performance, and his intentional maneuvering of the airplane into bushes and a fence during the aborted takeoff. Factors contributing to the accident were the high density…NTSB ATL07LA116Accident · 2 fatalLimited investigationFinal reportNiva Thorp T-18 · Wellington, FLA loss of engine power due to a partially blocked intake manifold and water contamination of the fuel.NTSB NYC07CA195Accident · No injuriesData collectionFinal reportCessna 172L · Winston-Salem, NCThe pilot's improper recovery from a bounced landing.